bitronix.tm.resource.jdbc
Class PoolingDataSource

java.lang.Object
  extended bybitronix.tm.resource.common.ResourceBean
      extended bybitronix.tm.resource.jdbc.PoolingDataSource
All Implemented Interfaces:
javax.sql.DataSource, PoolingDataSourceMBean, javax.naming.Referenceable, java.io.Serializable, XAResourceProducer

public class PoolingDataSource
extends ResourceBean
implements javax.sql.DataSource, XAResourceProducer, PoolingDataSourceMBean

Implementation of a JDBC DataSource wrapping vendor's XADataSource implementation.

© Bitronix Software

Author:
lorban, brettw
See Also:
Serialized Form

Constructor Summary
PoolingDataSource()
           
 
Method Summary
 void close()
          Release this XAResourceProducer's internal resources.
 XAStatefulHolder createPooledConnection(java.lang.Object xaFactory, ResourceBean bean)
          Create a XAStatefulHolder that will be placed in an XAPool.
 void endRecovery()
          Release internal resources held after call to startRecovery().
 XAResourceHolder findXAResourceHolder(javax.transaction.xa.XAResource xaResource)
          Find in the XAResourceHolders created by this XAResourceProducer the one which this XAResource belongs to.
 java.sql.Connection getConnection()
           
 java.sql.Connection getConnection(java.lang.String username, java.lang.String password)
           
 java.lang.String getCursorHoldability()
           
 long getInPoolSize()
           
 java.lang.String getIsolationLevel()
           
 java.lang.String getLocalAutoCommit()
           
 int getLoginTimeout()
           
 java.io.PrintWriter getLogWriter()
           
 int getPreparedStatementCacheSize()
           
 javax.naming.Reference getReference()
          PoolingDataSource must alway have a unique name so this method builds a reference to this object using the unique name as RefAddr.
 java.lang.String getTestQuery()
           
 long getTotalPoolSize()
           
 void init()
          Initializes the pool by creating the initial amount of connections.
 boolean isEnableJdbc4ConnectionTest()
           
 boolean isWrapperFor(java.lang.Class iface)
           
 void reset()
           
 void setCursorHoldability(java.lang.String cursorHoldability)
          Set the default cursor holdability for connections.
 void setEnableJdbc4ConnectionTest(boolean enableJdbc4ConnectionTest)
          When set and the underlying JDBC driver supports JDBC 4 isValid(), a Connection.isValid() call is performed to test the connection before handing it to the caller.
 void setFailed(boolean failed)
          Mark this resource producer as failed or not.
 void setIsolationLevel(java.lang.String isolationLevel)
          Set the default isolation level for connections.
 void setLocalAutoCommit(java.lang.String localAutoCommit)
          Set the default local transactions autocommit mode.
 void setLoginTimeout(int seconds)
           
 void setLogWriter(java.io.PrintWriter out)
           
 void setPreparedStatementCacheSize(int preparedStatementCacheSize)
          Set the target maximum size of the prepared statement cache.
 void setTestQuery(java.lang.String testQuery)
          When set, the specified query will be executed on the connection acquired from the pool before being handed to the caller.
 XAResourceHolderState startRecovery()
          Prepare the recoverable XAResource producer for recovery.
 java.lang.String toString()
           
 java.lang.Object unwrap(java.lang.Class iface)
           
 
Methods inherited from class bitronix.tm.resource.common.ResourceBean
getAcquireIncrement, getAcquisitionInterval, getAcquisitionTimeout, getAllowLocalTransactions, getApplyTransactionTimeout, getAutomaticEnlistingEnabled, getClassName, getDeferConnectionRelease, getDriverProperties, getMaxIdleTime, getMaxPoolSize, getMinPoolSize, getShareTransactionConnections, getTwoPcOrderingPosition, getUniqueName, getUseTmJoin, incCreatedResourcesCounter, setAcquireIncrement, setAcquisitionInterval, setAcquisitionTimeout, setAllowLocalTransactions, setApplyTransactionTimeout, setAutomaticEnlistingEnabled, setClassName, setDeferConnectionRelease, setDriverProperties, setMaxIdleTime, setMaxPoolSize, setMinPoolSize, setShareTransactionConnections, setTwoPcOrderingPosition, setUniqueName, setUseTmJoin
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 
Methods inherited from interface bitronix.tm.resource.common.XAResourceProducer
getUniqueName
 

Constructor Detail

PoolingDataSource

public PoolingDataSource()
Method Detail

init

public void init()
Initializes the pool by creating the initial amount of connections.

Specified by:
init in interface XAResourceProducer

getTestQuery

public java.lang.String getTestQuery()
Returns:
the query that will be used to test connections.

setTestQuery

public void setTestQuery(java.lang.String testQuery)
When set, the specified query will be executed on the connection acquired from the pool before being handed to the caller. The connections won't be tested when not set. Default value is null.

Parameters:
testQuery - the query that will be used to test connections.

setEnableJdbc4ConnectionTest

public void setEnableJdbc4ConnectionTest(boolean enableJdbc4ConnectionTest)
When set and the underlying JDBC driver supports JDBC 4 isValid(), a Connection.isValid() call is performed to test the connection before handing it to the caller. If both testQuery and enableJdbc4ConnectionTest are set, enableJdbc4ConnectionTest takes precedence.

Parameters:
enableJdbc4ConnectionTest - true if JDBC 4 isValid() testing should be performed, false otherwise.

isEnableJdbc4ConnectionTest

public boolean isEnableJdbc4ConnectionTest()
Returns:
true if JDBC 4 isValid() testing should be performed, false otherwise.

getPreparedStatementCacheSize

public int getPreparedStatementCacheSize()
Returns:
the target maximum prepared statement cache size.

setPreparedStatementCacheSize

public void setPreparedStatementCacheSize(int preparedStatementCacheSize)
Set the target maximum size of the prepared statement cache. In reality under certain unusual conditions the cache may temporarily drift higher in size.

Parameters:
preparedStatementCacheSize - the target maximum prepared statement cache size.

getIsolationLevel

public java.lang.String getIsolationLevel()
Returns:
the default isolation level.

setIsolationLevel

public void setIsolationLevel(java.lang.String isolationLevel)
Set the default isolation level for connections.

Parameters:
isolationLevel - the default isolation level.

getCursorHoldability

public java.lang.String getCursorHoldability()
Returns:
cursorHoldability the default cursor holdability.

setCursorHoldability

public void setCursorHoldability(java.lang.String cursorHoldability)
Set the default cursor holdability for connections.

Parameters:
cursorHoldability - the default cursor holdability.

getLocalAutoCommit

public java.lang.String getLocalAutoCommit()
Returns:
localAutoCommit the default local transactions autocommit mode.

setLocalAutoCommit

public void setLocalAutoCommit(java.lang.String localAutoCommit)
Set the default local transactions autocommit mode.

Parameters:
localAutoCommit - the default local transactions autocommit mode.

getConnection

public java.sql.Connection getConnection()
                                  throws java.sql.SQLException
Specified by:
getConnection in interface javax.sql.DataSource
Throws:
java.sql.SQLException

getConnection

public java.sql.Connection getConnection(java.lang.String username,
                                         java.lang.String password)
                                  throws java.sql.SQLException
Specified by:
getConnection in interface javax.sql.DataSource
Throws:
java.sql.SQLException

toString

public java.lang.String toString()

startRecovery

public XAResourceHolderState startRecovery()
                                    throws RecoveryException
Description copied from interface: XAResourceProducer
Prepare the recoverable XAResource producer for recovery.

Specified by:
startRecovery in interface XAResourceProducer
Returns:
a XAResourceHolderState object that can be used to call recover().
Throws:
RecoveryException - thrown when a XAResourceHolderState cannot be acquired.

endRecovery

public void endRecovery()
                 throws RecoveryException
Description copied from interface: XAResourceProducer
Release internal resources held after call to startRecovery().

Specified by:
endRecovery in interface XAResourceProducer
Throws:
RecoveryException - thrown when an error occured while releasing reserved resources.

setFailed

public void setFailed(boolean failed)
Description copied from interface: XAResourceProducer
Mark this resource producer as failed or not. A resource is considered failed if recovery fails to run on it.

Specified by:
setFailed in interface XAResourceProducer
Parameters:
failed - true is the resource must be considered failed, false it it must be considered sane.

close

public void close()
Description copied from interface: XAResourceProducer
Release this XAResourceProducer's internal resources.

Specified by:
close in interface XAResourceProducer

createPooledConnection

public XAStatefulHolder createPooledConnection(java.lang.Object xaFactory,
                                               ResourceBean bean)
                                        throws java.lang.Exception
Description copied from interface: XAResourceProducer
Create a XAStatefulHolder that will be placed in an XAPool.

Specified by:
createPooledConnection in interface XAResourceProducer
Parameters:
xaFactory - the vendor's resource-specific XA factory.
bean - the resource-specific bean describing the resource parameters.
Returns:
a XAStatefulHolder that will be placed in an XAPool.
Throws:
java.lang.Exception - thrown when the XAStatefulHolder cannot be created.

findXAResourceHolder

public XAResourceHolder findXAResourceHolder(javax.transaction.xa.XAResource xaResource)
Description copied from interface: XAResourceProducer
Find in the XAResourceHolders created by this XAResourceProducer the one which this XAResource belongs to.

Specified by:
findXAResourceHolder in interface XAResourceProducer
Parameters:
xaResource - the XAResource to look for.
Returns:
the associated XAResourceHolder or null if the XAResource does not belong to this XAResourceProducer.

getReference

public javax.naming.Reference getReference()
                                    throws javax.naming.NamingException
PoolingDataSource must alway have a unique name so this method builds a reference to this object using the unique name as RefAddr.

Specified by:
getReference in interface javax.naming.Referenceable
Returns:
a reference to this PoolingDataSource.
Throws:
javax.naming.NamingException

getLoginTimeout

public int getLoginTimeout()
                    throws java.sql.SQLException
Specified by:
getLoginTimeout in interface javax.sql.DataSource
Throws:
java.sql.SQLException

setLoginTimeout

public void setLoginTimeout(int seconds)
                     throws java.sql.SQLException
Specified by:
setLoginTimeout in interface javax.sql.DataSource
Throws:
java.sql.SQLException

getLogWriter

public java.io.PrintWriter getLogWriter()
                                 throws java.sql.SQLException
Specified by:
getLogWriter in interface javax.sql.DataSource
Throws:
java.sql.SQLException

setLogWriter

public void setLogWriter(java.io.PrintWriter out)
                  throws java.sql.SQLException
Specified by:
setLogWriter in interface javax.sql.DataSource
Throws:
java.sql.SQLException

isWrapperFor

public boolean isWrapperFor(java.lang.Class iface)
                     throws java.sql.SQLException
Throws:
java.sql.SQLException

unwrap

public java.lang.Object unwrap(java.lang.Class iface)
                        throws java.sql.SQLException
Throws:
java.sql.SQLException

getInPoolSize

public long getInPoolSize()
Specified by:
getInPoolSize in interface PoolingDataSourceMBean

getTotalPoolSize

public long getTotalPoolSize()
Specified by:
getTotalPoolSize in interface PoolingDataSourceMBean

reset

public void reset()
           throws java.lang.Exception
Specified by:
reset in interface PoolingDataSourceMBean
Throws:
java.lang.Exception