Access record not being added

[Tea]

I'm just trying to get started with servlets and JDBC and I am using MS Access as the database. I am having a lot of trouble with Access. Here is the scenario. Two days ago, the code listed below did not write the last record to the database, I struggled a long time trying to figure out what was happening. I finally gave up and got some sleep. The next day the exact same code worked, all records written. Went ahead working on some other items, knowing that the database connection and such were working. Well today the code does not work. The last record is not added! Specifically this line does not seem to be added "INSERT INTO testTable2 VALUES(789, 'name3')"
. Please note that in the java code the println statement comes after the insert into statement and the println statement is showing up on screen. I really can't continue on until this gets resolved. Can somebody suggest some reason why this is not working? Thanks.

To keep this short, I will paste only the necessary part, skipping the error handling section.

import java.sql.*;

public class BuildTables {
public static void main(String[] args) {
try {
String username = "guest";
String password = "guest";
String url = "jdbcdbc:db2";
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";

String[] SQLStatements = {
"CREATE TABLE testTable2 (Num INT NOT NULL PRIMARY KEY, name CHAR(20))",
"INSERT INTO testTable2 VALUES(123, 'name1')",
"INSERT INTO testTable2 VALUES(456, 'name2')",
"INSERT INTO testTable2 VALUES(789, 'name3')"
};

Class.forName(driver);
Connection conn = DriverManager.getConnection(url, username, password);
Statement stmt = conn.createStatement();
for(int i = 0; i < SQLStatements.length; i++) {
stmt.executeUpdate(SQLStatements[i]);
System.out.println(SQLStatements[i]);
}
}

[KnooKie]

what happens if you try and INSERT say 10 rows ? Is it always the last one ?

Why is name a CHAR datatype instead of a VARCHAR ??

[twinman326]

Question; Are you getting information from one table to another??