JDBC Issue

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

JDBC Issue

krish na
Hi All,
I'm facing below issue:
java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).

My SQL Query is:
[Prepared Select Statement] SELECT * FROM recipient;

Looking for some input to overcome my solutions.


Regards,
Krishna - +91-9884451279.
Reply | Threaded
Open this post in threaded view
|

Re: JDBC Issue

Konstantin Kalinin
You should use a simple "Select Statement", prepared statements are used when you need some JMeter variables to put into the statement.
https://jmeter.apache.org/usermanual/component_reference.html#JDBC_Request
https://jmeter.apache.org/usermanual/build-db-test-plan.html

26.07.2018, 10:19, "krish na" <[hidden email]>:

> Hi All,
> I'm facing below issue:
> java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
>
> My SQL Query is:
> [Prepared Select Statement] SELECT * FROM recipient;
>
> Looking for some input to overcome my solutions.
>
> Regards,
> Krishna - +91-9884451279.

-- 
Konstantin Kalinin
+7 912 468 00 00


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: JDBC Issue

krish na
In reply to this post by krish na
Thanks for the update.
Its working fine.
Regards,
Krishna - +91-9884451279.

CallSend SMSAdd to SkypeYou'll need Skype CreditFree via Skype

    On Thursday, 26 July, 2018, 12:44:23 PM IST, Konstantin Kalinin <[hidden email]> wrote:  
 
 This message is eligible for Automatic Cleanup! ([hidden email]) Add cleanup rule | More info
 You should use a simple "Select Statement", prepared statements are used when you need some JMeter variables to put into the statement.
https://jmeter.apache.org/usermanual/component_reference.html#JDBC_Request
https://jmeter.apache.org/usermanual/build-db-test-plan.html

26.07.2018, 10:19, "krish na" <[hidden email]>:

> Hi All,
> I'm facing below issue:
> java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
>
> My SQL Query is:
> [Prepared Select Statement] SELECT * FROM recipient;
>
> Looking for some input to overcome my solutions.
>
> Regards,
> Krishna - +91-9884451279.

-- 
Konstantin Kalinin
+7 912 468 00 00


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]