psdi.util

Class DBConnect

java.lang.Object

psdi.util.DBConnect

public class DBConnect
extends java.lang.Object

This class is used to get a database connection for utilities that are run OUTSIDE of MXServer. For classes inside MXServer, you must use DBManager or DBShortcut.

The getConnection method does the following:

1. It assumes that the Driver has already been registered via DriverManager.
2. Get the connection from DriverManager.
3. Set AutoCommit to False.
4. For Oracle and DB2, set current schema equal to the supplied value.
5. Set transaction isolation to the value specified on the MaxPropValue table for propname mxe.db.transaction_isolation. If the property is not defined or is invalid, the connection is set to Serializable.

See Also:

MXServer.getDBManager(), DBManager.getConnection(psdi.security.ConnectionKey), UserInfo.getConnectionKey(), DBManager, OracleProxyDBManager, DBShortcut

Constructor Summary

Constructors

Constructor and Description
DBConnect()

Method Summary

Modifier and Type	Method and Description
static java.sql.Connection	getConnection(java.lang.String url, java.lang.String user, java.lang.String password, java.lang.String schemaOwner) Return a database connection for the supplied parameters.
static java.sql.Connection	getConnection(java.lang.String url, java.lang.String user, java.lang.String password, java.lang.String schemaOwner, java.lang.String sslConnection, java.lang.String sslTrustStoreLocation, java.lang.String sslTrustStorePassword) Return a database connection for the supplied parameters.

Methods inherited from class java.lang.Object

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

Constructor Detail

DBConnect

public DBConnect()

Method Detail

getConnection

public static java.sql.Connection getConnection(java.lang.String url,
                                                java.lang.String user,
                                                java.lang.String password,
                                                java.lang.String schemaOwner)
                                         throws java.lang.Exception

Return a database connection for the supplied parameters.

Parameters:

url - Database url, normally from maximo.properties for mxe.db.url.

user - Database username, normally from maximo.properties for mxe.db.user.

password - Database password, normally from maximo.properties for mxe.db.password.

schemaOwner - Database schema, normally from maximo.properties for mxe.db.schemaowner.

Returns:

Connection

Throws:

java.lang.Exception

getConnection

public static java.sql.Connection getConnection(java.lang.String url,
                                                java.lang.String user,
                                                java.lang.String password,
                                                java.lang.String schemaOwner,
                                                java.lang.String sslConnection,
                                                java.lang.String sslTrustStoreLocation,
                                                java.lang.String sslTrustStorePassword)
                                         throws java.lang.Exception

Return a database connection for the supplied parameters.

Parameters:

url - Database url, normally from maximo.properties for mxe.db.url.

user - Database username, normally from maximo.properties for mxe.db.user.

password - Database password, normally from maximo.properties for mxe.db.password.

schemaOwner - Database schema, normally from maximo.properties for mxe.db.schemaowner.

sslConnection - For DB2 only, is ssl connection?

sslTrustStoreLocation - For DB2 only, ssl connection trust store location

sslTrustStorePassword - For DB2 only, ssl connection trust store password

Returns:

Connection

Throws:

java.lang.Exception