Hibernate SQL Syntax
Posted in 2007
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.informix.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.InformixDialect</property> </session-factory> </hibernate-configuration>