[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2225?page=c... ] Christian Bauer commented on HHH-2225: -------------------------------------- You can download CaveatEmptor stuff in a few days with the complete mappings and this test. -- 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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2225?page=c... ] Mihail Fridliand commented on HHH-2225: --------------------------------------- This seems to be a general problem when using components in the native SQL. Suppose, the have class "A" containing a component class "Component" containing a collection of "B" public class A { private Long oid; private Component comp = new Component(); public Component getComp() {return comp;} public void setComp(Component comp) {this.comp = comp;} public Long getOid() { return oid;} public void setOid(Long oid) {this.oid = oid;} } public class Component { private Set collection = new HashSet(0); public Set getCollection() { return collection;} public void setCollection(Set collection) { this.collection = collection;} } public class B { private Long oid; public Long getOid() { return oid;} public void setOid(Long oid) {this.oid = oid;} } the mappings test1.hbm.xml: <hibernate-mapping> <class name="A" table="A" > <id name="oid" type="java.lang.Long"> <column name="OID" /> <generator class="assigned" /> </id> <component name="comp" class="Component"> <set name="collection" inverse="true" cascade="all"> <key> <column name="A_OID" not-null="true" /> </key> <one-to-many class="B" /> </set> </component> </class> <class name="B" table="B" > <id name="oid" type="java.lang.Long"> <column name="OID" /> <generator class="assigned" /> </id> </class> <resultset name="AandB"> <return alias="a" class="A"/> <return-join alias="ac" property="a.comp"/> <return-join alias="b" property="ac.collection"/> </resultset> <sql-query name="getAandB" resultset-ref="AandB" > <![CDATA[ select DISTINCT {a.*},{b.*} from A a join B b on a.OID = b.A_OID ]]> </sql-query> </hibernate-mapping> For this simple case I get a NPE java.lang.NullPointerException at org.hibernate.loader.custom.sql.SQLQueryReturnProcessor.processJoinReturn(SQLQueryReturnProcessor.java:434) at org.hibernate.loader.custom.sql.SQLQueryReturnProcessor.processReturn(SQLQueryReturnProcessor.java:338) at org.hibernate.loader.custom.sql.SQLQueryReturnProcessor.process(SQLQueryReturnProcessor.java:148) at org.hibernate.loader.custom.sql.SQLCustomQuery.<init>(SQLCustomQuery.java:64) 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) at com.dcx.ivkmds.fwk.pc.hibernate.HibernateUtil.rebuildSessionFactory(HibernateUtil.java:191) at com.dcx.ivkmds.fwk.pc.hibernate.HibernateUtil.<clinit>(HibernateUtil.java:59) The NPE is caused by the following code in the SQLQueryReturnProcessor class: private void processJoinReturn(NativeSQLQueryJoinReturn fetchReturn) { ..... // If this return's alias has not been processed yet, do so b4 further processing of this return if ( !alias2Persister.containsKey( ownerAlias ) ) { NativeSQLQueryNonScalarReturn ownerReturn = ( NativeSQLQueryNonScalarReturn ) alias2Return.get(ownerAlias); processReturn( ownerReturn ); } SQLLoadable ownerPersister = ( SQLLoadable ) alias2Persister.get( ownerAlias ); Type returnType = ownerPersister.getPropertyType( fetchReturn.getOwnerProperty() ); ..... When the property ac.collection is processed, there is no for the component Component (ownerAlias = "ac"). Therefore processReturn(ownerReturn) is invoked. But processReturn ignores component types. Then alias2Persister.get(ownerAlias) still have no entry for the ownerAlias => ownerPersister is null => NullPointerException at the next line. If I change the resultset to (my first try) <resultset name="AandB"> <return alias="a" class="A"/> <return-join alias="b" property="a.comp.collection"/> </resultset> and try to relate to the collection of B's directly, I get org.hibernate.HibernateException: Owner alias [a.comp] is unknown for alias [b] at org.hibernate.loader.custom.sql.SQLQueryReturnProcessor.processJoinReturn(SQLQueryReturnProcessor.java:424) at org.hibernate.loader.custom.sql.SQLQueryReturnProcessor.processReturn(SQLQueryReturnProcessor.java:338) at org.hibernate.loader.custom.sql.SQLQueryReturnProcessor.process(SQLQueryReturnProcessor.java:148) at org.hibernate.loader.custom.sql.SQLCustomQuery.<init>(SQLCustomQuery.java:64) What is wrong ?? -- 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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2225?page=c... ] shailesh mangal commented on HHH-2225: -------------------------------------- Ran into the same issue, all I need is a count from another table. Is there any other way to do this? Will interceptor be a good choice? @Formula("(select count(*) from attachment a where a.item_id = id and a.item_type='xyz')") private Integer attachmentCount = null; -- 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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2225?page=c... ] Chris Nash commented on HHH-2225: --------------------------------- I've ran into this as well. The main problem for me is the sort of mapping that needs a formula is an ideal candidate for a native SQL query to optimize. I understand no progress has been made on this issue for three years, but is there even a workaround? The object I'm currently having difficulties with has other collections in it, so I'd much rather use query.addEntity() for Hibernate to map the fields and lazy-load the collections, than have to resort to straight JDBC. -- 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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2225?page=c... ] Rod Hoover commented on HHH-2225: --------------------------------- Sorry Hibernate team, but I agree with these frustrated users. Maybe formula is a little-used feature, but if you're using it, this bug is a total blocker. This needs to not be a minor bug. -- 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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2225?page=c... ] Maxym Pendyshchuk commented on HHH-2225: ---------------------------------------- few days gone with no success with the same issue... Writing "The SQL fragment can be as complex as you want and even include subselects." in documentation now looks like a joke, I tried both HQL and native sql as simple as possible, and all the time I get NullPointerException... Is here any progress? Any plans? -- 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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2225?page=c... ] Strong Liu reassigned HHH-2225: ------------------------------- Assignee: Strong Liu -- 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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2225?page=c... ] Strong Liu commented on HHH-2225: --------------------------------- meanwhile there are some workarounds you may want to give them a try: {code} @Entity @Table(name = "ALL_TABLES") public class AllTables { @Id @Column(name = "TABLE_NAME", nullable = false) private String tableName; @Formula(value = "(SYSDATE())") private String daysOld; //getters and setters } {code} {code} String sql = "select table_name , sysdate() from all_tables where table_name = 'AUDIT_ACTIONS' "; SQLQuery q = s.createSQLQuery( sql ).addEntity( "t",AllTables.class ); {code} workaround 1: {code} String sql = "select table_name as t_name, sysdate() as t_time from all_tables where table_name = 'AUDIT_ACTIONS' "; @SqlResultSetMapping(name = "all", entities = @EntityResult(entityClass = AllTables.class, fields = { @FieldResult(name = "tableName", column = "t_name"), @FieldResult(name = "daysOld", column = "t_time") })) {code} workaround 2: {code} String sql = "select table_name as t_name, sysdate() as t_time from all_tables where table_name = 'AUDIT_ACTIONS' "; q.addRoot( "alias23", AllTables.class ) .addProperty( "tableName", "t_name" ) .addProperty( "daysOld", "t_time" ); {code} workaround 3: {code} String sql = "select t.table_name as {t.tableName}, sysdate() as {t.daysOld} from all_tables t where t.table_name = 'AUDIT_ACTIONS' "; {code} -- 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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2225?page=c... ] Tomáš Šafařík updated HHH-2225: ------------------------------- Attachment: formula-test.zip -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2225?page=c... ] Tomáš Šafařík edited comment on HHH-2225 at 7/22/11 7:06 AM: ------------------------------------------------------------- Hi, This bug is marked like duplicate for HHH-2536, but still it's possible to get related failure. This bug appears in both 3.6.5 and 4.0.0.Beta1 versions. Using native sql with entity (addEntity), which has formula property, causes this exception: ------------------------------------------------------------------------------- Test set: org.hibernate.test.formula.FormulaWithNativeSqlTest ------------------------------------------------------------------------------- Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 0.991 sec <<< FAILURE! testBasicUsage(org.hibernate.test.formula.FormulaWithNativeSqlTest) Time elapsed: 0.966 sec <<< ERROR! java.lang.NullPointerException at org.hibernate.loader.DefaultEntityAliases.intern(DefaultEntityAliases.java:192) at org.hibernate.loader.DefaultEntityAliases.getSuffixedPropertyAliases(DefaultEntityAliases.java:150) at org.hibernate.loader.DefaultEntityAliases.determinePropertyAliases(DefaultEntityAliases.java:92) at org.hibernate.loader.DefaultEntityAliases.<init>(DefaultEntityAliases.java:64) at org.hibernate.loader.ColumnEntityAliases.<init>(ColumnEntityAliases.java:42) at org.hibernate.loader.custom.sql.SQLQueryReturnProcessor.generateCustomReturns(SQLQueryReturnProcessor.java:196) at org.hibernate.loader.custom.sql.SQLCustomQuery.<init>(SQLCustomQuery.java:151) at org.hibernate.engine.query.spi.NativeSQLQueryPlan.<init>(NativeSQLQueryPlan.java:65) at org.hibernate.engine.query.spi.QueryPlanCache.getNativeSQLQueryPlan(QueryPlanCache.java:156) at org.hibernate.internal.AbstractSessionImpl.getNativeSQLQueryPlan(AbstractSessionImpl.java:218) at org.hibernate.internal.AbstractSessionImpl.list(AbstractSessionImpl.java:224) at org.hibernate.internal.SQLQueryImpl.list(SQLQueryImpl.java:156) at org.hibernate.test.formula.FormulaWithNativeSqlTest.testBasicUsage(FormulaWithNativeSqlTest.java:53) 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:168) at junit.framework.TestCase.runBare(TestCase.java:134) at junit.framework.TestResult$1.protect(TestResult.java:110) at junit.framework.TestResult.runProtected(TestResult.java:128) at junit.framework.TestResult.run(TestResult.java:113) at junit.framework.TestCase.run(TestCase.java:124) at junit.framework.TestSuite.runTest(TestSuite.java:232) at junit.framework.TestSuite.run(TestSuite.java:227) at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:83) at org.apache.maven.surefire.junit4.JUnit4TestSet.execute(JUnit4TestSet.java:35) at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:146) at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:97) 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 org.apache.maven.surefire.booter.ProviderFactory$ClassLoaderProxy.invoke(ProviderFactory.java:103) at $Proxy0.invoke(Unknown Source) at org.apache.maven.surefire.booter.SurefireStarter.invokeProvider(SurefireStarter.java:145) at org.apache.maven.surefire.booter.SurefireStarter.runSuitesInProcess(SurefireStarter.java:87) at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:69) I've attached test file (https://hibernate.onjira.com/secure/attachment/16139/formula-test.zip) for this bug. was (Author: tomas11): Hi, This bug is marked like duplicate for HHH-2536, but still it's possible to get related failure. This bug appears in both 3.6.5 and 4.0.0.Beta1 versions. Using native sql with entity (addEntity), which has formula property, causes this exception: ------------------------------------------------------------------------------- Test set: org.hibernate.test.formula.FormulaWithNativeSqlTest ------------------------------------------------------------------------------- Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 0.991 sec <<< FAILURE! testBasicUsage(org.hibernate.test.formula.FormulaWithNativeSqlTest) Time elapsed: 0.966 sec <<< ERROR! java.lang.NullPointerException at org.hibernate.loader.DefaultEntityAliases.intern(DefaultEntityAliases.java:192) at org.hibernate.loader.DefaultEntityAliases.getSuffixedPropertyAliases(DefaultEntityAliases.java:150) at org.hibernate.loader.DefaultEntityAliases.determinePropertyAliases(DefaultEntityAliases.java:92) at org.hibernate.loader.DefaultEntityAliases.<init>(DefaultEntityAliases.java:64) at org.hibernate.loader.ColumnEntityAliases.<init>(ColumnEntityAliases.java:42) at org.hibernate.loader.custom.sql.SQLQueryReturnProcessor.generateCustomReturns(SQLQueryReturnProcessor.java:196) at org.hibernate.loader.custom.sql.SQLCustomQuery.<init>(SQLCustomQuery.java:151) at org.hibernate.engine.query.spi.NativeSQLQueryPlan.<init>(NativeSQLQueryPlan.java:65) at org.hibernate.engine.query.spi.QueryPlanCache.getNativeSQLQueryPlan(QueryPlanCache.java:156) at org.hibernate.internal.AbstractSessionImpl.getNativeSQLQueryPlan(AbstractSessionImpl.java:218) at org.hibernate.internal.AbstractSessionImpl.list(AbstractSessionImpl.java:224) at org.hibernate.internal.SQLQueryImpl.list(SQLQueryImpl.java:156) at org.hibernate.test.formula.FormulaWithNativeSqlTest.testBasicUsage(FormulaWithNativeSqlTest.java:53) 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:168) at junit.framework.TestCase.runBare(TestCase.java:134) at junit.framework.TestResult$1.protect(TestResult.java:110) at junit.framework.TestResult.runProtected(TestResult.java:128) at junit.framework.TestResult.run(TestResult.java:113) at junit.framework.TestCase.run(TestCase.java:124) at junit.framework.TestSuite.runTest(TestSuite.java:232) at junit.framework.TestSuite.run(TestSuite.java:227) at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:83) at org.apache.maven.surefire.junit4.JUnit4TestSet.execute(JUnit4TestSet.java:35) at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:146) at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:97) 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 org.apache.maven.surefire.booter.ProviderFactory$ClassLoaderProxy.invoke(ProviderFactory.java:103) at $Proxy0.invoke(Unknown Source) at org.apache.maven.surefire.booter.SurefireStarter.invokeProvider(SurefireStarter.java:145) at org.apache.maven.surefire.booter.SurefireStarter.runSuitesInProcess(SurefireStarter.java:87) at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:69) I've attached test file for this bug. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2225?page=c... ] Tomáš Šafařík edited comment on HHH-2225 at 7/22/11 7:12 AM: ------------------------------------------------------------- Added test case for NPE caused by loading entity with formula through native sql query. was (Author: tomas11): NPE caused by loading entity with formula through native sql query. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2225?page=c... ] Strong Liu commented on HHH-2225: --------------------------------- https://issues.jboss.org/browse/JBPAPP-6571 -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira