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

Document ID : KB000048934
Last Modified Date : 14/02/2018
Show Technical Document Details

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.