Forum Discussion

jason_optimal's avatar
jason_optimal
New Contributor
9 years ago

java.lang.IllegalArgumentException: Parameter 'Name' was not found in the SQL Query

Hi all,

 

I'm trying to configure a TestSuite with a JDBC call to a MS SQL database.

I succeeded in adding the jdbc jar files for MSSQL. The connection string is working.

 

The only problem I have is that it's not running any SQL query.

Whatever I may write in the query (even mistakes) is returning my this error:

 

  • Tue Sep 13 10:07:18 CEST 2016:ERROR:java.lang.IllegalArgumentException: Parameter 'Name' was not found in the SQL Query.
  • java.lang.IllegalArgumentException: Parameter 'Name' was not found in the SQL Query.
  • at com.eviware.soapui.impl.wsdl.panels.teststeps.support.NamedParameterStatement.getIndexes(NamedParameterStatement.java:139)
  • at com.eviware.soapui.impl.wsdl.panels.teststeps.support.NamedParameterStatement.setString(NamedParameterStatement.java:170)
  • at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.prepare(JdbcSubmit.java:238)
  • at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.runQuery(JdbcSubmit.java:173)
  • at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.run(JdbcSubmit.java:147)
  • at java.util.concurrent.Executors$RunnableAdapter.call(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)

 

Am I doing something wrong ?

 

Thanks in advance.

  • Solved !

     

    The problem was that I did add a parameter which wasn't used.