7 Replies Latest reply: Feb 15, 2008 5:33 AM by 807603 RSS

    Inserting issue with MS Access

    807603
      Hi,

      I am trying to insert a record in MS Access. Following is the code.

      class SqlTest {
      public static void main(String args[]) throws Exception {

      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

      Connection con = DriverManager.getConnection("jdbc:odbc:myDsn");
      Statement stmt = con.createStatement();
      stmt.executeUpdate("insert into emp values('e999', 'Raj')");
      }
      }

      After executing the program, if I check the data base the record would not have been inserted. The program does not even throw any exception. If I execute the same program with ORACLE, it works fne and record gets inserted. Could some one please let me know what could be the problem?