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