info.setProperty(ProxoolConstants.USER_PROPERTY, TestConstants.HYPERSONIC_USER);
info.setProperty(ProxoolConstants.PASSWORD_PROPERTY, TestConstants.HYPERSONIC_PASSWORD);
ProxoolFacade.registerConnectionPool(url, info);
Configuration configuration = null;
SessionFactory sessionFactory = null;
Session session = null;
Properties hibernateProperties = new Properties();
Connection connection = null;
try {
hibernateProperties.setProperty(Environment.PROXOOL_EXISTING_POOL, "true");
hibernateProperties.setProperty(Environment.PROXOOL_POOL_ALIAS, alias);
configuration = new Configuration().addProperties(hibernateProperties);
// create a session object to the database
sessionFactory = configuration.buildSessionFactory();
session = sessionFactory.openSession();
assertNotNull("Expected a session", session);
// Inspect the assigned connection to the session from
// the pool.
connection = session.connection();