[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5585) SubDialect of PostgreSQLDialect to support (@Lob + byte[]) combination

[Gail Badner (JIRA)]

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

Gail Badner commented on HHH-5585:
----------------------------------

I believe your sub-dialect is equivalent to type="image"...

> SubDialect of PostgreSQLDialect to support (@Lob + byte[]) combination
> ----------------------------------------------------------------------
>
>                 Key: HHH-5585
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5585
>             Project: Hibernate Core
>          Issue Type: Patch
>         Environment: 3.6.0.CR1, postgresql
>            Reporter: Justin Sands
>         Attachments: CustomPostgreSQLDialect.zip
>
>   Original Estimate: 50m
>  Remaining Estimate: 50m
>
> From hibernate 3.5 to 3.6 the annotation combination @Lob + byte[] does not on postgresql work due to idiosyncrasies in the postgresql JDBC driver.
> To support this combination, the following dialect variant can be used along with a basic-type override, provided that the application consistently uses the same annotation style (@Lob + byte[]).  A similar approach could be used to support using the OID blob type which postgresql provides, although this patch does not address it.
> The user must register the basic type override MateralizedVarBinaryBlobType at boot time.
> I am unsure exactly where in the distribution this would fit so I have kept it in one package (org.hibernate.dialect.variant).
> I have test cases which I could detach from my current project, if the maintainers think this patch is worth including.

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