File	Doc	Category	Size	Date	Package
PooledStatement.java	API Doc	Example	25064	Mon Mar 31 23:10:16 BST 2003	org.dasein.persist

PooledStatement

• java.lang.Object

Fields Summary
private Connection	connection The logical connection responsible for this statement.
private ArrayList	listeners The list of listeners interested in closings of this statement.
private String	sql The SQL behind this prepared statement.
private PreparedStatement	statement The underlying physical statement.

Constructors Summary
public PooledStatement(Connection conn, String sql, PreparedStatement stmt) Constructs a new pooled statement tied to the specified logical connection and prepared statement. param conn the logical database connection param sql the SQL this statemment represents param stmt the physical prepared statement super(); this.sql = sql; statement = stmt;

Methods Summary
public void	addBatch() Delegates to the underlying prepared statement. throws java.sql.SQLException a database error occurred validate(); statement.addBatch();
public void	addBatch(java.lang.String sql) Delegates to the underlying prepared statement. param sql unused throws java.sql.SQLException a database error occurred validate(); statement.addBatch(sql);
public void	addStatementEventListener(StatementEventListener lstnr) Adds a listener to this statement's list of listeners. param lstnr the listener to add synchronized( listeners ) { listeners.add(lstnr); }
public void	cancel() Delegates to the underlying prepared statement. throws java.sql.SQLException a database error occurred validate(); statement.cancel();
public void	clearBatch() Delegates to the underlying prepared statement. throws java.sql.SQLException a database error occurred validate(); statement.clearBatch();
public void	clearParameters() Delegates to the underlying prepared statement. throws java.sql.SQLException a database error occurred validate(); statement.clearParameters();
public void	clearWarnings() Delegates to the underlying prepared statement. throws java.sql.SQLException a database error occurred validate(); statement.clearWarnings();
public void	close() Closes this logical statementand notifies all listeners of the closure so that the physical statement can return to the pool. All parameters and warnings associated with the statement are cleared. throws java.sql.SQLException a database error occurred validate(); statement.clearParameters(); statement.clearWarnings(); statement = null; synchronized( listeners ) { Iterator it = listeners.iterator(); while( it.hasNext() ) { StatementEventListener lstnr; lstnr = (StatementEventListener)it.next(); lstnr.statementClosed(new StatementEvent(sql, statement)); } }
public boolean	execute() Delegates to the underlying prepared statement. return true if the execution generated results throws java.sql.SQLException a database error occurred validate(); return statement.execute();
public boolean	execute(java.lang.String sql) Delegates to the underlying prepared statement. param sql necessary from the Statement interface return true if the execution generated results throws java.sql.SQLException a database error occurred validate(); return statement.execute(sql);
public int[]	executeBatch() Delegates to the underlying prepared statement. return an array of update counts throws java.sql.SQLException a database error occurred validate(); return statement.executeBatch();
public java.sql.ResultSet	executeQuery() Delegates to the underlying prepared statement. return the query results throws java.sql.SQLException a database error occurred validate(); return statement.executeQuery();
public java.sql.ResultSet	executeQuery(java.lang.String sql) Delegates to the underlying prepared statement. param sql nonsense return the query results throws java.sql.SQLException a database error occurred validate(); return statement.executeQuery(sql);
public int	executeUpdate() Delegates to the underlying prepared statement. return the number of updated rows throws java.sql.SQLException a database error occurred validate(); return statement.executeUpdate();
public int	executeUpdate(java.lang.String sql) Delegates to the underlying prepared statement. param sql nonsense return the number of updated rows throws java.sql.SQLException a database error occurred validate(); return statement.executeUpdate(sql);
public java.sql.Connection	getConnection() Provides the logical connection associated with this statement return the statement's connection throws java.sql.SQLException a database error occurred validate(); return connection;
public int	getFetchDirection() Delegates to the underlying prepared statement. return the fetch direction throws java.sql.SQLException a database error occurred validate(); return statement.getFetchDirection();
public int	getFetchSize() Delegates to the underlying prepared statement. return the fetch size throws java.sql.SQLException a database error occurred validate(); return statement.getFetchSize();
public int	getMaxFieldSize() Delegates to the underlying prepared statement. return the maximum field size throws java.sql.SQLException a database error occurred validate(); return statement.getMaxFieldSize();
public int	getMaxRows() Delegates to the underlying prepared statement. return the maximum number of rows throws java.sql.SQLException a database error occurred validate(); return statement.getMaxRows();
public java.sql.ResultSetMetaData	getMetaData() Delegates to the underlying prepared statement. return the result set meta-data throws java.sql.SQLException a database error occurred validate(); return statement.getMetaData();
public boolean	getMoreResults() Delegates to the underlying prepared statement. return more results! throws java.sql.SQLException a database error occurred validate(); return statement.getMoreResults();
public int	getQueryTimeout() Delegates to the underlying prepared statement. return the query timeout throws java.sql.SQLException a database error occurred validate(); return statement.getQueryTimeout();
public java.sql.ResultSet	getResultSet() Delegates to the underlying prepared statement. return the lastt result set throws java.sql.SQLException a database error occurred validate(); return statement.getResultSet();
public int	getResultSetConcurrency() Delegates to the underlying prepared statement. return the concurrency for result sets throws java.sql.SQLException a database error occurred validate(); return statement.getResultSetConcurrency();
public int	getResultSetType() Delegates to the underlying prepared statement. return the type for result sets throws java.sql.SQLException a database error occurred validate(); return statement.getResultSetType();
public int	getUpdateCount() Delegates to the underlying prepared statement. return the number of rows updated throws java.sql.SQLException a database error occurred validate(); return statement.getUpdateCount();
public java.sql.SQLWarning	getWarnings() Delegates to the underlying prepared statement. return any warnings throws java.sql.SQLException a database error occurred validate(); return statement.getWarnings();
public boolean	isClosed() return true if no statement exists return (statement == null);
public void	removeStatementEventListener(StatementEventListener lstnr) Removes a listener from the stable of listeners. param lstnr the listener to remove synchronized( listeners ) { listeners.remove(lstnr); }
public void	setArray(int idx, java.sql.Array arr) Delegates to the underlying prepared statement. param idx the index to assign a value for param arr an array value throws java.sql.SQLException a database error occurred validate(); statement.setArray(idx, arr);
public void	setAsciiStream(int idx, java.io.InputStream is, int len) Delegates to the underlying prepared statement. param idx the index to assign a value for param is the input stream param len the length of the stream throws java.sql.SQLException a database error occurred validate(); statement.setAsciiStream(idx, is, len);
public void	setBigDecimal(int idx, java.math.BigDecimal d) Delegates to the underlying prepared statement. param idx the index to assign a value for param d the big decimal value throws java.sql.SQLException a database error occurred validate(); statement.setBigDecimal(idx, d);
public void	setBinaryStream(int idx, java.io.InputStream is, int len) Delegates to the underlying prepared statement. param idx the index to assign a value for param is the input stream param len the lenth of the input stream throws java.sql.SQLException a database error occurred validate(); statement.setBinaryStream(idx, is, len);
public void	setBlob(int idx, java.sql.Blob b) Delegates to the underlying prepared statement. param idx the index to assign a value for param bthe blob value throws java.sql.SQLException a database error occurred validate(); statement.setBlob(idx, b);
public void	setBoolean(int idx, boolean b) Delegates to the underlying prepared statement. param idx the index to assign a value for param b the boolean value throws java.sql.SQLException a database error occurred validate(); statement.setBoolean(idx, b);
public void	setByte(int idx, byte b) Delegates to the underlying prepared statement. param idx the index to assign a value for param b the byte value throws java.sql.SQLException a database error occurred validate(); statement.setByte(idx, b);
public void	setBytes(int idx, byte[] data) Delegates to the underlying prepared statement. param idx the index to assign a value for param data the binary data throws java.sql.SQLException a database error occurred validate(); statement.setBytes(idx, data);
public void	setCharacterStream(int idx, java.io.Reader rdr, int len) Delegates to the underlying prepared statement. param idx the index to assign a value for param rdr the reader from which the value should be read param len the length of the stream throws java.sql.SQLException a database error occurred validate(); statement.setCharacterStream(idx, rdr, len);
public void	setClob(int idx, java.sql.Clob c) Delegates to the underlying prepared statement. param idx the index to assign a value for param c the character large object value throws java.sql.SQLException a database error occurred validate(); statement.setClob(idx, c);
public void	setCursorName(java.lang.String name) Delegates to the underlying prepared statement. param name the name of the cursor throws java.sql.SQLException a database error occurred validate(); statement.setCursorName(name);
public void	setDate(int idx, java.sql.Date d) Delegates to the underlying prepared statement. param idx the index to assign a value for param d the date value throws java.sql.SQLException a database error occurred validate(); statement.setDate(idx, d);
public void	setDate(int idx, java.sql.Date d, java.util.Calendar cal) Delegates to the underlying prepared statement. param idx the index to assign a value for param d the date value param cal the calendar of the date throws java.sql.SQLException a database error occurred validate(); statement.setDate(idx, d, cal);
public void	setDouble(int idx, double d) Delegates to the underlying prepared statement. param idx the index to assign a value for param d the double value throws java.sql.SQLException a database error occurred validate(); statement.setDouble(idx, d);
public void	setEscapeProcessing(boolean en) Delegates to the underlying prepared statement. param en whether to enable escape processing throws java.sql.SQLException a database error occurred validate(); statement.setEscapeProcessing(en);
public void	setFetchDirection(int dir) Delegates to the underlying prepared statement. param idx dir the fetch direction throws java.sql.SQLException a database error occurred validate(); statement.setFetchDirection(dir);
public void	setFetchSize(int sz) Delegates to the underlying prepared statement. param sz the fetch size throws java.sql.SQLException a database error occurred validate(); statement.setFetchSize(sz);
public void	setFloat(int idx, float f) Delegates to the underlying prepared statement. param idx the index to assign a value for param f the float value throws java.sql.SQLException a database error occurred validate(); statement.setFloat(idx, f);
public void	setInt(int idx, int x) Delegates to the underlying prepared statement. param idx the index to assign a value for param x the integer value throws java.sql.SQLException a database error occurred validate(); statement.setInt(idx, x);
public void	setLong(int idx, long l) Delegates to the underlying prepared statement. param idx the index to assign a value for param l the long value throws java.sql.SQLException a database error occurred validate(); statement.setLong(idx, l);
public void	setMaxFieldSize(int max) Delegates to the underlying prepared statement. param max the maximum field size throws java.sql.SQLException a database error occurred validate(); statement.setMaxFieldSize(max);
public void	setMaxRows(int max) Delegates to the underlying prepared statement. param max the maximum number of rows throws java.sql.SQLException a database error occurred validate(); statement.setMaxRows(max);
public void	setNull(int idx, int type) Delegates to the underlying prepared statement. param idx the index to assign a value for param type the type from java.sql.Types throws java.sql.SQLException a database error occurred see java.sql.Types validate(); statement.setNull(idx, type);
public void	setNull(int idx, int type, java.lang.String name) Delegates to the underlying prepared statement. param idx the index to assign a value for param type the type from java.sql.Types param name the user defined type name throws java.sql.SQLException a database error occurred see java.sql.Types validate(); statement.setNull(idx, type, name);
public void	setObject(int idx, java.lang.Object ob) Delegates to the underlying prepared statement. param idx the index to assign a value for param ob the object value throws java.sql.SQLException a database error occurred validate(); statement.setObject(idx, ob);
public void	setObject(int idx, java.lang.Object ob, int type) Delegates to the underlying prepared statement. param idx the index to assign a value for param ob the object value param type the type from java.sql.Types throws java.sql.SQLException a database error occurred see java.sql.Types validate(); statement.setObject(idx, ob, type);
public void	setObject(int idx, java.lang.Object ob, int type, int scale) Delegates to the underlying prepared statement. param idx the index to assign a value for param ob the object value param type the type from java.sql.Types param scale the scale of the value throws java.sql.SQLException a database error occurred see java.sql.Types validate(); statement.setObject(idx, ob, type, scale);
public void	setQueryTimeout(int sec) Delegates to the underlying prepared statement. param sec the query timeout in seconds throws java.sql.SQLException a database error occurred validate(); statement.setQueryTimeout(sec);
public void	setRef(int idx, java.sql.Ref ref) Delegates to the underlying prepared statement. param idx the index to assign a value for param ref the reference value throws java.sql.SQLException a database error occurred validate(); statement.setRef(idx, ref);
public void	setShort(int idx, short s) Delegates to the underlying prepared statement. param idx the index to assign a value for param s the short value throws java.sql.SQLException a database error occurred validate(); statement.setShort(idx, s);
public void	setString(int idx, java.lang.String str) Delegates to the underlying prepared statement. param idx the index to assign a value for param str the string value throws java.sql.SQLException a database error occurred validate(); statement.setString(idx, str);
public void	setTime(int idx, java.sql.Time t) Delegates to the underlying prepared statement. param idx the index to assign a value for param t the time value throws java.sql.SQLException a database error occurred validate(); statement.setTime(idx, t);
public void	setTime(int idx, java.sql.Time t, java.util.Calendar cal) Delegates to the underlying prepared statement. param idx the index to assign a value for param t the time value param cal the calendar for the time value throws java.sql.SQLException a database error occurred validate(); statement.setTime(idx, t, cal);
public void	setTimestamp(int idx, java.sql.Timestamp ts) Delegates to the underlying prepared statement. param idx the index to assign a value for param ts the timestamp value throws java.sql.SQLException a database error occurred validate(); statement.setTimestamp(idx, ts);
public void	setTimestamp(int idx, java.sql.Timestamp ts, java.util.Calendar cal) Delegates to the underlying prepared statement. param idx the index to assign a value for param ts the timestamp value param cal the calendar for the tiemstamp value throws java.sql.SQLException a database error occurred validate(); statement.setTimestamp(idx, ts, cal);
public void	setUnicodeStream(int idx, java.io.InputStream is, int len) Delegates to the underlying prepared statement. param idx the index to assign a value for param is the input stream param len the length of the input stream throws java.sql.SQLException a database error occurred deprecated use setCharacterStream() validate(); statement.setUnicodeStream(idx, is, len);
public java.lang.String	toString() if( statement != null ) { return super.toString() + " [" + statement.toString() + "]"; } else { return super.toString(); }
private void	validate() Verifies that this statement is still valid. throws java.sql.SQLException the statement is no longer valid if( isClosed() ) { throw new SQLException("Illegal attempt to access statement."); }