This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Error in row Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Error in row" Watch "Error in row" New topic
Author

Error in row

Ketan KC Chachad
Ranch Hand

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

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

Joined: Jul 08, 2003
Posts: 24183
    
  34

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: 76
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!!!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Error in row
 
Similar Threads
jdbc error: Invalid Descriptor Index
updating database cause error
Error in row!!!
Java + MS Access
sql exception