SEO

I always get the error "insufficient data left in message" running a prepared statement via jdbc executeQuery

the java statement

"ResultSet rs = this.updateStatement.executeQuery();"

results in the following error message :
java.sql.SQLException: ERROR: insufficient data left in message.

the insert statement is

INSERT INTO person.person (id, lastName, readOnly, birthDay, firstName) VALUES(DEFAULT,?,?,?,?) RETURNING id

the server LOG file says the following

2008-04-29 00:15:24 CEST ERROR: insufficient data left in message
2008-04-29
00:15:24 CEST STATEMENT: INSERT INTO person.person (id, lastName,
readOnly, birthDay, firstName) VALUES(DEFAULT,$1,$2,$3,$4) RETURNING id
2008-04-29 00:15:24 CEST LOG: could not receive data from client: Connection reset by peer

i
also tried this statement via the psql command line and it worked.
there is also a similar update statement that works perfect

###
ResultSet rs = this.updateStatement.executeQuery();
// and the record is updated
// log
2008-04-29 00:34:45 CEST LOG: could not receive data from client: Connection reset by peer
2008-04-29 00:34:45 CEST LOG: unexpected EOF on client connection
###

i am using Postgres 8.2 and jdbc 3.0 for 8.2 (i also tried it with jdbc 4.0but it did not work either).

i have no idea what the problem is - can someone help me ?

regards sepp



__________________________________________________ _______________
Der Messenger plaudert gerne - egal ob zu zweit oder mit allen gemeinsam. Willkommen in der Familie! Den neuen Windows Live Messenger jetzt herunterladen!
http://get.live.com/messenger/overview/

Robert Wimmer wrote:
> I always get the error "insufficient data left in message" running a
> prepared statement via jdbc executeQuery

Can you send us a testcase showing exactly what you are doing?

-O

--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc

Hello Robert,

I had the same problem with Strings containing the 0x00-char. PostgreSQL
does not like those...

With best regards,
Daniel Migowski


--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc