Forum Discussion

bm103's avatar
bm103
New Contributor
10 months ago

SQL Server JDBC Connection Initialization

Hello!

 

I have a Soap UI Project/JDBC Test Step with the below configuration:

 

SoapUI Version: 5.5.0

bin\ext: mssql-jdbc-10.2.3.jre8.jar

jre\bin: mssql-jdbc_auth-10.2.3.x64.dll

JDBC driver (from JDBC test step): com.microsoft.sqlserver.jdbc.SQLServerDriver

JDBC Connection string (from JDBC test step): jdbc:sqlserver://SERVER.DOMAIN:1443;databaseName=DB;integratedSecurity=true;authenticationScheme=NTLM;domain=DOMAIN;User=USERNAME;password=PASSWORD

 

Any insight is much appreciated as to how I can resolve the issue!

 

For context, I continually receive "Failed to init connection for driver [com.microsoft.sqlserver.jdbc.SQLServerDriver]" error message and the following outputs in the Soapui.log file:

 

-------------------------------------------------------------------------------------------------------------------------

2023-11-21 13:39:58,496 INFO [SoapUI] Adding [C:\Program Files\SmartBear\SoapUI-5.5.0\bin\ext\mssql-jdbc-10.2.3.jre8.jar] to extensions classpath

2023-11-21 13:39:59,090 ERROR [SoapUI] An error occurred [no protocol: ], see error log for details
2023-11-21 13:39:59,090 ERROR [errorlog] java.net.MalformedURLException: no protocol:
java.net.MalformedURLException: no protocol:
at java.net.URL.<init>(Unknown Source)
at java.net.URL.<init>(Unknown Source)
at java.net.URL.<init>(Unknown Source)
at javax.swing.JEditorPane.setPage(Unknown Source)
at com.eviware.soapui.autoupdate.NewSoapUIVersionAvailableDialog.createReleaseNotesPane(NewSoapUIVersionAvailableDialog.java:96)
at com.eviware.soapui.autoupdate.NewSoapUIVersionAvailableDialog.Init(NewSoapUIVersionAvailableDialog.java:72)
at com.eviware.soapui.autoupdate.NewSoapUIVersionAvailableDialog.<init>(NewSoapUIVersionAvailableDialog.java:60)
at com.eviware.soapui.autoupdate.Install4jSoapUIUpdateProvider.showUpdateIsAvailableDialog(Install4jSoapUIUpdateProvider.java:210)
at com.eviware.soapui.autoupdate.Install4jSoapUIUpdateProvider.updatePostponedByUser(Install4jSoapUIUpdateProvider.java:218)
at com.eviware.soapui.autoupdate.Install4jSoapUIUpdateProvider.run(Install4jSoapUIUpdateProvider.java:200)

2023-11-21 13:40:00,684 INFO [SoapUI] Used java version: 1.8.0_181
2023-11-21 13:41:12,209 ERROR [SoapUI] An error occurred [No suitable driver], see error log for details
2023-11-21 13:41:12,210 ERROR [errorlog] java.sql.SQLException: No suitable driver
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(Unknown Source)

-------------------------------------------------------------------------------------------------------------------------------------------------------

soapui-errors.log output:

2023-11-21 13:54:16,304 ERROR [errorlog] java.sql.SQLException: No suitable driver
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(Unknown Source)
at com.eviware.soapui.support.jdbc.JdbcUtils.initConnection(JdbcUtils.java:51)

ERROR [errorlog] com.eviware.soapui.support.SoapUIException: Failed to init connection for driver [com.microsoft.sqlserver.jdbc.SQLServerDriver], connectionString [jdbc:sqlserver://SERVER.DOMAIN:1443;databaseName=DB;integratedSecurity=true;authenticationScheme=NTLM;domain=DOMAIN;User=USERNAME;password=PASSWORD]
com.eviware.soapui.support.SoapUIException: Failed to init connection for driver [com.microsoft.sqlserver.jdbc.SQLServerDriver], connectionString [jdbc:sqlserver://SERVER.DOMAIN:1443;databaseName=DB;integratedSecurity=true;authenticationScheme=NTLM;domain=DOMAIN;User=USERNAME;password=PASSWORD]
at com.eviware.soapui.support.jdbc.JdbcUtils.initConnection(JdbcUtils.java:58)

 

 

No RepliesBe the first to reply