1 package test.tuigwaa;
2
3 import java.sql.Connection;
4 import java.sql.PreparedStatement;
5 import java.sql.ResultSet;
6
7 import javax.sql.DataSource;
8
9 import junit.extensions.TestSetup;
10 import junit.framework.Test;
11 import junit.framework.TestCase;
12 import junit.framework.TestSuite;
13
14 import org.seasar.extension.dbcp.ConnectionPool;
15 import org.seasar.framework.container.S2Container;
16 import org.seasar.framework.container.factory.S2ContainerFactory;
17
18 import com.isenshi.util.extlib.HSQLDBUtil;
19
20 /***
21 * @author someda
22 */
23 public class HsqldbTest extends TestCase {
24
25 private static S2Container container;
26
27 DataSource datasource;
28 ConnectionPool connectionPool;
29
30 public static Test suite() throws Exception{
31
32 TestSuite suite = new TestSuite(HsqldbTest.class);
33 TestSetup setup = new TestSetup(suite){
34
35 public void setUp() throws Exception{
36 container = S2ContainerFactory.create("dicon/basedb.dicon");
37 container.init();
38 }
39
40 };
41 return setup;
42 }
43
44 public void setUp(){
45 datasource = (DataSource) container.getComponent(DataSource.class);
46 connectionPool = (ConnectionPool)container.getComponent(ConnectionPool.class);
47 }
48
49 public void testShowPoolsize(){
50 System.out.println("active pool : " + connectionPool.getActivePoolSize());
51 System.out.println("free pool : " + connectionPool.getFreePoolSize());
52 System.out.println("tx active pool : " + connectionPool.getTxActivePoolSize());
53 }
54
55
56 public void testShutdown() throws Exception{
57
58 HSQLDBUtil.shutdown(datasource);
59
60 Connection con = datasource.getConnection();
61 PreparedStatement pstmt = con.prepareStatement("select * from uri");
62 ResultSet rs = pstmt.executeQuery();
63 while(rs.next()){
64 System.out.println(rs.getString("URI_STRING"));
65 }
66 }
67
68 }