oid as long type - Mailing list pgsql-jdbc

From Ryan Li
Subject oid as long type
Date
Msg-id 20060208094744.74887.qmail@web34701.mail.mud.yahoo.com
Whole thread Raw
Responses Re: oid as long type  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
Re: oid as long type  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
What's the reason of using int rather than long for the large object oid? I am experiencing a problem where the
databaseserver is generating oids exceeding the size for a Java int, and got "org.postgresql.util.PSQLException: Bad
valuefor type int". Could this be solve by making org.postgresql.largeobject.LargeObject.oid a long type and make
correspondingchanges to the source tree? 

(for example in org.postgresql.jdbc3.Jdbc3ResultSet.getBlob(int), instead of:

 return new Jdbc3Blob(connection, getInt(i));

do:

return new Jdbc3Blob(connection, getLong(i));)

I am not familar with the internals of the driver, so not sure if there are other complications. Any advice on using
longoids would be much appreciated. 

Thanks in advance!

Ryan



pgsql-jdbc by date:

Previous
From: Markus Schaber
Date:
Subject: Re: Inconsistent casting with literal vs parameter
Next
From: Achilleus Mantzios
Date:
Subject: Re: oid as long type