Skip site navigation (1) Skip section navigation (2)

Re: Batch INSERT failing with error 22P02

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: ecf(at)goldencode(dot)com
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Batch INSERT failing with error 22P02
Date: 2007-09-17 21:59:22
Message-ID: 3FB6F105-AFD2-4BFC-8FF3-9CF24126C638@fastcrypt.com (view raw or flat)
Thread:
Lists: 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


In response to

Responses

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2007-09-17 22:15:58
Subject: Re: Batch INSERT failing with error 22P02
Previous:From: Eric FaulhaberDate: 2007-09-17 20:34:55
Subject: Batch INSERT failing with error 22P02

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group