Java JDBC Derby Connection createConnection()

Description

create Connection

License

Apache License

Declaration

public static void createConnection() 

Method Source Code

//package com.java2s;
/**/*from  w w  w.ja  va 2 s  . c om*/
 * Copyright 2015, Namrata Nehete
 *
 * 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.
 */

import java.sql.Connection;
import java.sql.DriverManager;

import java.sql.SQLException;

public class Main {
    private static final String dbURL = "jdbc:derby:DiscoHub;create=true;user=App;password=";
    private static Connection conn = null;

    public static void createConnection() {
        try {
            System.setProperty("derby.system.home", System.getProperty("user.home") + "/DiscoHub");
            Class.forName("org.apache.derby.jdbc.EmbeddedDriver").newInstance();
            //Get a connection
            conn = DriverManager.getConnection(dbURL);
        } catch (ClassNotFoundException | InstantiationException | IllegalAccessException | SQLException ex) {
            System.out.println("error " + ex.getMessage());
        }
    }
}

Related

1. cleanUpTest(Statement s, String[] testObjects)
2. closeConnection()
3. closeDB()
4. createAndOpen(String databaseName)
5. createConnection(String userName, String password)
6. createXATransactionView(Statement s)
7. deleteTestData()
8. existsInSessionTable(String id, boolean verbose)