[Hibernate-JIRA] Created: (HHH-4617) Using blobs with hibernate causes error

[Hibernate-JIRA] Created:...

Radosław Smogura (JIRA)

Saturday, 28 November 2009 Sat, 28 Nov '09

9:43 a.m.

Using blobs with hibernate causes error --------------------------------------- Key: HHH-4617 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.5.0-Beta-2 Environment: Hibernate 3.5-b2, Glassfish v3 promoted build 74, PostgreSQL 8.3.7 Reporter: Radosław Smogura Priority: Critical I have entity with byte[] property annotated as @Lob and lazy fetch type, when table is createad the created column is of type oid, but when the column is read in application, the Hibernate reads the OID value instead of bytes under given oid. It's behavior like to read / write bytea. If i remember well, auto-creating table with Hibernate creates oid column. The proper behavior for dealing in PostgreSQL (and this behavior is in Hibernate 3.4) is to use oids. -- 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

Show replies by date

Gail Badner (JIRA)

Monday, 10 May Mon, 10 May

12:58 p.m.

New subject: [Hibernate-JIRA] Assigned: (HHH-4617) Using blobs with hibernate causes error

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617?page=c... ] Gail Badner reassigned HHH-4617: -------------------------------- Assignee: Gail Badner

...

Using blobs with hibernate causes error --------------------------------------- Key: HHH-4617 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.5.0-Beta-2 Environment: Hibernate 3.5-b2, Glassfish v3 promoted build 74, PostgreSQL 8.3.7 Reporter: Radosław Smogura Assignee: Gail Badner Priority: Critical I have entity with byte[] property annotated as @Lob and lazy fetch type, when table is createad the created column is of type oid, but when the column is read in application, the Hibernate reads the OID value instead of bytes under given oid. It's behavior like to read / write bytea. If i remember well, auto-creating table with Hibernate creates oid column. The proper behavior for dealing in PostgreSQL (and this behavior is in Hibernate 3.4) is to use oids.

-- 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

Gail Badner (JIRA)

1 p.m.

New subject: [Hibernate-JIRA] Updated: (HHH-4617) Using blobs with hibernate causes error

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617?page=c... ] Gail Badner updated HHH-4617: ----------------------------- Fix Version/s: 3.6 3.5.2

...

Using blobs with hibernate causes error --------------------------------------- Key: HHH-4617 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.5.0-Beta-2 Environment: Hibernate 3.5-b2, Glassfish v3 promoted build 74, PostgreSQL 8.3.7 Reporter: Radosław Smogura Assignee: Gail Badner Priority: Critical Fix For: 3.5.2, 3.6 I have entity with byte[] property annotated as @Lob and lazy fetch type, when table is createad the created column is of type oid, but when the column is read in application, the Hibernate reads the OID value instead of bytes under given oid. It's behavior like to read / write bytea. If i remember well, auto-creating table with Hibernate creates oid column. The proper behavior for dealing in PostgreSQL (and this behavior is in Hibernate 3.4) is to use oids.

Steve Ebersole (JIRA)

3:28 p.m.

New subject: [Hibernate-JIRA] Commented: (HHH-4617) Using blobs with hibernate causes error

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617?page=c... ] Steve Ebersole commented on HHH-4617: ------------------------------------- Yes LOB support in pgsql is, mmmmm, fun. http://jdbc.postgresql.org/documentation/84/binary-data.html {quote} PostgreSQL™ provides two distinct ways to store binary data... {quote} The problem is that it really depends on the underlying column defintion. For example, {quote} To use the bytea data type you should simply use the getBytes(), setBytes(), getBinaryStream(), or setBinaryStream() methods. To use the Large Object functionality you can use either the LargeObject class provided by the PostgreSQL™ JDBC driver, or by using the getBLOB() and setBLOB() methods. {quote} Essentially there are 2 completely different ways to do BLOBs on pgsql and it does not do anything to make it transparent which you are using. Anyway, have you made sure that streaming of lobs is disabled (hibernate.jdbc.use_streams_for_binary)? For pgsql with an OID column it for sure sounds like this should be false (aka don't use get/setBinaryStream)

...

Using blobs with hibernate causes error --------------------------------------- Key: HHH-4617 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.5.0-Beta-2 Environment: Hibernate 3.5-b2, Glassfish v3 promoted build 74, PostgreSQL 8.3.7 Reporter: Radosław Smogura Assignee: Gail Badner Priority: Critical Fix For: 3.5.2, 3.6 I have entity with byte[] property annotated as @Lob and lazy fetch type, when table is createad the created column is of type oid, but when the column is read in application, the Hibernate reads the OID value instead of bytes under given oid. It's behavior like to read / write bytea. If i remember well, auto-creating table with Hibernate creates oid column. The proper behavior for dealing in PostgreSQL (and this behavior is in Hibernate 3.4) is to use oids.

Steve Ebersole (JIRA)

4:03 p.m.

New subject: [Hibernate-JIRA] Commented: (HHH-4617) Using blobs with hibernate causes error

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617?page=c... ] Steve Ebersole commented on HHH-4617: ------------------------------------- FYI -> http://in.relation.to/Bloggers/PostgreSQLAndBLOBs

...

Using blobs with hibernate causes error --------------------------------------- Key: HHH-4617 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.5.0-Beta-2 Environment: Hibernate 3.5-b2, Glassfish v3 promoted build 74, PostgreSQL 8.3.7 Reporter: Radosław Smogura Assignee: Gail Badner Priority: Critical Fix For: 3.5.2, 3.6 I have entity with byte[] property annotated as @Lob and lazy fetch type, when table is createad the created column is of type oid, but when the column is read in application, the Hibernate reads the OID value instead of bytes under given oid. It's behavior like to read / write bytea. If i remember well, auto-creating table with Hibernate creates oid column. The proper behavior for dealing in PostgreSQL (and this behavior is in Hibernate 3.4) is to use oids.

Gail Badner (JIRA)

Tuesday, 11 May Tue, 11 May

3:44 p.m.

New subject: [Hibernate-JIRA] Updated: (HHH-4617) Using blobs with hibernate causes error

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617?page=c... ] Gail Badner updated HHH-4617: ----------------------------- Fix Version/s: (was: 3.5.2) (was: 3.6)

...

Using blobs with hibernate causes error --------------------------------------- Key: HHH-4617 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.5.0-Beta-2 Environment: Hibernate 3.5-b2, Glassfish v3 promoted build 74, PostgreSQL 8.3.7 Reporter: Radosław Smogura Assignee: Gail Badner Priority: Critical I have entity with byte[] property annotated as @Lob and lazy fetch type, when table is createad the created column is of type oid, but when the column is read in application, the Hibernate reads the OID value instead of bytes under given oid. It's behavior like to read / write bytea. If i remember well, auto-creating table with Hibernate creates oid column. The proper behavior for dealing in PostgreSQL (and this behavior is in Hibernate 3.4) is to use oids.

Gail Badner (JIRA)

3:46 p.m.

New subject: [Hibernate-JIRA] Resolved: (HHH-4617) Using blobs with hibernate causes error

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617?page=c... ] Gail Badner resolved HHH-4617. ------------------------------ Resolution: Rejected This appears to be due to a configuration problem.

...

Using blobs with hibernate causes error --------------------------------------- Key: HHH-4617 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.5.0-Beta-2 Environment: Hibernate 3.5-b2, Glassfish v3 promoted build 74, PostgreSQL 8.3.7 Reporter: Radosław Smogura Assignee: Gail Badner Priority: Critical I have entity with byte[] property annotated as @Lob and lazy fetch type, when table is createad the created column is of type oid, but when the column is read in application, the Hibernate reads the OID value instead of bytes under given oid. It's behavior like to read / write bytea. If i remember well, auto-creating table with Hibernate creates oid column. The proper behavior for dealing in PostgreSQL (and this behavior is in Hibernate 3.4) is to use oids.

Justin Sands (JIRA)

Monday, 20 September Mon, 20 Sep

1:56 p.m.

New subject: [Hibernate-JIRA] Commented: (HHH-4617) Using blobs with hibernate causes error

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617?page=c... ] Justin Sands commented on HHH-4617: ----------------------------------- For those encountering this in [3.5.2.Beta, 3.5.5) I found this to be a bug, not a configuration problem. However, it seems to have been fixed in 3.6.

...

Using blobs with hibernate causes error --------------------------------------- Key: HHH-4617 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.5.0-Beta-2 Environment: Hibernate 3.5-b2, Glassfish v3 promoted build 74, PostgreSQL 8.3.7 Reporter: Radosław Smogura Assignee: Gail Badner Priority: Critical I have entity with byte[] property annotated as @Lob and lazy fetch type, when table is createad the created column is of type oid, but when the column is read in application, the Hibernate reads the OID value instead of bytes under given oid. It's behavior like to read / write bytea. If i remember well, auto-creating table with Hibernate creates oid column. The proper behavior for dealing in PostgreSQL (and this behavior is in Hibernate 3.4) is to use oids.

Gail Badner (JIRA)

Friday, 24 December Fri, 24 Dec

12:07 a.m.

New subject: [Hibernate-JIRA] Reopened: (HHH-4617) Using blobs with hibernate causes error

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617?page=c... ] Gail Badner reopened HHH-4617: ------------------------------ I am still seeing this in 3.6 with hibernate.jdbc.use_streams_for_binary=false. I'm getting org.postgresql.util.PSQLException: ERROR: column "long_byte_array" is of type oid but expression is of type bytea. A possible fix is to: 1) add Dialect.useLobForMaterializedLobBinding(); it can default to false; PostgreSQLDialect can override it to return true. 2) add WrapperOptions.useLobForMaterializedLobBinding(); it can be defined to return session.getFactory().getDialect().useLobForMaterializedLobBinding(). 3) change doBind(...) in BlobTypeDescriptor.getBinder(...) to create and bind a Blob for byte[] values, if options.useLobForMaterializedLobBinding() is true. Steve, how does that sound?

...

Using blobs with hibernate causes error --------------------------------------- Key: HHH-4617 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.5.0-Beta-2, 3.6.0 Environment: Hibernate 3.5-b2, Glassfish v3 promoted build 74, PostgreSQL 8.3.7 Reporter: Radosław Smogura Assignee: Gail Badner Priority: Critical I have entity with byte[] property annotated as @Lob and lazy fetch type, when table is createad the created column is of type oid, but when the column is read in application, the Hibernate reads the OID value instead of bytes under given oid. It's behavior like to read / write bytea. If i remember well, auto-creating table with Hibernate creates oid column. The proper behavior for dealing in PostgreSQL (and this behavior is in Hibernate 3.4) is to use oids.

Gail Badner (JIRA)

12:07 a.m.

New subject: [Hibernate-JIRA] Updated: (HHH-4617) Using blobs with Postgresql causes error

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617?page=c... ] Gail Badner updated HHH-4617: ----------------------------- Affects Version/s: 3.6.0 Summary: Using blobs with Postgresql causes error (was: Using blobs with hibernate causes error)

...

Using blobs with Postgresql causes error ---------------------------------------- Key: HHH-4617 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.5.0-Beta-2, 3.6.0 Environment: Hibernate 3.5-b2, Glassfish v3 promoted build 74, PostgreSQL 8.3.7 Reporter: Radosław Smogura Assignee: Gail Badner Priority: Critical I have entity with byte[] property annotated as @Lob and lazy fetch type, when table is createad the created column is of type oid, but when the column is read in application, the Hibernate reads the OID value instead of bytes under given oid. It's behavior like to read / write bytea. If i remember well, auto-creating table with Hibernate creates oid column. The proper behavior for dealing in PostgreSQL (and this behavior is in Hibernate 3.4) is to use oids.

Gail Badner (JIRA)

Friday, 7 January Fri, 7 Jan

4:57 p.m.

New subject: [Hibernate-JIRA] Commented: (HHH-4617) Using blobs with Postgresql causes error

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617?page=c... ] Gail Badner commented on HHH-4617: ---------------------------------- Pull request for fixing Postgresql MaterializedBlob by overriding MaterializedBlobType is at https://github.com/hibernate/hibernate-core/pull/28 .

...

Gail Badner (JIRA)

Monday, 10 January Mon, 10 Jan

10:16 p.m.

New subject: [Hibernate-JIRA] Updated: (HHH-4617) Using blobs with Postgresql causes error

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617?page=c... ] Gail Badner updated HHH-4617: ----------------------------- Fix Version/s: 4.0.0.Alpha1 3.6.1

...

Using blobs with Postgresql causes error ---------------------------------------- Key: HHH-4617 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.5.0-Beta-2, 3.6.0 Environment: Hibernate 3.5-b2, Glassfish v3 promoted build 74, PostgreSQL 8.3.7 Reporter: Radosław Smogura Assignee: Gail Badner Priority: Critical Fix For: 3.6.1, 4.0.0.Alpha1 I have entity with byte[] property annotated as @Lob and lazy fetch type, when table is createad the created column is of type oid, but when the column is read in application, the Hibernate reads the OID value instead of bytes under given oid. It's behavior like to read / write bytea. If i remember well, auto-creating table with Hibernate creates oid column. The proper behavior for dealing in PostgreSQL (and this behavior is in Hibernate 3.4) is to use oids.

Gail Badner (JIRA)

Thursday, 20 January Thu, 20 Jan

1:50 p.m.

New subject: [Hibernate-JIRA] Commented: (HHH-4617) Using blobs with Postgresql causes error

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617?page=c... ] Gail Badner commented on HHH-4617: ---------------------------------- (11:42:02 AM) sebersole: its more the general framework i am concerned with (11:42:50 AM) sebersole: types get registered under a number of "keys" (11:43:24 AM) sebersole: org.hibernate.type.BasicType#getRegistrationKeys (11:43:34 AM) sebersole: of which, getName() is one (11:44:01 AM) sebersole: really you should register the overrides based on that call (11:44:12 AM) sebersole: you "align" its name (11:44:21 AM) gbadner: oh, right (11:44:27 AM) sebersole: but again (11:44:35 AM) sebersole: there are potentially multiple keys (11:45:15 AM) sebersole: if you want to override a specific type, you should also delegate its getRegistrationKeys()

...

Using blobs with Postgresql causes error ---------------------------------------- Key: HHH-4617 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.5.0-Beta-2, 3.6.0 Environment: Hibernate 3.5-b2, Glassfish v3 promoted build 74, PostgreSQL 8.3.7 Reporter: Radosław Smogura Assignee: Gail Badner Priority: Critical Fix For: 3.6.1, 4.0.0.Alpha1 I have entity with byte[] property annotated as @Lob and lazy fetch type, when table is createad the created column is of type oid, but when the column is read in application, the Hibernate reads the OID value instead of bytes under given oid. It's behavior like to read / write bytea. If i remember well, auto-creating table with Hibernate creates oid column. The proper behavior for dealing in PostgreSQL (and this behavior is in Hibernate 3.4) is to use oids.

Gail Badner (JIRA)

Wednesday, 2 February Wed, 2 Feb

3:22 a.m.

New subject: [Hibernate-JIRA] Commented: (HHH-4617) Using blobs with Postgresql causes error

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617?page=c... ] Gail Badner commented on HHH-4617: ---------------------------------- https://github.com/hibernate/hibernate-core/pull/35

...

Using blobs with Postgresql causes error ---------------------------------------- Key: HHH-4617 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.5.0-Beta-2, 3.6.0 Environment: Hibernate 3.5-b2, Glassfish v3 promoted build 74, PostgreSQL 8.3.7 Reporter: Radosław Smogura Assignee: Gail Badner Priority: Critical Fix For: 3.6.1, 4.0.0.Alpha1 I have entity with byte[] property annotated as @Lob and lazy fetch type, when table is createad the created column is of type oid, but when the column is read in application, the Hibernate reads the OID value instead of bytes under given oid. It's behavior like to read / write bytea. If i remember well, auto-creating table with Hibernate creates oid column. The proper behavior for dealing in PostgreSQL (and this behavior is in Hibernate 3.4) is to use oids.

Gail Badner (JIRA)

1:01 p.m.

New subject: [Hibernate-JIRA] Updated: (HHH-4617) Using blobs with Postgresql causes error

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617?page=c... ] Gail Badner updated HHH-4617: ----------------------------- Fix Version/s: (was: 4.0.0.Alpha1)

...

Using blobs with Postgresql causes error ---------------------------------------- Key: HHH-4617 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.5.0-Beta-2, 3.6.0 Environment: Hibernate 3.5-b2, Glassfish v3 promoted build 74, PostgreSQL 8.3.7 Reporter: Radosław Smogura Assignee: Gail Badner Priority: Critical Fix For: 3.6.1 I have entity with byte[] property annotated as @Lob and lazy fetch type, when table is createad the created column is of type oid, but when the column is read in application, the Hibernate reads the OID value instead of bytes under given oid. It's behavior like to read / write bytea. If i remember well, auto-creating table with Hibernate creates oid column. The proper behavior for dealing in PostgreSQL (and this behavior is in Hibernate 3.4) is to use oids.

Gail Badner (JIRA)

1:28 p.m.

New subject: [Hibernate-JIRA] Updated: (HHH-4617) Using materialized blobs with Postgresql causes error

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617?page=c... ] Gail Badner updated HHH-4617: ----------------------------- Summary: Using materialized blobs with Postgresql causes error (was: Using blobs with Postgresql causes error)

...

Using materialized blobs with Postgresql causes error ----------------------------------------------------- Key: HHH-4617 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.5.0-Beta-2, 3.6.0 Environment: Hibernate 3.5-b2, Glassfish v3 promoted build 74, PostgreSQL 8.3.7 Reporter: Radosław Smogura Assignee: Gail Badner Priority: Critical Fix For: 3.6.1 I have entity with byte[] property annotated as @Lob and lazy fetch type, when table is createad the created column is of type oid, but when the column is read in application, the Hibernate reads the OID value instead of bytes under given oid. It's behavior like to read / write bytea. If i remember well, auto-creating table with Hibernate creates oid column. The proper behavior for dealing in PostgreSQL (and this behavior is in Hibernate 3.4) is to use oids.

Gail Badner (JIRA)

8:11 p.m.

New subject: [Hibernate-JIRA] Resolved: (HHH-4617) Using materialized blobs with Postgresql causes error

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617?page=c... ] Gail Badner resolved HHH-4617. ------------------------------ Resolution: Fixed Fixed in git hibernate-core 3.6 branch: https://github.com/hibernate/hibernate-core/commit/8e832d82a346769123bf48...

...

5194

days inactive

5626

days old

hibernate-issues@lists.jboss.org

Manage subscription

16 comments

4 participants

tags (0)

participants (4)

Gail Badner (JIRA)
Justin Sands (JIRA)
Radosław Smogura (JIRA)
Steve Ebersole (JIRA)

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

[Hibernate-JIRA] Created: (HHH-4617) Using blobs with hibernate causes error