info.setProperty(ProxoolConstants.PASSWORD_PROPERTY, TestConstants.HYPERSONIC_PASSWORD);
info.setProperty(ProxoolConstants.VERBOSE_PROPERTY, "true");
ProxoolFacade.registerConnectionPool(url, info);
Configuration configuration = null;
SessionFactory sessionFactory = null;
Session session = null;
Properties hibernateProperties = new Properties();
Connection connection = null;
try {
hibernateProperties.setProperty(Environment.DRIVER, ProxoolDriver.class.getName());
hibernateProperties.setProperty(Environment.URL, url);
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();