Tested yet another way to manage transactions through the user transaction.
[utils] / 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 }