Problem with eclipse 3.2.2 plugin 'Hibernate HQL editor' (Hibernate
Tools 3.2.0.beta9a) and IDS 10.00 UC6
----------------------------------------------------
org.hibernate.exception.SQLGrammarException ...

the ourput from Hibernate Dynamic SQL Preview:
SQL #0 types: string, string
-----------------
select
state0_.code as col_0_0_,
state0_.sname as col_1_0_
from
stores.informix.state state0_
------------------

What is to be done in the 'hibernate.cfg.xml' for producing query string
in Informix dialect (select * from stores:informix.state) ??

Any idea?

--
my hibernate.cfg.xml
.................
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property
name="hibernate.bytecode.use_reflection_optimizer" >false</property>
<property
name="hibernate.connection.driver_class">com.infor mix.jdbc.IfxDriver</property>
<property name="hibernate.connection.password">secret</property>
<property
name="hibernate.connection.url">jdbc:informix-sqli://localhost:1526/stores:informixserver=myserver</property>
<property name="hibernate.connection.username">dbuser</property>
<property
name="hibernate.dialect">org.hibernate.dialect.Inf ormixDialect</property>
</session-factory>
</hibernate-configuration>