2 Replies Latest reply on Apr 15, 2008 11:52 AM by Oliver Dohmen

    Executing SQL after opening DB session and before closing it

    Oliver Dohmen Newbie

      Hi all,


      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