Getting ArrayIndexOutOfBoundsException while setting prepared statement

Question

I am getting following exception while setting the parameters for the sql

java.ljava.lang.ArrayIndexOutOfBoundsException: 8
at oracle.jdbc.driver.OracleSql.computeBasicInfo(OracleSql.java:950)
    at oracle.jdbc.driver.OracleSql.getSqlKind(OracleSql.java:623)
    at oracle.jdbc.driver.OraclePreparedStatement.(OraclePreparedStatement.java:1212)
    at oracle.jdbc.driver.T4CPreparedStatement.(T4CPreparedStatement.java:28)
    at oracle.jdbc.driver.T4CDriverExtension.allocatePreparedStatement(T4CDriverExtension.java:68)
    at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3140)
    at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3042)
    at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:5890)

Code:

String sql = "insert into TEST_TABLE1(Field1,Field2,Field3,Field4,Field5,Field6,Field7,Field8,Field9,Field10) values(?,?,?,?,?,?,?,?,?,TEST_SEQ.nextval)";

protected static PreparedStatement prepareStatement(Connection connection , String sql , String idName, Object... values) throws SQLException{

    PreparedStatement statement = connection.prepareStatement(sql, new String[] {idName});

    setValues(statement, values);
    return statement;
}

protected static void setValues (PreparedStatement statement , Object... values) throws SQLException{
    for( int i = 0; i < values.length;i++){
        statement.setObject(i+1,values[i]);
    }
}

public long create (Connection connection, String sql, String idName, Object... parameters) throws ClassNotFoundException , SQLException{

    long key = -1;
    PreparedStatement statement = null;
    ResultSet resultset = null;

    try{
        statement = prepareStatement(connection,sql,idName,parameters);
        logger.debug("prepareStatement created");

        statement.execute();
        resultset = statement.getGeneratedKeys();

        if(resultset != null && resultset.next()){
            key = resultset.getLong(1)
        }
        logger.debug("key :"+key);

    }catch(SQLException sqle){
        logger.debug("error while creating db :"+slqe);
        throw sqle;
    } finally{
        close(statement,resultset);
    }
    return key;
}

key = resultset.getLong(1); should be key = resultset.getLong(0) i guess. — kosa, Aug 20 '15 at 02:50
Well, there are 9 markers (?) in the SQL. Are you calling `create` with 9 `parameters`? Try inserting `if (parameters.length != 9) throw IllegalArgumentException();`. — Andreas, Aug 20 '15 at 03:05

score 2 · Accepted Answer · edited May 23 '17 at 11:58

Refer to "JDBC - Oracle ArrayIndexOutOfBoundsException"

ArrayIndexOutOfBoundsException when use AutoGeneratedKeys and Oracle

I had similar issues ended up doing

1>Get a sequence value before calling create( method params ... ) long sequnceVal = getSequence( String sequenceSql);

2>Change prepareStatement to

    protected static PreparedStatement prepareStatement(Connection connection,
        String sql, String idName, Object... values)
        throws SQLException {

    PreparedStatement statement = connection.prepareStatement(sql);

    setValues(statement, values);
    return statement;
}

Which jdbc driver version you are using ? – user21 Aug 20 '15 at 14:18 — user21, Aug 20 '15 at 14:18

Getting ArrayIndexOutOfBoundsException while setting prepared statement

1 Answers1