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

JeroenDirks

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.

dvohra21

http://www.oracle.com/webfolder/technetwork/jdeveloper/howto/11114/managedserver/wlsadfms.html#8c
https://blogs.oracle.com/jdevotnharvest/entry/accessing_weblogic_jdbc_datasource_from

JeroenDirks

I would like to use whatever DataSource the application module is using without looking it up by hardcoded name in a jndi string.

Is that possible?