[sqlitejdbc] Can't See Table inside Database

[Em]

Hello,

   I have several database files in a folder, each database contains
only one table.  I have this code to get database files from the
folder, open the database, get data from one of the table and then
proceed to the next database file.  the problem is it only reads the
first database file.  in the next file, it can no longer see the
table.  can anybody help?

here is the code:

  File directory = new File("D:/JavaSqliteTest/testDir");
  File[]  files = directory.listFiles();
  for ( int i = 0; i < files.length; i++ ) {
     File file = files[i];
     String fileName = file.getName();
     try{
       Class.forName("org.sqlite.JDBC");
        Connection conn =
DriverManager.getConnection("jdbc:sqlite:"+fileName);
        // get table name from the database so that the table name
        // in the query is changed every time a new database file is
opened
        String tableName="";
        DatabaseMetaData meta = conn.getMetaData();
        ResultSet tables =
conn.getMetaData().getTables(null,null,null,new String[]{"TABLE"});

        while (tables.next()) {
             tableName = tables.getString(3);
        }

        //create a query whose table name reflects the table in the
current database
        String queryString = "SELECT TIMESTAMP, LOCATION_ID, MSG_TYPE,
MSG_MESSAGE FROM " + tableName;

        Statement stmt = conn.createStatement();
        ResultSet rs = stmt.executeQuery(queryString);

        while (rs.next()) {
                int timestamp = rs.getInt("TIMESTAMP");
                String id   = rs.getString("Location_id");   // Column
1
                String code = rs.getString("Msg_Type"); // Column 2
                String name = rs.getString("msg_Message"); // Column 3

                System.out.println("TimeStamp: "+ timestamp +" ID: "+id
+" Msg_Type: "+code+" Message: "+name);
            }
            // Close the connection
         tables.close();
         stmt.close();
         rs.close();
         conn.close();

       }
}

I will really appreciate any help.  Thanks.


--~--~---------~--~----~------------~-------~--~----~
Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en
To unsubscribe, send email to [EMAIL PROTECTED]
-~----------~----~----~----~------~----~------~--~---