1 Reply Latest reply on Jan 23, 2020 7:48 PM by Nirmala Sundarappa-Oracle

    Unable to load the driver from classpath


      Hi Experts,


      I am using EPM 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?