Hi,
I get the following exception when i try to run the following code segment.
stmt = (Statement) conn.createStatement();
rs = stmt.executeQuery( "SHOW TABLES");
if(rs.first()) {
stmt.execute( "DROP TABLE " + rs.getString(1));
while (rs.next()){
stmt.execute( "DROP TABLE " + rs.getString(1));
}
}
And the exception i get is:
SQLException: Operation not allowed after ResultSet closed
SQLState: S1000
VendorError: 0