Due to a compromise, all users are being forced to change their passwords as a precaution. You will need to use the "Can't access your account?" link next to the Log In button to request a reset email.

Hibernate Core

Informix 10 dialect with BLOB/CLOB support

Details

  • Type: Improvement Improvement
  • Status: Open Open
  • Priority: Minor Minor
  • Resolution: Unresolved
  • Affects Version/s: 3.2.4.sp1
  • Fix Version/s: None
  • Component/s: core
  • Description:
    Hide

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

    Show
    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.)
  • Environment:
    Informix 10
  1. Informix10Dialect.java
    (1 kB)
    Vladimir Kralik
    26/May/08 2:48 AM

Issue Links

Activity

Hide
Vladimir Kralik added a comment - 26/May/08 2:48 AM

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.

Show
Vladimir Kralik added a comment - 26/May/08 2:48 AM 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.

People

Dates

  • Created:
    31/May/07 7:14 AM
    Updated:
    26/May/08 2:48 AM