Hi,
I was using the updatable resultset and trying to insert a new row into a Microsoft Access database using the following code
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!!!