Hi,

Is there a way where i can get table data with out having mapping file & with out bean class.
Because until runtime i don't know the table names where data needs to be fetched.
Please let me know if my question is not clear!!!!

Thnx in Advance
King

Session.createSQLQuery()

Hi,

Thnx for the reply.

But,iam using Hibernate Template .
So,to use createSQLQuery shouldn't i pass Bean class in the query?
As i know syntax for createSQLQuery in hibernate and hibernate template are different.
Please send me example to use the same.

Thnx
Rana

I don't know anything about the HibernateTemplate, but with Session.createSQLQuery() you can create scalar queries that just return everything as an Object[].

Ok,
using hibernate only can i use this method with the above specified criteria.

Ex: createSQLQuery("select count(1) from tbl_test ");

Can i pass directly table name here instead of Bean class..

(Iam using hibernate template in spring mvc)