Hi,

What is the process to update a dialect for a specific database? Specifically:

1) If a new version of a DB is available that requires changes to the dialect, how are these changes submitted?

2) Does Hibernate provide a test suite/test harness to ensure that the dialect is compatible with all versions of Hibernate to prevent regressions?

3) What kind of problems would occur if dialect files for a specific database did not reflect its complete configuration? (i.e. some features were omitted)

Thanks for your time.

1. Like all other reasonable cases, through our issue tracking system.

2. Hibernate has a test suite in the regular download. We also provide commercial certification for JDBC drivers/dialect combinations.

3. That's why the dialects can be customized, subclassed, and extended by anyone. It's an open system.

In fact.... I've found some issues with the new JDBC driver for Informix Database, and some incompatibilities with Hibernate 2.

I'd like to post them, but I'm not sure how to do that. A Jira issue? A simple forum request?

By the way, the problem is this: a boolean-type column is mapped as smallint in Informix (no bit or boolean type in Ifx), a nullable boolean column works fine with Ifx JDBC Driver 2.x

With the new JDBC Driver 3, updating a null value throws an SQL Exception, saying that 'cannot convert from boolean to smallint'.
Guess it's a dialect problem.

Another thing: blob types are not covered by InformixDialect packaged with Hibernate. I extended the Dialect class and put the BLOB type, how can I 'contribute' this in the official Dialect?

Thanks for all your efforts!
Stefano

I dont think that hibernate2 will still be maintained.
Apart from that you can certainly create your own Dialect class.

Thanks for the replies. What is the cost for commercial certification for a JDBC driver/dialect combination?


Thanks.