[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2745) NullPointerException when eager fetching joined many-to-many with native SQL query

[Gail Badner (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2745?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_28548 ] 

Gail Badner commented on HHH-2745:
----------------------------------

Please attach a runnable test case (Java + mapping).

> 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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira