Skip navigation links

com.essbase.eas.server.dao.jdbc.dbPool
Class PooledConnection

java.lang.Object
com.essbase.eas.server.dao.jdbc.dbPool.PooledConnection

All Implemented Interfaces:

Resource

public class PooledConnection

extends java.lang.Object

implements Resource

Field Summary

static java.lang.String	ARCHIVE_PROPERTY
static java.lang.String	CONNECT_PROPERTY
static java.lang.String	DATABASE_PROPERTY
static java.lang.String	DRIVER_PROPERTY
static java.lang.String	MAXCONN_PROPERTY
static java.lang.String	PASSWORD_PROPERTY
static java.lang.String	TEST_STATEMENT_PROPERTY
static java.lang.String	USER_PROPERTY

Constructor Summary

PooledConnection()

PooledConnection(java.util.Properties props)

Method Summary

void	clearWarnings()
void	close()
void	commit()
java.sql.Statement	createStatement()
java.sql.Statement	createStatement(int resultSetType, int resultSetConcurrency)
boolean	getAutoCommit()
java.lang.String	getCatalog()
java.sql.DatabaseMetaData	getMetaData()
int	getTransactionIsolation()
java.util.Map	getTypeMap()
java.sql.SQLWarning	getWarnings()
void	initialize(java.util.Properties props) Creates the privately held JDBC connection.
boolean	isClosed()
boolean	isReadOnly()
boolean	isValid() Tests the privately held JDBC connection to see if it's still usable.
java.lang.String	nativeSQL(java.lang.String sql)
java.sql.CallableStatement	prepareCall(java.lang.String sql)
java.sql.CallableStatement	prepareCall(java.lang.String sql, int resultSetType, int resultSetConcurrency)
java.sql.PreparedStatement	prepareStatement(java.lang.String sql)
java.sql.PreparedStatement	prepareStatement(java.lang.String sql, int resultSetType, int resultSetConcurrency)
void	rollback()
void	setAutoCommit(boolean autoCommit)
void	setCatalog(java.lang.String catalog)
void	setReadOnly(boolean readOnly)
void	setTransactionIsolation(int level)
void	setTypeMap(java.util.Map map)
void	terminate() Terminates the privately held JDBC Connection.

Methods inherited from class java.lang.Object

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

Field Detail

TEST_STATEMENT_PROPERTY

public static final java.lang.String TEST_STATEMENT_PROPERTY

See Also:

Constant Field Values

ARCHIVE_PROPERTY

public static final java.lang.String ARCHIVE_PROPERTY

See Also:

Constant Field Values

DRIVER_PROPERTY

public static final java.lang.String DRIVER_PROPERTY

See Also:

Constant Field Values

DATABASE_PROPERTY

public static final java.lang.String DATABASE_PROPERTY

See Also:

Constant Field Values

CONNECT_PROPERTY

public static final java.lang.String CONNECT_PROPERTY

See Also:

Constant Field Values

USER_PROPERTY

public static final java.lang.String USER_PROPERTY

See Also:

Constant Field Values

PASSWORD_PROPERTY

public static final java.lang.String PASSWORD_PROPERTY

See Also:

Constant Field Values

MAXCONN_PROPERTY

public static final java.lang.String MAXCONN_PROPERTY

See Also:

Constant Field Values

Constructor Detail

PooledConnection

public PooledConnection()

PooledConnection

public PooledConnection(java.util.Properties props)
                 throws DataAccessException

Throws:

DataAccessException

Method Detail

initialize

public void initialize(java.util.Properties props)
                throws DataAccessException

Creates the privately held JDBC connection.

Specified by:

initialize in interface Resource

Throws:

DataAccessException

terminate

public void terminate()
               throws DataAccessException

Terminates the privately held JDBC Connection.

Specified by:

terminate in interface Resource

Throws:

DataAccessException

isValid

public boolean isValid()
                throws DataAccessException

Tests the privately held JDBC connection to see if it's still usable.

Specified by:

isValid in interface Resource

Returns:

True if resource is valid and usable, false if not.

Throws:

DataAccessException

createStatement

public java.sql.Statement createStatement()
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.lang.String sql)
                                            throws java.sql.SQLException

Throws:

java.sql.SQLException

prepareCall

public java.sql.CallableStatement prepareCall(java.lang.String sql)
                                       throws java.sql.SQLException

Throws:

java.sql.SQLException

nativeSQL

public java.lang.String nativeSQL(java.lang.String sql)
                           throws java.sql.SQLException

Throws:

java.sql.SQLException

setAutoCommit

public void setAutoCommit(boolean autoCommit)
                   throws java.sql.SQLException

Throws:

java.sql.SQLException

getAutoCommit

public boolean getAutoCommit()
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

commit

public void commit()
            throws java.sql.SQLException

Throws:

java.sql.SQLException

rollback

public void rollback()
              throws java.sql.SQLException

Throws:

java.sql.SQLException

close

public void close()
           throws java.sql.SQLException

Throws:

java.sql.SQLException

isClosed

public boolean isClosed()
                 throws java.sql.SQLException

Throws:

java.sql.SQLException

getMetaData

public java.sql.DatabaseMetaData getMetaData()
                                      throws java.sql.SQLException

Throws:

java.sql.SQLException

setReadOnly

public void setReadOnly(boolean readOnly)
                 throws java.sql.SQLException

Throws:

java.sql.SQLException

isReadOnly

public boolean isReadOnly()
                   throws java.sql.SQLException

Throws:

java.sql.SQLException

setCatalog

public void setCatalog(java.lang.String catalog)
                throws java.sql.SQLException

Throws:

java.sql.SQLException

getCatalog

public java.lang.String getCatalog()
                            throws java.sql.SQLException

Throws:

java.sql.SQLException

setTransactionIsolation

public void setTransactionIsolation(int level)
                             throws java.sql.SQLException

Throws:

java.sql.SQLException

getTransactionIsolation

public int getTransactionIsolation()
                            throws java.sql.SQLException

Throws:

java.sql.SQLException

getWarnings

public java.sql.SQLWarning getWarnings()
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

clearWarnings

public void clearWarnings()
                   throws java.sql.SQLException

Throws:

java.sql.SQLException

createStatement

public java.sql.Statement createStatement(int resultSetType,
                                          int resultSetConcurrency)
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.lang.String sql,
                                                   int resultSetType,
                                                   int resultSetConcurrency)
                                            throws java.sql.SQLException

Throws:

java.sql.SQLException

prepareCall

public java.sql.CallableStatement prepareCall(java.lang.String sql,
                                              int resultSetType,
                                              int resultSetConcurrency)
                                       throws java.sql.SQLException

Throws:

java.sql.SQLException

getTypeMap

public java.util.Map getTypeMap()
                         throws java.sql.SQLException

Throws:

java.sql.SQLException

setTypeMap

public void setTypeMap(java.util.Map map)
                throws java.sql.SQLException

Throws:

java.sql.SQLException

Skip navigation links