Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

Debug level Hibernate log excerpt:

Hi,

I need to execute a SQL query, let's say a select from a table, but the table is NOT linked to a persistent object. I'd just like tu use hibernate to get a connection on the database and then execute my query, so I don't have to manually create a JDBC connection...that is something like:

Session sess = Hibernate.getSession();

sess.executeQuery(MY SQL QUERY);

is there a way to do that?

thanks a lot

you can't!
the only thing you can do is get the jdbc connection from the hibernate session and strat working with jdbc