My Oracle Support Banner

SAP configtool.sh Fails with java.sql.SQLException: Unsupported Oracle JDBC driver version When Using JDBC 12c to Avoid ORA-28040 (Doc ID 2243782.1)

Last updated on SEPTEMBER 14, 2018

Applies to:

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

Symptoms


 After Oracle Client update to 12.1.0.2, SAP java related scripts like configtool.sh fail with the following error:

% ./configtool.sh
com.sap.engine.frame.core.configuration.ConfigurationException: Error while connecting to DB.
at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.createConnection(DBConnectionPool.java:365)
at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.(DBConnectionPool.java:130)
at com.sap.engine.core.configuration.impl.persistence.rdbms.PersistenceHandler.(PersistenceHandler.java:38)
at com.sap.engine.core.configuration.impl.cache.ConfigurationCache.(ConfigurationCache.java:149)
at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBootstrapImpl.init(ConfigurationManagerBootstrapImpl.java:236)
at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBootstrapImpl.(ConfigurationManagerBootstrapImpl.java:49)
at com.sap.engine.configtool.visual.ConfigTool.loadClusterData(ConfigTool.java:153)
at com.sap.engine.configtool.visual.ConfigTool.initScan(ConfigTool.java:135)
at com.sap.engine.configtool.visual.ConfigTool.(ConfigTool.java:124)
at com.sap.engine.configtool.visual.ConfigTool.main(ConfigTool.java:1147)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)
Caused by: com.sap.sql.log.OpenSQLException: Error while accessing porting layer for ORACLE database via createPortedConnection(conn).
at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:106)
at com.sap.sql.jdbc.direct.DirectConnectionFactory.createContextFactory(DirectConnectionFactory.java:671)
at com.sap.sql.jdbc.direct.DirectConnectionFactory.createDirectPooledConnection(DirectConnectionFactory.java:251)
at com.sap.sql.jdbc.direct.DirectConnectionFactory.createDirectPooledConnection(DirectConnectionFactory.java:214)
at com.sap.sql.connect.OpenSQLDataSourceImpl.createPooledConnection(OpenSQLDataSourceImpl.java:617)
at com.sap.sql.connect.OpenSQLDataSourceImpl.getPooledConnection(OpenSQLDataSourceImpl.java:285)
at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.createConnection(DBConnectionPool.java:307)
... 14 more
Caused by: java.sql.SQLException: Unsupported Oracle JDBC driver version
at com.sap.sql.jdbc.oracle.OraclePortingFactory.createPortedConnection(OraclePortingFactory.java:80)
at com.sap.sql.jdbc.direct.DirectConnectionFactory.createContextFactory(DirectConnectionFactory.java:654)
... 19 more

java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)
Caused by: java.lang.NullPointerException
at com.sap.engine.configtool.visual.ConfigTool.checkConfiguration(ConfigTool.java:183)
at com.sap.engine.configtool.visual.ConfigTool.loadClusterData(ConfigTool.java:173)
at com.sap.engine.configtool.visual.ConfigTool.initScan(ConfigTool.java:135)
at com.sap.engine.configtool.visual.ConfigTool.(ConfigTool.java:124)
at com.sap.engine.configtool.visual.ConfigTool.main(ConfigTool.java:1147)
... 5 more



When starting configtool.sh script, it was originally calling the JDBC driver location as "/oracle/client/12x/instantclient/ojdbc14.jar". After upgrading the database to 12c, the driver was changed to ojdbc6.jar 12.1.0.2 to overcome the issue on <Document: 2111118.1> ORA-28040 Using JDBC Connection to 12c Database. However, the error message "Unsupported Oracle JDBC driver version" is received.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrade JDBC from ojdbc14.jar 11.2 to ojdbc6.jar 12.1.0.2
2. Try to invoke configtool.sh.

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
Cause
Solution
References


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