Error in row!!!

[Ketan KC Chachad]

Hi,

I was using the updatable resultset and trying to insert a new row into a Microsoft Access database using the following code

resultset.moveToInsertRow();
for (column = 1; column <= columncount; column++)
{
System.out.print("Enter value for " + resultsetmetadata.getColumnLabel(column) + ": ");
columnvalue = br.readLine();
switch (resultsetmetadata.getColumnType(column))
{
case 4: //integer value
resultset.updateInt(resultsetmetadata.getColumnName(column), Integer.parseInt(columnvalue.trim()));
break;
case 12: //varchar value
resultset.updateString(resultsetmetadata.getColumnName(column), columnvalue);
break;
case 93: //date value
dob = new Date(sdf.parse(columnvalue).getTime());
resultset.updateDate(resultsetmetadata.getColumnName(column), dob);
break;
}//switch (resultsetmetadata.getColumnType(column))
}//for (column = 1; column <= columncount; column++)
resultset.insertRow();

where sdf is an object of SimpleDateFormat class and br is an object of BufferedReader class wrapped around InputStreamReader class that wraps the System.in object.
When I execute the code, the following exception is thrown

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Error in row
at sun.jdbc.odbc.JdbcOdbcResultSet.setPos(JdbcOdbcResultSet.java:5068)
at sun.jdbc.odbc.JdbcOdbcResultSet.insertRow(JdbcOdbcResultSet.java:4018)
at StudentsData.main(StudentsData.java:129)

is this because the ODBC driver does not support insertion into the resultset ? Please help!!!

[Ernest Friedman-Hill]

This is certainly not a beginner question! Moving to our JDBC forum.