aditya55
12 years agoNew Contributor
Unable to connect to MS SQL Server using jtds driver
Hi,
I am trying to connect to MS SQL server using jdbc driver.
e.g.
import groovy.sql.Sql
def sql = Sql.newInstance(DatabaseURL,'username', 'password', 'com.microsoft.jdbc.sqlserver.SQLServerDriver')
I have also tried
def sql = Sql.newInstance(DatabaseURL,'username', 'password', 'net.sourceforge.jtds.jdbc.Driver')
but I keep getting
for com.microsoft.jdbc.sqlserver.SQLServerDriver' :
2013-10-08 19:13:25,292 ERROR [errorlog] java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
or for net.sourceforge.jtds.jdbc.Driver:
java.sql.SQLException: No suitable driver found for jdbc:jtds:sqlserver:
I recently upgraded to soapui 4.5.2 pro and net.sourceforge.jtds.jdbc.Driver was working in previous verison.
do I need to do anything different for 4.5.2? I have included jtds driver in my ext folder . For com.microsoft.jdbc.sqlserver.SQLServerDriver I read online that it ships with soapui.
Regards,
Adi
I am trying to connect to MS SQL server using jdbc driver.
e.g.
import groovy.sql.Sql
def sql = Sql.newInstance(DatabaseURL,'username', 'password', 'com.microsoft.jdbc.sqlserver.SQLServerDriver')
I have also tried
def sql = Sql.newInstance(DatabaseURL,'username', 'password', 'net.sourceforge.jtds.jdbc.Driver')
but I keep getting
for com.microsoft.jdbc.sqlserver.SQLServerDriver' :
2013-10-08 19:13:25,292 ERROR [errorlog] java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
or for net.sourceforge.jtds.jdbc.Driver:
java.sql.SQLException: No suitable driver found for jdbc:jtds:sqlserver:
I recently upgraded to soapui 4.5.2 pro and net.sourceforge.jtds.jdbc.Driver was working in previous verison.
do I need to do anything different for 4.5.2? I have included jtds driver in my ext folder . For com.microsoft.jdbc.sqlserver.SQLServerDriver I read online that it ships with soapui.
Regards,
Adi