Re: BUG #5197: JDBC: selecting oid results in Exception

On Thu, 19 Nov 2009, Joseph Shraibman wrote:

>
> The following bug has been logged online:
>
> Bug reference:      5197
> Description:        JDBC: selecting oid results in Exception
> Details:
>
> query: "select oid FROM pg_catalog.pg_class c;"
>
> -----------------------------------------------
> org.postgresql.util.PSQLException: Bad value for type int : 2148618421
> 	at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.toInt(AbstractJdbc2ResultSet.jav
> a:2630)

Java doesn't have an equivalent for unsigned types, so the JDBC driver 
internally tries to fit it into a signed int by using the negative values. 
Unfortunately that's failing and it's not what the user wants for this 
case.  I imagine the user really wants to get a Long back from this.  I'm 
going on vacation next week, but when I return, I'll make that happen.

Kris Jurka