Hi,

Can any one please explain me how the Connection object which has been retrieved from calling session.connection() behaves.

After executing the following statements.......


Session session=sfactory.openSession();
Connection con=session.connection();
con.setAutoCommit(false);

PreparedStatement pstmt=con.prepareStatement("update arrears set arr_date=sysdate where arrear_id=100");
int n=pstmt.executeUpdate();

con.commit();


I get Connection already closed exception at con.commit() line. I am not able to understand where exactly i am going wrong. Later i initialized the connection object using JDBC and everything works fine. I am getting the problem only when i am retrieving the connection from session.

Any pointers or explanation is appreciated.

thanks.

Regards.

Lokesh.