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

[Justin Sands (JIRA)]

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

>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