Using Hibernate 3 , and I am trying to run multiple transactions within the same session.

OpenSession
OpenTrans
DoSomething
CloseTrans
OpenTrans
DoSomething
CloseTrans
OpenTrans
DoSomething
CloseTrans
OpenTrans
DoSomething
CloseTrans
CloseSession

I keep getting this error.
JDBC begin failed
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Object has been closed.

I step through the code, I am able to open the session execute my first transaction, then I execute a procedure outside a transaction (stored procedure using the session.getConnection and then CallableStatement) then try to begin a new transaction, this goes to the HibernateUtil file, beginTransaction gets the session and attempts to do a session.beginTransaction() this is where I am getting the error.

Thanks
Tim

Try with jTds. This is a better driver than the one provided by MS

Downloaded the jTDS driver and put it in my classpath. Is this correct for the cfg file? I think I read it right.


<property name="connection.url">jdbc:jtds:sqlserver://sqlstage2:1433/nations</property>
<property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
<property name="connection.password">*******</property>
<property name="connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property>

Looks right to me. Does it work?

Alin,
The jTDS Project.