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

[Steve Ebersole (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-923?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steve Ebersole closed HHH-923.
------------------------------


Closing stale resolved issues

> 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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira