Get the native JDBC Connection object from ConnectionHolder
Hi all...
I'm currently using an Oracle feature called OracleAQ which helps me to receive JMS messages from Oracle database when an event occurs. This feature allows me to connect from a Java application through a JDBC Connection -- actually I can connect by configuring a JDBC Connection through the "thin" driver as in a standalone environment, but this is a really mess when configuring several endpoints in my application server instance -- and receive JMS messages from the OracleAQ topics.
I tried to configure a DataSource connection pool from the AS (Sun Java System AS 9), but the Oracle AQ APIs required a native (oracle.jdbc.internal.OracleConnection) and I can only get (at least it seems to) from the pool is a wrapper java.sql.Connection object called ConnectionHolder with a package visibility method "getConnection" that seems to return the native connection I can not obtain...
Please, any help or comments would be very appreciated
Regards
Jonathan
