Hello group,
I just started working on this project --my first time with databases.
Im connecting to a database using this:
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc
dbc:records");
stat = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
res = stat.executeQuery("Select * from records");
res.next();
} catch(Exception e) {
System.out.println("Error " + e);
}
Reading the everything using getXXX() methods works great. I'm having problems with writing to the database.
// column 1 in database is
String res.updateString(1, "Some string");
res.updateRow();
looks like updateString() and all updateXXX() are not doing anything.
updateRow() then, I believe, gives me an error msg:
"[Microsoft][ODBC Microsoft Access Driver]Error in row"
what am I doing wrong here? Error in row???
All I want is read and write on each row from a single table. No complexity is needed in my program. Can tell me what does this error mean and how do I fix it?
Thanks Very much,
Tim
P.S. This Looks like a great site. I hope people check this frequently though because my assignment is due this friday