Java JDBC Connection Create getTestDBConnection()

Description

get Test DB Connection

License

Apache License

Declaration

public static Connection getTestDBConnection() throws Exception 

Method Source Code

//package com.java2s;
/*/*ww w.  ja  v a 2  s  . c  o  m*/
 * Copyright (c) 2011 Google Inc.
 *
 * 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;

public class Main {
    public static Connection getTestDBConnection() throws Exception {
        Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
        String url = "jdbc:ucanaccess://C:/users/cgrass/Desktop/" + "USM Marketing Application/Test Database/"
                + "test_USMMarketingIntelligenceDatabase.accdb";
        Connection conn = DriverManager.getConnection(url);
        return conn;
    }
}

Related

1. getNewConnection()
2. getPhoenixConnection()
3. getSourceConnection(final Hashtable env)
4. getStatement(Map config)
5. getTargetConnection()
6. getTRECConnection()
7. getUrlConnection()
8. getUserConnection()
9. internalShutdown(String connectionString, int expectedErrorCode, String expectedSQLState)