Forum Discussion

alibaba82's avatar
Super Contributor
15 years ago

(Res) JDBC Request not working in soapUI but works in MS SQL

I am using soapUI Pro 3.5, copyright (C) 2007-2009 | Build daily-2010-03-18-[1], Build Date 2010/03/18 06:27

I have a jdbc request with
connection string: which works fine when 'test connection' button is used

SQL Query
DECLARE @Locale nvarchar(5)
DECLARE @InterfacePartnersRolesId INT
DECLARE @ListGroupName NVARCHAR(255)
SET @ListGroupName = 'Liquid Recommendation List'
SET @InterfacePartnersRolesId = 3
SET @Locale = 'en-US'
EXECUTE @RC = [dbo].[usp_cps_GetRecommendationLists]  @ListGroupName, @Locale, @InterfacePartnersRolesId

in SQL Server I have no issues and can see the response
in soapUI, I get the following error.

Thu Mar 18 13:09:26 PDT Incorrect syntax near '{'. Incorrect syntax near '{'.
  at Source)
  at Source)
  at Source)
  at$PrepStmtExecCmd.doExecute(Unknown Source)
  at Source)
  at Source)
  at Source)
  at Source)
  at Source)
  at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.load(
  at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.runQuery(
  at java.util.concurrent.Executors$ Source)
  at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
  at Source)
  at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
  at java.util.concurrent.ThreadPoolExecutor$ Source)
  at Source)

4 Replies

  • SmartBear_Suppo's avatar
    SmartBear Alumni (Retired)

    hmm.. have you checked the "Stored Procedure" checkbox? If so, please try unchecking it to see if that makes a difference.. let us know!


  • PBell's avatar
    Occasional Contributor
    It does make a difference. thanks . but very strange behavior i must say.
    • jovanaSS's avatar
      Occasional Visitor

      Hi all,


      I had the same issue whit JDBC Request - 2019-05-09 15:25:43 - Error getting response; Incorrect syntax near '{'.

      Somehow I checked 'Select if this is a stored procedure' and when I unchecked this box my request worked fine.



      • groovyguy's avatar
        Community Hero

        jovanaSS be aware you're replying to a thread that's 6+ years old. You may want to consider starting a new thread with your specific details. :)