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}...
Forum Discussion
SmartBear_Suppo
Alumni
AlumniHi,
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
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