ERROR: insufficient data left in message
От | Robert Wimmer |
---|---|
Тема | ERROR: insufficient data left in message |
Дата | |
Msg-id | BAY139-W17522EA1404D646B6A38B3D0DE0@phx.gbl обсуждение исходный текст |
Ответы |
Re: ERROR: insufficient data left in message
Re: ERROR: insufficient data left in message |
Список | pgsql-jdbc |
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.0 but it did not work either).
i have no idea what the problem is - can someone help me ?
regards sepp
Hohe Telefonrechnungen? Gratis Gespräche von PC zu PC - unlimitiert mit dem Windows Live Messenger. Hier klicken!
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.0 but it did not work either).
i have no idea what the problem is - can someone help me ?
regards sepp
Hohe Telefonrechnungen? Gratis Gespräche von PC zu PC - unlimitiert mit dem Windows Live Messenger. Hier klicken!
В списке pgsql-jdbc по дате отправления: