atom feed7 messages in org.postgresql.pgsql-jdbcinvalid byte sequence for encoding "U...
FromSent OnAttachments
James ImFeb 20, 2007 2:48 am 
Altaf MalikFeb 20, 2007 2:56 am 
Csaba NagyFeb 20, 2007 3:13 am 
Oliver JowettFeb 20, 2007 3:49 am 
Ken JohansonFeb 21, 2007 10:37 pm 
Oliver JowettFeb 22, 2007 12:53 am 
Tore HalsetFeb 23, 2007 9:31 am 
Subject:invalid byte sequence for encoding "UTF8": 0x00
From:James Im (im-j@hotmail.com)
Date:Feb 20, 2007 2:48:20 am
List:org.postgresql.pgsql-jdbc

Hi,

I've got another problem. I sometimes get the following SQLException when doing an insert:

ERROR: invalid byte sequence for encoding "UTF8": 0x00 Exception: org.postgresql.util.PSQLException
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309) org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)

By the way, the insert is done with a PreparedStatement and I use only setLong(), setString(), setTimestamp() and setInt().

I don't understand it very well. It is obviously an encoding exception but I don't know why it happens and what I could do avoid it.

Any idea?