Forum Discussion

alibaba82's avatar
alibaba82
Super Contributor
15 years ago

[SOLVED]soapui 3.5 beta 2 SQL Query wizard does not seem to work

Hello,
using build
soapUI Pro 3.5-beta2, copyright (C) 2007-2009 eviware.com http://www.soapui.org | http://www.eviware.com Build daily-2010-01-26-[3], Build Date 2010/01/26 14:31

I am trying to follow the tutorial here
http://www.soapui.org/tutorials/jdbc/jd ... _SQL_Query

I have a stored proc in the 'SQL Query' windows and 'submit request' returns the results in the outline window.
When I try to use the 'Create Query' button to follow the above tutorial, I get the 'Database Configuration Wizard' instead of the 'Create Query / Build SQL Query' wizard as the tutorial seems to indicate.

Am I doing something wrong or is this a bug ?

Ali
  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    SmartBear Alumni (Retired)
    15 years ago
    Hi Ali,

    have you unchecked the "Stored Procedure" option? (the QueryBuilder only works for SQL queries..)

    regards,

    /Ole
    eviware.com
  • alibaba82's avatar
    alibaba82
    Super Contributor
    15 years ago
    the tutorial says
    'There are two options for configuring the SQL query to be used:'
    1. stored procedure checked
    -- in this scenario, using the 'build query' should display a window 'Create Query' with available output parameters. When I try this, I get the 'Database Configuration Wizard'

    2. stored procedure not checked ( a little confused about this one)
    --- In this scenario, I have only specified driver,connection string, and tested connection
    --- SQL Query window is blank and using 'build query' button does not do anything
  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    SmartBear Alumni (Retired)
    15 years ago
    Hi Ali,

    Unfortunately I can not reproduce your problem. Could you please attach screen shots of your configuration?
    Also, please check logs for any errors in case of second scenario.
    What about wizards in JDBC DataSource, is the situation same there as for JDBCRequest TestStep?


    Regards,
    Dragica
    /eviware.com
  • alibaba82's avatar
    alibaba82
    Super Contributor
    15 years ago
    hmm.. really odd. it works now using the same test case
    you can close this for now.