com.webmethods.portal.service.sql

Interface IConnectionProvider

public interface IConnectionProvider

This is generic interface which creates and manages database connections, and implements their pooling if neccessary

Field Summary

Fields

Modifier and Type	Field and Description
static String	PARAM_ALIAS_NAME

Method Summary

Modifier and Type	Method and Description
void	closeConnection(IConnectionInfo connInfo, Connection connection) Closes connection and remove from pool
void	closeConnectionPool(IConnectionInfo connInfo) Closes any connection pool associated with given connection info
Connection	getConnection(IConnectionInfo connInfo) Returns opened connection to a database by DatasourceName
Connection	getTemporaryConnection(IConnectionInfo connInfo) Creates connection using temporary pool which is not being registered
void	release() Releases all Connection resources aquired by that time
void	releaseConnection(Connection connection) Release used connection.
boolean	testConnection(IConnectionInfo connInfo, Connection connection) Tests connection.

Field Detail

PARAM_ALIAS_NAME

static final String PARAM_ALIAS_NAME

See Also:

Constant Field Values

Method Detail

getConnection

Connection getConnection(IConnectionInfo connInfo)

Returns opened connection to a database by DatasourceName

Parameters:

connInfo - information about the connection to be opened.

Returns:

an open connection to the requested database

getTemporaryConnection

Connection getTemporaryConnection(IConnectionInfo connInfo)

Creates connection using temporary pool which is not being registered

Parameters:

connInfo -

Returns:

valid Connection or null

releaseConnection

void releaseConnection(Connection connection)

Release used connection. Must be called after getConnection()

Parameters:

connection - the connection to be released

release

void release()

Releases all Connection resources aquired by that time

testConnection

boolean testConnection(IConnectionInfo connInfo,
                       Connection connection)

Tests connection. Returns false if diconnected from db

closeConnection

void closeConnection(IConnectionInfo connInfo,
                     Connection connection)

Closes connection and remove from pool

closeConnectionPool

void closeConnectionPool(IConnectionInfo connInfo)

Closes any connection pool associated with given connection info

Parameters:

connInfo -