Hi, I have a fairly simple question that I'm hoping someone can help me with... We decided to use Oracle Workspace Manager for our current project and so now I need to have a static sql statement fired right after opening any session which just connects a use to the correct workspace. The sql statement itself isn't important but I was just wondering how I fire an sql statement through hibernate without doing a load or anything. I looked into the hibernate Query and SQLQuery but both seem to only have an option for firing a query when loading objects and returning something.

Other than just knowing how to fire a static sql, I was wondering if there is a particularly nice way to do this via the config file or something along those lines, instead of directly in the daos...

Thanks in advance for any help!

You will need to obtain the JDBC Connection via session.connection() after you obtain it from the session factory. Execute the statement via JDBC and then carry on. As far as how to accomplish this in an easy manner, there are several architectural options I can think of off the top of my head: proxy the SessionFactory; obtain the session through your own factory class; use IoC to method inject into the SessionFactory.getCurrentSession() method. The choice really depends on your current architecture.

Thanks a lot ananasi...