[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-3915) Missing a table association when using nested criteria

[Chris Rose (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3915?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=33178#action_33178 ] 

Chris Rose commented on HHH-3915:
---------------------------------

Here's the complete exception trace:

org.hibernate.exception.SQLGrammarException: could not execute query
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
	at org.hibernate.loader.Loader.doList(Loader.java:2216)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
	at org.hibernate.loader.Loader.list(Loader.java:2099)
	at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569)
	at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
	at org.hibernate.impl.CriteriaImpl$Subcriteria.list(CriteriaImpl.java:458)
	at com.aciworldwide.ecourier.utility.hibernate.HibernateUtility.list(HibernateUtility.java:39)
	at com.planet.core360.djp.hibernate.HibernateDSM.loadRawDataProperties(HibernateDSM.java:120)
	at com.planet.core360.djp.hibernate.test.HibernateDSMTest.testLoadRawDataProperties(HibernateDSMTest.java:68)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at junit.framework.TestCase.runTest(TestCase.java:164)
	at com.aciworldwide.ecourier.utility.testsuite.EcourierTestCase.runTest(EcourierTestCase.java:431)
	at junit.framework.TestCase.runBare(TestCase.java:130)
	at junit.framework.TestResult$1.protect(TestResult.java:106)
	at junit.framework.TestResult.runProtected(TestResult.java:124)
	at junit.framework.TestResult.run(TestResult.java:109)
	at junit.framework.TestCase.run(TestCase.java:120)
	at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130)
	at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
Caused by: java.sql.SQLException: ORA-00904: "RAWDATA1_"."JOB_ID": invalid identifier

	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:158)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185)
	at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:592)
	at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:1048)
	at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:635)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1161)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3114)
	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3156)
	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
	at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
	at org.hibernate.loader.Loader.doQuery(Loader.java:674)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
	at org.hibernate.loader.Loader.doList(Loader.java:2213)
	... 26 more



> Missing a table association when using nested criteria
> ------------------------------------------------------
>
>                 Key: HHH-3915
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3915
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: query-criteria
>    Affects Versions: 3.2.6
>         Environment: Oracle 10g, Java 6
>            Reporter: Chris Rose
>            Priority: Critical
>         Attachments: DsmRawDataPropertyValue.hbm.xml, DsmRawDataValue.hbm.xml
>
>
> I get an invalid query using this criteria:
> Criteria crit = session.createCriteria (DsmRawDataPropertyValue.class)
>                 .createCriteria ("rawData", "rawData")
>                 .add (Restrictions.eq ("rawData.jobId", rawDataJobId));
> Here's the SQL:
> Hibernate: 
>     select
>         this_.raw_data_id as raw1_7_0_,
>         this_.property_name as property2_7_0_,
>         this_.property_value as property3_7_0_ 
>     from
>         core360a.dsm_raw_data_property this_ 
>     where
>         rawdata1_.job_id=?
> The mapping files are attached.  Ignore, please, the @___@ schema name; those are swapped out by an interceptor.

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