alvinalexander.com | career | drupal | java | mac | mysql | perl | scala | uml | unix  

What this is

This file is included in the DevDaily.com "Java Source Code Warehouse" project. The intent of this project is to help you "Learn Java by Example" TM.

Other links

The source code

/*
 *                 Sun Public License Notice
 * 
 * The contents of this file are subject to the Sun Public License
 * Version 1.0 (the "License"). You may not use this file except in
 * compliance with the License. A copy of the License is available at
 * http://www.sun.com/
 * 
 * The Original Code is NetBeans. The Initial Developer of the Original
 * Code is Sun Microsystems, Inc. Portions Copyright 1997-2004 Sun
 * Microsystems, Inc. All Rights Reserved.
 */

package org.netbeans.modules.db.util;

import java.util.LinkedList;
import java.util.List;
import java.util.Set;
import java.util.TreeSet;
import java.util.Vector;

import org.netbeans.modules.db.explorer.driver.JDBCDriver;
import org.netbeans.modules.db.explorer.driver.JDBCDriverManager;

public class DriverListUtil {
    
    private static List drivers = new LinkedList();
    private static List urls = new LinkedList();
    private static List names = new LinkedList();
    
    //private default constructor -> singleton
    private DriverListUtil() {
    }

    static {
        names.add("IBM DB2 (net)");
        drivers.add("COM.ibm.db2.jdbc.net.DB2Driver");
        urls.add("jdbc:db2://:/");

        names.add("IBM DB2 (local)");
        drivers.add("COM.ibm.db2.jdbc.app.DB2Driver");
        urls.add("jdbc:db2:");
        
        names.add("JDBC-ODBC Bridge");
        drivers.add("sun.jdbc.odbc.JdbcOdbcDriver");
        urls.add("jdbc:odbc:");
        
        names.add("Microsoft SQL Server (Weblogic driver)");
        drivers.add("weblogic.jdbc.mssqlserver4.Driver");
        urls.add("jdbc:weblogic:mssqlserver4:@:");
        
        names.add("Oracle"); //thin
        drivers.add("oracle.jdbc.driver.OracleDriver");
        urls.add("jdbc:oracle:thin:@::");
        
        names.add("PointBase"); //Network Server
        drivers.add("com.pointbase.jdbc.jdbcUniversalDriver");
        urls.add("jdbc:pointbase://[:]/");

        names.add("PointBase"); //Embedded Server
        drivers.add("com.pointbase.jdbc.jdbcUniversalDriver");
        urls.add("jdbc:pointbase://embedded[:]/");
        
        names.add("PointBase"); //Mobile Edition
        drivers.add("com.pointbase.jdbc.jdbcUniversalDriver");
        urls.add("jdbc:pointbase:");
        
        names.add("Cloudscape");
        drivers.add("COM.cloudscape.core.JDBCDriver");
        urls.add("jdbc:cloudscape:");
        
        names.add("Cloudscape RMI");
        drivers.add("RmiJdbc.RJDriver");
        urls.add("jdbc:rmi://:/jdbc:cloudscape:");
        
        names.add("Firebird (JCA/JDBC driver)");
        drivers.add("org.firebirdsql.jdbc.FBDriver");
        urls.add("jdbc:firebirdsql:[//[:]/]");
        
        names.add("FirstSQL/J"); //Enterprise Server Edition
        drivers.add("COM.FirstSQL.Dbcp.DbcpDriver");
        urls.add("jdbc:dbcp://:");
        
        names.add("FirstSQL/J"); //Professional Edition
        drivers.add("COM.FirstSQL.Dbcp.DbcpDriver");
        urls.add("jdbc:dbcp://local");
        
        names.add("IDS Server");
        drivers.add("ids.sql.IDSDriver");
        urls.add("jdbc:ids://:/conn?dsn=''");
        
        names.add("Informix Dynamic Server");
        drivers.add("com.informix.jdbc.IfxDriver");
        urls.add("jdbc:informix-sqli://:/:INFORMIXSERVER=");
        
        names.add("InstantDB (v3.13 and earlier)");
        drivers.add("jdbc.idbDriver");
        urls.add("jdbc:idb:");
        
        names.add("InstantDB (v3.14 and later)");
        drivers.add("org.enhydra.instantdb.jdbc.idbDriver");
        urls.add("jdbc:idb:");
        
        names.add("Interbase (InterClient driver)");
        drivers.add("interbase.interclient.Driver");
        urls.add("jdbc:interbase:///");
        
        names.add("HSQLDB"); //(server)
        drivers.add("org.hsqldb.jdbcDriver");
        urls.add("jdbc:hsqldb:hsql://[:]");
        
        names.add("HSQLDB"); //(standalone)
        drivers.add("org.hsqldb.jdbcDriver");
        urls.add("jdbc:hsqldb:");
        
        names.add("HSQLDB"); //(webserver)
        drivers.add("org.hsqldb.jdbcDriver");
        urls.add("jdbc:hsqldb:http://[:]");
        
        names.add("HSQLDB"); //(in-memory)
        drivers.add("org.hsqldb.jdbcDriver");
        urls.add("jdbc:hsqldb:.");
        
        names.add("Hypersonic SQL (v1.2 and earlier)");
        drivers.add("hSql.hDriver");
        urls.add("jdbc:HypersonicSQL:");
        
        names.add("Hypersonic SQL (v1.3 and later)");
        drivers.add("org.hsql.jdbcDriver");
        urls.add("jdbc:HypersonicSQL:");
        
        names.add("Mckoi SQL Database"); //(server)
        drivers.add("com.mckoi.JDBCDriver");
        urls.add("jdbc:mckoi://[:]");
        
        names.add("Mckoi SQL Database"); //(standalone)
        drivers.add("com.mckoi.JDBCDriver");
        urls.add("jdbc:mckoi:local://");
        
        names.add("Microsoft SQL Server (JTurbo driver)");
        drivers.add("com.ashna.jturbo.driver.Driver");
        urls.add("jdbc:JTurbo://:/");
        
        names.add("Microsoft SQL Server (Sprinta driver)");
        drivers.add("com.inet.tds.TdsDriver");
        urls.add("jdbc:inetdae::?database=");
        
        names.add("Microsoft SQL Server 2000 (Microsoft driver)");
        drivers.add("com.microsoft.jdbc.sqlserver.SQLServerDriver");
        urls.add("jdbc:microsoft:sqlserver://:[;DatabaseName=]");
        
        names.add("MySQL (MM.MySQL driver)");
        drivers.add("org.gjt.mm.mysql.Driver");
        urls.add("jdbc:mysql://:/");
        
        names.add("Oracle"); //OCI 8i
        drivers.add("oracle.jdbc.driver.OracleDriver");
        urls.add("jdbc:oracle:oci8:@");
        
        names.add("Oracle"); //OCI 9i
        drivers.add("oracle.jdbc.driver.OracleDriver");
        urls.add("jdbc:oracle:oci:@");
        
        names.add("PostgreSQL (v6.5 and earlier)");
        drivers.add("postgresql.Driver");
        urls.add("jdbc:postgresql://:/");
        
        names.add("PostgreSQL (v7.0 and later)");
        drivers.add("org.postgresql.Driver");
        urls.add("jdbc:postgresql://:/");
        
        names.add("Quadcap Embeddable Database");
        drivers.add("com.quadcap.jdbc.JdbcDriver");
        urls.add("jdbc:qed:");
        
        names.add("Sybase (jConnect 4.2 and earlier)");
        drivers.add("com.sybase.jdbc.SybDriver");
        urls.add("jdbc:sybase:Tds::");
        
        names.add("Sybase (jConnect 5.2)");
        drivers.add("com.sybase.jdbc2.jdbc.SybDriver");
        urls.add("jdbc:sybase:Tds::");
    }
    
    public static Set getDrivers() {
        return new TreeSet(drivers);
    }
    
    public static List getURLs(String drv) {
        List ret = new LinkedList();
        
        for (int i = 0; i < drivers.size(); i++)
            if (((String) drivers.get(i)).equals(drv))
                ret.add(urls.get(i));
        
        return ret;
    }
    
    public static String getName(String drv) {
        for (int i = 0; i < drivers.size(); i++)
            if (((String) drivers.get(i)).equals(drv))
                return (String) names.get(i);
        
        return "";
    }

    public static String findFreeName(String name) {
        String ret;
        Vector names = new Vector();
        JDBCDriver[] drivers = JDBCDriverManager.getDefault().getDrivers();
        for (int i = 0; i < drivers.length; i++)
            names.add(drivers[i].getName());
        
        if (names.contains(name))
            for (int i = 1;;i++) {
                ret = name + " (" + i + ")";
                if (!names.contains(ret))
                    return ret;
            }
        else
            return name;
    }
}
... this post is sponsored by my books ...

#1 New Release!

FP Best Seller

 

new blog posts

 

Copyright 1998-2021 Alvin Alexander, alvinalexander.com
All Rights Reserved.

A percentage of advertising revenue from
pages under the /java/jwarehouse URI on this website is
paid back to open source projects.