Hi!
I m using preparedStatement for my update statement as follows
---------------------
pstmt = con.prepareStatement ("update KIStructure set type= ? , name='?' , description='?', sql='?', othervalues=? where KIStructureID = ? ");
pstmt.setInt (1, keyIndicator.getChartType ());
pstmt.setString(2, keyIndicator.getName ());
pstmt.setString(3, keyIndicator.getDescription ());
pstmt.setString(4, keyIndicator.getSQL());
pstmt.setBoolean(5, keyIndicator.otherValues());
pstmt.setInt(6, kiid);
---------------------
but I am getting following after
pstmt.setString(3, keyIndicator.getDescription ());
---------------------------------
java.lang.ArrayIndexOutOfBoundsException
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.clearParameter(JdbcOdbcPreparedStatement.java:1027)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setChar(JdbcOdbcPreparedStatement.java:2788)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setString(JdbcOdbcPreparedStatement.java:775)
-----------------------------------
pls suggest...
thanks
padmaja
[ May 11, 2003: Message edited by: Padmaja Godbole ]