I cannot update an Access DB using
JDBC. This is my small
test program:
import java.sql.*;
import java.io.*;
public class testdb {
public static void main (
String args[]) throws Exception{
String user = "admin";
String password = "";
String url = "jdbc
dbc:MyAccessDSN";
Connection myConnection;
Statement myStatement;
ResultSet myResultSet;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
myConnection = DriverManager.getConnection (url, user, password);
myStatement = myConnection.createStatement(
ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
myResultSet = myStatement.executeQuery("Select * from school");
myResultSet.absolute(2);
myResultSet.updateString ("name", "new name");
myResultSet.updateString ("isTeacher", false);
myResultSet.updateRow();
} catch (SQLException e) {
System.err.println("An error occurred: " + e);
} catch (ClassNotFoundException e) {
System.err.println("An error occurred: " + e);
}
} //main
} //testdb