A C D E G N P R S T

A

addBatch(String) - Method in class com.bentofw.sql.PSWraper

JDBC 2.0 Adds a SQL command to the current batch of commmands for the statement.

addBatch() - Method in class com.bentofw.sql.PSWraper

JDBC 2.0 Add a set of parameters to the batch.

C

cancel() - Method in class com.bentofw.sql.PSWraper

Cancel can be used by one thread to cancel a statement that is being executed by another thread.

clearBatch() - Method in class com.bentofw.sql.PSWraper

JDBC 2.0 Make the set of commands in the current batch empty.

clearParameters() - Method in class com.bentofw.sql.PSWraper

In general, parameter values remain in force for repeated used of a Statement.

clearWarnings() - Method in class com.bentofw.sql.PSWraper

After this call, getWarnings returns null until a new warning is reported for this Statement.

close() - Method in class com.bentofw.sql.PooledPS

Close all the PreparedStatement and Connection.

close() - Method in class com.bentofw.sql.PSWraper

In many cases, it is desirable to immediately release a Statement's database and JDBC resources instead of waiting for this to happen when it is automatically closed.

closeIfOpen() - Static method in class com.bentofw.sql.PooledPS

Close all the PreparedStatement and Connection.

com.bentofw.sql - package com.bentofw.sql

Java API for pooling JDBC PreparedStatement.

com.bentofw.util - package com.bentofw.util

The classes and interfaces required for APIs by OOP-Research.

D

disposePS(PSWraper) - Method in class com.bentofw.sql.PooledPS

Deprecated. As of PooledStatement Version 3.0, replaced by PooledPS.disposePS(PreparedStatement)

disposePS(PreparedStatement) - Method in class com.bentofw.sql.PooledPS

Push back the instance of PreparedStatement to the dead pool.

E

execute(String, int) - Method in class com.bentofw.sql.PSWraper

Executes the given SQL statement, which may return multiple results, and signals the driver that any auto-generated keys should be made available for retrieval.

execute(String, int[]) - Method in class com.bentofw.sql.PSWraper

Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.

execute(String, String[]) - Method in class com.bentofw.sql.PSWraper

Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.

execute(String) - Method in class com.bentofw.sql.PSWraper

Execute a SQL statement that may return multiple results.

execute() - Method in class com.bentofw.sql.PSWraper

Some prepared statements return multiple results; the execute method handles these complex statements as well as the simpler form of statements handled by executeQuery and executeUpdate

executeBatch() - Method in class com.bentofw.sql.PSWraper

JDBC 2.0 Submit a batch of commands to the database for execution.

executeQuery(String) - Method in class com.bentofw.sql.PSWraper

Execute a SQL statement that retruns a single ResultSet

executeQuery() - Method in class com.bentofw.sql.PSWraper

A Prepared SQL query is executed and its ResultSet is returned

executeUpdate(String, int) - Method in class com.bentofw.sql.PSWraper

Executes the given SQL statement and signals the driver with the given flag about whether the auto-generated keys produced by this Statement object should be made available for retrieval.

executeUpdate(String, int[]) - Method in class com.bentofw.sql.PSWraper

Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.

executeUpdate(String, String[]) - Method in class com.bentofw.sql.PSWraper

Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.

executeUpdate(String) - Method in class com.bentofw.sql.PSWraper

Execute a SQL INSERT, UPDATE or DELETE statement.

executeUpdate() - Method in class com.bentofw.sql.PSWraper

Execute a SQL INSERT, UPDATE or DELETE statement.

G

getConnection() - Method in class com.bentofw.sql.PSWraper

JDBC 2.0 Return the Connection that produced the Statement.

getFetchDirection() - Method in class com.bentofw.sql.PSWraper

JDBC 2.0 Determine the fetch direction.

getFetchSize() - Method in class com.bentofw.sql.PSWraper

JDBC 2.0 Determine the default fetch size.

getGeneratedKeys() - Method in class com.bentofw.sql.PSWraper

Retrieves any auto-generated keys created as a result of executing this Statement object.

getInstance() - Static method in class com.bentofw.sql.PooledPS

Reads the property file and returns the instance of this class.

getMaxFieldSize() - Method in class com.bentofw.sql.PSWraper

The maxFieldSize limit (in bytes) is the maximum amount of data returned for any column value; it only applies to BINARY, VARBINARY, LONGVARBINARY, CHAR, VARCHAR and LONGVARCHAR columns.

getMaxRows() - Method in class com.bentofw.sql.PSWraper

The maxRows limit is set to limit the number of rows that any ResultSet can contain.

getMessage() - Method in exception com.bentofw.util.NestedException

Returns the error message of original Throwable.

getMetaData() - Method in class com.bentofw.sql.PSWraper

The number, types and properties of a ResultSet's columns are provided by the getMetaData method.

getMoreResults(int) - Method in class com.bentofw.sql.PSWraper

Moves to this Statement object's next result, deals with any current ResultSet object(s) according to the instructions specified by the given flag, and returns true if the next result is a ResultSet object.

getMoreResults() - Method in class com.bentofw.sql.PSWraper

getMoreResults moves to a Statement's next result.

getOriginal() - Method in exception com.bentofw.util.NestedException

Returns the original Throwable.

getParameterMetaData() - Method in class com.bentofw.sql.PSWraper

Retrieves the number, types and properties of this PreparedStatement object's parameters.

getPS(String) - Method in class com.bentofw.sql.PooledPS

Returns the PreparedStatement for the given SQL statement.

getQueryTimeout() - Method in class com.bentofw.sql.PSWraper

The queryTimeout limit is the number of seconds the driver will wait for a Statement to execute.

getResultSet() - Method in class com.bentofw.sql.PSWraper

getResultSet returns the current result as a ResultSet.

getResultSetConcurrency() - Method in class com.bentofw.sql.PSWraper

JDBC 2.0 Determine the result set concurrency.

getResultSetHoldability() - Method in class com.bentofw.sql.PSWraper

Retrieves the result set holdability for ResultSet objects generated by this Statement object.

getResultSetType() - Method in class com.bentofw.sql.PSWraper

JDBC 2.0 Determine the result set type.

getUpdateCount() - Method in class com.bentofw.sql.PSWraper

getUpdateCount returns the current result as an update count, if the result is a ResultSet or there are no more results, -1 is returned.

getWarnings() - Method in class com.bentofw.sql.PSWraper

The first warning reported by calls on this Statement is returned.

N

NestedException - Exception in com.bentofw.util

The exception for the system error.

NestedException(Throwable) - Constructor for exception com.bentofw.util.NestedException

The custructor.

P

PooledPS - Class in com.bentofw.sql

Keeps the PreparedStatement in pool and re-use it.

printStackTrace() - Method in exception com.bentofw.util.NestedException

Print this Throwable and its backtrace to the standard error stream.

printStackTrace(PrintStream) - Method in exception com.bentofw.util.NestedException

Print this Throwable and its backtrace to the specified PrintStream.

printStackTrace(PrintWriter) - Method in exception com.bentofw.util.NestedException

Print this Throwable and its backtrace to the specified PrintWriter.

PSWraper - Class in com.bentofw.sql

Wraper class for PreparedStatement, which is returned from PooledPS.

R

reusePS(PSWraper) - Method in class com.bentofw.sql.PooledPS

Deprecated. As of PooledStatement Version 3.0, replaced by PooledPS.reusePS(PreparedStatement)

reusePS(PreparedStatement) - Method in class com.bentofw.sql.PooledPS

Push back the instance of PreparedStatement to the free pool so that it can be re-used.

S

setArray(int, Array) - Method in class com.bentofw.sql.PSWraper

JDBC 2.0 Set an Array parameter.

setAsciiStream(int, InputStream, int) - Method in class com.bentofw.sql.PSWraper

When a very large ASCII value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.InputStream.

setBigDecimal(int, BigDecimal) - Method in class com.bentofw.sql.PSWraper

Set a parameter to a java.lang.BigDecimal value.

setBinaryStream(int, InputStream, int) - Method in class com.bentofw.sql.PSWraper

When a very large binary value is input to a LONGVARBINARY parameter, it may be more practical to send it via a java.io.InputStream.

setBlob(int, Blob) - Method in class com.bentofw.sql.PSWraper

JDBC 2.0 Set a BLOB parameter.

setBoolean(int, boolean) - Method in class com.bentofw.sql.PSWraper

Set a parameter to a Java boolean value.

setByte(int, byte) - Method in class com.bentofw.sql.PSWraper

Set a parameter to a Java byte value.

setBytes(int, byte[]) - Method in class com.bentofw.sql.PSWraper

Set a parameter to a Java array of bytes.

setCharacterStream(int, Reader, int) - Method in class com.bentofw.sql.PSWraper

JDBC 2.0 When a very large UNICODE value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.Reader.

setClob(int, Clob) - Method in class com.bentofw.sql.PSWraper

JDBC 2.0 Set a CLOB parameter.

setCursorName(String) - Method in class com.bentofw.sql.PSWraper

setCursorName defines the SQL cursor name that will be used by subsequent execute methods.

setDate(int, Date) - Method in class com.bentofw.sql.PSWraper

Set a parameter to a java.sql.Date value.

setDate(int, Date, Calendar) - Method in class com.bentofw.sql.PSWraper

Set a parameter to a java.sql.Date value.

setDebug(boolean) - Method in class com.bentofw.sql.PooledPS

Set if debugging mode.

setDouble(int, double) - Method in class com.bentofw.sql.PSWraper

Set a parameter to a Java double value.

setEscapeProcessing(boolean) - Method in class com.bentofw.sql.PSWraper

If escape scanning is on (the default), the driver will do escape substitution before sending the SQL to the database.

setFetchDirection(int) - Method in class com.bentofw.sql.PSWraper

JDBC 2.0 Give a hint as to the direction in which the rows in a result set will be processed.

setFetchSize(int) - Method in class com.bentofw.sql.PSWraper

JDBC 2.0 Give the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed.

setFloat(int, float) - Method in class com.bentofw.sql.PSWraper

Set a parameter to a Java float value.

setInt(int, int) - Method in class com.bentofw.sql.PSWraper

Set a parameter to a Java int value.

setLong(int, long) - Method in class com.bentofw.sql.PSWraper

Set a parameter to a Java long value.

setMaxFieldSize(int) - Method in class com.bentofw.sql.PSWraper

Sets the maxFieldSize

setMaxRows(int) - Method in class com.bentofw.sql.PSWraper

Set the maximum number of rows

setNull(int, int) - Method in class com.bentofw.sql.PSWraper

Set a parameter to SQL NULL.

setNull(int, int, String) - Method in class com.bentofw.sql.PSWraper

Set a parameter to SQL NULL.

setObject(int, Object, int, int) - Method in class com.bentofw.sql.PSWraper

Set the value of a parameter using an object; use the java.lang equivalent objects for integral values.

setObject(int, Object, int) - Method in class com.bentofw.sql.PSWraper

setObject(int, Object) - Method in class com.bentofw.sql.PSWraper

setQueryTimeout(int) - Method in class com.bentofw.sql.PSWraper

Sets the queryTimeout limit

setRef(int, Ref) - Method in class com.bentofw.sql.PSWraper

JDBC 2.0 Set a REF(<structured-type>) parameter.

setShort(int, short) - Method in class com.bentofw.sql.PSWraper

Set a parameter to a Java short value.

setString(int, String) - Method in class com.bentofw.sql.PSWraper

Set a parameter to a Java String value.

setTime(int, Time) - Method in class com.bentofw.sql.PSWraper

Set a parameter to a java.sql.Time value.

setTime(int, Time, Calendar) - Method in class com.bentofw.sql.PSWraper

Set a parameter to a java.sql.Time value.

setTimestamp(int, Timestamp) - Method in class com.bentofw.sql.PSWraper

Set a parameter to a java.sql.Timestamp value.

setTimestamp(int, Timestamp, Calendar) - Method in class com.bentofw.sql.PSWraper

Set a parameter to a java.sql.Timestamp value.

setUnicodeStream(int, InputStream, int) - Method in class com.bentofw.sql.PSWraper

When a very large Unicode value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.InputStream.

setURL(int, URL) - Method in class com.bentofw.sql.PSWraper

Sets the designated parameter to the given java.net.URL value.

SimpleException - Exception in com.bentofw.util

The exception for the logical error.

SimpleException(String) - Constructor for exception com.bentofw.util.SimpleException

The custructor.

T

toString() - Method in class com.bentofw.sql.PSWraper

A C D E G N P R S T