December 2006 - hibernate-issues - Jboss List Archives

[Hibernate-JIRA] Commented: (HB-655) Oracle limitation: large "where x in (....)'

by Emmanuel Bernard (JIRA)

[ http://opensource.atlassian.com/projects/hibernate/browse/HB-655?page=com... ] Emmanuel Bernard commented on HB-655: ------------------------------------- the query parser of HB 2 was a PITA to maintain > Oracle limitation: large "where x in (....)' > -------------------------------------------- > > Key: HB-655 > URL: http://opensource.atlassian.com/projects/hibernate/browse/HB-655 > Project: Hibernate2 > Type: Improvement > Components: core > Versions: 2.1.1 > Environment: Hibernate 2.1.1 > Oracle 8i > Reporter: Christian Gruber > Assignee: Emmanuel Bernard > > > Hello! > There is a problem with queries with named parameters that consist of big lists with Oracle. An example: > Collection idList = new LinkedList(); > for (int i=0; i<1001; i++) { > idList.add(new Integer(i)); > } > Query query = session.createQuery("from Geneticelem as geneticelem where geneticelem.id in (:ids)"); > query.setParameterList("ids", idList, Hibernate.INTEGER); > Iterator geneticelems = query.iterate(); > This code results in an ORA-01795 exception, because not more than 1000 elements are allowed for "in". > In OJB, this is solved by splitting the "in" condition is split up in chunks: http://db.apache.org/ojb/api/org/apache/ojb/broker/query/Criteria.html#ad... > Can something like this also be implemented in Hibernate? I know, it's a limitation that will rarely be encountered, but still it's a limitation. > Thanks, > Christian -- 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

17 years, 6 months

1
0
0 / 0

[Hibernate-JIRA] Commented: (ANN-332) Using an @OneToMany/ManyToMany to hbm mapped class causes error.

by Emmanuel Bernard (JIRA)

[ http://opensource.atlassian.com/projects/hibernate/browse/ANN-332?page=co... ] Emmanuel Bernard commented on ANN-332: -------------------------------------- User questions should be posted to http://forum.hibernate.org > Using an @OneToMany/ManyToMany to hbm mapped class causes error. > ---------------------------------------------------------------- > > Key: ANN-332 > URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-332 > Project: Hibernate Annotations > Type: Bug > Components: binder > Versions: 3.1beta8 > Environment: hibernate 3.1 > hibernate-annotations 3.1-beta8 > Reporter: Chris Rudd > Attachments: mappings.tar.gz > > > Using an OneToMany/ManyToMany relationship to hbm mapped class from an annotated class causes error. If both classes are mapped the same way (annotated or hbm) this works fine. Also using a ManyToOne or OneToOne relationship works correctly. > Stack Trace : > org.hibernate.MappingException: Could not determine type for: mappings.HbmMapped, for columns: [org.hibernate.mapping.Column(elt)] > at org.hibernate.mapping.SimpleValue.getType(SimpleValue.java:266) > at org.hibernate.mapping.SimpleValue.isValid(SimpleValue.java:253) > at org.hibernate.mapping.Collection.validate(Collection.java:262) > at org.hibernate.cfg.Configuration.validate(Configuration.java:988) > at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1169) > at mappings.MappingTest.testOneToMany(MappingTest.java:113) > 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:585) > at org.testng.internal.MethodHelper.invokeMethod(MethodHelper.java:536) > at org.testng.internal.Invoker.invokeMethod(Invoker.java:395) > at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:672) > at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:92) > at org.testng.TestRunner.privateRun(TestRunner.java:624) > at org.testng.TestRunner.run(TestRunner.java:515) > at org.testng.SuiteRunner.privateRun(SuiteRunner.java:221) > at org.testng.SuiteRunner.run(SuiteRunner.java:147) > at org.testng.eclipse.runner.RemoteTestNG.run(RemoteTestNG.java:98) > at org.testng.eclipse.runner.RemoteTestNG.main(RemoteTestNG.java:138) -- 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

17 years, 6 months

1
0
0 / 0

[Hibernate-JIRA] Created: (EJB-258) Flushing EntityManager again @PostPersist caused duplicate insert SQL

by Yau ML (JIRA)

Flushing EntityManager again @PostPersist caused duplicate insert SQL --------------------------------------------------------------------- Key: EJB-258 URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-258 Project: Hibernate Entity Manager Type: Bug Components: EntityManager Versions: 3.2.1 Environment: Derby 10.2.1.6 Reporter: Yau ML I'm simulating cascade persist, flushing the EntityManager again @PostPersist of one entity to persist another entity caused duplicate insert SQL generated for the first entity. -- 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

17 years, 6 months

2
1
0 / 0

[Hibernate-JIRA] Updated: (HHH-1902) Alias Problem... Hibernate is replacing our alias at one place but not at another place

by Max Rydahl Andersen (JIRA)

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1902?page=all ] Max Rydahl Andersen updated HHH-1902: ------------------------------------- Version: 3.2.1 updated since the test also fails on 3.2 > Alias Problem... Hibernate is replacing our alias at one place but not at another place > --------------------------------------------------------------------------------------- > > Key: HHH-1902 > URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1902 > Project: Hibernate3 > Type: Bug > Components: query-hql > Versions: 3.2.1, 3.0.3 > Environment: Hibernate 3.0.3 > Database Platform : MSSQL Server 2000 > Reporter: Paras Dhawan > Attachments: testhibernate.rar > > > I have a query which contains a sub query in the select list... I have defined an alias of the sub query as _sqry1 now I am putting an Order By clause in the query.... Order By is on the result of the sub query and I have given the alias of the sub query in the Order By clause > My Query is which i am giving to Hibernate is > SELECT (SELECT SUM(_0_ServiceCharge_0_service.chargeAmount) FROM Service AS _0_service , ServiceCharge AS _0_ServiceCharge_0_service WHERE _transportService_Challan = _0_service AND _0_service = _0_ServiceCharge_0_service.service) AS _sqry1 FROM Challan AS _Challan LEFT OUTER JOIN _Challan.transportService AS _transportService_Challan ORDER BY _sqry1 > Now the problem is that Hibernate is replacing my aliases.... it replaced my alias of the sub query from _sqry1 to col_0_0_ .... it replaced this alias in the select list but not in the Order By clause... i.e. it replaced the alias where I defined it but it did not replaced the alias where I used it.... so the place where I am using the alias it is giving an error as undefined alias > The generated SQL by Hibernate: > select (select SUM(servicecha3_.ChargeAmount) from Services service2_, ServiceCharges servicecha3_ where transports1_.TransportServiceId=service2_.ServiceId and service2_.ServiceId=servicecha3_.serviceGroupTablePKId) as col_0_0_ from Challans challan0_ left outer join TransportServices transports1_ on challan0_.TransportServiceId=transports1_.TransportServiceId left outer join Services transports1_1_ on transports1_.TransportServiceId=transports1_1_.ServiceId order by _sqry1 > when I manually replaced my alias in the Order By clause then my query run successfully > Either Hibernate should not replace my alias, even if it is replacing then it must replace all the occurences > I cannot use criteria, I cannot use named queries, i cannot use native sql because my queries are formed at run time, I have to specify a HQL only... This is bug in Hibernate > Hibernate version: 3.0.5 > Name and version of the database that I am using: > MS SQL Server 2000 > Full stack trace of any exception that occurs: > Exception in thread "main" 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:2148) > at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029) > at org.hibernate.loader.Loader.list(Loader.java:2024) > at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375) > at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308) > at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153) > at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106) > at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) > at com.daffodilwoods.framework.utils.HibernateUtil.main(HibernateUtil.java:296) > Caused by: java.sql.SQLException: [DataDirect][SQLServer JDBC Driver][SQLServer]Invalid column name '_sqry1'. > at com.ddtek.jdbc.base.BaseExceptions.createException(Unknown Source) > at com.ddtek.jdbc.base.BaseExceptions.getException(Unknown Source) > at com.ddtek.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source) > at com.ddtek.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source) > at com.ddtek.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source) > at com.ddtek.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source) > at com.ddtek.jdbc.sqlserver.tds.TDSRPCNonCursorExecuteRequest.submitPrepare(Unknown Source) > at com.ddtek.jdbc.sqlserver.tds.TDSRPCExecuteRequest.doPrepExec(Unknown Source) > at com.ddtek.jdbc.sqlserver.tds.TDSRPCExecuteRequest.execute(Unknown Source) > at com.ddtek.jdbc.sqlserver.SQLServerImplStatement.execute(Unknown Source) > at com.ddtek.jdbc.base.BaseStatement.commonExecute(Unknown Source) > at com.ddtek.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source) > at com.ddtek.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source) > at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139) > at org.hibernate.loader.Loader.getResultSet(Loader.java:1669) > at org.hibernate.loader.Loader.doQuery(Loader.java:662) > at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) > at org.hibernate.loader.Loader.doList(Loader.java:2145) > ... 8 more -- 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

17 years, 6 months

1
0
0 / 0

[Hibernate-JIRA] Updated: (HHH-1612) Serious performance lost within IdentityMap...

by Steve Ebersole (JIRA)

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1612?page=all ] Steve Ebersole updated HHH-1612: -------------------------------- Comment: was deleted > Serious performance lost within IdentityMap... > ---------------------------------------------- > > Key: HHH-1612 > URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1612 > Project: Hibernate3 > Type: Improvement > Components: core > Versions: 3.1.3 > Reporter: Peter Fassev > Priority: Critical > Attachments: Hibernate_3.1.3_performance.jpg, hack.zip > > > Please look at the attached profiler snapshot. > After I switched from 3.0.5 to 3.1.3 I have mentioned a serious performance decrease when perfecting data, especially on loading non lazy collection (for instance Arrays of String[]). A simple fetch query, which was executed in 6 seconds on hibernate 3.0.5, now it takes 40 seconds on 3.1.3 (without any changes to the application). The fetch of the whole data needs with 3.1.3 about 90 seconds, with 3.0.5 about 49, which is a serious performance lost. > The NetBeans Profiler shows a huge increase of the self time of the IdentityMap.entrySet() method. Now it takes 22,3% of the whole start time. Together with it's calling method BatchFetchQueue.getCollectionBatch() it consumes 36 % of the start time, which explains the performance lost pretty good. > Looking at the source code I saw that there is already a TO DO regarding the performance of the IdentityMap.entrySet(), so please fix it, if possible. I think the whole implementation of the IdentityMap should be rethinked, because currently only a dirty hack is possible. If you can't use the IdentityHashMap of 1.4 due to compatibility reasons, please take a look at the current release of apache commons-collections (3.1), where you will find an IdentityHashMap. > With best regards > Peter -- 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

17 years, 6 months

1
0
0 / 0

[Hibernate-JIRA] Updated: (HHH-957) SubqueryExpression throws ClassCastException on DetachedCriteria subqueries

by Steve Ebersole (JIRA)

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-957?page=all ] Steve Ebersole updated HHH-957: ------------------------------- Comment: was deleted > SubqueryExpression throws ClassCastException on DetachedCriteria subqueries > --------------------------------------------------------------------------- > > Key: HHH-957 > URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-957 > Project: Hibernate3 > Type: Bug > Versions: 3.0.5 > Environment: Oracle 9i, but probably not DB specific. > Reporter: Rob MacGrogan > Priority: Minor > Attachments: SubqueryExpression.java, SubqueryExpression.java, subcriteria-patch.txt > > > The toSqlString() method in SubqueryExpression contains a line that casts a Criteria object to CriteriaImpl in order to call the getSession() method. However, if DetachedCriteria is used as a subquery in a Criteria query, the underlying Criteria object will be CriteriaImpl.Subcriteria, thus a ClassCastException will be thrown. > I have created a bug fix. Add the following method to SubqueryExpression: > private SessionImpl getSessionImpl(Criteria criteria) { > SessionImpl session = null; > if (criteria instanceof CriteriaImpl) { > CriteriaImpl impl = (CriteriaImpl)criteria; > session = impl.getSession(); > } > else if (criteria instanceof CriteriaImpl.Subcriteria){ > CriteriaImpl.Subcriteria sub = (CriteriaImpl.Subcriteria)criteria; > //Alert! Recursive call here! > session = getSessionImpl(sub.getParent()); > } > return session; > } > And then replace the offending line in toSqlString() with a call to the new method. > Attached is SubqueryExpression with proposed changes in place. -- 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

17 years, 6 months

1
0
0 / 0

[Hibernate-JIRA] Commented: (HHH-957) SubqueryExpression throws ClassCastException on DetachedCriteria subqueries

by john john (JIRA)

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-957?page=co... ] john john commented on HHH-957: ------------------------------- http://www2.tltc.ttu.edu/kelly/_5346disc/00000597.htm http://www2.tltc.ttu.edu/kelly/_5346disc/00000598.htm http://www2.tltc.ttu.edu/kelly/_5346disc/00000599.htm http://www2.tltc.ttu.edu/kelly/_5346disc/0000059a.htm http://www2.tltc.ttu.edu/kelly/_5346disc/0000059b.htm http://www2.tltc.ttu.edu/kelly/_5346disc/0000059c.htm http://www2.tltc.ttu.edu/kelly/_5346disc/0000059d.htm http://www2.tltc.ttu.edu/kelly/_5346disc/0000059e.htm http://www2.tltc.ttu.edu/kelly/_5346disc/0000059f.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005a0.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005a1.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005a2.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005a3.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005a4.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005a5.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005a6.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005a7.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005a8.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005a9.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005aa.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005ab.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005ac.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005ad.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005ae.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005af.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005b0.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005b1.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005b2.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005b3.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005b4.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005b5.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005b6.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005b7.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005b8.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005b9.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005ba.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005bb.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005bc.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005bd.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005be.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005bf.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005c0.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005c1.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005c2.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005c3.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005c4.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005c5.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005c6.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005c7.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005c8.htm http://www2.tltc.ttu.edu/kelly/_5346disc/000005c9.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/000000fc.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/000000fd.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/000000fe.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/000000ff.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/00000100.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/00000101.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/00000102.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/00000103.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/00000104.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/00000105.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/00000106.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/00000107.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/00000108.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/00000109.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/0000010a.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/0000010b.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/0000010c.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/0000010d.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/0000010e.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/0000010f.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/00000110.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/00000111.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/00000112.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/00000113.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/00000114.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/00000115.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/00000116.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/00000117.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/00000118.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/00000119.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/0000011a.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/0000011b.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/0000011c.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/0000011d.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/0000011e.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/0000011f.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/00000120.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/00000121.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/00000122.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/00000123.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/00000124.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/00000125.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/00000126.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/00000127.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/00000128.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/00000129.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/000000f5.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/000000f6.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/000000f7.htm http://www.acadweb.wwu.edu/courses/math312-TR/_disc1/000000f8.htm > SubqueryExpression throws ClassCastException on DetachedCriteria subqueries > --------------------------------------------------------------------------- > > Key: HHH-957 > URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-957 > Project: Hibernate3 > Type: Bug > Versions: 3.0.5 > Environment: Oracle 9i, but probably not DB specific. > Reporter: Rob MacGrogan > Priority: Minor > Attachments: SubqueryExpression.java, SubqueryExpression.java, subcriteria-patch.txt > > > The toSqlString() method in SubqueryExpression contains a line that casts a Criteria object to CriteriaImpl in order to call the getSession() method. However, if DetachedCriteria is used as a subquery in a Criteria query, the underlying Criteria object will be CriteriaImpl.Subcriteria, thus a ClassCastException will be thrown. > I have created a bug fix. Add the following method to SubqueryExpression: > private SessionImpl getSessionImpl(Criteria criteria) { > SessionImpl session = null; > if (criteria instanceof CriteriaImpl) { > CriteriaImpl impl = (CriteriaImpl)criteria; > session = impl.getSession(); > } > else if (criteria instanceof CriteriaImpl.Subcriteria){ > CriteriaImpl.Subcriteria sub = (CriteriaImpl.Subcriteria)criteria; > //Alert! Recursive call here! > session = getSessionImpl(sub.getParent()); > } > return session; > } > And then replace the offending line in toSqlString() with a call to the new method. > Attached is SubqueryExpression with proposed changes in place. -- 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

17 years, 6 months

1
0
0 / 0

[Hibernate-JIRA] Commented: (HHH-1612) Serious performance lost within IdentityMap...

by john john (JIRA)

17 years, 6 months

1
0
0 / 0

[Hibernate-JIRA] Updated: (HHH-1902) Alias Problem... Hibernate is replacing our alias at one place but not at another place

by M (JIRA)

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1902?page=all ] M updated HHH-1902: ------------------- Attachment: testhibernate.rar So here comes a very simple testcase which showing the problem that Hibernate ignores custom column aliases. > Alias Problem... Hibernate is replacing our alias at one place but not at another place > --------------------------------------------------------------------------------------- > > Key: HHH-1902 > URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1902 > Project: Hibernate3 > Type: Bug > Components: query-hql > Versions: 3.0.3 > Environment: Hibernate 3.0.3 > Database Platform : MSSQL Server 2000 > Reporter: Paras Dhawan > Attachments: testhibernate.rar > > > I have a query which contains a sub query in the select list... I have defined an alias of the sub query as _sqry1 now I am putting an Order By clause in the query.... Order By is on the result of the sub query and I have given the alias of the sub query in the Order By clause > My Query is which i am giving to Hibernate is > SELECT (SELECT SUM(_0_ServiceCharge_0_service.chargeAmount) FROM Service AS _0_service , ServiceCharge AS _0_ServiceCharge_0_service WHERE _transportService_Challan = _0_service AND _0_service = _0_ServiceCharge_0_service.service) AS _sqry1 FROM Challan AS _Challan LEFT OUTER JOIN _Challan.transportService AS _transportService_Challan ORDER BY _sqry1 > Now the problem is that Hibernate is replacing my aliases.... it replaced my alias of the sub query from _sqry1 to col_0_0_ .... it replaced this alias in the select list but not in the Order By clause... i.e. it replaced the alias where I defined it but it did not replaced the alias where I used it.... so the place where I am using the alias it is giving an error as undefined alias > The generated SQL by Hibernate: > select (select SUM(servicecha3_.ChargeAmount) from Services service2_, ServiceCharges servicecha3_ where transports1_.TransportServiceId=service2_.ServiceId and service2_.ServiceId=servicecha3_.serviceGroupTablePKId) as col_0_0_ from Challans challan0_ left outer join TransportServices transports1_ on challan0_.TransportServiceId=transports1_.TransportServiceId left outer join Services transports1_1_ on transports1_.TransportServiceId=transports1_1_.ServiceId order by _sqry1 > when I manually replaced my alias in the Order By clause then my query run successfully > Either Hibernate should not replace my alias, even if it is replacing then it must replace all the occurences > I cannot use criteria, I cannot use named queries, i cannot use native sql because my queries are formed at run time, I have to specify a HQL only... This is bug in Hibernate > Hibernate version: 3.0.5 > Name and version of the database that I am using: > MS SQL Server 2000 > Full stack trace of any exception that occurs: > Exception in thread "main" 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:2148) > at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029) > at org.hibernate.loader.Loader.list(Loader.java:2024) > at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375) > at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308) > at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153) > at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106) > at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) > at com.daffodilwoods.framework.utils.HibernateUtil.main(HibernateUtil.java:296) > Caused by: java.sql.SQLException: [DataDirect][SQLServer JDBC Driver][SQLServer]Invalid column name '_sqry1'. > at com.ddtek.jdbc.base.BaseExceptions.createException(Unknown Source) > at com.ddtek.jdbc.base.BaseExceptions.getException(Unknown Source) > at com.ddtek.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source) > at com.ddtek.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source) > at com.ddtek.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source) > at com.ddtek.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source) > at com.ddtek.jdbc.sqlserver.tds.TDSRPCNonCursorExecuteRequest.submitPrepare(Unknown Source) > at com.ddtek.jdbc.sqlserver.tds.TDSRPCExecuteRequest.doPrepExec(Unknown Source) > at com.ddtek.jdbc.sqlserver.tds.TDSRPCExecuteRequest.execute(Unknown Source) > at com.ddtek.jdbc.sqlserver.SQLServerImplStatement.execute(Unknown Source) > at com.ddtek.jdbc.base.BaseStatement.commonExecute(Unknown Source) > at com.ddtek.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source) > at com.ddtek.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source) > at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139) > at org.hibernate.loader.Loader.getResultSet(Loader.java:1669) > at org.hibernate.loader.Loader.doQuery(Loader.java:662) > at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) > at org.hibernate.loader.Loader.doList(Loader.java:2145) > ... 8 more -- 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

17 years, 6 months

1
0
0 / 0

[Hibernate-JIRA] Created: (HBX-838) Update docs to reflect ui simplification

by Max Rydahl Andersen (JIRA)

Update docs to reflect ui simplification ---------------------------------------- Key: HBX-838 URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-838 Project: Hibernate Tools Type: Improvement Components: eclipse Versions: 3.2beta8 Reporter: Max Rydahl Andersen Fix For: 3.2beta9 -- 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

17 years, 6 months

1
1
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues December 2006