[hibernate-issues] [Hibernate-JIRA] Updated: (HHH-2646) Informix 10 dialect with BLOB/CLOB support

[Vladimir Kralik (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Vladimir Kralik updated HHH-2646:
---------------------------------

    Attachment: Informix10Dialect.java

Two new features were added to this patch.

1.) Informix 10 has "skip", so now it's possible to implement limixOffset on the database.
2.) when is used "first" in select, it's also useful give hint {+ FIRST_ROWS }, for better performance. 

> Informix 10 dialect with BLOB/CLOB support
> ------------------------------------------
>
>                 Key: HHH-2646
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2646
>             Project: Hibernate3
>          Issue Type: Improvement
>          Components: core
>    Affects Versions: 3.2.4.sp1
>         Environment: Informix 10
>            Reporter: Thomas Much
>            Assignee: Diego Plentz
>            Priority: Minor
>         Attachments: Informix10Dialect.java
>
>
> We discovered that Informix 10 works well with mapping types "blob" and "clob" if we use our own dialect that's simply derived from the existing Informix dialect by adding the two missing types:
>     public class Informix10Dialect extends InformixDialect {
>         public Informix10Dialect() {
>             super();
>             registerColumnType( Types.BLOB, "blob" );
>             registerColumnType( Types.CLOB, "clob" );
>         }
>     }
> We suggest adding this new dialect to Hibernate Core. (This is similar to issue HHH-2523, but here "clob" is mapped, too.)

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