java sql SQLException: Parameter index out of range (1 > number of parameters, which is 0)

Question

I keep getting this error when trying to connect to the database.

This is my prepared statement

String SQL = "SELECT * FROM `?` WHERE `HomeTeam` = '?'";
        PreparedStatement prepst;            

        prepst =  con.prepareStatement(SQL);
        prepst.setString(1,box1.getSelectedItem().toString());
        prepst.setString(2,box1.getSelectedItem().toString());
        rs = prepst.executeQuery();

Anyone know why I get this error?

AlexR · Accepted Answer · 2014-02-18 12:51:11Z

1

I think that your problem is in ' and ``` symbols. You should fix the sql as follwing:

String SQL = "SELECT * FROM ? WHERE HomeTeam = ?";

However I am not sure that parameter placeholder ? is supported after from. So, propbably you will have to put it yourself, e.g.:

String table = box1.getSelectedItem().toString();
String SQL = "SELECT * FROM " + table + " WHERE HomeTeam = ?";

answered Feb 18, 2014 at 12:51

AlexR

116k16 gold badges137 silver badges216 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

David · Accepted Answer · 2014-02-18 12:56:42Z

0

Use

String SQL = "SELECT * FROM ? WHERE HomeTeam = ?";

Don't use ` to nest parameters, use ' to nest values you're comparing against if you're hard coding them.

You can't use ? to specify a table name.

edited Feb 18, 2014 at 12:56

answered Feb 18, 2014 at 12:48

David

20.2k31 gold badges110 silver badges128 bronze badges

2 Comments

user3139748 Over a year ago

Ok,I've tried that and now I get a MySQL syntax error although the SQL statement works when I tried it manually on the database

David Over a year ago

You can't use ? to specify a table name

Collectives™ on Stack Overflow

java sql SQLException: Parameter index out of range (1 > number of parameters, which is 0)

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related