Package sailpoint.connector.util

Class JDBCUtil

java.lang.Object

sailpoint.connector.util.JDBCUtil

public class JDBCUtil
extends Object

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static enum	JDBCUtil.ConnectorType

Field Summary

Fields

Modifier and Type	Field	Description
static String	ORACLE_CLOB_HANDLER

Constructor Summary

Constructors

Constructor	Description
JDBCUtil()

Method Summary

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

Methods inherited from class java.lang.Object

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

Field Details

ORACLE_CLOB_HANDLER

public static String ORACLE_CLOB_HANDLER

Constructor Details

JDBCUtil

public JDBCUtil()

Method Details

escapeSpecialCharacter

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

getConnection

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

Throws:

sailpoint.tools.GeneralException

getConnection

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

Throws:

sailpoint.tools.GeneralException

getConnection

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

Throws:

sailpoint.tools.GeneralException

closeConnection

public static void closeConnection(Connection con)

closeStatement

public static void closeStatement(Statement stmt)

closeResult

public static void closeResult(ResultSet res)

useQuoteForScripts

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

escapeSpecialCharactor

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

initializeSession

public static void initializeSession(Connection connection,
 int userId,
 int responsibilityID,
 int applicationID)
                              throws Exception

Throws:

Exception

getOracleDBVersionDetails

public static String getOracleDBVersionDetails(Connection connection,
 String applicationName,
 String applicationType)
                                        throws Throwable

Throws:

Throwable

getOracleDBTimeZoneDetails

public static String getOracleDBTimeZoneDetails(Connection connection,
 String applicationName,
 String applicationType)
                                         throws Throwable

Throws:

Throwable