OK, so I don't understand your first comment about the "SELECT" but if you are using HQL, you do not need the select portion, if it was going to be "Select * from..."
Anyway, you have your Hibernate Session Factory defined in your Spring configuration. The next step is to inject the Session Factory into you DAO/Repository class. So you can either do that with a constructor or a settter. Now in your code you just call sessionFactory.getCurrentSession() to get the session and now you are good to go. Do not use the new Configuration().configure().buildSessionFactory(); you do not need to do that if you are using Spring and Spring is creating the SessionFactory for you.
hi Mark thank you for your answer my sql query is select max(P.notu)-1 from (select sum(ky.notu) as notu from Yorum ky group by ky.yorumPK.kitapSiraNo) P
actually, i wanted to get max of sums.
Could you give an example about how to inject the Session Factory into my DAO/Repository class via constructor please? I can't see any configuration about session factory in applicationContext.xml (configuration file of Spring) [ September 15, 2008: Message edited by: asli kilic ]
Joined: Sep 15, 2008
I get session but i have a new problem when i run the query i take the exception above what is my mistake?
"Caused by: org.hibernate.exception.SQLGrammarException: could not execute query"
In my DAO
part of applicationContext.xml (forum does not allow text contains url , i can not paste the header here)