Re: Batch INSERT failing with error 22P02

On Mon, 17 Sep 2007, Eric Faulhaber wrote:

> I recently upgraded from PG 8.1.8 to 8.2.4.  I made a corresponding move in 
> JDBC driver versions from postgresql-8.1-408.jdbc3.jar to 
> postgresql-8.2-506.jdbc4.jar (binary distributions in both cases).  During a 
> lengthy import using Hibernate (yes, I realize it's not the most efficient 
> mechanism for bulk import), I hit the following error:
>
> SEVERE: ERROR: invalid input syntax for type oid: ""
>
> Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into 
> turnaround (turn_number, site, item, purchase_order_number, 
> purchase_order_line, lot, serial_number, quantity_issued, expiration_date, 
> id) values (0000XBJG, GSO, 0A0001H9L, 427190, 15, , , -14000.00000, NULL, 
> 59657893) was aborted.  Call getNextException to see the cause.
> SEVERE: An SQLException was provoked by the following failure: 
> java.lang.IllegalArgumentException: Can't change resolved type for param: 7 
> from 1043 to 26
> ....

We've seen this report once before, but weren't able to get to the bottom 
of it because it also occurred on a large dataset.

http://archives.postgresql.org/pgsql-jdbc/2007-06/threads.php#00041

In his case int4 and int8 were getting mixed up which is a little more 
understandable, in your case it's confusing varchar and oid which seems 
less likely.  Is there any chance you can run this with the URL parameter 
loglevel=2, which will produce tons of logging information, or can you 
make this test case available to me?

Kris Jurka