Guys,

I have deployed a application on resin-3.0.14 version on linux.
I am using oracle as db.

My application uses hibernate along with c3p0 connection pool.
The configuration are as follows:-

In hibernate.properties the following is defined :

hibernate.c3p0.acquire_increment 3
hibernate.c3p0.idle_test_period 100
hibernate.c3p0.max_size 100
hibernate.c3p0.max_statements 0
hibernate.c3p0.min_size 10
hibernate.c3p0.timeout 100

In c3p0.properties following is defined :

c3p0.automaticTestTable=dual
#c3p0.idleConnectionTestPeriod=300
#c3p0.preferredTestQuery=SELECT 1
c3p0.testConnectionOnCheckin=true
c3p0.testConnectionOnCheckout=true
c3p0.autoCommitOnClose=false

When I start my application I get the following exception :

ERROR com.uniken.util.HibernateUtil <clinit>- Initial SessionFactory creation failed.
java.lang.AbstractMethodError: oracle.jdbc.driver.OracleConnection.getTypeMap()Ljava/util/Map;
at com.mchange.v2.c3p0.impl.NewPooledConnection.carefulCheckTypeMap(NewPooledConnection.java:114)
at com.mchange.v2.c3p0.impl.NewPooledConnection.<init>(NewPooledConnection.java:92)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:145)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAutomaticTestTable(C3P0PooledConnectionPoolManager.java:571)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooledConnectionPool(C3P0PooledConnectionPoolManager.java:527)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0PooledConnectionPoolManager.java:202)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0PooledConnectionPoolManager.java:216)
at com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBackedDataSource.java:120)
at org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:35)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:72)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1463)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1004)
at com.uniken.util.HibernateUtil.<clinit>(HibernateUtil.java:33)
at _jsp._adsales._Login__jsp._jspService(_Login__jsp.java:101)
at com.caucho.jsp.JavaPage.service(JavaPage.java:60)
at com.caucho.jsp.Page.pageservice(Page.java:570)
at com.caucho.server.dispatch.PageFilterChain.doFilter(PageFilterChain.java:159)

I am not able to figure out this problem.
Please help me urgently since it is deployed on production server.

Thanks

are you using Hibernate 3.2.2 which comes with c3p0-0.9.1?

don't know if it will help your issue, but there was a bug in either Hibernate 3.2.1 or c3p0-0.9.0 that was giving me a pooling related problem.

good luck

mark

Hi.

Seconding fizzbananafrance, please try upgrading to hibernate 0.9.1. Problems with JDBC drivers that don't support setTypeMap() were resolved a while back, I think.

Good luck!
Steve