Java JDBC Derby Connection startDerby()

Description

start Derby

License

Apache License

Declaration

public static void startDerby() throws Exception 

Method Source Code

//package com.java2s;
/*/*  w ww. j a va2s . 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.sql.Connection;
import java.sql.DriverManager;

import java.sql.Statement;
import java.util.Properties;

public class Main {
    public static void startDerby() throws Exception {
        // Start Apache Derby
        Class.forName("org.apache.derby.jdbc.EmbeddedDriver").newInstance();

        Properties props = new Properties();
        Connection conn = DriverManager.getConnection("jdbc:derby:memory:derbyDB;create=true", props);

        Statement statement = conn.createStatement();
        statement.execute("CREATE SCHEMA KMSADMIN");

        statement.execute("SET SCHEMA KMSADMIN");

        // Create masterkey table
        statement.execute("CREATE SEQUENCE RANGER_MASTERKEY_SEQ START WITH 1 INCREMENT BY 1");
        String tableCreationString = "CREATE TABLE ranger_masterkey (id VARCHAR(20) NOT NULL PRIMARY KEY, create_time DATE,"
                + "update_time DATE, added_by_id VARCHAR(20), upd_by_id VARCHAR(20),"
                + "cipher VARCHAR(255), bitlength VARCHAR(11), masterkey VARCHAR(2048))";
        statement.execute(tableCreationString);

        // Create keys table
        statement.execute("CREATE SEQUENCE RANGER_KEYSTORE_SEQ START WITH 1 INCREMENT BY 1");
        statement.execute("CREATE TABLE ranger_keystore(id VARCHAR(20) NOT NULL PRIMARY KEY, create_time DATE,"
                + "update_time DATE, added_by_id VARCHAR(20), upd_by_id VARCHAR(20),"
                + "kms_alias VARCHAR(255) NOT NULL, kms_createdDate VARCHAR(20), kms_cipher VARCHAR(255),"
                + "kms_bitLength VARCHAR(20), kms_description VARCHAR(512), kms_version VARCHAR(20),"
                + "kms_attributes VARCHAR(1024), kms_encoded VARCHAR(2048))");

        conn.close();
    }
}

Related

1. getSize2()
2. getTables(File database)
3. printStats(String statstring)
4. removeUnitDB()
5. saveContact(String fName, String lName)
6. startDerbyInEmbeddedMode()
7. stopDerby()