sql exception:Parameter index out of range

Question

I wrote the following method to execute update statement inside the database:

 public boolean updateEmployee(int id){
    try {
        String update="UPDATE employee set name='updatedName' and address='updatedaddress' where id=(?)";
        pst=connection.prepareStatement(update);
        pst.setInt(1, id);
        pst.executeUpdate();

    } catch (SQLException ex) {
        Logger.getLogger(DAO.class.getName()).log(Level.SEVERE, null, ex);
        return false;
    }
    return true;
 }

But the following exception occurs:

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

And this exception is also thrown:

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: 'UpdatedName'

What's the problem here? In addition, how can I return the result of an update statement (since executeQuery doesn't work with DML Statements)?

Why are you using this "id=(?)"? Just "id=?" is not enough? I'm not saying that this is wrong, ok? It's because I can't remember about parameters in JDBC PreparedStatements. From what I remember, the parentheses is not necessary... — Diogo Moreira
– Diogo Moreira, Commented Feb 1, 2013 at 19:23

Brian Agnew · Accepted Answer · 2013-02-01 17:46:32Z

5

Looks like an unclosed quote issue ?

name='updatedname and address

answered Feb 1, 2013 at 17:46

Brian Agnew

273k38 gold badges342 silver badges443 bronze badges

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

4 Comments

Eslam Hamdy Over a year ago

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: 'updatedname'

Rohit Jain Over a year ago

@Eslam.. Check the type of name column in database. I suspect you set it as Double. It should be Varchar.

Anugoonj Over a year ago

the type of the column does not match the value type you are trying to insert, String to Double perhaps ?

Eslam Hamdy Over a year ago

I SWEAR THAT I'AM SETTING BOTH NAME AND ADDRESS AS VARCHAR(45)

Eran · Accepted Answer · 2013-02-02 01:27:01Z

2

I might be wrong, but perhaps the statement should be

UPDATE employee set name='updatedName' , address='updatedaddress' where id=(?)

instead of

UPDATE employee set name='updatedName' and address='updatedaddress' where id=(?)

and should be used only in the where clause.

answered Feb 2, 2013 at 1:27

Eran

395k57 gold badges726 silver badges793 bronze badges

Collectives™ on Stack Overflow

sql exception:Parameter index out of range

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related