01: /*
02: * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
03: *
04: * Copyright 1997-2007 Sun Microsystems, Inc. All rights reserved.
05: *
06: * The contents of this file are subject to the terms of either the GNU
07: * General Public License Version 2 only ("GPL") or the Common
08: * Development and Distribution License("CDDL") (collectively, the
09: * "License"). You may not use this file except in compliance with the
10: * License. You can obtain a copy of the License at
11: * http://www.netbeans.org/cddl-gplv2.html
12: * or nbbuild/licenses/CDDL-GPL-2-CP. See the License for the
13: * specific language governing permissions and limitations under the
14: * License. When distributing the software, include this License Header
15: * Notice in each file and include the License file at
16: * nbbuild/licenses/CDDL-GPL-2-CP. Sun designates this
17: * particular file as subject to the "Classpath" exception as provided
18: * by Sun in the GPL Version 2 section of the License file that
19: * accompanied this code. If applicable, add the following below the
20: * License Header, with the fields enclosed by brackets [] replaced by
21: * your own identifying information:
22: * "Portions Copyrighted [year] [name of copyright owner]"
23: *
24: * Contributor(s):
25: *
26: * The Original Software is NetBeans. The Initial Developer of the Original
27: * Software is Sun Microsystems, Inc. Portions Copyright 1997-2006 Sun
28: * Microsystems, Inc. All Rights Reserved.
29: *
30: * If you wish your version of this file to be governed by only the CDDL
31: * or only the GPL Version 2, indicate your decision by adding
32: * "[Contributor] elects to include this software in this distribution
33: * under the [CDDL or GPL Version 2] license." If you do not indicate a
34: * single choice of license, a recipient has the option to distribute
35: * your version of this file under either the CDDL, the GPL Version 2 or
36: * to extend the choice of license to its licensees as provided above.
37: * However, if you add GPL Version 2 code and therefore, elected the GPL
38: * Version 2 license, then the option applies only if the new code is
39: * made subject to such option by the copyright holder.
40: */
41:
42: package org.netbeans.test.db.util;
43:
44: import java.io.File;
45: import java.net.MalformedURLException;
46: import java.net.URL;
47: import java.sql.Connection;
48: import java.sql.Driver;
49: import java.sql.SQLException;
50: import org.netbeans.modules.derby.DbURLClassLoader;
51: import org.netbeans.modules.derby.DerbyOptions;
52: import org.openide.util.Exceptions;
53:
54: /**
55: *
56: * @author luke
57: */
58: public class DbUtil {
59: public static final String DRIVER_CLASS_NAME = "org.apache.derby.jdbc.ClientDriver";
60:
61: public static Connection createDerbyConnection(String dbURL) {
62: // Derby Installation folder
63: String location = DerbyOptions.getDefault().getLocation();
64: File clientJar = new File(location, "lib/derbyclient.jar");
65: Connection con = null;
66: try {
67: System.out.println("> Creating Derby connection using: "
68: + clientJar.toURL());
69: URL[] driverURLs = new URL[] { clientJar.toURL() };
70: DbURLClassLoader loader = new DbURLClassLoader(driverURLs);
71: Driver driver = (Driver) Class.forName(DRIVER_CLASS_NAME,
72: true, loader).newInstance();
73: con = driver.connect(dbURL, null);
74: } catch (MalformedURLException ex) {
75: Exceptions.attachMessage(ex, "Cannot convert to URL: "
76: + clientJar);
77: Exceptions.printStackTrace(ex);
78: } catch (SQLException ex) {
79: Exceptions.attachMessage(ex, "Cannot conect to: " + dbURL);
80: Exceptions.printStackTrace(ex);
81: } catch (InstantiationException ex) {
82: Exceptions.attachMessage(ex, "Cannot instantiate: "
83: + DRIVER_CLASS_NAME + " from: " + clientJar);
84: Exceptions.printStackTrace(ex);
85: } catch (IllegalAccessException ex) {
86: Exceptions.attachMessage(ex, "Cannot instantiate: "
87: + DRIVER_CLASS_NAME + " from: " + clientJar);
88: Exceptions.printStackTrace(ex);
89: } catch (ClassNotFoundException ex) {
90: Exceptions.attachMessage(ex, "Cannot obtain: "
91: + DRIVER_CLASS_NAME + " from: " + clientJar);
92: Exceptions.printStackTrace(ex);
93: }
94: return con;
95: }
96:
97: }
|