Example usage for java.sql DriverManager registerDriver

Introduction

In this page you can find the example usage for java.sql DriverManager registerDriver.

Prototype

public static void registerDriver(java.sql.Driver driver) throws SQLException 

Source Link

Document

Registers the given driver with the DriverManager .

Usage

From source file:Main.java

public static void main(String[] args) throws Exception {

    Driver myDriver = new org.hsqldb.jdbcDriver();
    DriverManager.registerDriver(myDriver);
    System.out.println(myDriver.acceptsURL("jdbc:mydriver://tutorial/"));
    System.out.println("Major Version: " + myDriver.getMajorVersion());
    System.out.println("Minor Version: " + myDriver.getMinorVersion());
    System.out.println("JDBC COMPLIANT driver? " + myDriver.jdbcCompliant());

}

---

From source file:Main.java

public static void main(String[] args) throws Exception {
    Class driverClass = Class.forName("org.hsqldb.jdbcDriver");
    DriverManager.registerDriver((Driver) driverClass.newInstance());

    // Print out all loaded JDBC drivers.
    java.util.Enumeration e = java.sql.DriverManager.getDrivers();
    while (e.hasMoreElements()) {
        Object driverAsObject = e.nextElement();
        System.out.println("JDBC Driver=" + driverAsObject);
    }//ww w.  j a  v  a  2s .c om

}

---

From source file:DataInserter.java

public static void main(String args[]) throws Exception {
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    DriverManager.registerDriver(new JdbcOdbcDriver());
    String SQLCommand = "INSERT INTO CONTACT_INFO " + "(First_Name,MI,Last_Name,Street,City,State,Zip) "
            + "VALUES " + "('Michael','J','Corleone','86 Horsehead Blvd','NY','NY','12345');";
    String url = "jdbc:odbc:Contacts";
    Connection con = DriverManager.getConnection(url);
    Statement stmt = con.createStatement();
    stmt.execute(SQLCommand);/*from  www  . j a va 2s .com*/
    con.close();

}

---

From source file:TestDataEncryptionIntegrity.java

public static void main(String[] argv) throws Exception {

    DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

    Properties prop = new Properties();
    prop.setProperty("user", "scott");
    prop.setProperty("password", "tiger");
    prop.setProperty("oracle.net.encryption_client", "REQUIRED");
    prop.setProperty("oracle.net.encryption_types_client", "( RC4_40 )");
    prop.setProperty("oracle.net.crypto_checksum_client", "REQUIRED");
    prop.setProperty("oracle.net.crypto_checksum_types_client", "( MD5 )");

    Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@dssw2k01:1521:orcl", prop);
    Statement stmt = conn.createStatement();
    ResultSet rset = stmt.executeQuery(
            "select 'Hello Thin driver Encryption & Integrity " + "tester '||USER||'!' result from dual");
    while (rset.next())
        System.out.println(rset.getString(1));
    rset.close();//from w  w  w.  ja v a 2  s  .c  om
    stmt.close();
    conn.close();
}

---

From source file:DataUpdater.java

public static void main(String args[]) throws Exception {

    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    DriverManager.registerDriver(new JdbcOdbcDriver());
    String url = "jdbc:odbc:Contacts";

    Connection con = DriverManager.getConnection(url);
    Statement stmt = con.createStatement();
    String SQLCommand = "UPDATE CONTACT_INFO " + "SET STREET = '58 Broadway', ZIP = '10008' "
            + "WHERE First_Name = 'Michael' AND " + "Last_Name ='Corleone';";

    stmt.execute(SQLCommand);/*from   w  ww .  ja  v a2  s .c  om*/
    con.close();
}

---

From source file:TestRegisterDriverApp.java

public static void main(String args[]) {

    try {/*from  w  w w .  j  a  va2 s.c  o  m*/
        DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
    } catch (SQLException e) {
        System.out.println("Oops! Got a SQL error: " + e.getMessage());
        System.exit(1);
    }

    Connection conn = null;
    Statement stmt = null;
    ResultSet rset = null;
    try {
        conn = DriverManager.getConnection("jdbc:oracle:thin:@dssw2k01:1521:orcl", "scott", "tiger");

        stmt = conn.createStatement();
        rset = stmt.executeQuery("select 'Hello '||USER||'!' result from dual");
        while (rset.next())
            System.out.println(rset.getString(1));
        rset.close();
        rset = null;
        stmt.close();
        stmt = null;
        conn.close();
        conn = null;
    } catch (SQLException e) {
        System.out.println("Darn! A SQL error: " + e.getMessage());
    } finally {
        if (rset != null)
            try {
                rset.close();
            } catch (SQLException ignore) {
            }
        if (stmt != null)
            try {
                stmt.close();
            } catch (SQLException ignore) {
            }
        if (conn != null)
            try {
                conn.close();
            } catch (SQLException ignore) {
            }
    }
}

---

From source file:TestSSL.java

public static void main(String[] argv) throws Exception {

    DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

    Properties prop = new Properties();
    prop.setProperty("user", "scott");
    prop.setProperty("password", "tiger");
    // THIS DOES NOT WORK YET
    prop.setProperty("oracle.net.ssl_cipher_suites",
            "(ssl_rsa_export_with_rc4_40_md5, ssl_rsa_export_with_des40_cbc_sha)");
    prop.setProperty("oracle.net.ssl_client_authentication", "false");
    prop.setProperty("oracle.net.ssl_version", "3.0");
    prop.setProperty("oracle.net.encryption_client", "REJECTED");
    prop.setProperty("oracle.net.crypto_checksum_client", "REJECTED");
    Connection conn = DriverManager.getConnection(
            "jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCPS)(HOST = dssw2k01)(PORT = 2484))) (CONNECT_DATA = (SERVICE_NAME = DSSW2K01)))",
            prop);//from  ww  w . j a  v a  2  s  .c  om
    Statement stmt = conn.createStatement();
    ResultSet rset = stmt
            .executeQuery("select 'Hello Thin driver SSL " + "tester '||USER||'!' result from dual");
    while (rset.next())
        System.out.println(rset.getString(1));
    rset.close();
    stmt.close();
    conn.close();
}

---

From source file:com.linuxrouter.netcool.test.DbPoolTest.java

public static void main(String[] args) {
    String host = "192.168.0.201";
    String port = "4100";
    String dbName = "alerts";
    String url = "jdbc:sybase:Tds:" + host + ":" + port + "/" + dbName;
    Driver drv = new com.sybase.jdbc3.jdbc.SybDriver();
    try {/*from   ww  w  .  java2 s. c  om*/
        DriverManager.registerDriver(drv);
    } catch (SQLException ex) {
        Logger.getLogger(DbPoolTest.class.getName()).log(Level.SEVERE, null, ex);
    }
    ConnectionFactory connectionFactory = new DriverManagerConnectionFactory(url, "root", "omni12@#");
    PoolableConnectionFactory poolableConnectionFactory = new PoolableConnectionFactory(connectionFactory,
            null);
    ObjectPool<PoolableConnection> connectionPool = new GenericObjectPool<>(poolableConnectionFactory);
    poolableConnectionFactory.setPool(connectionPool);
    PoolingDataSource<PoolableConnection> poolingDataSource = new PoolingDataSource<>(connectionPool);
    try {
        Connection con = poolingDataSource.getConnection();
        Statement st = con.createStatement();
        ResultSet rs = st.executeQuery("select * from alerts.status");
        int x = 0;
        while (rs.next()) {
            //System.out.println(":::" + rs.getString(1));
            x++;
        }
        System.out.println("::::::" + x);
    } catch (SQLException ex) {
        Logger.getLogger(DbPoolTest.class.getName()).log(Level.SEVERE, null, ex);
    }
}

---

From source file:org.miloss.fgsms.tools.DatabaseExport.java

public static void main(String[] args) throws Exception {
    System.out.println("For best results, stop the FGSMS server(s)");
    String database = "fgsms_performance";
    String url = "jdbc:postgresql://localhost:5432/";
    String username = "fgsms";
    String password = "";
    String outputFile = "export";
    Options options = new Options();
    options.addOption("u", true, "username, if not specified, fgsms will be used");
    options.addOption("p", true, "password, if not specified, you will be prompted");
    options.addOption("db", true,
            "database to export, default is fgsms_performance but can also be fgsms_config");
    options.addOption("server", true,
            "the jdbc connection url to the database server, default is jdbc:postgresql://localhost:5432/");
    options.addOption("output", true,
            "output file name, if not specified, export_databasename.sql will be used");
    //options.addOption("type", true, "default output is SQL, but CSV can also be specified");
    CommandLineParser parser = new DefaultParser();
    CommandLine cmd = parser.parse(options, args);

    if (cmd.hasOption("server")) {
        url = cmd.getOptionValue("server");
    }//from ww w.ja  v  a 2  s  .  c o  m
    if (cmd.hasOption("u")) {
        username = cmd.getOptionValue("u");
    }
    if (cmd.hasOption("p")) {
        password = cmd.getOptionValue("p");
    } else {
        password = getStringPw();
    }
    if (cmd.hasOption("db")) {
        database = cmd.getOptionValue("db");
    }
    if (cmd.hasOption("output")) {
        outputFile = cmd.getOptionValue("output");
    } else {
        outputFile = outputFile + "_" + database + ".sql";
    }

    Driver d = (Driver) Class.forName("org.postgresql.Driver").newInstance();
    DriverManager.registerDriver(d);
    Connection con = DriverManager.getConnection(url + database, username, password);

    PrintWriter fos = new PrintWriter(outputFile, Constants.CHARSET);

    exportPerformance(fos, con);
    System.out.println(
            outputFile + " can now be imported into another postgres instance using the following command");
    System.out.println("## makes 2 test databases with all the tables and indexes");
    System.out.println("> psql -U postgres -f db_test.sql");
    System.out.println("## import the data");
    System.out.println("> psql -U postgres -d (target database) -f " + outputFile);
    System.out.println("example > psql -U postgres -d fgsms_performance_test -f " + outputFile);

}

---

From source file:datatableinputdata.DataTableInputData.java

/**
 * @param args the command line arguments
 *///from   w w w.  j  av a 2s  . c  om
private static void DBConnect() throws SQLException {
    CallableStatement cstmt = null;
    String serverIP = "192.168.16.13";
    String portNumber = "1521";
    String instanceName = "pudp";
    String username = "argen666";
    String password = "argen666";
    DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
    String url = "jdbc:oracle:thin:@" + serverIP + ":" + portNumber + ":" + instanceName;
    connection = DriverManager.getConnection(url, username, password);

}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• »