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

mysql.com | 7 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    MySQL Bugs: #9288: parameter index out of range

    mysql.com | 7 months ago
    java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).

    Root Cause Analysis

    1. java.sql.SQLException

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

      at com.mysql.jdbc.SQLError.createSQLException()
    2. MySQL jdbc
      PreparedStatement.setBoolean
      1. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
      2. com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:2306)
      3. com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:2332)
      4. com.mysql.jdbc.PreparedStatement.setBoolean(PreparedStatement.java:1886)
      4 frames