Hi,

I am using Hibernate v22branch and I was trying to access the JDBC connection object of a session. When I load hibernate I get this message:

INFO DriverManagerConnectionProvider:42 - Using Hibernate built-in connection pool (not for production use!)

I understand what this means: I am using no external connection pool manager. This is not the problem. When I use this I can get in my code the JDBC connection object like this:



Of course, this will only work if I use the PostgreSQL database dialect.

Well, the problem is when I started to use C3P0Connection provider. What is returned by the session.connection() method? Java throws a invalid typecast exception. This means that the JDBC connection is not a PGConnection anymore. Does anyone have experience on this?

Thanks,
Romano

Use your debugger to look at it.

What you'll get here is the C3P0 Connection wrapper. To get the underlying Connection, you can for example call session.connection().getMetaData().getConnection(), which will give you the native Connection that can safely be cast to the driver implementation (like OracleConnection or PGConnection).

Unfortunately, the exact strategy to do this is specific to the connection pool. So if you don't want to tie your code to a specific connection pool, use some sort of abstraction. <plug>Spring includes such an abstraction in the form of the NativeJdbcExtractor interface, with various out-of-the-box implementations.</plug>

Juergen
http://www.springframework.org