File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes out of range Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "out of range" Watch "out of range" New topic

out of range

D Ravi Kumar

Joined: Dec 11, 2008
Posts: 4

i got the these error

java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
at com.mysql.jdbc.PreparedStatement.setInternal(
at com.mysql.jdbc.PreparedStatement.setString(
at com.izmocars.inventory.homenet.Test.main(

give me solution

Ravi Kumar
[ December 11, 2008: Message edited by: Ulf Dittmer ]
Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42965
Welcome to JavaRanch.

You need to remove the quotation marks from the parameters. JDBC will automatically add those where necessary.

In the future, please UseCodeTags when posting code of any length. As it was, the code was basically unreadable.

(As an aside, I think you meant to say "please give me a solution".)
D Ravi Kumar

Joined: Dec 11, 2008
Posts: 4
Simply change the below statement


your statement is

remove the "query"
I agree. Here's the link:
subject: out of range
It's not a secret anymore!