hi,
I'm using hibernate 3.1 adn oracle 10g.

During any transaction i call a stored procedure (in EJB1) that modify a register in DB(in EJB2), immediatly and under same transaction(in EJB1), I read the record, but I cant see the changes.

The problem is that apparently, when calling store procedure this releases to the connection, the connection is lost.

There is some form to solve this?

Problem:

Unfortunately, even though the SQL statements are being sent to the database, and this all happens within the same transaction, the second select retrieves stale data (from de cache session), as if the previous execute stored procedure had never happened

Solution:


To use refresh method for retrieve persistents objets from de DataBase.