ifs.fnd.plsql.jdbc

Class JdbcConnectionSource

java.lang.Object

ifs.fnd.plsql.jdbc.JdbcConnectionSource

Direct Known Subclasses:

OracleJdbcConnectionSource

public abstract class JdbcConnectionSource
extends java.lang.Object

Class that encapsulates creation and closing of database connections.

Constructor Summary

Constructors

Constructor and Description
JdbcConnectionSource()

Method Summary

Modifier and Type	Method and Description
static void	clear() Shuts down the data source.
static void	close(java.sql.Connection con) Closes a database connection.
static java.sql.Connection	createConnection() Creates a new database connection from JDBC driver.
static java.lang.String	getDatabaseUser()
static void	init(java.lang.String user, java.lang.String password, java.lang.String url, int maxStatementsLimit) Initializes a data source for creation of new connections.
static boolean	isConnectionValid(java.sql.Connection c) Check if a connection is valid.

Methods inherited from class java.lang.Object

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

Constructor Detail

JdbcConnectionSource

public JdbcConnectionSource()

Method Detail

init

public static void init(java.lang.String user,
                        java.lang.String password,
                        java.lang.String url,
                        int maxStatementsLimit)
                 throws java.sql.SQLException

Initializes a data source for creation of new connections. This method may be called many times, but only the first call performs the initialization, all other calls are ignored.

Parameters:

user - database user

password - database user password

url - database connection url

maxStatementsLimit - the size of statement cache, 0 means no statement caching

Throws:

java.sql.SQLException - if a JDBC error occurs

getDatabaseUser

public static java.lang.String getDatabaseUser()

clear

public static void clear()

Shuts down the data source.

createConnection

public static java.sql.Connection createConnection()
                                            throws java.sql.SQLException

Creates a new database connection from JDBC driver.

Returns:

database connection

Throws:

java.sql.SQLException - if a JDBC error occurs

close

public static void close(java.sql.Connection con)
                  throws java.sql.SQLException

Closes a database connection.

Parameters:

con - database connection to be closed

Throws:

java.sql.SQLException - if a JDBC error occurs

isConnectionValid

public static boolean isConnectionValid(java.sql.Connection c)

Check if a connection is valid.

Parameters:

c - the database connection to check

Returns:

true if a call to a driver specific validation method succeeds, false otherwise