com.portal.pcm

Class DatabaseConnection

java.lang.Object

com.portal.pcm.DatabaseConnection

public class DatabaseConnection
extends java.lang.Object

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	SQLSERVER_DRIVER
static java.lang.String	SQLSERVER_SELECTMETHOD
static java.lang.String	SQLSERVER_URL
static java.lang.String	TIMESTEN_DRIVER
static java.lang.String	TIMESTENDSNPREFIX

Constructor Summary

Constructors

Constructor and Description
DatabaseConnection()

Method Summary

Modifier and Type	Method and Description
static java.sql.Connection	createOracleConnection(java.lang.String user, java.lang.String password, java.lang.String dbName) Attempts to establish a connection to an oracle database through a Oracle JDBC thin driver.
static java.sql.Connection	createOracleConnection(java.lang.String user, java.lang.String password, java.lang.String dbName, java.util.Properties prop) Attempts to establish a connection to an oracle database through a Oracle JDBC thin driver.
static java.sql.Connection	createOracleConnection(java.lang.String user, java.lang.String password, java.lang.String dbHost, java.lang.String dbPort, java.lang.String svcName) Attempts to establish a connection to an oracle database through a Oracle JDBC thin driver.
static java.sql.Connection	createOracleConnection(java.lang.String user, java.lang.String password, java.lang.String dbHost, java.lang.String dbPort, java.lang.String svcName, java.util.Properties prop) Attempts to establish a connection to an oracle database through a Oracle JDBC thin driver.
static java.sql.Connection	createOracleThinConnection(java.lang.String user, java.lang.String password, java.lang.String Host, java.lang.String Port, java.lang.String Sid) Attempts to establish a connection to an oracle database through a Oracle thin JDBC driver.
static java.sql.Connection	createTimesTenConnection(java.lang.String user, java.lang.String password, java.lang.String dsnName) Attempts to establish a connection to a TimesTen datastore through a TimesTen JDBC driver.
static java.sql.Connection	createTimesTenConnection(java.lang.String user, java.lang.String password, java.lang.String dsnName, java.lang.String oraclePwd) Attempts to establish a connection to a TimesTen datastore through a TimesTen JDBC driver.
static java.lang.Process	exec_sql_cmd(java.lang.String cmd, java.lang.String password) Provides an interface to execute sqlloader/sqlplus operation as system command by decrypting the password, second parameter.
static java.lang.Process	exec_sql_cmd(java.lang.String cmd, java.lang.String[] envp, java.io.File dir, java.lang.String password) Provides an interface to execute sqlloader/sqlplus operation as system command by decrypting the password, second parameter.
static java.lang.Process	exec_sql_cmd(java.lang.String cmd, java.lang.String[] envp, java.lang.String password) Provides an interface to execute sqlloader/sqlplus operation as system command by decrypting the password, second parameter.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

TIMESTEN_DRIVER

public static final java.lang.String TIMESTEN_DRIVER

See Also:

Constant Field Values

TIMESTENDSNPREFIX

public static final java.lang.String TIMESTENDSNPREFIX

See Also:

Constant Field Values

SQLSERVER_DRIVER

public static final java.lang.String SQLSERVER_DRIVER

See Also:

Constant Field Values

SQLSERVER_URL

public static final java.lang.String SQLSERVER_URL

See Also:

Constant Field Values

SQLSERVER_SELECTMETHOD

public static final java.lang.String SQLSERVER_SELECTMETHOD

See Also:

Constant Field Values

Constructor Detail

DatabaseConnection

public DatabaseConnection()

Method Detail

createOracleConnection

public static java.sql.Connection createOracleConnection(java.lang.String user,
                                                         java.lang.String password,
                                                         java.lang.String dbName)
                                                  throws java.lang.Exception

Attempts to establish a connection to an oracle database through a Oracle JDBC thin driver. If successful, returns a JDBC Connection object. Multiple connections if need be created with this method.

Parameters:

user - - User name

password - - Password

dbName - - Name of the database

Returns:

Connection - JDBC Connection object

Throws:

java.lang.Exception

createOracleConnection

public static java.sql.Connection createOracleConnection(java.lang.String user,
                                                         java.lang.String password,
                                                         java.lang.String dbName,
                                                         java.util.Properties prop)
                                                  throws java.lang.Exception

Attempts to establish a connection to an oracle database through a Oracle JDBC thin driver. If successful, returns a JDBC Connection object. Multiple connections if need be created with this method. This method can be used to connect over TLS port

Parameters:

user - - User name

password - - Password

dbName - - Name of the database

prop - - Connection Properties

Returns:

Connection - JDBC Connection object

Throws:

java.lang.Exception

createOracleConnection

public static java.sql.Connection createOracleConnection(java.lang.String user,
                                                         java.lang.String password,
                                                         java.lang.String dbHost,
                                                         java.lang.String dbPort,
                                                         java.lang.String svcName,
                                                         java.util.Properties prop)
                                                  throws java.lang.Exception

Attempts to establish a connection to an oracle database through a Oracle JDBC thin driver. If successful, returns a JDBC Connection object. Multiple connections if need be created with this method. This method can be used to connect over TLS port

Parameters:

user - - User name

password - - Password

dbHost - - Database hostname

dbPort - - Database port

svcName - - Database service name

prop - - Connection Properties

Returns:

Connection - JDBC Connection object

Throws:

java.lang.Exception

createOracleConnection

public static java.sql.Connection createOracleConnection(java.lang.String user,
                                                         java.lang.String password,
                                                         java.lang.String dbHost,
                                                         java.lang.String dbPort,
                                                         java.lang.String svcName)
                                                  throws java.lang.Exception

Attempts to establish a connection to an oracle database through a Oracle JDBC thin driver. If successful, returns a JDBC Connection object. Multiple connections if need be created with this method.

Parameters:

user - - User name

password - - Password

dbHost - - Database hostname

dbPort - - Database port

svcName - - Database service name

Returns:

Connection - JDBC Connection object

Throws:

java.lang.Exception

createOracleThinConnection

public static java.sql.Connection createOracleThinConnection(java.lang.String user,
                                                             java.lang.String password,
                                                             java.lang.String Host,
                                                             java.lang.String Port,
                                                             java.lang.String Sid)
                                                      throws java.lang.Exception

Attempts to establish a connection to an oracle database through a Oracle thin JDBC driver. If successful, returns a JDBC Connection object. Multiple connections if need be created with this method.

Parameters:

user - - User name

password - - Password

Host - - Database host

Port - - Database port

Sid - - SID of the database

Returns:

Connection - JDBC Connection object

Throws:

java.lang.Exception

exec_sql_cmd

public static java.lang.Process exec_sql_cmd(java.lang.String cmd,
                                             java.lang.String password)
                                      throws java.lang.Exception

Provides an interface to execute sqlloader/sqlplus operation as system command by decrypting the password, second parameter.

Parameters:

cmd - - sqlloader/sqlplus command with PASSWORD constant embedded in it. Like 'sqlloader <username>/PASSWORD@<database>'

password - - plain or encrypted password. Like '&aes|05|...'

Returns:

process id

Throws:

java.lang.Exception

exec_sql_cmd

public static java.lang.Process exec_sql_cmd(java.lang.String cmd,
                                             java.lang.String[] envp,
                                             java.lang.String password)
                                      throws java.lang.Exception

Provides an interface to execute sqlloader/sqlplus operation as system command by decrypting the password, second parameter.

Parameters:

cmd - - sqlloader/sqlplus command with PASSWORD constant embedded in it. Like 'sqlloader <username>/PASSWORD@<database>'

password - - plain or encrypted password. Like '&aes|05|...'

envp - - environment variables array

Returns:

process id

Throws:

java.lang.Exception

exec_sql_cmd

public static java.lang.Process exec_sql_cmd(java.lang.String cmd,
                                             java.lang.String[] envp,
                                             java.io.File dir,
                                             java.lang.String password)
                                      throws java.lang.Exception

Provides an interface to execute sqlloader/sqlplus operation as system command by decrypting the password, second parameter.

Parameters:

cmd - - sqlloader/sqlplus command with PASSWORD constant embedded in it. Like 'sqlloader <username>/PASSWORD@<database>'

password - - plain or encrypted password. Like '&aes|05|...'

envp - - environment variables array

dir - - Directory path

Returns:

process id

Throws:

java.lang.Exception

createTimesTenConnection

public static java.sql.Connection createTimesTenConnection(java.lang.String user,
                                                           java.lang.String password,
                                                           java.lang.String dsnName)
                                                    throws java.lang.Exception

Attempts to establish a connection to a TimesTen datastore through a TimesTen JDBC driver. If successful, returns a JDBC Connection object.

Parameters:

user - - User name

password - - plain or encrypted password. Like '&aes|05|0D5E11BFDD97D2769D9B0DBFBD1BBF7E5A47EE7B6C8677D6E95F4E14E55CA745C1'

dsnName - - DataStoreName that matches the entry in odbc.ini

Returns:

Connection - JDBC Connection object

Throws:

java.lang.Exception

createTimesTenConnection

public static java.sql.Connection createTimesTenConnection(java.lang.String user,
                                                           java.lang.String password,
                                                           java.lang.String dsnName,
                                                           java.lang.String oraclePwd)
                                                    throws java.lang.Exception

Attempts to establish a connection to a TimesTen datastore through a TimesTen JDBC driver. If successful, returns a JDBC Connection object.

Parameters:

user - - User name

password - - plain or encrypted password. Like '&aes|05|...'

dsnName - - DataStoreName that matches the entry in odbc.ini

oraclePwd - - backend oracle password plain or encrypted

Returns:

Connection - JDBC Connection object

Throws:

java.lang.Exception