Help,

In order to fix a previous issue with Hibernate 3.5.x we had to put back-ticks or brackets around column names that were also reserved words.
e.g. @Column(name = "`desc`") or @Column(name = "[desc]")

If we didn't use the back-ticks or brackets then the alias no longer gets pre-fixed and an ambiguous column error ensues.
e.g. select x.end, y.end from ... would become select end, end from...

However, after adding the back-ticks the select now works, but inserts fail with a syntax error because of the quotes generated.
e.g. insert into mytable ("end", othercol) values ...

This appears to be a problem with Hibernate and unless resolved we can't use Hibernate 3.5.x with Informix and may have to abandon Hibernate - not desirable.

For more information see my previous post: "Errors with generated SQL after moving from 3.2.1 to 3.5.2"

Any ideas very much appreciated.

Regards, Martin.

Just check the code of appropriate SQL dialect class in Hibernate.

Hi Martin,

I'm encountering the same problem as you, did you find a solution?