2 Replies Latest reply: Dec 3, 2012 10:25 AM by JeroenDirks RSS

    What is the recommended way to get a java.sql.Connection to the DB  for ADF

      How do I create a standalone database connection based on the datasource setup in ADF?

      I have seen code like this in a method of AppModuleImpl.java but that seems a bit of a hack.

      Connection conn = this.getDBTransaction().createStatement(0).getConnection();

      What I need is a java.sql.Connection to the database used in the application module so I can call PL/SQL code and or work with AQ queues.

      I would prefer a separate connection from the one used by the ADF model so it can have its own transaction control etc.

      But I would like to get the connection created authenticated based on regular datasource setup.