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

   1 /*
   2  * Copyright 2005-2010 the original author or authors.
   3  *
   4  * Licensed under the Apache License, Version 2.0 (the "License");
   5  * you may not use this file except in compliance with the License.
   6  * You may obtain a copy of the License at
   7  *
   8  *      http://www.apache.org/licenses/LICENSE-2.0
   9  *
  10  * Unless required by applicable law or agreed to in writing, software
  11  * distributed under the License is distributed on an "AS IS" BASIS,
  12  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  13  * See the License for the specific language governing permissions and
  14  * limitations under the License.
  15  */
  16 package org.wamblee.test.persistence;
  17
  18 import java.sql.Connection;
  19
  20 import javax.sql.DataSource;
  21
  22 import org.junit.Test;
  23 import org.wamblee.test.persistence.Database;
  24 import org.wamblee.test.persistence.DatabaseBuilder;
  25 import org.wamblee.test.persistence.DatabaseProvider;
  26 import org.wamblee.test.persistence.ExternalDatabase;
  27
  28 import static junit.framework.TestCase.*;
  29
  30 public class ExternalDatabaseTest {
  31
  32     @Test
  33     public void testExternalDB() throws Exception {
  34         // Connect to inmemory db using External database class.
  35
  36         Database inmemory = DatabaseBuilder
  37             .getDatabase(DatabaseProvider.CAPABILITY_IN_MEMORY);
  38         try {
  39             inmemory.start();
  40
  41             System.setProperty(ExternalDatabase.DB_URL_PROP, inmemory
  42                 .getExternalJdbcUrl());
  43             System.setProperty(ExternalDatabase.DB_USER_PROP, inmemory
  44                 .getUsername());
  45             System.setProperty(ExternalDatabase.DB_PASSWORD_PROP, inmemory
  46                 .getPassword());
  47
  48             Database external = DatabaseBuilder
  49                 .getDatabase(DatabaseProvider.CAPABILITY_EXTERNAL);
  50             assertTrue(external instanceof ExternalDatabase);
  51             try {
  52                 DataSource ds = external.start();
  53                 Connection conn = ds.getConnection();
  54                 try {
  55                     System.out.println("Database name: " +
  56                         conn.getMetaData().getDatabaseProductName());
  57                 } finally {
  58                     conn.close();
  59                 }
  60             } finally {
  61                 external.stop();
  62             }
  63         } finally {
  64             inmemory.stop();
  65         }
  66
  67     }
  68 }