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
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.) |