edu.uiowa.icts.spring.HsqlAnnotationSessionFactoryBean Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of spring-utils Show documentation
ICTS Utilities for Spring Hibernate Projects
The newest version!
/**
 * Institute for Clinical and Translation Science (ICTS)
 * University of Iowa
 */
package edu.uiowa.icts.spring;

/*
 * #%L
 * spring-utils
 * %%
 * Copyright (C) 2010 - 2015 University of Iowa Institute for Clinical and Translational Science (ICTS)
 * %%
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 * 
 *      http://www.apache.org/licenses/LICENSE-2.0
 * 
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 * #L%
 */

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.List;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean;

/**
 * @author bkusenda
 * @since January 5, 2011
 */
public class HsqlAnnotationSessionFactoryBean extends AnnotationSessionFactoryBean {

	private static final Log log = LogFactory.getLog( HsqlAnnotationSessionFactoryBean.class );

	private List schemas;
	private String url = "jdbc:hsqldb:file:testdb";

	public void create() {
		log.debug( "Creating schemas :" + schemas.size() );

		try {
			Class.forName( "org.hsqldb.jdbcDriver" );
		} catch ( ClassNotFoundException e1 ) {
			log.error( "error calling Class.forName( \"org.hsqldb.jdbcDriver\" );", e1 );
		}

		Connection conn = null;
		try {
			conn = DriverManager.getConnection( url, "sa", "" );
			for ( String schema : schemas ) {
				Statement st = conn.createStatement();
				String expression = "CREATE SCHEMA " + schema + " AUTHORIZATION DBA";
				st.executeUpdate( expression );
				st.close();
			}
		} catch ( Exception e ) {
			log.error( "error creating schema", e );
		} finally {
			try {
				if ( conn != null && !conn.isClosed() ) {
					conn.close();
				}
			} catch ( SQLException e ) {
				log.error( "error closing connection", e );
			}
		}
	}

	public List getSchemas() {
		return schemas;
	}

	public void setSchemas( List schemas ) {
		this.schemas = schemas;
	}

	public String getUrl() {
		return url;
	}

	public void setUrl( String url ) {
		this.url = url;
	}

}