import org.h2.jdbcx.JdbcConnectionPool;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;

public class Client
{
	public static void main(String[] args) throws Exception
	{
		JdbcConnectionPool pool = JdbcConnectionPool.create("jdbc:h2:tcp://localhost:8801,localhost:8802/test", "user", "pass");
		Connection conn = pool.getConnection();
		conn.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);
		
		Statement stmt = conn.createStatement();
		ResultSet rs = stmt.executeQuery("SELECT value FROM information_schema.settings WHERE name='CLUSTER';");
		System.out.println("Found: " + (rs.next() ? rs.getString(1) : "nothing"));
		
		rs.close();
		stmt.close();
		conn.close();
	}
}
