ConnectionPoolXADataSourceProxyTest.java

package org.jdbcdslog;

import java.sql.Connection;
import java.sql.ResultSet;

import junit.framework.Test;
import junit.framework.TestCase;
import junit.framework.TestSuite;

public class ConnectionPoolXADataSourceProxyTest extends TestCase {
	public ConnectionPoolXADataSourceProxyTest(String testName) {
		super(testName);
	}

	public static Test suite() {
		return new TestSuite(ConnectionPoolXADataSourceProxyTest.class);
	}

	public void testConnectionPoolXADataSource() throws Exception {
		ConnectionPoolXADataSourceProxy ds = new ConnectionPoolXADataSourceProxy();
		ds.setDatabase("jdbc:hsqldb:mem:mymemdb;targetDS=org.hsqldb.jdbc.jdbcDataSource");
		ds.setUser("sa");
		Connection con = ds.getConnection();
		con.createStatement().execute("create table test (a integer)");
		con.createStatement().execute("insert into test values(1)");
		ResultSet rs = con.createStatement().executeQuery("select * from test");
		rs.close();
		con.close();
	}
	
	public void testSetTartetDS() throws Exception {
		ConnectionPoolXADataSourceProxy ds = new ConnectionPoolXADataSourceProxy();
		ds.setDatabase("jdbc:hsqldb:mem:mymemdb");
		ds.setTargetDS("org.hsqldb.jdbc.jdbcDataSource");
		ds.setUser("sa");
		Connection con = ds.getConnection();
		con.createStatement().execute("create table test5 (a integer)");
		con.createStatement().execute("insert into test5 values(1)");
		ResultSet rs = con.createStatement().executeQuery("select * from test5");
		rs.close();
		con.close();
	}
}