SQL Update statement only working sometimes
I've got a test case with these steps: 1. JDBC SQL request like: UPDATE DBName..TableName set var1 = '9' WHERE var2 = '12345' AND var3 = '5' 2. JDBC SQL request like: SELECT * FROM DBName..TableNa...
Forum Discussion
Hi,
Please disable the grrovy script testStep.
Add a JDBC request testStep,
http://www.soapui.org/JDBC/the-jdbc-request-window.html
For using the JDBC TestStep you will need to add a JDBC driver to soapui_home/bin/ext folder and restart the application.
Check format File > Preferences > JDBC Drivers Properties
If your connection string is not present add it
Add query in the request.
For connection string, jdbc:jtds:sqlserver://servername/dbname;user=username;password=password
you may have to add this jar, jtds-1.2.5.jar
Thanks,
Jeshtha
Please disable the grrovy script testStep.
Add a JDBC request testStep,
http://www.soapui.org/JDBC/the-jdbc-request-window.html
For using the JDBC TestStep you will need to add a JDBC driver to soapui_home/bin/ext folder and restart the application.
Check format File > Preferences > JDBC Drivers Properties
If your connection string is not present add it
Add query in the request.
For connection string, jdbc:jtds:sqlserver://servername/dbname;user=username;password=password
you may have to add this jar, jtds-1.2.5.jar
Thanks,
Jeshtha
