I am using spring's getHibernateTemplate().find(tmp,parms), where in tmp when I passes hql it works, but when I passes native sql it failed. can any one pl. tell, whether this method support native sql or not. I have written query in DaoImpl only.
The query I am using contains subquery and From clause query.thows exception 'org.hibernate.hql.ast.QuerySyntaxException: unexpected token' giving location from where next select start
Thanks, Raj [ August 21, 2008: Message edited by: Rajan Nath ]
Hibernate supports native SQL. Not sure about Spring, but I'd be very surprised if it didn't. Since this is a Spring issue, I'll move it over to a more appropriate forum. [ August 21, 2008: Message edited by: Paul Sturrock ]