Hi,
I think my problem should be very simple, I started a new Session with hibernate to save or update some entities, before commit I have to call some oracle procedure to validate these entities, but the entities are not visible to oracle before commit.
Is there some Hibernate method or configuration to make uncommitted data visible to the when u call a procedure o function?
The original code is quite complex, but in general is something like that:
Code:
Session session = SessionFactory.currentSession();
session.saveOrUpdate(entity);
Connection conn = session.getConnection();
CallableStatement cst = conn.prepareCall("{call SOME_SP(?, ?, ?, ?, ?)}");
cst.setInt(1, 123);
cst.execute();
// in this point the procedure do not see the entity
Any help is welcome.
Thx a lot
Rodrigo Souza
Sao Paulo - Brazil