[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-1101) associations join fetched in HQL without owner being selected

[Steve Ebersole (JIRA)]

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

Steve Ebersole closed HHH-1101.
-------------------------------


Closing stale resolved issues

> associations join fetched in HQL without owner being selected
> -------------------------------------------------------------
>
>                 Key: HHH-1101
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1101
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 3.0.5, 3.1 rc2
>            Reporter: Emmanuel Bernard
>            Assignee: Steve Ebersole
>            Priority: Minor
>             Fix For: 3.1
>
>         Attachments: fetchselect.zip
>
>
> select parent from Child c left join *fetch* c.parent parent
> throw an exception similar to
> org.hibernate.exception.SQLGrammarException: could not execute query
> 	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65)
> 	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
> 	at org.hibernate.loader.Loader.doList(Loader.java:2150)
> 	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2026)
> 	at org.hibernate.loader.Loader.list(Loader.java:2021)
> 	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369)
> 	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:298)
> 	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1020)
> 	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
> 	at org.hibernate.test.annotations.emmanuel.SonicTest.testQuery(SonicTest.java:104)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 	at org.hibernate.test.annotations.TestCase.runTest(TestCase.java:61)
> 	at com.intellij.rt.execution.junit2.JUnitStarter.main(JUnitStarter.java:31)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 	at com.intellij.rt.execution.application.AppMain.main(AppMain.java:86)
> Caused by: java.sql.SQLException: Column not found: SONIC1_3_
> 	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
> 	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
> 	at org.hsqldb.jdbc.jdbcResultSet.findColumn(Unknown Source)
> 	at org.hsqldb.jdbc.jdbcResultSet.getInt(Unknown Source)
> 	at org.hibernate.type.IntegerType.get(IntegerType.java:28)
> 	at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:113)
> 	at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:102)
> 	at org.hibernate.loader.Loader.getKeyFromResultSet(Loader.java:1088)
> 	at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:553)
> 	at org.hibernate.loader.Loader.doQuery(Loader.java:689)
> 	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:223)
> 	at org.hibernate.loader.Loader.doList(Loader.java:2147)

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