I am trying to check if a table exists in the DB before dropping the table in the following method that I have put together in a JUnit test trying to use the getMetaData() from the API:

    public void testDropTable () throws SQLException{
        Connection con = getConnection();
        Statement stmt = con.createStatement();
        ResultSet checkTable = con.getMetaData().getTables(null, null, "POITest", null);
        if (checkTable != null){
            try {
                String dropTable = "DROP TABLE ";
                String[] tables = DB_TABLE;
                for (int i = 0; i < tables.length; i++){
                    String stringCode = new String();
                    stringCode = stringCode + tables[i];
                    System.out.println(dropTable + tables[i]);

                    // Drop each table in the array.
                    int temp = stmt.executeUpdate(dropTable + tables[i]);
                }
            }
            catch (Exception e) {
                fail("Drop Table testDropTable threw an exception: " +(e.getMessage()));
            }
        }
        else{
            con.close();
        }
    }

If my table does not exist it still goes into the IF statement and I just want to bypass this method all together. Any suggestions or direction would be appreciated.

Thanks.

Hi,

Try in the IF statement checkTable.next()

Regards,
 LOOP

Thanks for the response. The bolded code is what I found to fix my problem and I hope it helps someone else:

public void testDropTable () throws SQLException{
        Connection con = getConnection();
        Statement stmt = con.createStatement();
        ResultSet checkTable = con.getMetaData().getTables(null, null, "POI", null);
        String tableName = null;
        while (checkTable.next())
        {
            System.out.println("In here");
            tableName = checkTable.getString("TABLE_NAME");
            System.out.println(tableName);
        }
        if (tableName != null){
            try {
                String dropTable = "DROP TABLE ";
                String[] tables = DB_TABLE;
                for (int i = 0; i < tables.length; i++){
                    String stringCode = new String();
                    stringCode = stringCode + tables[i];
                    System.out.println(dropTable + tables[i]);

                    // Drop each table in the array.
                    int temp = stmt.executeUpdate(dropTable + tables[i]);
                }
            }
            catch (Exception e) {
                fail("Drop Table testDropTable threw an exception: " +(e.getMessage()));
            }
        }
        else{
            con.close();
        }
    }

Thank you.

I also want this code for my application.
I have one table "data_table" in "local_data" Microsoft Access database file.
I want my application first check whether this table exit or not. If exit then delete it, if not exit do nothing.
So what I need to change in your code.
In your code:
here I need to change "TABLE_NAME" with "data_table"?
And what I need to change here:
or I also need to change in other part of program.

Hello, I am new to the forum.