File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Error in row Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Error in row" Watch "Error in row" New topic

Error in row

Ketan KC Chachad
Ranch Hand

Joined: Nov 23, 2003
Posts: 77

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 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(
at sun.jdbc.odbc.JdbcOdbcResultSet.insertRow(
at StudentsData.main(

is this because the ODBC driver does not support insertion into the resultset ? Please help!!!
[ October 23, 2005: Message edited by: Bear Bibeault ]

Regards,<br />Ketan KC Chachad
Ernest Friedman-Hill
author and iconoclast

Joined: Jul 08, 2003
Posts: 24199

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

[Jess in Action][AskingGoodQuestions]
Ketan KC Chachad
Ranch Hand

Joined: Nov 23, 2003
Posts: 77
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(
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(
at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(
at StudentsData.main(

Please do help me with this error. Please!!!
I agree. Here's the link:
subject: Error in row
It's not a secret anymore!