c3p0 icon indicating copy to clipboard operation
c3p0 copied to clipboard

Are JDBC 4.3 drivers required since version 0.10.x ? NoSuchMethodError: java.sql.Connection.beginRequest()V

Open skarzhevskyy opened this issue 11 months ago • 0 comments

We are running app with Oracel JDBC drivers v21.13.0.0 under java 8.

after upgrade to c3p0 0.10.0 We observed error

Caused by: java.lang.NoSuchMethodError: java.sql.Connection.beginRequest()V
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$LiveRequestBoundaryMarker.attemptNotifyBeginRequest(C3P0PooledConnectionPool.java:145)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.markBeginRequest(C3P0PooledConnectionPool.java:217)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:726)
	at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:105)

the same application (same dependencies ojdbc8_g-21.13.0.0.jar) runs runder java 11. Also there are no problem running on PostgreSQL with java 8 or 11.

The question is since you try to make c3p0 compatible with previos generations of java (even v 7) do you want want to try to make it compatible with JDBC 4.2 or this is the end of an era ?

FIY https://www.oracle.com/database/technologies/faq-jdbc.html The table lists the Oracle JDBC drivers and the JDBC specification supported in that release.

v 19.x     
      ojdbc8.jar  is JDBC 4.2
      ojdbc10.jar  is JDBC 4.3

v 21.x      and  v 3.x
      ojdbc8.jar    is JDBC 4.2
      ojdbc10.jar  is JDBC 4.3

skarzhevskyy avatar Mar 30 '24 15:03 skarzhevskyy