@Test
public void testNewConnectionSql() throws Exception {

	InitialContext ic = new InitialContext();
	TransactionManager tm = (TransactionManager) ic
			.lookup("TransactionManager");
	DataSource ds = (DataSource) ic.lookup("TestDS");
	assertNotNull(ds);
	Connection conn = null;
	java.sql.Statement st = null;
	java.sql.ResultSet rs = null;
	tm.begin();
	try {
		conn = (Connection) ds.getConnection();
		st = conn.createStatement();
		rs = st.executeQuery("select count(0) from testTable");
		assertTrue(rs.next());
		assertTrue(rs.getInt(1) > 0);
	} finally {
		if (rs != null) {
			rs.close();
		}
		if (st != null) {
			st.close();
		}
		if (conn != null) {
			conn.close();
		}
	}
	tm.commit();
}