This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
The moose likes JDBC 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
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: 42056
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".)

Ping & DNS - my free Android networking tools app
D Ravi Kumar

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


your statement is

remove the "query"
GeeCON Prague 2014
subject: out of range