[hibernate-issues] [Hibernate-JIRA] Created: (HHH-2745) NullPointerException when eager fetching joined many-to-many with native SQL query
NullPointerException when eager fetching joined many-to-many with native SQL query
----------------------------------------------------------------------------------
Key: HHH-2745
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2745
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.1
Environment: Hibernate 3.2.1, DB2
Reporter: Mihail Fridliand
NullPointerException when joining many-to-many assoziation with native SQL query:
java.lang.NullPointerException
at
org.hibernate.loader.custom.sql.SQLQueryParser.resolveProperties(SQLQueryParser.java:182)
at
org.hibernate.loader.custom.sql.SQLQueryParser.resolveCollectionProperties(SQLQueryParser.java:135)
at
org.hibernate.loader.custom.sql.SQLQueryParser.substituteBrackets(SQLQueryParser.java:98)
at org.hibernate.loader.custom.sql.SQLQueryParser.process(SQLQueryParser.java:51)
at org.hibernate.loader.custom.sql.SQLCustomQuery.<init>(SQLCustomQuery.java:110)
at
org.hibernate.engine.query.NativeSQLQueryPlan.<init>(NativeSQLQueryPlan.java:43)
at
org.hibernate.engine.query.QueryPlanCache.getNativeSQLQueryPlan(QueryPlanCache.java:114)
at org.hibernate.impl.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:444)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:351)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1291)
The SQLQueryReturnProcessor ignores many-to-many assoziations:
private void addCollection(String role, String alias, Map propertyResults) {
SQLLoadableCollection collectionPersister = ( SQLLoadableCollection )
factory.getCollectionPersister( role );
alias2CollectionPersister.put( alias, collectionPersister );
String suffix = generateCollectionSuffix();
log.trace( "mapping alias [" + alias + "] to collection-suffix [" +
suffix + "]" );
alias2CollectionSuffix.put( alias, suffix );
collectionPropertyResultMaps.put( alias, propertyResults );
if ( collectionPersister.isOneToMany() ) {
SQLLoadable persister = ( SQLLoadable ) collectionPersister.getElementPersister();
addPersister( alias, filter( propertyResults ), persister );
}
}
Mapping of a many-to-many:
<hibernate-mapping>
<class name="A" table="A" schema="TEST" >
<set name="manyToMany" inverse="true" table="AC"
>
<key>
<column name="A_OID" not-null="true" />
</key>
<many-to-many class="C">
<column name="C_OID" not-null="true" />
</many-to-many>
</set>
</class>
<class name="C" table="C" schema="TEST">
</class>
<resultset name="AandC">
<return alias="a" class="A"/>
<return-join alias="c" property="a.manyToMany"/>
</resultset>
<sql-query name="getAandC" resultset-ref="AandC" >
<![CDATA[
select DISTINCT {a.*},{c.*} from A a join AC ac on a.OID = ac.A_OID join C c
on c.C_OID=ac.C_OID
]]>
</sql-query>
</hibernate-mapping>
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira