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