Forum Stats

  • 3,757,253 Users
  • 2,251,215 Discussions
  • 7,869,779 Comments

Discussions

Unable to load the driver from classpath

AndyHsu
AndyHsu Member Posts: 10 Red Ribbon

Hi Experts,

I am using EPM 11.1.2.4 with Microsoft SQL Server 2012.

Recently, I was trying to change JDBC Driver but it failed.

The procedure that I followed is based on Oracle official guide which can be referred to  "Using Third-Party JDBC Drivers".

1. Replaced the wlsqlserver.jar by sqljdbc41.jar which is downloaded from Microsoft.

2. Prepended the new jdbc driver in Weblogic_Classpath declaration in commEnv.cmd:

set WEBLOGIC_CLASSPATH=%WL_HOME%\server\lib\sqljdbc41.jar;%JAVA_HOME%\lib\tools.jar;%WL_HOME%\server\lib\weblogic_sp.jar;%WL_HOME%\server\lib\weblogic.jar;%FEATURES_DIR%\weblogic.server.modules_10.3.6.0.jar;%WL_HOME%\server\lib\webservices.jar;%ANT_HOME%/lib/ant-all.jar;%ANT_CONTRIB%/lib/ant-contrib.jar

3. Restart all services

The error message from server logs show Failed to obtain database connection. RootCause : weblogic.jdbc.sqlserver.SQLServerDriver .Unable to load the driver from classpath.

I was wondering if I miss some steps that is not mentioned in the guide.

Does anyone have any idea?

Sincerely,

Andy

Tagged:

Answers