Error - Cannot load JDBC driver class encountered when deploying ARCOT UDS (Arcot User Data Service)

book

Article ID: 48934

calendar_today

Updated On:

Products

CA Rapid App Security CA Advanced Authentication CA API Gateway

Issue/Introduction

Description:

Deployment of ARCOT UDS via an application server fails if the sqljdbc.jar is not found in the <APPLICATION_SERVER_HOME>\lib. Note if JRE version greater or equal to 1.6 sqljdbc4.jar may be required in the afore mentioned directory. The stack trace that is generated when this error is encountered is as follows:

==================== Stack Trace related to the issue =======================================================
[ERROR] Internal error: Unable to list common configuration '
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1429)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at com.arcot.common.database.DBManagerImpl.getConnection(DBManagerImpl.java:43)
at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.init(JdbcTransaction.java:48)
at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:89)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(Sql
MapExecutorDelegate.java:567)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(Sql
MapExecutorDelegate.java:541)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSe
ssionImpl.java:118)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSe
ssionImpl.java:122)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapCli
entImpl.java:98)
at com.arcot.common.cache.db.ConfigService.listConfiguration(ConfigServi
ce.java:46)
========================= End of Stack Trace =======================================================

Solution:

Copy the sqljdbc.jar to the <APPLICATION_SEVERVER_HOME>\lib. Restart the application server to re-deploy Arcot UDS.

Environment

Release:
Component: WEBFRT