Forum Discussion

dejvid-smth's avatar
dejvid-smth
New Contributor
5 years ago

Parametrized JDBC broken in Ready API 3.1

I am using JDBC Test Step in SoapUI to select data from an Oracle database. My sql statement contains parameters and looks something like this: select ID from MY_TABLE where REF_ID = :ref_id order b...
Editors
richie's avatar
richie
Community Hero
Hi dejvid-smth,

So your query worked in v3.0 but now doesnt for v3.1?

At this point id check the release notes for v3.1 to see if there are any related changes that have introduced a regression.

Once that is done, id raise a support ticket with Smartbear (sorry im typing this on my phone so i cant provide the link, but youll be able to find it without too much trouble) detailing the issue. This definitely sounds like a regression and is gonna break a lot of peoples tests so its likely Smartbear will try and fix this in a subsequent maintenance release.

In regards to the fact that the query executes fine in the QueryBuilder function, a couple of people have raised forum posts saying theyre struggling with thr jdbc step but using the QueryBuilder executes the query fine.

As a short term workaround, could you perhaps downgrade your ReadyAPI! version back down to v3.0 to get you up and running again until Smartbear can resolve the issue? (assuming theres nothing in the v3.1 release notes saying otherwise)

Hope this helps,

Rich
richie's avatar
richie
Community Hero
5 years ago
Hey dejvid-smth ,

Ive just reread your post and so youre saying using sql defined parms in the JDBC step with the : identifier is failing, right?

In all my use of the JDBC step ive never bothered using the parms in the JDBC step this way (using the : identifier/alias).

Instead ive always used properties like ${Properties#attribute} (sourcing my parm values from values stored elsewhere (i.e. in a Properties step)) or via inline scripting ${=inlinescriptingtodynamicallygeneratethevalue}

Have you tried this approach rather than sql parms needing the :identifier syntax?

Cheers

Rich
  • dejvid-smth's avatar
    dejvid-smth
    New Contributor
    5 years ago

    Hi richie,

     

    I have tried using the property references via Get Data and that works. Although even a simples use case with : parameter/alias doesn't. I can solve my problem with the property concatenation like you suggested but that is not the point. The parameters are there for a reason and if they don't work it is either a bug or the functionality should be removed :smileyhappy:

    • richie's avatar
      richie
      Community Hero
      5 years ago

      Hi dejvid-smth 

       

      apologies - I thought you were looking for a workaround not just highlighting a possible issue.

       

      Yeah - as I said before - best thing would be to raise a ticket with Smartbear so they're aware of the issue,

       

      nice one,

       

      rich

      • TwoFang's avatar
        TwoFang
        Contributor
        5 years ago

        Have this issue as well and was wondering if there were a ticket posted so we can get it fixed?