[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-923) Inappropriate generation of query using HQL

Inappropriate generation of query using HQL ------------------------------------------- Key: HHH-923 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-923 Project: Hibernate Core Issue Type: Bug Components: core Environment: Hibernate 3.0.5, Progress 9.1D database Reporter: Medhavi Gupta Attachments: Bin.hbm.xml, hibernate.cfg.xml I am trying to talk to Progress Database using Hibernate. Everything goes fine(taking connection etc.) till it meets the query part. In progress if you are not the admin then you have to use pub prefixing table name. So if you have table called employee then you will have access to it only if you specify it as pub.employee. So for this case what I did is I specified it in the schema property of the hibernate cfg file. When I try to run my application it gives me error messages like these: [java] Hibernate: select bin0_.BinName as col_0_0_ from .pub.Bin bin0_ [java] org.hibernate.exception.SQLGrammarException: could not execute query [java] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:59) [java] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) [java] at org.hibernate.loader.Loader.doList(Loader.java:1596) [java] at org.hibernate.loader.Loader.list(Loader.java:1577) [java] at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:395) [java] at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271) [java] at org.hibernate.impl.SessionImpl.list(SessionImpl.java:844) [java] at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74) [java] at showWarehouse.main(Unknown Source) [java] Caused by: java.sql.SQLException: [JDBC Progress Driver]:Syntax error (7587) [java] at com.progress.sql.jdbc.JdbcProgress.createSQLException(JdbcProgress.java:6626) [java] at com.progress.sql.jdbc.JdbcProgress.standardError(JdbcProgress.java:6801) [java] at com.progress.sql.jdbc.JdbcProgress.SQLUTFPrepare(JdbcProgress.java:4610) [java] at com.progress.sql.jdbc.JdbcProgressConnection.prepareStatement(JdbcProgressConnection.java:499) [java] at com.progress.sql.jdbc.JdbcProgressConnection.prepareStatement(JdbcProgressConnection.java:466) [java] at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:396) [java] at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:334) [java] at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:88) [java] at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1162) [java] at org.hibernate.loader.Loader.doQuery(Loader.java:390) [java] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218) [java] at org.hibernate.loader.Loader.doList(Loader.java:1593) [java] ... 6 more [java] Session closed [java] org.hibernate.exception.SQLGrammarException: could not execute query [java] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:59) [java] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) [java] at org.hibernate.loader.Loader.doList(Loader.java:1596) [java] at org.hibernate.loader.Loader.list(Loader.java:1577) [java] at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:395) [java] at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271) [java] at org.hibernate.impl.SessionImpl.list(SessionImpl.java:844) [java] at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74) [java] at showWarehouse.main(Unknown Source) [java] Caused by: java.sql.SQLException: [JDBC Progress Driver]:Syntax error (7587) [java] at com.progress.sql.jdbc.JdbcProgress.createSQLException(JdbcProgress.java:6626) [java] at com.progress.sql.jdbc.JdbcProgress.standardError(JdbcProgress.java:6801) [java] at com.progress.sql.jdbc.JdbcProgress.SQLUTFPrepare(JdbcProgress.java:4610) [java] at com.progress.sql.jdbc.JdbcProgressConnection.prepareStatement(JdbcProgressConnection.java:499) [java] at com.progress.sql.jdbc.JdbcProgressConnection.prepareStatement(JdbcProgressConnection.java:466) [java] at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:396) [java] at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:334) [java] at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:88) [java] at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1162) [java] at org.hibernate.loader.Loader.doQuery(Loader.java:390) [java] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218) [java] at org.hibernate.loader.Loader.doList(Loader.java:1593) [java] ... 6 more [java] Exception in thread "main" [java] Java Result: 1 I guess the problem is because i is appending on its own a dot before pub. Regards, Medhavi.