ResultSet is from UPDATE. No Data Excpetion Error SoapUI JDBC MySQL


Did your first test work and suddenly stop? Did you get this error?
(- This page will also help you make JDBC Work for SQL in SoapUI -)

PRO-VERSION:

Pro Version Snapshot: java.sql.SQLException: ResultSet is from UPDATE. No Data.
Pro Version Snapshot: java.sql.SQLException: ResultSet is from UPDATE. No Data.

FREE-VERSION:

Free Version Error - Can't get the Connection for specified properties; java.sqlSQLExcpetion: ResultSet is from UPDATE. No Data.
Free Version Error – Can’t get the Connection for specified properties; java.sqlSQLExcpetion: ResultSet is from UPDATE. No Data.

Mon Mar 11 12:09:05 EDT 2013:ERROR:java.sql.SQLException: ResultSet is from UPDATE. No Data.
ERROR LOG

Mon Mar 11 12:09:05 EDT 2013:ERROR:java.sql.SQLException: ResultSet is from UPDATE. No Data.
java.sql.SQLException: ResultSet is from UPDATE. No Data.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:6999)
at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java:4141)
at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3548)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2513)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2283)
at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:822)
at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317)
at com.eviware.soapui.support.GroovyUtils$DriverProxy.connect(GroovyUtils.java:171)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.eviware.soapui.support.jdbc.JdbcUtils.initConnection(JdbcUtils.java:68)
at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.getDatabaseConnection(JdbcSubmit.java:218)
at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.prepare(JdbcSubmit.java:261)
at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.runQuery(JdbcSubmit.java:197)
at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.run(JdbcSubmit.java:161)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Reason

As SoapUI makes updates to the application, we all know oracle/sql jar files are also being updated. Apparently QA cannot keep up with verifications. The jar file SoapUI give is the most recent “mysql-connector-java-5.1.23-bin.jar”. For some unknown reason it seems some UPDATE is being attempted after the first try.


RESOLUTION Use an older jar file such as this: mysql-connector-java-3.0.14-production-bin.zip.zip
1. Place in: C:\Program Files\SmartBear\soapUI-Pro-4.5.1.1\bin\ext
2. Don’t forget extract it! It doesn’t read zip! (yea some have done that)
3. Be sure to close SoapUI and re-open as it checks the bin for jar files to pre-load.
5. Verify your string is correct:
jdbc:mysql://YOURHOSTNETWORK.NET:3306/YOURDATABASENAME?user=USERNAME&password=PASSWORD