protected void tearDown() throws Exception {
   Statement stmt = createStatement();
   stmt.execute("DROP TABLE T0");
   stmt.close();
   commit();
   super.tearDown();
 }
 /**
  * Creates a new database and keeps track of it to delete it when the clean up is invoked.
  *
  * <p>If the database already exists, a connection to the existing database is returned.
  *
  * @param dbName the database name
  * @param dbAttributes database attributes (i.e. encryption)
  * @param user user name
  * @param password user password
  * @return A connection to the database.
  * @throws SQLException if creating or connecting to the database fails
  */
 public Connection createDatabase(String dbName, String dbAttributes, String user, String password)
     throws SQLException {
   String userAttr = "";
   if (user != null) {
     userAttr = ";user="******";password="******";" + dbAttributes;
   }
   if (!userAttr.equals("")) {
     url += userAttr;
   }
   if (url.indexOf(ATTR_CREATE) == -1) {
     url += ATTR_CREATE;
   }
   Connection con = getConnection(url);
   if (con.getWarnings() != null) {
     // See if there are more than one warning.
     SQLWarning w = con.getWarnings();
     String warnings = w.getMessage();
     while ((w = w.getNextWarning()) != null) {
       warnings += " || " + w.getMessage();
     }
     BaseJDBCTestCase.fail("Warning(s) when creating database: " + warnings);
   }
   // Keep track of the database we just created, so that we can
   // delete it.
   DATABASES.add(dbName + userAttr);
   return con;
 }
 protected void tearDown() throws Exception {
   if (clob != null) {
     clob.free();
     clob = null;
   }
   excludedMethodSet = null;
   super.tearDown();
 }
 /**
  * Drops the specified database.
  *
  * <p>Note that the specified URL will be appended to a fixed JDBC protcol prefix.
  *
  * @param dbNameAndAttributes the database name and any attributes required to access the database
  *     (<em>excluding</em> the delete attribute, which is added by this method)
  * @throws SQLException if deleting the database fails
  */
 public void dropDatabase(String dbNameAndAttributes) throws SQLException {
   String url = JDBC_PREFIX + dbNameAndAttributes + ";drop=true";
   try {
     DriverManager.getConnection(url);
     BaseJDBCTestCase.fail("Dropping database should raise exception.");
   } catch (SQLException sqle) {
     if (sqle.getSQLState().equals("08006")) {
       // Database was deleted.
     } else if (sqle.getSQLState().equals("XJ004")) {
       // Database didn't exist. Already dropped?
     } else {
       BaseJDBCTestCase.assertSQLState(
           "Dropping database failed: (" + sqle.getSQLState() + ") " + sqle.getMessage(),
           "08006",
           sqle);
     }
   }
 }
 protected void tearDown() throws Exception {
   getTestConfiguration().setVerbosity(savedVerbosity);
   super.tearDown();
 }