Re: Batch INSERT failing with error 22P02 - Mailing list pgsql-jdbc

From Eric Faulhaber
Subject Re: Batch INSERT failing with error 22P02
Date
Msg-id 46EFFF1C.90000@goldencode.com
Whole thread Raw
In response to Re: Batch INSERT failing with error 22P02  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
Dave Cramer wrote:
>>
>> So, my questions:
>>
>> A) Can anyone think what might have changed between the 8.1-408 and
>> 8.2-506 versions of the JDBC driver which might result in an INVALID
>> TEXT REPRESENTATION (22P02) error?
> I seem to recall the backend becoming more restrictive on valid UTF
> sequences.

The particular parameter on which the error is being reported is an
empty string, going into a column of type text.  BTW, the database is
encoded as LATIN1.

> However that doesn't make sense if an 8.1 driver does work.

Agreed.

> Any chance we can get the server logs ?

I am sending a client log (debug=2) to Kris Jurka.  What level of
debugging would you need to see in the server logs?

Thanks,
Eric Faulhaber

pgsql-jdbc by date:

Previous
From: Eric Faulhaber
Date:
Subject: Re: Batch INSERT failing with error 22P02
Next
From: "Berkes Alexander"
Date:
Subject: AbstractJdbc2Connection.java getObject(String type, String value)