[hibernate-issues] [Hibernate-JIRA] Commented: (ANN-677) Blob is null with Postgresql

[Aaron Luchko (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/ANN-677?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_28722 ] 

Aaron Luchko commented on ANN-677:
----------------------------------

Since it's playing around with hibernate sessions and clears, ie toggling the second last clear also changes whether the bug occurs which makes be think there might be something other than just loading the blob, it seemed to me to more likely be a problem with how hibernate was interacting with the postgresql driver than just with the driver itself. Unfortunately I don't really know the intricacies of either well enough to know which project has the bug, I could try reporting the bug to postgresql though I have a hunch they'd claim it was a hibernate bug :)

> Blob is null with Postgresql
> ----------------------------
>
>                 Key: ANN-677
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-677
>             Project: Hibernate Annotations
>          Issue Type: Bug
>    Affects Versions: 3.2.1
>         Environment: hibernate-3.2.1, hibernate-annotations-3.2.1, postgresql-8.2.5-1.fc7, postgresql-jdbc-8.2.504-1jpp.fc7 and postgresql-8.2-506.jdbc4.jar
>            Reporter: Aaron Luchko
>         Attachments: hibPostgresbug.zip
>
>
> I've found that after a sequence of queries, starting new transactions and clearing the session, a Blob will not be successfully from the database and null will be returned by the InputStream instead. Using the debugger I've followed this into the jdbc code and from what I can tell some message is sent to load the blob but the database replies with an empty set of data which naturally causes the InputStream to read null.
> I've attached a test case (sorry, no makefile or pom.xml, I just ran it using eclipse) which, for me, replicates the bug.
> Note I've also used hsqldb and mysql and didn't see the bug with them, only postgresql.
> thanks,
> Aaron

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira