blob load errors

From: "jonerf1" <jonesrf1(at)qwest(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: blob load errors
Date: 2002-10-15 16:17:36
Message-ID: 3DAC3FA0.7070000@qwest.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2002-10-15 17:25:17 Re: blob load errors
Previous Message Jan Wieck 2002-10-15 14:37:41 Re: Changing Column Order (Was Re: MySQL vs PostgreSQL.)