not insering all the records (please help!!)

[catherine matthews]

Hi all,

i am creating a tableA with a few records in one connection.
With another connection i am inserting all the records from tableB into tableA

In short i append the tableA with tableB using the execute statement below.

st2.executeUpdate("insert into FormulaQ1Q2 select * from FormulaQ1")

The prblem is not all the records are being inserted. After appen i should have 2000records. I am only having 1923 records. Please let me know what is the problem?
[ April 23, 2008: Message edited by: catherine matthews ]

[Paul Sturrock]

"Lost" records are very unlikely, and if there were an error the whole insert would fail. Are you sure 2000 is what you should get?

[catherine matthews]

I am using Jackess to copy the tables. As i copy The first tableA i have the correct amount of records. After i copy the second Table. The records in the first table gets changed. I loose 4 records. And the number of records in tableA becomes lesser. This is my method to copy the table.
I am using the same method. Changing the variable for the Connection.
Please let me know why this wierd thing is happening

 
 private void getFile2OK() {
 
 
        ResultSet resultSet = null;
 
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            System.out.println("Starting DB");
            String filename = file2.getAbsolutePath();
            String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=";
            database += filename.trim() + ";DriverID=22;READONLY=true}";
            con = DriverManager.getConnection(database, "", "");
            Statement st = con.createStatement();
            String QueryTable = "SELECT * from " + jList2.getSelectedValue();
            System.out.println(QueryTable);
            resultSet = st.executeQuery(QueryTable);
            Database.open(new File("d:/whitetrap/whitetrap.mdb")).copyTable("FormulaQ2", resultSet);
 
        } catch (SQLException e) {
            System.out.println("SQL Error is here at3 :" + e);
        } catch (Exception e) {
            System.out.println("Error :" + e);
        } finally {
            try {
                if (con != null) {
                    con.close();
                }
            } catch (SQLException e) {
                System.out.println(e);
            }
 
 
 
 
        }
    }
 
 
 
 
 
 
   

[ April 24, 2008: Message edited by: catherine matthews ]