Forum Discussion

robertc's avatar
robertc
Occasional Contributor
16 years ago

Problem with SoapUI 3.5 Beta1 Nightly Build/JDBC test step

I am running 3.5 Nightly Build (18/1/2010)
I have created a JDBC test step which connects correclty to an Informix database.
However a select statement gives the error:
1970-01-01 12:00:00 - Error getting response; null
The XML result box is empty.

If I try an update statement i.e. update table set x=1 where id=1
the update actually works (db record updated) but the XML displays:


  There's been an error in executing query!


This is an excellent addition as it makes test cases so much easier to create that are re-runnable.

7 Replies

  • Hi!

    Are you getting any errors in any of the log tabs at the bottom (ie the error log)?

    regards,

    /Ole
    eviware.com
  • robertc's avatar
    robertc
    Occasional Contributor
    Hi

    Error log is empty.
    The Soapui log contains:
    Tue Jan 19 16:54:51 NZDT 2010:INFO:Error getting response for [Revert sample to non-received]; null
    Tue Jan 19 16:57:03 NZDT 2010:INFO:Got response for [Revert sample to non-received] in 16ms (82 bytes)
    The first one in response to the select and the 2nd in response to the update.

    Is there any debugging I can turn on to help?

    Cheers
    Robert
  • Hi,

    hmm... could you run soapUI using the bat file and see if you get any errors in the console window?

    regards,

    /Ole
    eviware.com
  • robertc's avatar
    robertc
    Occasional Contributor
    I get this from the select:

    java.sql.SQLException: Method can be called only once.
            at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:407)
            at com.informix.jdbc.IfxStatement.chkAndSetGetRsltCalledFlag(IfxStatement.java:1812)
            at com.informix.jdbc.IfxStatement.getResultSet(IfxStatement.java:1022)
            at com.eviware.soapui.support.xml.XmlUtils.createJdbcXmlResult(XmlUtils.java:1438)
            at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcResponse.(JdbcResponse.java:35)
            at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.createResponse(JdbcSubmit.java:363)
            at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.runQuery(JdbcSubmit.java:205)
            at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.run(JdbcSubmit.java:163)
            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$Worker.runTask(Unknown Source)
            at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
            at java.lang.Thread.run(Unknown Source)
    10:34:15,206 INFO  [AbstractHttpRequestDesktopPanel] Error getting response for [Revert sample to non-received]; null

    and this for the update:
    10:36:45,269 INFO  [AbstractHttpRequestDesktopPanel] Got response for [Revert sample to non-received] in 0ms (82 bytes)
  • Thanks!

    Looks like some unexpected limitation in the JDBC driver, I'll create a workaround and a nightly build for you to try out.. gimme an hour..

    regards!

    /Ole
    eviware.com
  • robertc's avatar
    robertc
    Occasional Contributor
    That fixed it.
    Update returns:

      1

    Which I presume means one row updated, which is correct.

    Select returns XML structure:
    ... etc

    Thanks for that.

    By the I tried to connect to your repository to have a look at the code, not that I'm a java programmer but I can read it.
    Checkout from svn://svn.eviware.com/soapui/trunk/core, revision HEAD, Fully recursive, Externals included

    but there was no response. Is this the correct url?