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

    Unable to load the driver from classpath

    AndyHsu

      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