I'm using JasperReports and would like to hand a connection off that I obtain from Hibernate's DBCP connection pool.

Using...


...I find that what I get is not a java.sql.Connection that Jasper can deal with but rather a org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper

Searching around I found that there is a way to get at the underlying connection by setting a preference...


The problem is that Hibernate is handling the DBCP connection pool, so I need to somehow set this flag via Hibernate's properties file. Something like...


...only this didn't work. Any ideas?

Well the "solution" I came up with was to relieve Hibernate of it's connection pool responsibilities. Instead I've set up DBCP independently and provide Hibernate with connections as needed. Probably better this way in any case.

-S