Database connection test failed in web-logic server

347 Views Asked by At

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
1

There are 1 best solutions below

2
httPants On BEST ANSWER

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.