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

[Gail Badner (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=39721#action_39721 ] 

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.

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