: Index
A B C D E F G I J N P Q R S T U W
A
acceptsURL(String) ConnectionPoolManager
Returns true of url starts with URL_PREFIX
addAlias(ConnectionPool) ConnectionPoolManager
Adds an alias to the pool using a supplied ConnectionPool object.
addAlias(String, String, String, String, String, int, int, int) ConnectionPoolManager
Adds an alias to the pool.
addAlias(String, String, String, String, String, int, int, int, int) ConnectionPoolManager
Adds an alias to the pool.
addAlias(String, String, String, String, String, int, int, int, int, boolean) ConnectionPoolManager
Adds an alias to the pool.
addAlias(String, String, String, String, String, int, int, int, int, int) ConnectionPoolManager
Adds an alias to the pool.
addAlias(String, String, String, String, String, int, int, int, int, int, boolean) ConnectionPoolManager
Adds an alias to the pool.
addBatch() PooledPreparedStatement
addBatch(String) PooledStatement
addBatch(String) PooledPreparedStatement
B
booleanToString(boolean) SQLUtil
returns "y" if b is true.
C
cancel() PooledStatement
clearBatch() PooledStatement
clearBatch() PooledPreparedStatement
clearParameters() PooledPreparedStatement
clearWarnings() PooledStatement
clearWarnings() PooledConnection
close() PooledStatement
close() PooledPreparedStatement
close() PooledConnection
Doesn't actually close the connection, but instead returns itself
back to the pool to be re-used.
close() PooledCallableStatement
closeStatements() PooledConnection
Closes all PreparedStatments and CallableStatements
com.bitmechanic.sql com.bitmechanic.util commit() PooledConnection
connect(String, Properties) ConnectionPoolManager
Returns a connection from pool
ConnectionPool ConnectionPool .Individual pool associated with a JDBC datasource and username. ConnectionPool(String, String, String, String, int, int, int) ConnectionPool
Creates a Connection pool with no maxCheckout parameter.
ConnectionPool(String, String, String, String, int, int, int, int) ConnectionPool
Creates a Connection pool
ConnectionPoolManager ConnectionPoolManager .Implements java.sql.Driver and controls access to connections in the pool. ConnectionPoolManager() ConnectionPoolManager
Creates a pool that doesn't monitor itself to check for idle/stale
connections.
ConnectionPoolManager(int) ConnectionPoolManager
Creates a pool with a monitoring thread that checks the pool to make
sure no connections are stale or idle.
createStatement() PooledConnection
createStatement(int, int) PooledConnection
cstmt PooledCallableStatement
D
dequeue() Queue
dumpInfo() PooledStatement
dumpInfo() PooledConnection
Dump some information about this connection and the statement
dumpInfo() ConnectionPoolManager
Dump some information about all connections and pools into a String
dumpInfo() ConnectionPool
Dump some information about all connections
E
empty() Queue
enqueue(Object) Queue
escapeString(String) SQLUtil
Calls escapeString(str, int) with a length of 999999
escapeString(String, int) SQLUtil
Escapes ' with '' and truncates the string to the length specified.
execute() PooledPreparedStatement
execute(String) PooledStatement
executeBatch() PooledStatement
executeBatch() PooledPreparedStatement
executeQuery() PooledPreparedStatement
PreparedStatment methods
executeQuery(String) PooledStatement
executeUpdate() PooledPreparedStatement
executeUpdate(String) PooledStatement
F
formatHiResMysqlDate(Date) SQLUtil
Formats a date using the SimpleDateFormat "yyyy-MM-dd HH:mm:ss"
formatMysqlDate(Date) SQLUtil
Formats a date using the SimpleDateFormat "yyyy-MM-dd"
G
getAlias() ConnectionPool
Returns the alias for this pool.
getArray(int) PooledCallableStatement
getAutoCommit() PooledConnection
getBigDecimal(int) PooledCallableStatement
getBigDecimal(int, int) PooledCallableStatement
getBlob(int) PooledCallableStatement
getBoolean(int) PooledCallableStatement
getByte(int) PooledCallableStatement
getBytes(int) PooledCallableStatement
getCacheStatements() ConnectionPool
Returns whether connections in this pool will cache Statement and
PreparedStatement objects.
getCatalog() PooledConnection
getCheckoutCount() PooledConnection
Returns number of times this node has been checked out from the pool
getClob(int) PooledCallableStatement
getConnection() PooledStatement
getConnection() PooledPreparedStatement
getConnection() PooledConnection
getConnection() ConnectionPool
Returns a connection for the pool.
getDate(int) PooledCallableStatement
getDate(int, Calendar) PooledCallableStatement
getDouble(int) PooledCallableStatement
getFetchDirection() PooledStatement
getFetchDirection() PooledPreparedStatement
getFetchSize() PooledStatement
getFetchSize() PooledPreparedStatement
getFloat(int) PooledCallableStatement
getInt(int) PooledCallableStatement
getLastAccess() PooledConnection
Returns when this connection was last checked out; 0 if it has never
been used.
getLastCheckin() PooledConnection
Returns when this connection was last checked in (when it's lock was last released);
0 if it has never been released.
getLock() PooledConnection
Returns true if this Connection is not in use.
getLong(int) PooledCallableStatement
getMajorVersion() ConnectionPoolManager
getMaxConn() ConnectionPool
Returns the maximum number of connections this pool can open
getMaxFieldSize() PooledStatement
getMaxRows() PooledStatement
getMetaData() PooledPreparedStatement
getMetaData() PooledConnection
getMinorVersion() ConnectionPoolManager
getMoreResults() PooledStatement
getNativeConnection() PooledConnection
getNumCheckoutTimeouts() ConnectionPool
Returns the number of times a Connection has been closed by the
reapIdleConnections() method due to being checked out for longer than
the checkoutSeconds interval.
getNumRequests() ConnectionPool
Returns the number of times a Connection has been checked out from the
pool
getNumWaits() ConnectionPool
Returns the number of times a thread has had to block on wait() as a
result of all PooledConnections being in use.
getObject(int) PooledCallableStatement
getObject(int, Map) PooledCallableStatement
getPool(String) ConnectionPoolManager
Returns the pool with the supplied alias
getPools() ConnectionPoolManager
Returns an Enumeration of the ConnectionPool objects currently created
getPrefetchSize() ConnectionPool
Get the current prefetch size
getPropertyInfo(String, Properties) ConnectionPoolManager
getQueryTimeout() PooledStatement
getRef(int) PooledCallableStatement
getResultSet() PooledStatement
getResultSetConcurrency() PooledStatement
getResultSetConcurrency() PooledPreparedStatement
getResultSetType() PooledStatement
getResultSetType() PooledPreparedStatement
getShort(int) PooledCallableStatement
getStatement() PooledStatement
getString(int) PooledCallableStatement
getTime(int) PooledCallableStatement
getTime(int, Calendar) PooledCallableStatement
getTimestamp(int) PooledCallableStatement
getTimestamp(int, Calendar) PooledCallableStatement
getTraceException() PooledConnection
If the connection pool is in trace mode, you can examine the stack trace
in this exception to determine where it was last checked out.
getTransactionIsolation() PooledConnection
getTypeMap() PooledConnection
Proxy all other JDBC calls to actual Connection object
getUpdateCount() PooledStatement
getWarnings() PooledStatement
getWarnings() PooledConnection
guardConnection() PooledConnection
I
isClosed() PooledConnection
isLocked() PooledConnection
isReadOnly() PooledConnection
J
JavaAlarm JavaAlarm .Provides a way to run a Runnable object with a timer. JavaAlarm(Runnable, long) JavaAlarm
jdbcCompliant() ConnectionPoolManager
Always returns false since I haven't sent this code to Sun for approval
N
nativeSQL(String) PooledConnection
notNull(String) SQLUtil
Checks if str is null, and if it is returns an empty string.
P
parseMysqlDate(String) SQLUtil
PooledCallableStatement PooledCallableStatement . PooledCallableStatement(CallableStatement) PooledCallableStatement
PooledConnection PooledConnection . PooledConnection(Connection, ConnectionPool) PooledConnection
PooledPreparedStatement PooledPreparedStatement . PooledPreparedStatement() PooledPreparedStatement
PooledPreparedStatement(PreparedStatement) PooledPreparedStatement
PooledStatement PooledStatement . PooledStatement() PooledStatement
PooledStatement(Statement) PooledStatement
prepareCall(String) PooledConnection
prepareCall(String, int, int) PooledConnection
prepareStatement(String) PooledConnection
prepareStatement(String, int, int) PooledConnection
pstmt PooledPreparedStatement
Q
Queue Queue .A simple queue implementation. Queue() Queue
Queue(int) Queue
R
reapIdleConnections() ConnectionPool
Check all connections to make sure they haven't:
1) gone idle for too long registerOutParameter(int, int) PooledCallableStatement
CallableStatment methods
registerOutParameter(int, int, int) PooledCallableStatement
registerOutParameter(int, int, String) PooledCallableStatement
releaseLock() PooledConnection
called by ConnectionPool.returnConnection() right before it wakes up
the threads
removeAlias(String) ConnectionPoolManager
Closes all Connections in the pool with the supplied alias
removeAllConnections() ConnectionPool
Removes all connections from the pool and calls close() on them.
returnConnection(PooledConnection) ConnectionPool
rollback() PooledConnection
run() PooledConnection
This is used by ConnectionPool.removeConnection().
run() ConnectionPoolManager
Monitors each ConnectionPool and makes sure that no connection has gone
idle or has been checked out for too long.
run() JavaAlarm
S
setArray(int, Array) PooledPreparedStatement
setAsciiStream(int, InputStream, int) PooledPreparedStatement
setAutoCommit(boolean) PooledConnection
setBigDecimal(int, BigDecimal) PooledPreparedStatement
setBinaryStream(int, InputStream, int) PooledPreparedStatement
setBlob(int, Blob) PooledPreparedStatement
setBoolean(int, boolean) PooledPreparedStatement
setByte(int, byte) PooledPreparedStatement
setBytes(int, byte[]) PooledPreparedStatement
setCacheStatements(boolean) ConnectionPool
If set to true, connections in the pool will reuse Statements and
PreparedStatements.
setCatalog(String) PooledConnection
setCharacterStream(int, Reader, int) PooledStatement
setCharacterStream(int, Reader, int) PooledPreparedStatement
setClob(int, Clob) PooledPreparedStatement
setCursorName(String) PooledStatement
setDate(int, Date) PooledPreparedStatement
setDate(int, Date, Calendar) PooledPreparedStatement
setDouble(int, double) PooledPreparedStatement
setEscapeProcessing(boolean) PooledStatement
setFetchDirection(int) PooledStatement
setFetchDirection(int) PooledPreparedStatement
setFetchSize(int) PooledStatement
setFetchSize(int) PooledPreparedStatement
setFloat(int, float) PooledPreparedStatement
setInt(int, int) PooledPreparedStatement
setLong(int, long) PooledPreparedStatement
setMaxFieldSize(int) PooledStatement
setMaxRows(int) PooledStatement
setNull(int, int) PooledPreparedStatement
setNull(int, int, String) PooledPreparedStatement
setObject(int, Object) PooledPreparedStatement
setObject(int, Object, int) PooledPreparedStatement
setObject(int, Object, int, int) PooledPreparedStatement
setPrefetchSize(int) ConnectionPool
Change the number of rows prefetched for a result set, for those
drivers that support it.
setQueryTimeout(int) PooledStatement
setReadOnly(boolean) PooledConnection
setRef(int, Ref) PooledPreparedStatement
setShort(int, short) PooledPreparedStatement
setString(int, String) PooledPreparedStatement
setTime(int, Time) PooledPreparedStatement
setTime(int, Time, Calendar) PooledPreparedStatement
setTimestamp(int, Timestamp) PooledPreparedStatement
setTimestamp(int, Timestamp, Calendar) PooledPreparedStatement
setTraceException(Exception) PooledConnection
setTracing(boolean) ConnectionPoolManager
Turns tracing on or off.
setTracing(boolean) ConnectionPool
Turns tracing on or off.
setTransactionIsolation(int) PooledConnection
setTypeMap(Map) PooledConnection
setUnicodeStream(int, InputStream, int) PooledPreparedStatement
size() ConnectionPool
Returns the current number of Connections in the pool.
size() Queue
SQLUtil SQLUtil .A set of utility SQL methods. SQLUtil() SQLUtil
stmt PooledStatement
stringToBoolean(String) SQLUtil
returns true if str is not null and equals "y"
otherwise returns true
T
TimeoutException TimeoutException . TimeoutException(String) TimeoutException
U
URL_PREFIX ConnectionPoolManager
W
wasNull() PooledCallableStatement
A B C D E F G I J N P Q R S T U W
