sailpoint.connector.util

Class JDBCUtil

java.lang.Object

sailpoint.connector.util.JDBCUtil

public class JDBCUtil
extends java.lang.Object

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	JDBCUtil.ConnectorType

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	ORACLE_CLOB_HANDLER

Constructor Summary

Constructors

Constructor and Description
JDBCUtil()

Method Summary

Modifier and Type	Method and Description
static void	closeConnection(java.sql.Connection con)
static void	closeResult(java.sql.ResultSet res)
static void	closeStatement(java.sql.Statement stmt)
static java.lang.String	escapeSpecialCharacter(java.lang.String name, JDBCUtil.ConnectorType type)
static java.lang.String	escapeSpecialCharactor(java.lang.String name, JDBCUtil.ConnectorType type)
static java.sql.Connection	getConnection(java.util.Map args)
static java.sql.Connection	getConnection(java.lang.String driverClass, java.lang.String driverPrefix, java.lang.String url, java.lang.String user, java.lang.String password)
static java.sql.Connection	getConnection(java.lang.String driverClass, java.lang.String driverPrefix, java.lang.String url, java.lang.String user, java.lang.String password, java.util.Properties props)
static java.lang.String	getOracleDBTimeZoneDetails(java.sql.Connection connection, java.lang.String applicationName, java.lang.String applicationType)
static java.lang.String	getOracleDBVersionDetails(java.sql.Connection connection, java.lang.String applicationName, java.lang.String applicationType)
static void	initializeSession(java.sql.Connection connection, int userId, int responsibilityID, int applicationID)
static java.lang.String	useQuoteForScripts(java.lang.String val, java.lang.String quoteForCaseInsensitveDatabase, java.lang.String quoteForCaseSensitiveDatabase, boolean caseSensitive)

Methods inherited from class java.lang.Object

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

Field Detail

ORACLE_CLOB_HANDLER

public static java.lang.String ORACLE_CLOB_HANDLER

Constructor Detail

JDBCUtil

public JDBCUtil()

Method Detail

escapeSpecialCharacter

public static java.lang.String escapeSpecialCharacter(java.lang.String name,
                                                      JDBCUtil.ConnectorType type)

getConnection

public static java.sql.Connection getConnection(java.util.Map args)
                                         throws sailpoint.tools.GeneralException

Throws:

sailpoint.tools.GeneralException

getConnection

public static java.sql.Connection getConnection(java.lang.String driverClass,
                                                java.lang.String driverPrefix,
                                                java.lang.String url,
                                                java.lang.String user,
                                                java.lang.String password,
                                                java.util.Properties props)
                                         throws sailpoint.tools.GeneralException

Throws:

sailpoint.tools.GeneralException

getConnection

public static java.sql.Connection getConnection(java.lang.String driverClass,
                                                java.lang.String driverPrefix,
                                                java.lang.String url,
                                                java.lang.String user,
                                                java.lang.String password)
                                         throws sailpoint.tools.GeneralException

Throws:

sailpoint.tools.GeneralException

closeConnection

public static void closeConnection(java.sql.Connection con)

closeStatement

public static void closeStatement(java.sql.Statement stmt)

closeResult

public static void closeResult(java.sql.ResultSet res)

useQuoteForScripts

public static java.lang.String useQuoteForScripts(java.lang.String val,
                                                  java.lang.String quoteForCaseInsensitveDatabase,
                                                  java.lang.String quoteForCaseSensitiveDatabase,
                                                  boolean caseSensitive)

escapeSpecialCharactor

public static java.lang.String escapeSpecialCharactor(java.lang.String name,
                                                      JDBCUtil.ConnectorType type)

initializeSession

public static void initializeSession(java.sql.Connection connection,
                                     int userId,
                                     int responsibilityID,
                                     int applicationID)
                              throws java.lang.Exception

Throws:

java.lang.Exception

getOracleDBVersionDetails

public static java.lang.String getOracleDBVersionDetails(java.sql.Connection connection,
                                                         java.lang.String applicationName,
                                                         java.lang.String applicationType)
                                                  throws java.lang.Throwable

Throws:

java.lang.Throwable

getOracleDBTimeZoneDetails

public static java.lang.String getOracleDBTimeZoneDetails(java.sql.Connection connection,
                                                          java.lang.String applicationName,
                                                          java.lang.String applicationType)
                                                   throws java.lang.Throwable

Throws:

java.lang.Throwable