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

From Dave Cramer
Subject Re: Batch INSERT failing with error 22P02
Date
Msg-id 3FB6F105-AFD2-4BFC-8FF3-9CF24126C638@fastcrypt.com
Whole thread Raw
In response to Batch INSERT failing with error 22P02  (Eric Faulhaber <ecf@goldencode.com>)
Responses Re: Batch INSERT failing with error 22P02
List pgsql-jdbc
>
> 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. However that doesn't make sense if an 8.1 driver does
work. Any chance we can get the server logs ?
>
> B) While the JDBC drivers are documented to be backward compatible
> with older back-ends, is there anything that would make it
> obviously unsafe for me to go the other way round, using the 8.1
> JDBC driver with the 8.2.4 back-end?  Although this doesn't seem to
> be a viable permanent solution, for the time being I have no
> working alternative for PG 8.2.4.
>
Iyou can do this if the code is just doing select/insert/update/
delete in other words nothing fancy.
> Thanks in advance,
> Eric Faulhaber
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org


pgsql-jdbc by date:

Previous
From: Eric Faulhaber
Date:
Subject: Batch INSERT failing with error 22P02
Next
From: Kris Jurka
Date:
Subject: Re: Batch INSERT failing with error 22P02