GeeCON Prague 2014*
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
Author

out of range

D Ravi Kumar
Greenhorn

Joined: Dec 11, 2008
Posts: 4


i got the these error


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


give me solution

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

Joined: Mar 22, 2005
Posts: 42047
    
  64
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
Greenhorn

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

statement.executeUpdate();

your statement is
statement.executeUpdate(query);

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