execute straight SQL?

carl.sjoquist · **Joined:** Tue Oct 07, 2003 4:17 pm **Posts:** 9

Can someone point me to a Hibernate API that would let me execute straight SQL, i.e. not generated by Hibernate. And I would want to be able to iterate a resultset to build my own objects.... is this supported somehow?
Thx

emmanuel · **Posted:** Tue Oct 07, 2003 5:14 pm

Code:

java.sql.Connection myJdbcConnection = myHibernateSession.connection();
...

jmacenri · **Joined:** Tue Oct 07, 2003 4:41 am **Posts:** 21

Bit of a newbie myself but I think what you may be looking for is

SQL Queries (Chapter 14 of the 2.1b4 ref doc)

Code:

Query sqlQuery = sess.createSQLQuery("select {xc.*} from XCAT {xc}", "xc", Cat.class);
sqlQuery.setMaxResults(50);
List cats = sqlQuery.list();

is the example code taken from the top of the chapter

John

max · **Posted:** Wed Oct 08, 2003 2:01 am

Build your own objects ? may I ask why ? And do you know the implications for it ?
(I know a couple of reasons - but I would like to hear yours ;)

Options you got:
1. session.connection().putYourFavoriteJDBCStuffHere()
2. session.createSQLQuery();
3. HQL new() syntax ...like "select new PersonDTO(p.name, p.address) from Person p
4. HQL report queries like "select p.name, p.address from Person" ...

That should give you data in a tabular form from which you can create ya' own objects

gavin · **Posted:** Wed Oct 08, 2003 6:16 am

5. Create a custom ClassPersister :)

carl.sjoquist · **Joined:** Tue Oct 07, 2003 4:17 pm **Posts:** 9

is basically legacy driven - a pre-determined data model, lots of existing SQL and other non-Java modules that need to continue to work.

Thanks much for the pointers.