SQL exception

[Vladimir Kositsky]

Hello,
i am trying to update MS Access database from JTable while editing in cell, so setValueAt() overriden as shows below.
First update it works , but on second following exception appears:

[Microsoft][ODBC Microsoft Access Driver]Prepared statement not a cursor-specification
<code>
public void setValueAt(Object value, int row, int column) {
String query = null;
try {
String tableName = metaData.getTableName(column+1);
if (tableName == null) {
System.out.println("Table name returned null.");
}
String columnName = getColumnName(column);
query =
"update "+ "EMPLOYEES_7"+
" set "+columnName+" = "+dbRepresentation(column, value)+
" where inx = " + row;
System.out.println(query);
querry = null;
statement.executeUpdate(query);
}
catch (SQLException e) {
System.err.println(e.getMessage());
System.err.println("Update failed");
}
Vector dataRow = (Vector)rows.elementAt(row);
dataRow.setElementAt(value, column);
}
<\code>
Please help
V

[Madhav Lakkapragada]

check out this discussion where it says that MS Access
doesn't support prepared stmts.
http://www.javaranch.com/ubb/Forum3/HTML/000055.html
regds.
- satya

[Anurag Mishra]

Just Use rs.next() to remove an exception.
Anurag
SCJP,SCJD,IBM Cert, MS-IT, MBA-IT