public class TestWeeklyStatHsqldbSchema extends TestCase {
@Override
protected void setUp() throws Exception {
Configuration config = new Configuration().
setProperty("hibernate.dialect", "org.hibernate.dialect.HSQLDialect").
setProperty("hibernate.connection.driver_class", "org.hsqldb.jdbcDriver").
setProperty("hibernate.connection.url", "jdbc:hsqldb:mem:baseball").
setProperty("hibernate.connection.username", "sa").
setProperty("hibernate.connection.password", "").
setProperty("hibernate.connection.pool_size", "1").
setProperty("hibernate.connection.autocommit", "true").
setProperty("hibernate.cache.provider_class", "org.hibernate.cache.HashtableCacheProvider").
setProperty("hibernate.hbm2ddl.auto", "create-drop").
setProperty("hibernate.show_sql", "true").
addClass(WeeklyStat.class);
HibernateUtil.setSessionFactory(config.buildSessionFactory());
// uncomment the following if you want to launch a the dbmanager gui (while debugging through this class probably)
/* Runnable r = new Runnable() {
@Override
public void run() {