Initialize hsqldb database storage. - Java java.sql

Java examples for java.sql:hsql

  1. HOME
  2. Java
  3. java.sql
  4. hsql

Description

Initialize hsqldb database storage.

Demo Code

/**//from   w w  w .j  a va 2s  .c o m
 * Licensed to the Apache Software Foundation (ASF) under one
 * or more contributor license agreements.  See the NOTICE file
 * distributed with this work for additional information
 * regarding copyright ownership.  The ASF licenses this file
 * to you 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.
 */
import java.io.BufferedReader;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

public class Main{
    public static void main(String[] argv) throws Exception{
        initializeDatabaseStorage();
    }
    /**
     * Initialize database storage.
     *
     * @throws Exception the exception
     */
    public static void initializeDatabaseStorage() throws Exception {

        try {
            Class.forName("org.hsqldb.jdbcDriver");
        } catch (ClassNotFoundException e) {
            System.err
                    .println("Unable to locate the JDBC driver class for DB Storage");
        }
        Connection con = DriverManager.getConnection(
                "jdbc:hsqldb:/tmp/db-storage.db", "SA", "");

        con.setAutoCommit(true);
        Statement statement = con.createStatement();

        InputStream file = DatabaseUtil.class.getClassLoader()
                .getResourceAsStream("db-storage-schema.sql");
        BufferedReader reader = new BufferedReader(new InputStreamReader(
                file, "UTF-8"));
        String line;
        while ((line = reader.readLine()) != null) {
            if (line.trim().equals("") || line.startsWith("--")) {
                continue;
            }
            statement.executeUpdate(line);
        }
        statement.execute("SHUTDOWN");
        statement.close();
        con.close();
    }
}

Related Tutorials