*
The moose likes JDBC and the fly likes Invalid column index Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Invalid column index" Watch "Invalid column index" New topic
Author

Invalid column index

Gaurav .Singh
Greenhorn

Joined: Apr 06, 2010
Posts: 8
My program is as follows

dbStatement.executeUpdate("create table employee(id INTEGER constraint employee_pk primary key not null, " +
"name VARCHAR(50), salary float)");
dbStatement.executeUpdate("insert into employee values(1, 'A', 30000)");
dbStatement.executeUpdate("insert into employee values (2, 'B', 50000)");
dbStatement.executeUpdate("insert into employee values (3, 'C', 20000)");
dbStatement.executeUpdate("insert into employee values (4, 'D', 40000)");

PreparedStatement preparedStatement = dbConnection.prepareStatement("update employee set salary = ? where salary <= ");
preparedStatement.setFloat(1, 65000);
preparedStatement.setFloat(2, 40000);
preparedStatement.executeUpdate();
preparedStatement.close();
dbStatement.close();
dbConnection.close();

And I am getting the error --
Invalid column index at the line --- preparedStatement.setFloat(2, 40000);

Could somebody please help me out
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336


update employee set salary = ? where salary <=

is not valid SQL. You are missing a parameter.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Gaurav .Singh
Greenhorn

Joined: Apr 06, 2010
Posts: 8
got it.. thanks
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

You are welcome
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Invalid column index
 
Similar Threads
java.sql.SQLException: Invalid column index
help with a statement
setting the null and getting null
Prepared Statement Problem
How to call procedure in JDBC