On the server side, we need to override design-time connection string as Jason suggested:

task.getAppContext().put("OdaJDBCDriverPassInConnection", myconn);

Our web application use Hibernate that uses c3p0 connection pool. I am wondering if it is possible to get a connection from that pool for better performance. It is easier to config and manage have one connection pool.

I can get CurrentSession from EntityManagerFactory, but I can not get connection from session.