Oracle Weblogic Server (MOSC)

MOSC Banner

Issue with MS SQLServer jar on weblogic

edited Aug 20, 2014 5:03AM in Oracle Weblogic Server (MOSC) 1 commentAnswered

Experts!

I am trying to add MSSQL driver so that weblogic can support MSSQL JDBC calls.

I added the jar file to WL_HOME/server/lib and then added the same to classpath in commEnv.cmd file.

Now when I try to create a connection in Data Sources it fails with the following message

Error Connection test failed.

Error Cannot load driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

Content added to commEnv.cmd file

@rem set up WebLogic Server's class path and config tools classpath

set WEBLOGIC_CLASSPATH=%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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center