Hello,

I`m using Seam with JPA/Hibernate.

my current problem is that our database (Oracle 10g) controls the access rights. This is implemented with ONE technical user and a PL/SQL hell.

I need to call a PL/SQL procedure after i get a connection or after i started a transaction and before i end the transaction or release the connection.

Can someone give me a hint where the correct hook for this kind of functionality is ? I already written my own ManagedPersistenceContext and EnityManager (like the EntityManagerProxy). But this do not prevent me from getting different Connection with different access rights.

Thanks, Oliver

Hibernate version: 3.2.4.sp1
Seam version: 2.0.1.GA
Name and version of the database you are using: Oracle 10g
App Server: JBoss 4.2.2.GA