Large Objects with OID > 2147483647
От | Albe Laurenz |
---|---|
Тема | Large Objects with OID > 2147483647 |
Дата | |
Msg-id | 52EF20B2E3209443BC37736D00C3C1380BD46155@EXADV1.host.magwien.gv.at обсуждение исходный текст |
Ответы |
Re: Large Objects with OID > 2147483647
Re: Large Objects with OID > 2147483647 |
Список | pgsql-jdbc |
In a posting to the newsgroup comp.databases.postgresql, somebody has complained that he gets org.postgresql.util.PSQLException: Bad value for type int : 2338491788. when he tries to access a BLOB. The problem is new for the poster, it used to work. This looks like a bug in the driver to me: In the driver source code, I see that the OID is treated as 'int', which according to http://java.sun.com/docs/books/jls/third_edition/html/typesValues.html is a 4 byte signed integer, while OIDs are 4 byte unsigned integers. So accessing Large Objects with OID > 2147483647 as BLOB will not work, right? I think that 'long' would be more appropriate than 'int'. Is this problem known? Yours, Laurenz Albe
В списке pgsql-jdbc по дате отправления: