--_069e3534-4af6-460c-a9ae-5cf2802f71ab_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I always get the error "insufficient data left in message" running a
prepar=
ed statement via jdbc executeQuery
the java statement
"ResultSet rs =3D this.updateStatement.executeQuery();" =20
results in the following error message :
java.sql.SQLException: ERROR: insufficient data left in message.=20
the insert statement is=20
INSERT INTO person.person (id, lastName, readOnly, birthDay, firstName)
VA=
LUES(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:
Connecti=
on reset by peer
i
also tried this statement via the psql command line and it worked.=20
there is also a similar update statement that works perfect=20
###
ResultSet rs =3D this.updateStatement.executeQuery(); =20
// and the record is updated
// log=20
2008-04-29 00:34:45 CEST LOG: could not receive data from client:
Connecti=
on 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).=20
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.
W=
illkommen in der Familie! Den neuen Windows Live Messenger jetzt
herunterla=
den!
http://get.live.com/messenger/overview/=
--_069e3534-4af6-460c-a9ae-5cf2802f71ab_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<html>
<head>
<style>
..hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class=3D'hmmessage'>
I always get the error "<span></span>insufficient data left in message"
run=
ning a prepared statement via jdbc executeQuery<br><br>the java
statement<=
br><br> "ResultSet rs =3D this.updateStatement.executeQuery();"
=
<br><br>results in the following error message
:<br>java.sql.SQLExc=
eption: ERROR: insufficient data left in message. <br><br>the insert
statem=
ent is <br><br>INSERT INTO person.person (id, lastName, readOnly,
birthDay,=
firstName) VALUES(DEFAULT,?,?,?,?) RETURNING id<br><br>the server
LO=
G file says the following<br><br>2008-04-29 00:15:24 CEST ERROR:
insu=
fficient data left in message<br>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<br>2008-04-29 00:15:24 CEST LOG: could not receive data from
clien=
t: Connection reset by peer<br><br>i
also tried this statement via the psql command line and it worked.
there is also a similar update statement that works perfect
<br><br>###<br>=
ResultSet rs =3D this.updateStatement.executeQuery();
&nb=
sp; <br>// and the record is updated<br>// log <br>2008-04-29 00:34:45
CEST=
LOG: could not receive data from client: Connection reset by
peer<br=
>2008-04-29 00:34:45 CEST LOG: unexpected EOF on client
connection<br=
>###<br><br>i am using Postgres 8.2 and jdbc 3.0 for 8.2 (i also tried it
w=
ith jdbc 4.0 but it did not work either). <br><br>i have no idea
what=
the problem is - can someone help me ?<br><br>regards sepp<br><br><br><br
=
/><hr />Hohe Telefonrechnungen? Gratis Gespr=E4che von PC zu PC -
unlimitie=
rt mit dem Windows Live Messenger. <a
href=3D'http://get.live.com/messenger=
/overview/' target=3D'_new'>Hier klicken!</a></body>
</html>=
--_069e3534-4af6-460c-a9ae-5cf2802f71ab_--
|
