1. Convert JQL to CriteriaBuilder stackoverflow.comOK.. I'm stuck. Can someone help me converting this JQL SELECT a FROM Asset a WHERE ?1 IN (SELECT c FROM a.categories c)categories is a collection of Enum. I have difficulty ... |
2. Need Help Converting from HQL to Criteria coderanch.comHibernate version: 3.2.6 Full stack trace of any exception that occurs: org.springframework.orm.hibernate3.HibernateQueryException: could not resolve property: type of: org.oz.report.Report; nested exception is org.hibernate.QueryException: could not resolve property: type of: org.oz.report.Report Caused by: org.hibernate.QueryException: could not resolve property: type of: org.oz.report.Report Name and version of the database you are using: Oracle 9i I am trying to convert a fairly complicated HQL query ... |
3. Converting Criteria to SQL forum.hibernate.orgHi, I am trying to convert criteria to Native SQL. CriteriaImpl c = (CriteriaImpl) criteria; SessionImpl s = (SessionImpl)c.getSession(); SessionFactoryImplementor factory = (SessionFactoryImplementor)s.getSessionFactory(); String[] implementors = factory.getImplementors( c.getEntityOrClassName() ); CriteriaLoader loader = new CriteriaLoader((OuterJoinLoadable)factory.getEntityPersister(implementors[0]), factory, c, implementors[0], s.getEnabledFilters()); Field f = OuterJoinLoader.class.getDeclaredField("sql"); f.setAccessible(true); return (String) f.get(loader); Problem with the above code it doesn't take care of the parameters. Is there anyway ... |
4. Convert to hibernate criteria forum.hibernate.orgdoes anyone knows the equivalent hibernate criteria for this native sql? Code: select this_.QUERY_DT as QUERY1_2_1_, this_.LINK as LINK2_1_, this_.YYYYMM ... |
5. Help converting HQL to Criteria forum.hibernate.orgfrom BalanceItem i where i.accountItem = :account and i.date = (select max(i2.date) from BalanceItem i2 where i2.accountItem = :account and ... |
6. Converting HQL to Criteria forum.hibernate.orgHello, Is there any way to convert some HQL into a Criteria object? The Criteria objects seem to be more useful (in terms of tuning fetch strategies, etc.) yet I can't see an obvious mechanism I can write out my query in HQL but can't see how it's performed using a Criteria: from Login l1, Login l2 where l1.time>=1197800000000 and l2.time>=1197800000000 ... |
7. Need Help Converting from HQL to Criteria forum.hibernate.orgHibernate version: 3.2.6 Full stack trace of any exception that occurs: org.springframework.orm.hibernate3.HibernateQueryException: could not resolve property: type of: org.oz.report.Report; nested exception is org.hibernate.QueryException: could not resolve property: type of: org.oz.report.Report Caused by: org.hibernate.QueryException: could not resolve property: type of: org.oz.report.Report Name and version of the database you are using: Oracle 9i I am trying to convert a fairly complicated HQL query ... |
8. convert SQL to HQL/Criteria forum.hibernate.orgdoes anybody can help me convert this sql to HQL / Criteria? Code: select count(*) from ( select 1 as col_0_0_ from settled_txn_log settledtxn0_, terminal terminal1_, bank bank2_ ... |
9. Convert HQL to Criteria forum.hibernate.orgHi All, I have classes like these: class User { private List addresses; //setter n getter } class Address { private City city; //setter n getter } HQL : select distinct city from User user inner join user.addresses addresses inner join addresses.city city where user.id = 1 How can I convert this HQL to Criteria? Thanks |
10. convert sqlQuery to criteria forum.hibernate.orgNewbie Joined: Mon May 04, 2009 5:07 pm Posts: 2 Hi all , Can you help to write this query in a better way (something like using criteria or hibernate template) ... Code: public List |