Hi,

I make the first steps with Hibernate.
I use Myeclipse for the steps, because the integration
of hibernate is for a new user quit helpfull.

I managed to create of the DAO/POJO classes I need, (looks fine),
but when I use HQL-Editor,
I get an syntax-error at the generated FROM part.

the Naming is: "FROM server.database.table" is wrong

But informix need a colon after the database-name "FROM server:databse.table"
(or even better) FROM database.table (even FROM table would be sufficent)

I do not understand, wether this is an Informix-dialect or an hibernate-problem.

Qestion:
- do I see a pseudo-code or the real SQL-Code which will be used for informix?
- is this a problem of the informix-dialect ?
- how can I influence i.e. the generation of the from-part ?
- can I supress the server-part in the FROM clause ?

Yours Bernhard / Berlin

Hi,

as I understand now, this is a problem with the informix-integration,
not a problem with hibernate or MySql itself.

There is a patch für 3.3-version at teh IIUG-Homepage.
If the 3.6-Version has this patch included, I don´t know till now.

Yours Bernhard