000028083 - AxM error on startup in RSA Access Manager: No suitable driver found for jdbc20:oracle:oci:@axm1:1521:ORCL Code: (0) State: (08001)]

Document created by RSA Customer Support Employee on Jul 25, 2017
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000028083
Applies ToRSA Product Set: Oracle OCI driver
RSA Product/Service Type: Access Manager
RSA Version/Condition: 6.2  (AxM)
Platform: Windows

IssueAxM error on startup: No suitable driver found for jdbc20:oracle:oci:@axm1:1521:ORCL Code: (0) State: (08001)]

The following error message is thrown when attempting to use an Oracle SQL datastore/Oracle OCI driver with AxM 6.2:

sirrus.da.exception.DataStoreException: An error occurred in connecting to the database server.
[SQL Error : No suitable driver found for jdbc20:oracle:oci:@axm1:1521:ORCL Code: (0) State: (08001)]15:58:08:855 - There are 1 registered log listenersat sirrus.da.sql.util.SQLConnectionManager.getNewConnection(SQLConnectionManager.java:129)
at sirrus.da.util.ConnectionManager.getRetryNewConnection(ConnectionManager.java:408)
at sirrus.da.util.ConnectionManager.openFreeConnection(ConnectionManager.java:563)
at sirrus.da.util.ConnectionManager.init(ConnectionManager.java:327)
at sirrus.da.util.ConnectionManager.init(ConnectionManager.java:305)
at sirrus.da.sql.util.SQLConnectionManager.<init>(SQLConnectionManager.java:62)
at sirrus.da.sql.util.SQLConfiguration.loadConnectionData(SQLConfiguration.java:122)
at sirrus.da.sql.util.SQLConfiguration.<init>(SQLConfiguration.java:78)
at sirrus.da.sql.admin.factory.SQLFactory.<init>(SQLFactory.java:125)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
CauseThe driver name is incorrectly noted in both the sql.conf file and in the Installation and Configuration guide on page 170.  It is jdbc, not jdbc20.

Edit the sql.conf file.  Locate the following parameter

cleartrust.data.sql.server.oracle.jdbc_url: jdbc20:oracle:oci:@hostname:port:AXM

Remove the 20 after jdbc, i.e.

cleartrust.data.sql.server.oracle.jdbc_url: jdbc:oracle:oci:@hostname:port:AXM

and restart.



Legacy Article IDa61476