My Oracle Support Banner

"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 JANUARY 08, 2021

Applies to:

JDBC - Version 19.5 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


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