wamblee.org Git - utils/blob - test/enterprise/src/test/java/org/wamblee/support/persistence/DerbyDatabaseTest.java

   1 package org.wamblee.support.persistence;
   2
   3 import java.sql.Connection;
   4
   5 import javax.sql.DataSource;
   6
   7 import org.junit.After;
   8 import org.junit.Before;
   9 import org.junit.Test;
  10 import org.wamblee.support.persistence.Database;
  11 import org.wamblee.support.persistence.DatabaseBuilder;
  12
  13 public class DerbyDatabaseTest {
  14
  15     private Database db;
  16     private DataSource ds;
  17
  18     @Before
  19     public void setUp() {
  20         db = DatabaseBuilder.getDatabase();
  21         ds = db.start();
  22     }
  23
  24     @After
  25     public void tearDown() {
  26         db.stop();
  27     }
  28
  29     @Test
  30     public void testConnect() throws Exception {
  31         Connection conn = ds.getConnection();
  32         try {
  33             System.out.println("Database name: " +
  34                 conn.getMetaData().getDatabaseProductName());
  35         } finally {
  36             conn.close();
  37         }
  38     }
  39
  40     @Test
  41     public void testUseASecondTimeInTheSameTestCase() throws Exception {
  42         testConnect();
  43         tearDown();
  44         setUp();
  45         testConnect();
  46     }
  47 }