Hi All,

I am doing My Application With Hibernate And Trinidad. I am using Transactiontemplate and HibernateTemplate. Trinidad is for view layer like JSF. To make my query working with Trinidad, I specified the follwing property in hibernate.cfg.xml
<property name="hibernate.query.factory_class">org.hibernate.hql.classic.ClassicQueryTranslatorFactory</property>

Then The simple Select Queries with aggregation is working with Trinidad.

These works fine upto Hibernate and Spring Layer.
1. No Query with concatenated fields with '+' sign, concat function or || sign are working with Trinidad.
2. No Query with Case when....then...else...end are working.
3. No registerFunctions like milliseconds_between, days_between are working.
etc etc

Can AnyOne have some idea to solve this problem or any suggestion ?
I am using hibernate3.x. But ASTQueryTranslatorFactory is working upto Spring Layer. For Migration With Trinidad, I specified ClassicQueryTranslatorFactory. ClassicQueryTranslatorFactory is supported with hibernate2.x so I am thinking that HibernateTemplate and TransactionTemplate are not supported with hibernate2.x. May be that Due to this query is not properly parsed.

If Any Other information regading problem is required please let me know.

Thanks,
Gopal