transactions and sessions

ravnfan · **Joined:** Tue Aug 23, 2005 11:38 am **Posts:** 14

we are using hibernate 3.0.5

We create the session,
begin a transaction
do some work
commit transation
begin transaction
try to do some more work and get error saying unable to obtain session.

So, what happens one you commit transacion? Do you loose the session?

How do you do multiple commits with the same session?

d · **Joined:** Mon Jul 04, 2005 5:19 pm **Posts:** 720

You can have > 1 transaction for a session.

Can you elaborate on "unable to obtain session"? Is it closed? Is it misplaced in a different thread local ? are you calling SessionFactory.getCurrentSession() in a managed environment w/ a misconfigured JTA?

pksiv · **Posted:** Fri Sep 02, 2005 1:14 pm

http://www.hibernate.org/ForumMailingli ... AskForHelp

Show your code!

ravnfan · **Joined:** Tue Aug 23, 2005 11:38 am **Posts:** 14

I'm in a non managed environment.

I obtain the session by..
session = HibernateSessionFactory.currentSession();

After I call commit, I perform a load using session to get my next class to work on...
Dog dog = (Dog) session.get(Dog.class, dogcelOID);

And get this exception..
FINE: loading entity: xxxxxxxx
Sep 2, 2005 1:29:10 PM org.hibernate.jdbc.AbstractBatcher logOpenPreparedStatement
FINE: about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
Sep 2, 2005 1:29:10 PM org.hibernate.event.def.DefaultLoadEventListener onLoad
INFO: Error performing load command
org.hibernate.HibernateException: Not able to obtain connection
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:113)