Hi

I have a minor compatibility issue between hibernate and Informix.

The Informix dialect is using the SQL statement below, where I would prefer one without the "first ?" (but rather "first 1", for example). I see that DB2400 dialect does not try to use a parameter when generating the first, can the same not be done for Informix?

(i.e.

public String getLimitString(String querySelect, boolean hasOffset, int limit) {
if (hasOffset) throw new UnsupportedOperationException("informix has no offset");
return new StringBuffer( querySelect.length()+8 )
.append(querySelect)
.insert( getAfterSelectInsertPoint(querySelect), " first " +limit )
.toString();
}


)
Hibernate version: 2.1.7
Name and version of the database you are using:IBM Informix JDBC Driver for IBM Informix Dynamic Server 7.31.FD7

The generated SQL (show_sql=true):select first ? this.tt_type as tt_type0_, this.tt_group as tt_group0_, this.tt_lang as tt_lang0_, this.tt_text as tt_text0_ from tt_type_text this where this.tt_lang=? and this.tt_group=? and this.tt_type=?

Take a look at http://www.hibernate.org/221.html there is a lot of stuff about informix there.

I did look at that page, the one thing that I noticed there was

"Use new InformixDialect, submitted to JIRA as a patch HB-1167. Note in particular that in our tests we turned off all the "limit" functionality in the dialect, we haven't yet tracked down why this didn't work in our environment."

I looked also at CVS and saw that the latest revision 1.15 (Dec 24) has the code I want in it. Do you know when this will be included in a hibernate release?

We do not give any schedule, but the next release is expected quite soon.

Thanks

I've created my own subclass of InformixDialect for now... and will use the official one when it matches what I want!