Java Utililty Methods JDBC Oracle Connection

List of utility methods to do JDBC Oracle Connection

  1. HOME
  2. Java
  3. J
  4. JDBC Oracle Connection

Description

The list of methods to do JDBC Oracle Connection are organized into topic(s).

Method

ConnectiongetOracleDBConnection(String server, String database, String username, String password)
get Oracle DB Connection 
Connection conn = null;
try {
    Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
    e.printStackTrace();
try {
    conn = DriverManager.getConnection("jdbc:oracle:thin:@" + server + ":1521:" + database, username,
...
StringGetSchemaList(String dbSourceName, String server, int port, String dbName, String userid, String pwd)
Get Schema List 
Connection mainConn = null;
String tableSchema = "";
String schemaNames = "";
String driverName = getDriverName(dbSourceName);
Message = "";
try {
    Class.forName(driverName).newInstance();
    log("Driver " + driverName + " loaded");
...
ConnectionOpenConnection(String dbSourceName, String server, int port, String dbName, String userid, String pwd)
Open Connection 
Connection mainConn = null;
Message = "";
String driverName = getDriverName(dbSourceName);
try {
    try {
        Class.forName(driverName).newInstance();
    } catch (Exception e) {
        e.printStackTrace();
...