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!!!
[ October 23, 2005: Message edited by: Bear Bibeault ]

[Ernest Friedman-Hill]

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

[Ketan KC Chachad]

Thank you for shifting my query to the JDBC section but I would like to add on to my query and say that I tried updating an existing record and it gave me the same exception when I try updating the first record. But if move the cursor to a particular record using the absolute() method and then try updating the record values, the following exception is thrown

java.sql.SQLException: No data found
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6287)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3307)
at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:
5494)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:342)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:399)
at StudentsData.main(StudentsData.java:138)

Please do help me with this error. Please!!!