Connect to more than one database : Connection « Database SQL JDBC « Java






Connect to more than one database

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

public class TestConnectToMoreThanOneDatabase {

  public static Connection getOracleConnection() throws Exception {
    String driver = "oracle.jdbc.driver.OracleDriver";
    String url = "jdbc:oracle:thin:@localhost:1521:scorpian";
    String username = "userName";
    String password = "pass";
    Class.forName(driver); // load Oracle driver
    Connection conn = DriverManager.getConnection(url, username, password);
    return conn;
  }

  public static Connection getMySqlConnection() throws Exception {
    String driver = "org.gjt.mm.mysql.Driver";
    String url = "jdbc:mysql://localhost/tiger";
    String username = "root";
    String password = "root";
    Class.forName(driver); // load MySQL driver
    Connection conn = DriverManager.getConnection(url, username, password);
    return conn;
  }

  public static void main(String[] args) {

    Connection oracleConn = null;
    Connection mysqlConn = null;
    try {
      oracleConn = getOracleConnection();
      mysqlConn = getMySqlConnection();
      System.out.println("oracleConn=" + oracleConn);
      System.out.println("mysqlConn=" + mysqlConn);
    } catch (Exception e) {
      // handle the exception
      e.printStackTrace();
      System.exit(1);
    } finally {
      // release database resources
      try {
        oracleConn.close();
        mysqlConn.close();
      } catch (SQLException e) {
        e.printStackTrace();
      }
    }
  }
}
           
         
    
    
    
  








Related examples in the same category

1.Verify database setup
2.Debug Database connection
3.Create Connection With Properties
4.Set save point
5.JDBC Simple Connection
6.Load some drivers
7.Encapsulate the Connection-related operations that every JDBC program seems to use
8.Test of loading a driver and connecting to a database
9.Load MySQL JDBC Driver
10.Oracle JDBC Driver load
11.Oracle JDBC Driver load test: NewInstance
12.Test Register Oracle JDBC Driver
13.Install Oracle Driver and Execute Resultset
14.Test Thin Net8 App
15.Specify a CharSet when connecting to a DBMS
16.Listing All Available Parameters for Creating a JDBC Connection
17.String java.sql.DriverPropertyInfo.name (Get name of property)
18.boolean java.sql.DriverPropertyInfo.required (Is property value required?)
19.String java.sql.DriverPropertyInfo.value (Get current value)
20.String java.sql.DriverPropertyInfo.description (Get description of property)
21.String[] java.sql.DriverPropertyInfo.choices (Get possible choices for property; if null, value can be any string)
22.Determining If a Database Supports Transactions
23.Committing and Rolling Back Updates to a Database
24.Disable auto commit mode in JDBC
25.Print warnings on a Connection to STDERR.
26.Print warnings on a Connection to a specified PrintWriter.
27.This program tests that the database and the JDBC driver are correctly configured.
28.Manage Db connections providing shortcuts for Statements, PreparedStatements and ResultSets.