Forum Discussion

Thomas_Heysa's avatar
Thomas_Heysa
New Contributor
17 years ago

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

7 Replies

  • Hello,
    Sorry, my first letter was not correct. I use SoapUi 2.5.1, and I have the problem.
  • Hi,

    Could you please attach a screenshot showing your entire DataSink panel?

    /Dain
    eviware support
  • Hello,
    here is the attached screenshot. Thank you!
    Thomas
  • Hi,

    First off, you're not using the DataSink quite as it is designed to be used, you should have two properties in the left pane.
    These properties should have the values you want "${DataSource#field}" and ${DataSource#id}. The names do not really matter.
    Then in the statement, you should replace the property expansions with question marks, so the statement should be:

    UPDATE Proba
    SET field = ?
    WHERE (id = ?)

    Now, on to the error message. This is actually due to the fact that soapUI tries dome different stuff for loading the drivers, some of which may fail.
    That this generates an error message that isn't really an error at all (it has been removed from the next version of soapUI).
    If the first run isn't updating the field, it's likely due to something else.

    /Dain
    eviware support
  • Thank you!
    Your version of settings of dataSink works also. But the problem is the same.
    We use the SoapUI with Confluence - GreenPepper. If the error appears, then the test result on Confluence page is red.
    I hope, it will work in next relase.
    Thank you for your help.

    Sincerely
    Thomas
  • Great! Let us know if the problem persists after upgrading to the next version.

    /Dain
    eviware support