"Wrong driver class [net.sf.log4jdbc.sql.jdbcapi.DriverSpy] for this connection URL ["jdbc:log4jdbc:oracle:thin:@<TNS ENTRY>?TNS_ADMIN=<TNSNAMES DIRECTORY>"]" Error When Configuring 3rd Party Software With Oracle JDBC And SSL (Doc ID 2741803.1)

Last updated on FEBRUARY 20, 2025

Applies to:

Symptoms

On : 19.5 version, Thin JDBC driver

Unable to connect to a database from 3rd party vendor application.
The next error message is reported when trying to connect through the application.

ERROR
-----------------------
...
Caused by: javax.resource.ResourceException: IJ031083: Wrong driver class [net.sf.log4jdbc.sql.jdbcapi.DriverSpy] for this connection URL ["jdbc:log4jdbc:oracle:thin:@<TNS ENTRY>?TNS_ADMIN=<TNSNAMES DIRECTORY>"]
  at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:323)
  ... 29 more

2020-12-07 10:43:23,086 ERROR [org.hibernate.hql.spi.id.IdTableHelper] (ServerService Thread Pool -- 85) Unable obtain JDBC Connection: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/<DS>
  at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:146)
  at org.jboss.as.connector.subsystems.datasources.WildFlyDataSource.getConnection(WildFlyDataSource.java:64)
  at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122)
  at org.hibernate.internal.SessionFactoryImpl$3.obtainConnection(SessionFactoryImpl.java:675)
  at org.hibernate.hql.spi.id.IdTableHelper.executeIdTableCreationStatements(IdTableHelper.java:67)
  at org.hibernate.hql.spi.id.global.GlobalTemporaryTableBulkIdStrategy.finishPreparation(GlobalTemporaryTableBulkIdStrategy.java:125)
  at org.hibernate.hql.spi.id.global.GlobalTemporaryTableBulkIdStrategy.finishPreparation(GlobalTemporaryTableBulkIdStrategy.java:42)
  at org.hibernate.hql.spi.id.AbstractMultiTableBulkIdStrategyImpl.prepare(AbstractMultiTableBulkIdStrategyImpl.java:88)
  at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:469)
  at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:422)
  at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:711)
  at com.ec.os.webservices.model.ejb.AnnotationSessionFactoryUtility.contextInitialized(AnnotationSessionFactoryUtility.java:24)
...

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.