Hi all!

I'm working with hibernate transactions and it's working very fine with the persistence of the objects.
Now I'm working also with Stored procedures, and the process is taking too much time to show the data into the DB(oracle 9i) for the SP.

- I'm openning transactions like this:

getSession().beginTransaction();


- Executing SP like this:

Connection conn = session.connection();
conn.setAutoCommit(false);
CallableStatement callStmt = conn.prepareCall(chamada);
stmt.executeUpdate();
stmt.close();

- the commit:

getTransaction().commit();

What could be the problem? I'm testing with a SP that just insert a register and it takes about 15 seconds. For the persistent objects is very fast.

Thanx.

I think that the transaction is taking too long to close/commit.
I run the process and during the some time I can't see the register inserted and can't insert others... is it locking the table or something like?

And if I execute the commit like below, the information is written on the act of the command... very fast.

stmt.executeUpdate();
dt = stmt.getString(4);
stmt.getConnection().commit();

.....

It is the net.sf.hibernate.Transaction.commit() that is making it slow.
What should I do?

I have another doubt that would probably solve the problem...
In the code I'm setting the connection to autoCommit(false) because when the SP executed and after was thrown an exception, the data stored in the SP wasn't rolled back.

My question is... using the connection obtained through the session, would it be in the same transaction of the session?

Somebody help me on this...

Thanks.