[hibernate-issues] [Hibernate-JIRA] Commented: (ANN-677) Blob is null with Postgresql
[
http://opensource.atlassian.com/projects/hibernate/browse/ANN-677?page=co...
]
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira