Thomas_Heysa
17 years agoNew Contributor
DataSink - JDBC - MsSql error on first run
Hello.
Please, help me.
I use soapUI Pro 2.5
I would like to use a dataSink to update a field in a MsSql table.
The SQL update:
UPDATE Proba
SET field = ${DataSource#field}
WHERE (id = ${DataSource#id})
If I execute the update in soapUi in first time, then the following message appears on error log tab: "Thu Mar 05 16:43:12 CET 2009:ERROR:java.sql.SQLException: No suitable driver"
If I execute it once more, the update runs correctly, without error message, and the field is updated.
If I restart the SoapUI, the error message appears at first execute....
The driver is loaded (I think) because I see the next message in soapUi log:
15:12:53,255 INFO [SoapUI] Added [file:/C:/Program%20Files/eviware/soapUI-Pro-2
.5.1/bin/ext/jtds-1.2.2.jar] to classpath
the driver settings: net.sourceforge.jtds.jdbc.Driver
Thanks a lot
Thomas
Please, help me.
I use soapUI Pro 2.5
I would like to use a dataSink to update a field in a MsSql table.
The SQL update:
UPDATE Proba
SET field = ${DataSource#field}
WHERE (id = ${DataSource#id})
If I execute the update in soapUi in first time, then the following message appears on error log tab: "Thu Mar 05 16:43:12 CET 2009:ERROR:java.sql.SQLException: No suitable driver"
If I execute it once more, the update runs correctly, without error message, and the field is updated.
If I restart the SoapUI, the error message appears at first execute....
The driver is loaded (I think) because I see the next message in soapUi log:
15:12:53,255 INFO [SoapUI] Added [file:/C:/Program%20Files/eviware/soapUI-Pro-2
.5.1/bin/ext/jtds-1.2.2.jar] to classpath
the driver settings: net.sourceforge.jtds.jdbc.Driver
Thanks a lot
Thomas