The problem is already described viewtopic.php?f=1&t=997341&start=0

In the generated sql Informix expects actually generated is



which leads to syntax error.

setting:



had no effect. I even removed schema and catalog from the tabe annotation, this caused a different issues : the tablename in the query looked like that same for seting catalog and schema to an empty string.

Versions

* seam 2.1.2
* Hibernate Annotations 3.3.1.GA.CP01
* Hibernate 3.2.4.sp1.cp08
* Hibernate EntityManager 3.3.2.GAhibernate
* Jboss 4.3 (similar to 4.2.3)

Thanks in advance

I got the same problem. I also use the informix-dialect.

Hibernate generates the sql-statement

select ...
from db_name.schema.table

but informix expects (":" between Database-name and table-name)

select ...
from db_name:schema.table


How can I solve this problem? Is there any workaround for this informix-problem.

I fixed it as described here

http://stackoverflow.com/questions/2873 ... talog-name

Thanks for the hack.

It so bad, that Informix is not really supported
in many good software products.
I hope, IBM;/Informix will wake up.