2:41 p.m.
Postgresql @Lob problem
-----------------------
Key: HHH-4876
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.5.0-Beta-4
Environment: Reproducable on Windows and Linux with Postgresql 8.4
Reporter: Radosław Smogura
The current version of Hibernate (Beta) wrongly reads PgSQL blob values (mapped from @Lob
byte[]). In general Hibernate properly creates OID type columns for storing blobs, but
when it read blob it reads oid value instead of LOB referenced by oid valu (so as the
output i get 6 bytes length table instead of 120kb table) This works fine in previous
release 3.3 / 3.2.
This was I saw is: previous version uses getBlob(), but 3.5 version uses getBytes() of
resultset class.
--
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
11:30 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-4876) Postgresql @Lob problem
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876?page=c...
]
Strong Liu commented on HHH-4876:
---------------------------------
this can be reproduced by org.hibernate.test.annotations.lob.LobTest.testBlob()
Postgresql @Lob problem
-----------------------
Key: HHH-4876
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.5.0-Beta-4
Environment: Reproducable on Windows and Linux with Postgresql 8.4
Reporter: Radosław Smogura
The current version of Hibernate (Beta) wrongly reads PgSQL blob values (mapped from @Lob
byte[]). In general Hibernate properly creates OID type columns for storing blobs, but
when it read blob it reads oid value instead of LOB referenced by oid valu (so as the
output i get 6 bytes length table instead of 120kb table) This works fine in previous
release 3.3 / 3.2.
This was I saw is: previous version uses getBlob(), but 3.5 version uses getBytes() of
resultset class.
--
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
12:58 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-4876) Postgresql @Lob problem
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876?page=c...
]
Strong Liu commented on HHH-4876:
---------------------------------
previous version of ann maps byte[] with @Lob property to
org.hibernate.type.PrimitiveByteArrayBlobType, it is actually a BlobType, and it calls
st.setBlob()
actually, if you set hibernate.jdbc.use_streams_for_binary true, you will get the same
error.
so, the simple workaround is change the property type to Blob, yeah, i know it is bad...
:(
Postgresql @Lob problem
-----------------------
Key: HHH-4876
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.5.0-Beta-4
Environment: Reproducable on Windows and Linux with Postgresql 8.4
Reporter: Radosław Smogura
The current version of Hibernate (Beta) wrongly reads PgSQL blob values (mapped from @Lob
byte[]). In general Hibernate properly creates OID type columns for storing blobs, but
when it read blob it reads oid value instead of LOB referenced by oid valu (so as the
output i get 6 bytes length table instead of 120kb table) This works fine in previous
release 3.3 / 3.2.
This was I saw is: previous version uses getBlob(), but 3.5 version uses getBytes() of
resultset class.
--
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
1:09 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-4876) Postgresql @Lob problem
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876?page=c...
]
Strong Liu commented on HHH-4876:
---------------------------------
Version 7.2 was the first release of the JDBC driver that supports the bytea data type.
The introduction of this functionality in 7.2 has introduced a change in behavior as
compared to previous releases. Since 7.2, the methods getBytes(), setBytes(),
getBinaryStream(), and setBinaryStream() operate on the bytea data type
[http://jdbc.postgresql.org/documentation/83/binary-data.html]
Postgresql @Lob problem
-----------------------
Key: HHH-4876
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.5.0-Beta-4
Environment: Reproducable on Windows and Linux with Postgresql 8.4
Reporter: Radosław Smogura
The current version of Hibernate (Beta) wrongly reads PgSQL blob values (mapped from @Lob
byte[]). In general Hibernate properly creates OID type columns for storing blobs, but
when it read blob it reads oid value instead of LOB referenced by oid valu (so as the
output i get 6 bytes length table instead of 120kb table) This works fine in previous
release 3.3 / 3.2.
This was I saw is: previous version uses getBlob(), but 3.5 version uses getBytes() of
resultset class.
--
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
1:18 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-4876) Postgresql @Lob problem
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876?page=c...
]
Strong Liu commented on HHH-4876:
---------------------------------
sorry, there is another better workaround, you can map ImageType to the byte[] type
instead of @Blob.
take a look of
[https://anonsvn.jboss.org/repos/hibernate/core/trunk/annotations/src/test...
for more details]
Postgresql @Lob problem
-----------------------
Key: HHH-4876
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.5.0-Beta-4
Environment: Reproducable on Windows and Linux with Postgresql 8.4
Reporter: Radosław Smogura
The current version of Hibernate (Beta) wrongly reads PgSQL blob values (mapped from @Lob
byte[]). In general Hibernate properly creates OID type columns for storing blobs, but
when it read blob it reads oid value instead of LOB referenced by oid valu (so as the
output i get 6 bytes length table instead of 120kb table) This works fine in previous
release 3.3 / 3.2.
This was I saw is: previous version uses getBlob(), but 3.5 version uses getBytes() of
resultset class.
--
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
1:39 p.m.
New subject: [Hibernate-JIRA] Assigned: (HHH-4876) Postgresql @Lob problem
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876?page=c...
]
Strong Liu reassigned HHH-4876:
-------------------------------
Assignee: Strong Liu
Postgresql @Lob problem
-----------------------
Key: HHH-4876
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.5.0-Beta-4
Environment: Reproducable on Windows and Linux with Postgresql 8.4
Reporter: Radosław Smogura
Assignee: Strong Liu
The current version of Hibernate (Beta) wrongly reads PgSQL blob values (mapped from @Lob
byte[]). In general Hibernate properly creates OID type columns for storing blobs, but
when it read blob it reads oid value instead of LOB referenced by oid valu (so as the
output i get 6 bytes length table instead of 120kb table) This works fine in previous
release 3.3 / 3.2.
This was I saw is: previous version uses getBlob(), but 3.5 version uses getBytes() of
resultset class.
--
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
1:46 p.m.
New subject: [Hibernate-JIRA] Resolved: (HHH-4876) Postgresql @Lob problem
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876?page=c...
]
Strong Liu resolved HHH-4876.
-----------------------------
Resolution: Rejected
as my previous comment, this is a API change came from 3.5-beta2
we will document this (HHH-4878) change before 3.5 GA
so, issue reject :)
Postgresql @Lob problem
-----------------------
Key: HHH-4876
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.5.0-Beta-4
Environment: Reproducable on Windows and Linux with Postgresql 8.4
Reporter: Radosław Smogura
Assignee: Strong Liu
The current version of Hibernate (Beta) wrongly reads PgSQL blob values (mapped from @Lob
byte[]). In general Hibernate properly creates OID type columns for storing blobs, but
when it read blob it reads oid value instead of LOB referenced by oid valu (so as the
output i get 6 bytes length table instead of 120kb table) This works fine in previous
release 3.3 / 3.2.
This was I saw is: previous version uses getBlob(), but 3.5 version uses getBytes() of
resultset class.
--
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
2:03 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-4876) Postgresql @Lob problem
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876?page=c...
]
Radosław Smogura commented on HHH-4876:
---------------------------------------
Hm... it doesn't sound good, because it's breaks current system. Is there any
chance to revert reading blobs using blob.getBytes(), in a way of some configuration
parameter, or put back the PrimitiveByteArrayBlobType so I could annotate my @Lob wit
@Type("old_working_blob") :)
In any way I want to thank you for above information, as I now know what to change to make
it work (unfortunate I can't build trunk to jar, because of test fails).
And by the way, I've forgotten to mention this
When Hibernate creates @Lob byte[] column it sets it's type to oid - this will cases
full trip "create -> use" to fail (from above reasons).
Postgresql @Lob problem
-----------------------
Key: HHH-4876
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.5.0-Beta-4
Environment: Reproducable on Windows and Linux with Postgresql 8.4
Reporter: Radosław Smogura
Assignee: Strong Liu
The current version of Hibernate (Beta) wrongly reads PgSQL blob values (mapped from @Lob
byte[]). In general Hibernate properly creates OID type columns for storing blobs, but
when it read blob it reads oid value instead of LOB referenced by oid valu (so as the
output i get 6 bytes length table instead of 120kb table) This works fine in previous
release 3.3 / 3.2.
This was I saw is: previous version uses getBlob(), but 3.5 version uses getBytes() of
resultset class.
--
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
2:44 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-4876) Postgresql @Lob problem
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876?page=c...
]
Strong Liu commented on HHH-4876:
---------------------------------
org.hibernate.type.PrimitiveByteArrayBlobType is there, i didn't remove it, only
deprecated
Postgresql @Lob problem
-----------------------
Key: HHH-4876
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.5.0-Beta-4
Environment: Reproducable on Windows and Linux with Postgresql 8.4
Reporter: Radosław Smogura
Assignee: Strong Liu
The current version of Hibernate (Beta) wrongly reads PgSQL blob values (mapped from @Lob
byte[]). In general Hibernate properly creates OID type columns for storing blobs, but
when it read blob it reads oid value instead of LOB referenced by oid valu (so as the
output i get 6 bytes length table instead of 120kb table) This works fine in previous
release 3.3 / 3.2.
This was I saw is: previous version uses getBlob(), but 3.5 version uses getBytes() of
resultset class.
--
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
4:18 a.m.
New subject: [Hibernate-JIRA] Reopened: (HHH-4876) Postgresql @Lob problem
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876?page=c...
]
Strong Liu reopened HHH-4876:
-----------------------------
I'm wondering maybe "reject" is not a good decision, reopen to correct it
Postgresql @Lob problem
-----------------------
Key: HHH-4876
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.5.0-Beta-4
Environment: Reproducable on Windows and Linux with Postgresql 8.4
Reporter: Radosław Smogura
Assignee: Strong Liu
The current version of Hibernate (Beta) wrongly reads PgSQL blob values (mapped from @Lob
byte[]). In general Hibernate properly creates OID type columns for storing blobs, but
when it read blob it reads oid value instead of LOB referenced by oid valu (so as the
output i get 6 bytes length table instead of 120kb table) This works fine in previous
release 3.3 / 3.2.
This was I saw is: previous version uses getBlob(), but 3.5 version uses getBytes() of
resultset class.
--
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
4:20 a.m.
New subject: [Hibernate-JIRA] Updated: (HHH-4876) Postgresql @Lob problem
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876?page=c...
]
Strong Liu updated HHH-4876:
----------------------------
Component/s: (was: core)
annotations
Postgresql @Lob problem
-----------------------
Key: HHH-4876
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876
Project: Hibernate Core
Issue Type: Bug
Components: annotations
Affects Versions: 3.5.0-Beta-4
Environment: Reproducable on Windows and Linux with Postgresql 8.4
Reporter: Radosław Smogura
Assignee: Strong Liu
The current version of Hibernate (Beta) wrongly reads PgSQL blob values (mapped from @Lob
byte[]). In general Hibernate properly creates OID type columns for storing blobs, but
when it read blob it reads oid value instead of LOB referenced by oid valu (so as the
output i get 6 bytes length table instead of 120kb table) This works fine in previous
release 3.3 / 3.2.
This was I saw is: previous version uses getBlob(), but 3.5 version uses getBytes() of
resultset class.
--
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
4:22 a.m.
New subject: [Hibernate-JIRA] Resolved: (HHH-4876) Postgresql @Lob problem
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876?page=c...
]
Strong Liu resolved HHH-4876.
-----------------------------
Resolution: Won't Fix
I'm prefer resolve this as "won't fix"
this mapping behavior change came from 3.5-beta2, and the workarounds are simple:
1. using image type
or
2. using the only org.hibernate.type.PrimitiveByteArrayBlobType
Postgresql @Lob problem
-----------------------
Key: HHH-4876
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876
Project: Hibernate Core
Issue Type: Bug
Components: annotations
Affects Versions: 3.5.0-Beta-4
Environment: Reproducable on Windows and Linux with Postgresql 8.4
Reporter: Radosław Smogura
Assignee: Strong Liu
The current version of Hibernate (Beta) wrongly reads PgSQL blob values (mapped from @Lob
byte[]). In general Hibernate properly creates OID type columns for storing blobs, but
when it read blob it reads oid value instead of LOB referenced by oid valu (so as the
output i get 6 bytes length table instead of 120kb table) This works fine in previous
release 3.3 / 3.2.
This was I saw is: previous version uses getBlob(), but 3.5 version uses getBytes() of
resultset class.
--
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
2:41 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-4876) Postgresql @Lob problem
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876?page=c...
]
Radosław Smogura commented on HHH-4876:
---------------------------------------
I think last comment from my side
1. @Type(type="image") doesn't resolve problem I still get 6 bytes oid
value, nor compatible=7.1
2. PrimitiveByteArrayBlobType is the way - (maybe some warning during entity deployment
about this type will be good)
Can I suggest to put in @deprecated note of PrimitiveByteArrayBlobType following
information "Left for backwards compatibility" - just to don't accidentally
delete of it in the future.
Please remember that @Lob byte[] creates oid type column in PgSQL.
Thanks for time and your help
Have a nice day!
Postgresql @Lob problem
-----------------------
Key: HHH-4876
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876
Project: Hibernate Core
Issue Type: Bug
Components: annotations
Affects Versions: 3.5.0-Beta-4
Environment: Reproducable on Windows and Linux with Postgresql 8.4
Reporter: Radosław Smogura
Assignee: Strong Liu
The current version of Hibernate (Beta) wrongly reads PgSQL blob values (mapped from @Lob
byte[]). In general Hibernate properly creates OID type columns for storing blobs, but
when it read blob it reads oid value instead of LOB referenced by oid valu (so as the
output i get 6 bytes length table instead of 120kb table) This works fine in previous
release 3.3 / 3.2.
This was I saw is: previous version uses getBlob(), but 3.5 version uses getBytes() of
resultset class.
--
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
1:56 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-4876) Postgresql @Lob problem
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876?page=c...
]
Justin Sands commented on HHH-4876:
-----------------------------------
This seems to have been fixed in 3.6.
Postgresql @Lob problem
-----------------------
Key: HHH-4876
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876
Project: Hibernate Core
Issue Type: Bug
Components: annotations
Affects Versions: 3.5.0-Beta-4
Environment: Reproducable on Windows and Linux with Postgresql 8.4
Reporter: Radosław Smogura
Assignee: Strong Liu
The current version of Hibernate (Beta) wrongly reads PgSQL blob values (mapped from @Lob
byte[]). In general Hibernate properly creates OID type columns for storing blobs, but
when it read blob it reads oid value instead of LOB referenced by oid valu (so as the
output i get 6 bytes length table instead of 120kb table) This works fine in previous
release 3.3 / 3.2.
This was I saw is: previous version uses getBlob(), but 3.5 version uses getBytes() of
resultset class.
--
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
4:28 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-4876) Postgresql @Lob problem
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876?page=c...
]
Julien Serdaru commented on HHH-4876:
-------------------------------------
Are there any plans to fix this in 3.5?
This issue prevents us from migrating to 3.5. We use an external library that ships
@Lob-annotated entity classes which breaks on PostgreSQL.
Thanks!
Postgresql @Lob problem
-----------------------
Key: HHH-4876
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876
Project: Hibernate Core
Issue Type: Bug
Components: annotations
Affects Versions: 3.5.0-Beta-4
Environment: Reproducable on Windows and Linux with Postgresql 8.4
Reporter: Radosław Smogura
Assignee: Strong Liu
The current version of Hibernate (Beta) wrongly reads PgSQL blob values (mapped from @Lob
byte[]). In general Hibernate properly creates OID type columns for storing blobs, but
when it read blob it reads oid value instead of LOB referenced by oid valu (so as the
output i get 6 bytes length table instead of 120kb table) This works fine in previous
release 3.3 / 3.2.
This was I saw is: previous version uses getBlob(), but 3.5 version uses getBytes() of
resultset class.
--
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
1:58 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-4876) Postgresql @Lob problem
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876?page=c...
]
Strong Liu commented on HHH-4876:
---------------------------------
i don't think it's fixed in 3.6..
Postgresql @Lob problem
-----------------------
Key: HHH-4876
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4876
Project: Hibernate Core
Issue Type: Bug
Components: annotations
Affects Versions: 3.5.0-Beta-4
Environment: Reproducable on Windows and Linux with Postgresql 8.4
Reporter: Radosław Smogura
Assignee: Strong Liu
The current version of Hibernate (Beta) wrongly reads PgSQL blob values (mapped from @Lob
byte[]). In general Hibernate properly creates OID type columns for storing blobs, but
when it read blob it reads oid value instead of LOB referenced by oid valu (so as the
output i get 6 bytes length table instead of 120kb table) This works fine in previous
release 3.3 / 3.2.
This was I saw is: previous version uses getBlob(), but 3.5 version uses getBytes() of
resultset class.
--
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
5170
days inactive
5442
days old
hibernate-issues@lists.jboss.org
15 comments
4 participants
participants (4)
-
Julien Serdaru (JIRA) -
Justin Sands (JIRA)
-
Radosław Smogura (JIRA)
-
Strong Liu (JIRA)