A B C D E F G I J N P Q R S T U W

A

acceptsURL(String) - Method in class com.bitmechanic.sql.ConnectionPoolManager

Returns true of url starts with URL_PREFIX

addAlias(ConnectionPool) - Method in class com.bitmechanic.sql.ConnectionPoolManager

Adds an alias to the pool using a supplied ConnectionPool object.

addAlias(String, String, String, String, String, int, int, int) - Method in class com.bitmechanic.sql.ConnectionPoolManager

Adds an alias to the pool.

addAlias(String, String, String, String, String, int, int, int, int) - Method in class com.bitmechanic.sql.ConnectionPoolManager

Adds an alias to the pool.

addAlias(String, String, String, String, String, int, int, int, int, boolean) - Method in class com.bitmechanic.sql.ConnectionPoolManager

Adds an alias to the pool.

addAlias(String, String, String, String, String, int, int, int, int, int) - Method in class com.bitmechanic.sql.ConnectionPoolManager

Adds an alias to the pool.

addAlias(String, String, String, String, String, int, int, int, int, int, boolean) - Method in class com.bitmechanic.sql.ConnectionPoolManager

Adds an alias to the pool.

addBatch() - Method in class com.bitmechanic.sql.PooledPreparedStatement

addBatch(String) - Method in class com.bitmechanic.sql.PooledStatement

addBatch(String) - Method in class com.bitmechanic.sql.PooledPreparedStatement

B

booleanToString(boolean) - Static method in class com.bitmechanic.sql.SQLUtil

returns "y" if b is true.

C

cancel() - Method in class com.bitmechanic.sql.PooledStatement

clearBatch() - Method in class com.bitmechanic.sql.PooledStatement

clearBatch() - Method in class com.bitmechanic.sql.PooledPreparedStatement

clearParameters() - Method in class com.bitmechanic.sql.PooledPreparedStatement

clearWarnings() - Method in class com.bitmechanic.sql.PooledStatement

clearWarnings() - Method in class com.bitmechanic.sql.PooledConnection

close() - Method in class com.bitmechanic.sql.PooledStatement

close() - Method in class com.bitmechanic.sql.PooledPreparedStatement

close() - Method in class com.bitmechanic.sql.PooledConnection

Doesn't actually close the connection, but instead returns itself back to the pool to be re-used.

close() - Method in class com.bitmechanic.sql.PooledCallableStatement

closeStatements() - Method in class com.bitmechanic.sql.PooledConnection

Closes all PreparedStatments and CallableStatements

com.bitmechanic.sql - package com.bitmechanic.sql

com.bitmechanic.util - package com.bitmechanic.util

commit() - Method in class com.bitmechanic.sql.PooledConnection

connect(String, Properties) - Method in class com.bitmechanic.sql.ConnectionPoolManager

Returns a connection from pool

ConnectionPool - class com.bitmechanic.sql.ConnectionPool.

Individual pool associated with a JDBC datasource and username.

ConnectionPool(String, String, String, String, int, int, int) - Constructor for class com.bitmechanic.sql.ConnectionPool

Creates a Connection pool with no maxCheckout parameter.

ConnectionPool(String, String, String, String, int, int, int, int) - Constructor for class com.bitmechanic.sql.ConnectionPool

Creates a Connection pool

ConnectionPoolManager - class com.bitmechanic.sql.ConnectionPoolManager.

Implements java.sql.Driver and controls access to connections in the pool.

ConnectionPoolManager() - Constructor for class com.bitmechanic.sql.ConnectionPoolManager

Creates a pool that doesn't monitor itself to check for idle/stale connections.

ConnectionPoolManager(int) - Constructor for class com.bitmechanic.sql.ConnectionPoolManager

Creates a pool with a monitoring thread that checks the pool to make sure no connections are stale or idle.

createStatement() - Method in class com.bitmechanic.sql.PooledConnection

createStatement(int, int) - Method in class com.bitmechanic.sql.PooledConnection

cstmt - Variable in class com.bitmechanic.sql.PooledCallableStatement

D

dequeue() - Method in class com.bitmechanic.util.Queue

dumpInfo() - Method in class com.bitmechanic.sql.PooledStatement

dumpInfo() - Method in class com.bitmechanic.sql.PooledConnection

Dump some information about this connection and the statement

dumpInfo() - Method in class com.bitmechanic.sql.ConnectionPoolManager

Dump some information about all connections and pools into a String

dumpInfo() - Method in class com.bitmechanic.sql.ConnectionPool

Dump some information about all connections

E

empty() - Method in class com.bitmechanic.util.Queue

enqueue(Object) - Method in class com.bitmechanic.util.Queue

escapeString(String) - Static method in class com.bitmechanic.sql.SQLUtil

Calls escapeString(str, int) with a length of 999999

escapeString(String, int) - Static method in class com.bitmechanic.sql.SQLUtil

Escapes ' with '' and truncates the string to the length specified.

execute() - Method in class com.bitmechanic.sql.PooledPreparedStatement

execute(String) - Method in class com.bitmechanic.sql.PooledStatement

executeBatch() - Method in class com.bitmechanic.sql.PooledStatement

executeBatch() - Method in class com.bitmechanic.sql.PooledPreparedStatement

executeQuery() - Method in class com.bitmechanic.sql.PooledPreparedStatement

PreparedStatment methods

executeQuery(String) - Method in class com.bitmechanic.sql.PooledStatement

executeUpdate() - Method in class com.bitmechanic.sql.PooledPreparedStatement

executeUpdate(String) - Method in class com.bitmechanic.sql.PooledStatement

F

formatHiResMysqlDate(Date) - Static method in class com.bitmechanic.sql.SQLUtil

Formats a date using the SimpleDateFormat "yyyy-MM-dd HH:mm:ss"

formatMysqlDate(Date) - Static method in class com.bitmechanic.sql.SQLUtil

Formats a date using the SimpleDateFormat "yyyy-MM-dd"

G

getAlias() - Method in class com.bitmechanic.sql.ConnectionPool

Returns the alias for this pool.

getArray(int) - Method in class com.bitmechanic.sql.PooledCallableStatement

getAutoCommit() - Method in class com.bitmechanic.sql.PooledConnection

getBigDecimal(int) - Method in class com.bitmechanic.sql.PooledCallableStatement

getBigDecimal(int, int) - Method in class com.bitmechanic.sql.PooledCallableStatement

getBlob(int) - Method in class com.bitmechanic.sql.PooledCallableStatement

getBoolean(int) - Method in class com.bitmechanic.sql.PooledCallableStatement

getByte(int) - Method in class com.bitmechanic.sql.PooledCallableStatement

getBytes(int) - Method in class com.bitmechanic.sql.PooledCallableStatement

getCacheStatements() - Method in class com.bitmechanic.sql.ConnectionPool

Returns whether connections in this pool will cache Statement and PreparedStatement objects.

getCatalog() - Method in class com.bitmechanic.sql.PooledConnection

getCheckoutCount() - Method in class com.bitmechanic.sql.PooledConnection

Returns number of times this node has been checked out from the pool

getClob(int) - Method in class com.bitmechanic.sql.PooledCallableStatement

getConnection() - Method in class com.bitmechanic.sql.PooledStatement

getConnection() - Method in class com.bitmechanic.sql.PooledPreparedStatement

getConnection() - Method in class com.bitmechanic.sql.PooledConnection

getConnection() - Method in class com.bitmechanic.sql.ConnectionPool

Returns a connection for the pool.

getDate(int) - Method in class com.bitmechanic.sql.PooledCallableStatement

getDate(int, Calendar) - Method in class com.bitmechanic.sql.PooledCallableStatement

getDouble(int) - Method in class com.bitmechanic.sql.PooledCallableStatement

getFetchDirection() - Method in class com.bitmechanic.sql.PooledStatement

getFetchDirection() - Method in class com.bitmechanic.sql.PooledPreparedStatement

getFetchSize() - Method in class com.bitmechanic.sql.PooledStatement

getFetchSize() - Method in class com.bitmechanic.sql.PooledPreparedStatement

getFloat(int) - Method in class com.bitmechanic.sql.PooledCallableStatement

getInt(int) - Method in class com.bitmechanic.sql.PooledCallableStatement

getLastAccess() - Method in class com.bitmechanic.sql.PooledConnection

Returns when this connection was last checked out; 0 if it has never been used.

getLastCheckin() - Method in class com.bitmechanic.sql.PooledConnection

Returns when this connection was last checked in (when it's lock was last released); 0 if it has never been released.

getLock() - Method in class com.bitmechanic.sql.PooledConnection

Returns true if this Connection is not in use.

getLong(int) - Method in class com.bitmechanic.sql.PooledCallableStatement

getMajorVersion() - Method in class com.bitmechanic.sql.ConnectionPoolManager

getMaxConn() - Method in class com.bitmechanic.sql.ConnectionPool

Returns the maximum number of connections this pool can open

getMaxFieldSize() - Method in class com.bitmechanic.sql.PooledStatement

getMaxRows() - Method in class com.bitmechanic.sql.PooledStatement

getMetaData() - Method in class com.bitmechanic.sql.PooledPreparedStatement

getMetaData() - Method in class com.bitmechanic.sql.PooledConnection

getMinorVersion() - Method in class com.bitmechanic.sql.ConnectionPoolManager

getMoreResults() - Method in class com.bitmechanic.sql.PooledStatement

getNativeConnection() - Method in class com.bitmechanic.sql.PooledConnection

getNumCheckoutTimeouts() - Method in class com.bitmechanic.sql.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() - Method in class com.bitmechanic.sql.ConnectionPool

Returns the number of times a Connection has been checked out from the pool

getNumWaits() - Method in class com.bitmechanic.sql.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) - Method in class com.bitmechanic.sql.PooledCallableStatement

getObject(int, Map) - Method in class com.bitmechanic.sql.PooledCallableStatement

getPool(String) - Method in class com.bitmechanic.sql.ConnectionPoolManager

Returns the pool with the supplied alias

getPools() - Method in class com.bitmechanic.sql.ConnectionPoolManager

Returns an Enumeration of the ConnectionPool objects currently created

getPrefetchSize() - Method in class com.bitmechanic.sql.ConnectionPool

Get the current prefetch size

getPropertyInfo(String, Properties) - Method in class com.bitmechanic.sql.ConnectionPoolManager

getQueryTimeout() - Method in class com.bitmechanic.sql.PooledStatement

getRef(int) - Method in class com.bitmechanic.sql.PooledCallableStatement

getResultSet() - Method in class com.bitmechanic.sql.PooledStatement

getResultSetConcurrency() - Method in class com.bitmechanic.sql.PooledStatement

getResultSetConcurrency() - Method in class com.bitmechanic.sql.PooledPreparedStatement

getResultSetType() - Method in class com.bitmechanic.sql.PooledStatement

getResultSetType() - Method in class com.bitmechanic.sql.PooledPreparedStatement

getShort(int) - Method in class com.bitmechanic.sql.PooledCallableStatement

getStatement() - Method in class com.bitmechanic.sql.PooledStatement

getString(int) - Method in class com.bitmechanic.sql.PooledCallableStatement

getTime(int) - Method in class com.bitmechanic.sql.PooledCallableStatement

getTime(int, Calendar) - Method in class com.bitmechanic.sql.PooledCallableStatement

getTimestamp(int) - Method in class com.bitmechanic.sql.PooledCallableStatement

getTimestamp(int, Calendar) - Method in class com.bitmechanic.sql.PooledCallableStatement

getTraceException() - Method in class com.bitmechanic.sql.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() - Method in class com.bitmechanic.sql.PooledConnection

getTypeMap() - Method in class com.bitmechanic.sql.PooledConnection

Proxy all other JDBC calls to actual Connection object

getUpdateCount() - Method in class com.bitmechanic.sql.PooledStatement

getWarnings() - Method in class com.bitmechanic.sql.PooledStatement

getWarnings() - Method in class com.bitmechanic.sql.PooledConnection

guardConnection() - Method in class com.bitmechanic.sql.PooledConnection

I

isClosed() - Method in class com.bitmechanic.sql.PooledConnection

isLocked() - Method in class com.bitmechanic.sql.PooledConnection

isReadOnly() - Method in class com.bitmechanic.sql.PooledConnection

J

JavaAlarm - class com.bitmechanic.util.JavaAlarm.

Provides a way to run a Runnable object with a timer.

JavaAlarm(Runnable, long) - Constructor for class com.bitmechanic.util.JavaAlarm

jdbcCompliant() - Method in class com.bitmechanic.sql.ConnectionPoolManager

Always returns false since I haven't sent this code to Sun for approval

N

nativeSQL(String) - Method in class com.bitmechanic.sql.PooledConnection

notNull(String) - Static method in class com.bitmechanic.sql.SQLUtil

Checks if str is null, and if it is returns an empty string.

P

parseMysqlDate(String) - Static method in class com.bitmechanic.sql.SQLUtil

PooledCallableStatement - class com.bitmechanic.sql.PooledCallableStatement.

PooledCallableStatement(CallableStatement) - Constructor for class com.bitmechanic.sql.PooledCallableStatement

PooledConnection - class com.bitmechanic.sql.PooledConnection.

PooledConnection(Connection, ConnectionPool) - Constructor for class com.bitmechanic.sql.PooledConnection

PooledPreparedStatement - class com.bitmechanic.sql.PooledPreparedStatement.

PooledPreparedStatement() - Constructor for class com.bitmechanic.sql.PooledPreparedStatement

PooledPreparedStatement(PreparedStatement) - Constructor for class com.bitmechanic.sql.PooledPreparedStatement

PooledStatement - class com.bitmechanic.sql.PooledStatement.

PooledStatement() - Constructor for class com.bitmechanic.sql.PooledStatement

PooledStatement(Statement) - Constructor for class com.bitmechanic.sql.PooledStatement

prepareCall(String) - Method in class com.bitmechanic.sql.PooledConnection

prepareCall(String, int, int) - Method in class com.bitmechanic.sql.PooledConnection

prepareStatement(String) - Method in class com.bitmechanic.sql.PooledConnection

prepareStatement(String, int, int) - Method in class com.bitmechanic.sql.PooledConnection

pstmt - Variable in class com.bitmechanic.sql.PooledPreparedStatement

Q

Queue - class com.bitmechanic.util.Queue.

A simple queue implementation.

Queue() - Constructor for class com.bitmechanic.util.Queue

Queue(int) - Constructor for class com.bitmechanic.util.Queue

R

reapIdleConnections() - Method in class com.bitmechanic.sql.ConnectionPool

Check all connections to make sure they haven't: 1) gone idle for too long
2) been checked out by a thread for too long (cursor leak)

registerOutParameter(int, int) - Method in class com.bitmechanic.sql.PooledCallableStatement

CallableStatment methods

registerOutParameter(int, int, int) - Method in class com.bitmechanic.sql.PooledCallableStatement

registerOutParameter(int, int, String) - Method in class com.bitmechanic.sql.PooledCallableStatement

releaseLock() - Method in class com.bitmechanic.sql.PooledConnection

called by ConnectionPool.returnConnection() right before it wakes up the threads

removeAlias(String) - Method in class com.bitmechanic.sql.ConnectionPoolManager

Closes all Connections in the pool with the supplied alias

removeAllConnections() - Method in class com.bitmechanic.sql.ConnectionPool

Removes all connections from the pool and calls close() on them.

returnConnection(PooledConnection) - Method in class com.bitmechanic.sql.ConnectionPool

rollback() - Method in class com.bitmechanic.sql.PooledConnection

run() - Method in class com.bitmechanic.sql.PooledConnection

This is used by ConnectionPool.removeConnection().

run() - Method in class com.bitmechanic.sql.ConnectionPoolManager

Monitors each ConnectionPool and makes sure that no connection has gone idle or has been checked out for too long.

run() - Method in class com.bitmechanic.util.JavaAlarm

S

setArray(int, Array) - Method in class com.bitmechanic.sql.PooledPreparedStatement

setAsciiStream(int, InputStream, int) - Method in class com.bitmechanic.sql.PooledPreparedStatement

setAutoCommit(boolean) - Method in class com.bitmechanic.sql.PooledConnection

setBigDecimal(int, BigDecimal) - Method in class com.bitmechanic.sql.PooledPreparedStatement

setBinaryStream(int, InputStream, int) - Method in class com.bitmechanic.sql.PooledPreparedStatement

setBlob(int, Blob) - Method in class com.bitmechanic.sql.PooledPreparedStatement

setBoolean(int, boolean) - Method in class com.bitmechanic.sql.PooledPreparedStatement

setByte(int, byte) - Method in class com.bitmechanic.sql.PooledPreparedStatement

setBytes(int, byte[]) - Method in class com.bitmechanic.sql.PooledPreparedStatement

setCacheStatements(boolean) - Method in class com.bitmechanic.sql.ConnectionPool

If set to true, connections in the pool will reuse Statements and PreparedStatements.

setCatalog(String) - Method in class com.bitmechanic.sql.PooledConnection

setCharacterStream(int, Reader, int) - Method in class com.bitmechanic.sql.PooledStatement

setCharacterStream(int, Reader, int) - Method in class com.bitmechanic.sql.PooledPreparedStatement

setClob(int, Clob) - Method in class com.bitmechanic.sql.PooledPreparedStatement

setCursorName(String) - Method in class com.bitmechanic.sql.PooledStatement

setDate(int, Date) - Method in class com.bitmechanic.sql.PooledPreparedStatement

setDate(int, Date, Calendar) - Method in class com.bitmechanic.sql.PooledPreparedStatement

setDouble(int, double) - Method in class com.bitmechanic.sql.PooledPreparedStatement

setEscapeProcessing(boolean) - Method in class com.bitmechanic.sql.PooledStatement

setFetchDirection(int) - Method in class com.bitmechanic.sql.PooledStatement

setFetchDirection(int) - Method in class com.bitmechanic.sql.PooledPreparedStatement

setFetchSize(int) - Method in class com.bitmechanic.sql.PooledStatement

setFetchSize(int) - Method in class com.bitmechanic.sql.PooledPreparedStatement

setFloat(int, float) - Method in class com.bitmechanic.sql.PooledPreparedStatement

setInt(int, int) - Method in class com.bitmechanic.sql.PooledPreparedStatement

setLong(int, long) - Method in class com.bitmechanic.sql.PooledPreparedStatement

setMaxFieldSize(int) - Method in class com.bitmechanic.sql.PooledStatement

setMaxRows(int) - Method in class com.bitmechanic.sql.PooledStatement

setNull(int, int) - Method in class com.bitmechanic.sql.PooledPreparedStatement

setNull(int, int, String) - Method in class com.bitmechanic.sql.PooledPreparedStatement

setObject(int, Object) - Method in class com.bitmechanic.sql.PooledPreparedStatement

setObject(int, Object, int) - Method in class com.bitmechanic.sql.PooledPreparedStatement

setObject(int, Object, int, int) - Method in class com.bitmechanic.sql.PooledPreparedStatement

setPrefetchSize(int) - Method in class com.bitmechanic.sql.ConnectionPool

Change the number of rows prefetched for a result set, for those drivers that support it.

setQueryTimeout(int) - Method in class com.bitmechanic.sql.PooledStatement

setReadOnly(boolean) - Method in class com.bitmechanic.sql.PooledConnection

setRef(int, Ref) - Method in class com.bitmechanic.sql.PooledPreparedStatement

setShort(int, short) - Method in class com.bitmechanic.sql.PooledPreparedStatement

setString(int, String) - Method in class com.bitmechanic.sql.PooledPreparedStatement

setTime(int, Time) - Method in class com.bitmechanic.sql.PooledPreparedStatement

setTime(int, Time, Calendar) - Method in class com.bitmechanic.sql.PooledPreparedStatement

setTimestamp(int, Timestamp) - Method in class com.bitmechanic.sql.PooledPreparedStatement

setTimestamp(int, Timestamp, Calendar) - Method in class com.bitmechanic.sql.PooledPreparedStatement

setTraceException(Exception) - Method in class com.bitmechanic.sql.PooledConnection

setTracing(boolean) - Method in class com.bitmechanic.sql.ConnectionPoolManager

Turns tracing on or off.

setTracing(boolean) - Method in class com.bitmechanic.sql.ConnectionPool

Turns tracing on or off.

setTransactionIsolation(int) - Method in class com.bitmechanic.sql.PooledConnection

setTypeMap(Map) - Method in class com.bitmechanic.sql.PooledConnection

setUnicodeStream(int, InputStream, int) - Method in class com.bitmechanic.sql.PooledPreparedStatement

size() - Method in class com.bitmechanic.sql.ConnectionPool

Returns the current number of Connections in the pool.

size() - Method in class com.bitmechanic.util.Queue

SQLUtil - class com.bitmechanic.sql.SQLUtil.

A set of utility SQL methods.

SQLUtil() - Constructor for class com.bitmechanic.sql.SQLUtil

stmt - Variable in class com.bitmechanic.sql.PooledStatement

stringToBoolean(String) - Static method in class com.bitmechanic.sql.SQLUtil

returns true if str is not null and equals "y" otherwise returns true

T

TimeoutException - exception com.bitmechanic.util.TimeoutException.

TimeoutException(String) - Constructor for class com.bitmechanic.util.TimeoutException

U

URL_PREFIX - Static variable in class com.bitmechanic.sql.ConnectionPoolManager

W

wasNull() - Method in class com.bitmechanic.sql.PooledCallableStatement

A B C D E F G I J N P Q R S T U W