C3PO: native JDBC connection

Kai · **Posted:** Tue Aug 17, 2004 7:30 am

Hi,

is it possible to retrieve the underlying JDBC connection from a connection which is provided by C3PO?

For DBCP I know:

Code:

          if( conn instanceof PoolableConnection) {
            PoolableConnection pconn = (PoolableConnection) conn;
            conn = pconn.getInnermostDelegate();
            if (OracleConnection.class.isAssignableFrom(conn.getClass())) {
              OracleConnection oracleCon = (OracleConnection) conn;
              // do nasty Oracle stuff
            }
          }

christian · **Posted:** Tue Aug 17, 2004 7:31 am

session.connection();

Kai · **Posted:** Tue Aug 17, 2004 7:38 am

Unfortunately not.

session.connection() returns a JDBC connection, but not the Oracle JDBC connection if you are working with C3PO.
I need the Oracle JDBC-Connection because of the nasty Blob-Handling (refer http://www.hibernate.org/56.html which shows a little bit ugly solution)

christian · **Posted:** Tue Aug 17, 2004 7:39 am

The DataDirect JDBC driver for Oracle is much better if you have lots of LOBs, it supports real JDBC LOB handling.

michael · **Posted:** Tue Aug 17, 2004 8:30 am

There should be a way to get the real connection from the wrapped c3p0 connection - read the c3p0 api

jhoeller · **Posted:** Tue Aug 17, 2004 11:39 am

An easy way that works with most connection pools is the following:

Code:

Connection nativeCon = session.connection().getMetaData().getConnection();

Hardly any pool cares to wrap the DatabaseMetaData connection. I've recently checked that this works for C3P0.

Juergen

Kai · **Posted:** Tue Aug 17, 2004 12:05 pm

Thanks Juergen, this works fine for me.

foxmarco · **Joined:** Wed Sep 22, 2004 8:27 am **Posts:** 89

I try this code

session.connection().getMetaData().getConnection() with c3p0 this return
not a real connection but an instance of NewProxyConnetion

i'm using the last version of c3p0.

Kai · **Posted:** Mon Jun 27, 2005 5:52 am

I am currently using DBCP because of problems with c3p0 (some statements hanging).
With DBCP it works fine, but thank you for your posting, so I be careful with changing to a newer c3p0 version.

michael · **Posted:** Mon Jun 27, 2005 8:30 am

For Oracle-Blob handling with c3p0 look here: http://www.mchange.com/projects/c3p0/in ... appendix_c

For all other non-standard methods look here: http://www.mchange.com/projects/c3p0/in ... ection_ops