blob load errors
От | jonerf1 |
---|---|
Тема | blob load errors |
Дата | |
Msg-id | 3DAC3FA0.7070000@qwest.net обсуждение исходный текст |
Список | pgsql-jdbc |
I have two machines running the same small java program; one machine can load files as blobs, the other gets the oidin error. This happens even when the same postgresql server is acccessed; the local upload works on machine A, the local upload fails on machine B, and upload to machine Aover tcpip fails as well. Both machines are running pgsql7.2.3, using jdbc7.1-1.3.jar, jdk1.4.0x, kernel 2.4.18 on redhat 7.3 this is the insert statement try { //ist fld is serial id, 2nd is name, 3rd is oid String sqlstr = "INSERT INTO images(imgname, imgoid) VALUES(?,?)"; pst = conn.prepareStatement(sqlstr); System.out.println("pst = "+pst); }//end try below is output from posmaster on machine A from machine B DEBUG: query: begin; DEBUG: parse tree: { QUERY :command 5 :utility ? :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable <> :jointree <> :rowMarks () :targetList <> :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: ProcessUtility: begin; DEBUG: CommitTransactionCommand DEBUG: StartTransactionCommand DEBUG: query: INSERT INTO images HERE NEXT LINE SHORTENED UP VALUES('doss','\\377WPC^\\012\\000\\000\\001\\012\\002\\001\\000\\000\\000\\002\\005\\0\\000\\324') ERROR: pg_atoi: error in "doss": can't parse "doss" DEBUG: AbortCurrentTransaction DEBUG: StartTransactionCommand DEBUG: query: commit;begin; Any help greatly appreciated. TIA rfjones
В списке pgsql-jdbc по дате отправления: