First thing I would suggest is trying the latest driver from
jdbc.postgresql.org (either the latest dev build or the 7.3b1 build).
Also your example below is missing the code that is setting the values
for the prepared statement. So I am unsure as to what your code is
trying to do. Finally why are you running a 7.1 driver against a 7.2
database?
thanks,
--Barry
jonerf1 wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>