Since Hibernate 6, the InformixDialect class file has been moved out of Hibernate core to the community provided content. Are there anyone with experience in the combination of Hibernate and Informix here? Have you modified or adapted the InformixDialect class? We are having some problems with Hibernate 6 that may look like something is wrong in the default provided InformixDialect class.

Since Hibernate 6, the InformixDialect class file has been moved out of Hibernate core to the community provided content. Are there anyone with experience in the combination of Hibernate and Informix here? Have you modified or adapted the InformixDialect class? We are having some problems with Hibernate 6 that may look like something is wrong in the default provided InformixDialect class.

SQL Query generated by Hibernate version 5.x.x: 

 select
       varestrom0_.varestr_kode as varestr_1_641_0_,
        varestrom0_.beskr as beskr2_641_0_,
        varestrom0_.edi_varestr_kode as edi_vare3_641_0_
from
        varestrommer varestrom0_
where
        varestrom0_.varestr_kode=?

Which works completely fine.... 

SQL Query generated by Hibernate version 6.x.x:

select
       null,
       v1_0.beskr,
       v1_0.edi_varestr_kode
from
       varestrommer v1_0
where
       v1_0.varestr_kode=?

Which doesn't work and gives SQLGrammarException: could not prepare statement [A syntax error has occurred.]

The primary key here is varestr_kode, this is a char(3) field, and is an assigned key with Hibernate.

We are still using the legacy hbm.xml based mappings rather than annotation based mappings. The mapping for this table is as follows (package names changed):

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd" >
    
<hibernate-mapping>
<class 
    name="com.example.dal.tgprod.domain.Varestrom" 
    table="varestrommer"
    lazy="false"
>
    <meta attribute="class-description" inherit="false">
       @hibernate.class
        table="varestrommer"
    </meta>
    
    <id
        name="varestrKode"
        type="com.example.hibernate.type.TrimmedString"
        column="varestr_kode"
    >
        <meta attribute="field-description">
           @hibernate.id
            generator-class="assigned"
            type="com.example.hibernate.type.TrimmedString"
            column="varestr_kode"
 
        </meta>
        <generator class="assigned" />
    </id>
 
    <property
        name="beskr"
        type="com.example.hibernate.type.TrimmedString"
        column="beskr"
        length="70"
    >
        <meta attribute="use-in-tostring">true</meta>
        <meta attribute="field-description">
           @hibernate.property
            column="beskr"
            length="70"
        </meta>    
    </property>
 
    <property
        name="ediVarestrKode"
        type="com.example.hibernate.type.TrimmedString"
        column="edi_varestr_kode"
        length="5"
    >
        <meta attribute="use-in-tostring">true</meta>
        <meta attribute="field-description">
           @hibernate.property
            column="edi_varestr_kode"
            length="5"
        </meta>    
    </property>
    
    <!-- Associations -->
</class>
</hibernate-mapping>

Since Hibernate 6, the InformixDialect class file has been moved out of Hibernate core to the community provided content. Are there anyone with experience in the combination of Hibernate and Informix here? Have you modified or adapted the InformixDialect class? We are having some problems with Hibernate 6 that may look like something is wrong in the default provided InformixDialect class.

Hi Øyvind,

apart from the question whether or how these two queries could be considered equivalent,  selecting NULL without any type information currently isn't allowed in Informix (whether "syntax error" is the best possible error for this might be a separate question.)  Unfortunately we cannot conclude any type information from such NULL's position in the projection clause, as that might be the writer's intention only in some cases.

I can see that other RDBMS do handle such syntax, even more complex ones where type info is more relevant, like

SELECT 1.234 AS a, NULL AS b

  FROM dual

UNION

SELECT NULL AS a, 1234 AS b

  FROM dual;

But it's hard to anticipate in what all contexts this had to be made working, or what implications this might be having on client code.

Anyway, a feature request shouldn't hurt!

Further thoughts?

BR,
 Andreas

SQL Query generated by Hibernate version 5.x.x: 

 select
       varestrom0_.varestr_kode as varestr_1_641_0_,
        varestrom0_.beskr as beskr2_641_0_,
        varestrom0_.edi_varestr_kode as edi_vare3_641_0_
from
        varestrommer varestrom0_
where
        varestrom0_.varestr_kode=?

Which works completely fine.... 

SQL Query generated by Hibernate version 6.x.x:

select
       null,
       v1_0.beskr,
       v1_0.edi_varestr_kode
from
       varestrommer v1_0
where
       v1_0.varestr_kode=?

Which doesn't work and gives SQLGrammarException: could not prepare statement [A syntax error has occurred.]

The primary key here is varestr_kode, this is a char(3) field, and is an assigned key with Hibernate.

We are still using the legacy hbm.xml based mappings rather than annotation based mappings. The mapping for this table is as follows (package names changed):

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd" >
    
<hibernate-mapping>
<class 
    name="com.example.dal.tgprod.domain.Varestrom" 
    table="varestrommer"
    lazy="false"
>
    <meta attribute="class-description" inherit="false">
       @hibernate.class
        table="varestrommer"
    </meta>
    
    <id
        name="varestrKode"
        type="com.example.hibernate.type.TrimmedString"
        column="varestr_kode"
    >
        <meta attribute="field-description">
           @hibernate.id
            generator-class="assigned"
            type="com.example.hibernate.type.TrimmedString"
            column="varestr_kode"
 
        </meta>
        <generator class="assigned" />
    </id>
 
    <property
        name="beskr"
        type="com.example.hibernate.type.TrimmedString"
        column="beskr"
        length="70"
    >
        <meta attribute="use-in-tostring">true</meta>
        <meta attribute="field-description">
           @hibernate.property
            column="beskr"
            length="70"
        </meta>    
    </property>
 
    <property
        name="ediVarestrKode"
        type="com.example.hibernate.type.TrimmedString"
        column="edi_varestr_kode"
        length="5"
    >
        <meta attribute="use-in-tostring">true</meta>
        <meta attribute="field-description">
           @hibernate.property
            column="edi_varestr_kode"
            length="5"
        </meta>    
    </property>
    
    <!-- Associations -->
</class>
</hibernate-mapping>

Since Hibernate 6, the InformixDialect class file has been moved out of Hibernate core to the community provided content. Are there anyone with experience in the combination of Hibernate and Informix here? Have you modified or adapted the InformixDialect class? We are having some problems with Hibernate 6 that may look like something is wrong in the default provided InformixDialect class.

SQL Query generated by Hibernate version 5.x.x: 

 select
       varestrom0_.varestr_kode as varestr_1_641_0_,
        varestrom0_.beskr as beskr2_641_0_,
        varestrom0_.edi_varestr_kode as edi_vare3_641_0_
from
        varestrommer varestrom0_
where
        varestrom0_.varestr_kode=?

Which works completely fine.... 

SQL Query generated by Hibernate version 6.x.x:

select
       null,
       v1_0.beskr,
       v1_0.edi_varestr_kode
from
       varestrommer v1_0
where
       v1_0.varestr_kode=?

Which doesn't work and gives SQLGrammarException: could not prepare statement [A syntax error has occurred.]

The primary key here is varestr_kode, this is a char(3) field, and is an assigned key with Hibernate.

We are still using the legacy hbm.xml based mappings rather than annotation based mappings. The mapping for this table is as follows (package names changed):

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd" >
    
<hibernate-mapping>
<class 
    name="com.example.dal.tgprod.domain.Varestrom" 
    table="varestrommer"
    lazy="false"
>
    <meta attribute="class-description" inherit="false">
       @hibernate.class
        table="varestrommer"
    </meta>
    
    <id
        name="varestrKode"
        type="com.example.hibernate.type.TrimmedString"
        column="varestr_kode"
    >
        <meta attribute="field-description">
           @hibernate.id
            generator-class="assigned"
            type="com.example.hibernate.type.TrimmedString"
            column="varestr_kode"
 
        </meta>
        <generator class="assigned" />
    </id>
 
    <property
        name="beskr"
        type="com.example.hibernate.type.TrimmedString"
        column="beskr"
        length="70"
    >
        <meta attribute="use-in-tostring">true</meta>
        <meta attribute="field-description">
           @hibernate.property
            column="beskr"
            length="70"
        </meta>    
    </property>
 
    <property
        name="ediVarestrKode"
        type="com.example.hibernate.type.TrimmedString"
        column="edi_varestr_kode"
        length="5"
    >
        <meta attribute="use-in-tostring">true</meta>
        <meta attribute="field-description">
           @hibernate.property
            column="edi_varestr_kode"
            length="5"
        </meta>    
    </property>
    
    <!-- Associations -->
</class>
</hibernate-mapping>

Since Hibernate 6, the InformixDialect class file has been moved out of Hibernate core to the community provided content. Are there anyone with experience in the combination of Hibernate and Informix here? Have you modified or adapted the InformixDialect class? We are having some problems with Hibernate 6 that may look like something is wrong in the default provided InformixDialect class.

SQL Query generated by Hibernate version 5.x.x: 

 select
       varestrom0_.varestr_kode as varestr_1_641_0_,
        varestrom0_.beskr as beskr2_641_0_,
        varestrom0_.edi_varestr_kode as edi_vare3_641_0_
from
        varestrommer varestrom0_
where
        varestrom0_.varestr_kode=?

Which works completely fine.... 

SQL Query generated by Hibernate version 6.x.x:

select
       null,
       v1_0.beskr,
       v1_0.edi_varestr_kode
from
       varestrommer v1_0
where
       v1_0.varestr_kode=?

Which doesn't work and gives SQLGrammarException: could not prepare statement [A syntax error has occurred.]

The primary key here is varestr_kode, this is a char(3) field, and is an assigned key with Hibernate.

We are still using the legacy hbm.xml based mappings rather than annotation based mappings. The mapping for this table is as follows (package names changed):

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd" >
    
<hibernate-mapping>
<class 
    name="com.example.dal.tgprod.domain.Varestrom" 
    table="varestrommer"
    lazy="false"
>
    <meta attribute="class-description" inherit="false">
       @hibernate.class
        table="varestrommer"
    </meta>
    
    <id
        name="varestrKode"
        type="com.example.hibernate.type.TrimmedString"
        column="varestr_kode"
    >
        <meta attribute="field-description">
           @hibernate.id
            generator-class="assigned"
            type="com.example.hibernate.type.TrimmedString"
            column="varestr_kode"
 
        </meta>
        <generator class="assigned" />
    </id>
 
    <property
        name="beskr"
        type="com.example.hibernate.type.TrimmedString"
        column="beskr"
        length="70"
    >
        <meta attribute="use-in-tostring">true</meta>
        <meta attribute="field-description">
           @hibernate.property
            column="beskr"
            length="70"
        </meta>    
    </property>
 
    <property
        name="ediVarestrKode"
        type="com.example.hibernate.type.TrimmedString"
        column="edi_varestr_kode"
        length="5"
    >
        <meta attribute="use-in-tostring">true</meta>
        <meta attribute="field-description">
           @hibernate.property
            column="edi_varestr_kode"
            length="5"
        </meta>    
    </property>
    
    <!-- Associations -->
</class>
</hibernate-mapping>

Since Hibernate 6, the InformixDialect class file has been moved out of Hibernate core to the community provided content. Are there anyone with experience in the combination of Hibernate and Informix here? Have you modified or adapted the InformixDialect class? We are having some problems with Hibernate 6 that may look like something is wrong in the default provided InformixDialect class.

Some new findings: Turns out that it Hibernate 6.X is a bit too imprecise.
We are using JBoss EAP 8 (currently 8.0), which bundles hibernate core 6.2.13, and that version seems to have this behavior, while for instance Hibernate 6.5 seems to have fixed this.
I don't think it will be easy to do brain surgery on JBoss to change this version.

JBoss 8.1 (currently in beta) bundles Hibernate 6.6, so should fix the issue. We may decide to wait for that, if it isn't too far away.

SQL Query generated by Hibernate version 5.x.x: 

 select
       varestrom0_.varestr_kode as varestr_1_641_0_,
        varestrom0_.beskr as beskr2_641_0_,
        varestrom0_.edi_varestr_kode as edi_vare3_641_0_
from
        varestrommer varestrom0_
where
        varestrom0_.varestr_kode=?

Which works completely fine.... 

SQL Query generated by Hibernate version 6.x.x:

select
       null,
       v1_0.beskr,
       v1_0.edi_varestr_kode
from
       varestrommer v1_0
where
       v1_0.varestr_kode=?

Which doesn't work and gives SQLGrammarException: could not prepare statement [A syntax error has occurred.]

The primary key here is varestr_kode, this is a char(3) field, and is an assigned key with Hibernate.

We are still using the legacy hbm.xml based mappings rather than annotation based mappings. The mapping for this table is as follows (package names changed):

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd" >
    
<hibernate-mapping>
<class 
    name="com.example.dal.tgprod.domain.Varestrom" 
    table="varestrommer"
    lazy="false"
>
    <meta attribute="class-description" inherit="false">
       @hibernate.class
        table="varestrommer"
    </meta>
    
    <id
        name="varestrKode"
        type="com.example.hibernate.type.TrimmedString"
        column="varestr_kode"
    >
        <meta attribute="field-description">
           @hibernate.id
            generator-class="assigned"
            type="com.example.hibernate.type.TrimmedString"
            column="varestr_kode"
 
        </meta>
        <generator class="assigned" />
    </id>
 
    <property
        name="beskr"
        type="com.example.hibernate.type.TrimmedString"
        column="beskr"
        length="70"
    >
        <meta attribute="use-in-tostring">true</meta>
        <meta attribute="field-description">
           @hibernate.property
            column="beskr"
            length="70"
        </meta>    
    </property>
 
    <property
        name="ediVarestrKode"
        type="com.example.hibernate.type.TrimmedString"
        column="edi_varestr_kode"
        length="5"
    >
        <meta attribute="use-in-tostring">true</meta>
        <meta attribute="field-description">
           @hibernate.property
            column="edi_varestr_kode"
            length="5"
        </meta>    
    </property>
    
    <!-- Associations -->
</class>
</hibernate-mapping>

Since Hibernate 6, the InformixDialect class file has been moved out of Hibernate core to the community provided content. Are there anyone with experience in the combination of Hibernate and Informix here? Have you modified or adapted the InformixDialect class? We are having some problems with Hibernate 6 that may look like something is wrong in the default provided InformixDialect class.