weblogicoracle12cjdeveloperoracle12.2

Database connection test failed in web-logic server

I am getting below error while creating data-source to a database in weblogic server 12.

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

  • Weblogic comes with it's own driver for sql server, weblogic.jdbc.sqlserver.SQLServerDriver which is available in the classpath. An example jdbc url for connecting using that driver is jdbc:weblogic:sqlserver://SBNSWDV63\\SSQLDV03:1433;allowPortWithNamedInstance=true

    If you want to use the microsoft driver, you have to make sure the jar file containing that driver is copied to your <domain_home>/lib folder, so it's visible to weblogic.