com.p6spy.engine.spy

Class P6CallableStatement

Implemented Interfaces:
CallableStatement, PreparedStatement, Statement
Known Direct Subclasses:
P6LogCallableStatement, P6OutageCallableStatement

public class P6CallableStatement
extends P6PreparedStatement
implements CallableStatement

Description: JDBC Driver Extension implementing CallableStatement. $Author: bradleydot $ $Revision: 1.5 $ $Date: 2003/08/04 20:18:23 $ $Id: P6CallableStatement.java,v 1.5 2003/08/04 20:18:23 bradleydot Exp $ $Source: /cvsroot/p6spy/p6spy/com/p6spy/engine/spy/P6CallableStatement.java,v $ $Log: P6CallableStatement.java,v $ Revision 1.5 2003/08/04 20:18:23 bradleydot Added calls to growvalues in registerOutParameters if they are outside the current array size. Revision 1.4 2003/06/03 19:20:24 cheechq removed unused imports Revision 1.3 2003/01/03 20:33:42 aarvesen Added getJDBC() method to return the underlying jdbc object. Revision 1.2 2002/12/06 22:40:13 aarvesen Extend P6Base. New factory registration in the constructor. Revision 1.1 2002/05/24 07:31:13 jeffgoke version 1 rewrite Revision 1.4 2002/04/18 06:54:39 jeffgoke added batch statement logging support Revision 1.3 2002/04/15 05:13:32 jeffgoke Simon Sadedin added timing support. Fixed bug where batch execute was not getting logged. Added result set timing. Updated the log format to include categories, and updated options to control the categories. Updated documentation. Revision 1.2 2002/04/11 04:18:03 jeffgoke fixed bug where callable & prepared were not passing their ancestors the correct constructor information Revision 1.1 2002/04/10 04:24:26 jeffgoke added support for callable statements and fixed numerous bugs that allowed the real class to be returned Revision 1.1.1.1 2002/04/07 04:52:25 jeffgoke no message Revision 1.2 2001-08-05 09:16:04-05 andy final version on the website Revision 1.1 2001-08-02 07:52:43-05 andy <> Revision 1.0 2001-08-02 06:37:42-05 andy Initial revision

Field Summary

protected CallableStatement
callStmtPassthru
protected String
callableQuery

Fields inherited from class com.p6spy.engine.spy.P6PreparedStatement

P6_GROW_MAX, P6_MAX_FIELDS, isString, prepStmtPassthru, preparedQuery, values

Fields inherited from class com.p6spy.engine.spy.P6Statement

connection, passthru, statementQuery

Fields inherited from class com.p6spy.engine.spy.P6Base

factory

Constructor Summary

P6CallableStatement(P6Factory factory, CallableStatement statement, P6Connection conn, String query)

Method Summary

Array
getArray(String p0)
Array
getArray(int p0)
BigDecimal
getBigDecimal(String p0)
BigDecimal
getBigDecimal(int p0)
BigDecimal
getBigDecimal(int p0, int p1)
Blob
getBlob(String p0)
Blob
getBlob(int p0)
boolean
getBoolean(String p0)
boolean
getBoolean(int p0)
byte
getByte(String p0)
byte
getByte(int p0)
byte[]
getBytes(String p0)
byte[]
getBytes(int p0)
Clob
getClob(String p0)
Clob
getClob(int p0)
Date
getDate(String p0)
Date
getDate(String p0, Calendar p1)
Date
getDate(int p0)
Date
getDate(int p0, Calendar calendar)
double
getDouble(String p0)
double
getDouble(int p0)
float
getFloat(String p0)
float
getFloat(int p0)
int
getInt(String p0)
int
getInt(int p0)
Statement
getJDBC()
Returns the underlying JDBC object (in this case, a java.sql.CallableStatement).
long
getLong(String p0)
long
getLong(int p0)
Object
getObject(String p0)
Object
getObject(String p0, Map p1)
Object
getObject(int p0)
Object
getObject(int p0, Map p1)
Ref
getRef(String p0)
Ref
getRef(int p0)
short
getShort(String p0)
short
getShort(int p0)
String
getString(String p0)
String
getString(int p0)
Time
getTime(String p0)
Time
getTime(String p0, Calendar p1)
Time
getTime(int p0)
Time
getTime(int p0, Calendar p1)
Timestamp
getTimestamp(String p0)
Timestamp
getTimestamp(String p0, Calendar p1)
Timestamp
getTimestamp(int p0)
Timestamp
getTimestamp(int p0, Calendar p1)
URL
getURL(String p0)
URL
getURL(int p0)
void
registerOutParameter(String p0, int p1)
void
registerOutParameter(String p0, int p1, String p2)
void
registerOutParameter(String p0, int p1, int p2)
void
registerOutParameter(int p0, int p1)
void
registerOutParameter(int p0, int p1, String p2)
void
registerOutParameter(int p0, int p1, int p2)
void
setAsciiStream(String p0, InputStream p1, int p2)
void
setBigDecimal(String p0, BigDecimal p1)
void
setBinaryStream(String p0, InputStream p1, int p2)
void
setBoolean(String p0, boolean p1)
void
setByte(String p0, byte p1)
void
setBytes(String p0, p1[] )
void
setCharacterStream(String p0, Reader p1, int p2)
void
setDate(String p0, Date p1)
void
setDate(String p0, Date p1, Calendar p2)
void
setDouble(String p0, double p1)
void
setFloat(String p0, float p1)
void
setInt(String p0, int p1)
void
setLong(String p0, long p1)
void
setNull(String p0, int p1)
void
setNull(String p0, int p1, String p2)
void
setObject(String p0, Object p1)
void
setObject(String p0, Object p1, int p2)
void
setObject(String p0, Object p1, int p2, int p3)
void
setShort(String p0, short p1)
void
setString(String p0, String p1)
void
setTime(String p0, Time p1)
void
setTime(String p0, Time p1, Calendar p2)
void
setTimestamp(String p0, Timestamp p1)
void
setTimestamp(String p0, Timestamp p1, Calendar p2)
void
setURL(String p0, URL p1)
boolean
wasNull()

Methods inherited from class com.p6spy.engine.spy.P6PreparedStatement

addBatch, clearParameters, execute, executeQuery, executeUpdate, getJDBC, getMetaData, getParameterMetaData, getQueryFromPreparedStatement, getResultSet, getValuesLength, growValues, initValues, setArray, setAsciiStream, setBigDecimal, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setObjectAsInt, setObjectAsString, setRef, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setURL, setUnicodeStream

Methods inherited from class com.p6spy.engine.spy.P6Statement

addBatch, cancel, clearBatch, clearWarnings, close, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getJDBC, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout

Methods inherited from class com.p6spy.engine.spy.P6Base

getP6Factory, setP6Factory

Field Details

callStmtPassthru

protected CallableStatement callStmtPassthru


callableQuery

protected String callableQuery

Constructor Details

P6CallableStatement

public P6CallableStatement(P6Factory factory,
                           CallableStatement statement,
                           P6Connection conn,
                           String query)

Method Details

getArray

public Array getArray(String p0)
            throws SQLException


getArray

public Array getArray(int p0)
            throws SQLException


getBigDecimal

public BigDecimal getBigDecimal(String p0)
            throws SQLException


getBigDecimal

public BigDecimal getBigDecimal(int p0)
            throws SQLException


getBigDecimal

public BigDecimal getBigDecimal(int p0,
                                          int p1)
            throws SQLException


getBlob

public Blob getBlob(String p0)
            throws SQLException


getBlob

public Blob getBlob(int p0)
            throws SQLException


getBoolean

public boolean getBoolean(String p0)
            throws SQLException


getBoolean

public boolean getBoolean(int p0)
            throws SQLException


getByte

public byte getByte(String p0)
            throws SQLException


getByte

public byte getByte(int p0)
            throws SQLException


getBytes

public byte[] getBytes(String p0)
            throws SQLException


getBytes

public byte[] getBytes(int p0)
            throws SQLException


getClob

public Clob getClob(String p0)
            throws SQLException


getClob

public Clob getClob(int p0)
            throws SQLException


getDate

public Date getDate(String p0)
            throws SQLException


getDate

public Date getDate(String p0,
                             Calendar p1)
            throws SQLException


getDate

public Date getDate(int p0)
            throws SQLException


getDate

public Date getDate(int p0,
                             Calendar calendar)
            throws SQLException


getDouble

public double getDouble(String p0)
            throws SQLException


getDouble

public double getDouble(int p0)
            throws SQLException


getFloat

public float getFloat(String p0)
            throws SQLException


getFloat

public float getFloat(int p0)
            throws SQLException


getInt

public int getInt(String p0)
            throws SQLException


getInt

public int getInt(int p0)
            throws SQLException


getJDBC

public Statement getJDBC()
Returns the underlying JDBC object (in this case, a java.sql.CallableStatement).

The returned object is a java.sql.Statement due to inheritance reasons, so you'll need to cast appropriately.

Overrides:
getJDBC in interface P6PreparedStatement

Returns:
the wrapped JDBC object


getLong

public long getLong(String p0)
            throws SQLException


getLong

public long getLong(int p0)
            throws SQLException


getObject

public Object getObject(String p0)
            throws SQLException


getObject

public Object getObject(String p0,
                        Map p1)
            throws SQLException


getObject

public Object getObject(int p0)
            throws SQLException


getObject

public Object getObject(int p0,
                        Map p1)
            throws SQLException


getRef

public Ref getRef(String p0)
            throws SQLException


getRef

public Ref getRef(int p0)
            throws SQLException


getShort

public short getShort(String p0)
            throws SQLException


getShort

public short getShort(int p0)
            throws SQLException


getString

public String getString(String p0)
            throws SQLException


getString

public String getString(int p0)
            throws SQLException


getTime

public Time getTime(String p0)
            throws SQLException


getTime

public Time getTime(String p0,
                             Calendar p1)
            throws SQLException


getTime

public Time getTime(int p0)
            throws SQLException


getTime

public Time getTime(int p0,
                             Calendar p1)
            throws SQLException


getTimestamp

public Timestamp getTimestamp(String p0)
            throws SQLException


getTimestamp

public Timestamp getTimestamp(String p0,
                                       Calendar p1)
            throws SQLException


getTimestamp

public Timestamp getTimestamp(int p0)
            throws SQLException


getTimestamp

public Timestamp getTimestamp(int p0,
                                       Calendar p1)
            throws SQLException


getURL

public URL getURL(String p0)
            throws SQLException


getURL

public URL getURL(int p0)
            throws SQLException


registerOutParameter

public void registerOutParameter(String p0,
                                 int p1)
            throws SQLException


registerOutParameter

public void registerOutParameter(String p0,
                                 int p1,
                                 String p2)
            throws SQLException


registerOutParameter

public void registerOutParameter(String p0,
                                 int p1,
                                 int p2)
            throws SQLException


registerOutParameter

public void registerOutParameter(int p0,
                                 int p1)
            throws SQLException


registerOutParameter

public void registerOutParameter(int p0,
                                 int p1,
                                 String p2)
            throws SQLException


registerOutParameter

public void registerOutParameter(int p0,
                                 int p1,
                                 int p2)
            throws SQLException


setAsciiStream

public void setAsciiStream(String p0,
                           InputStream p1,
                           int p2)
            throws SQLException


setBigDecimal

public void setBigDecimal(String p0,
                          BigDecimal p1)
            throws SQLException


setBinaryStream

public void setBinaryStream(String p0,
                            InputStream p1,
                            int p2)
            throws SQLException


setBoolean

public void setBoolean(String p0,
                       boolean p1)
            throws SQLException


setByte

public void setByte(String p0,
                    byte p1)
            throws SQLException


setBytes

public void setBytes(String p0,
                     p1[] )
            throws SQLException


setCharacterStream

public void setCharacterStream(String p0,
                               Reader p1,
                               int p2)
            throws SQLException


setDate

public void setDate(String p0,
                    Date p1)
            throws SQLException


setDate

public void setDate(String p0,
                    Date p1,
                    Calendar p2)
            throws SQLException


setDouble

public void setDouble(String p0,
                      double p1)
            throws SQLException


setFloat

public void setFloat(String p0,
                     float p1)
            throws SQLException


setInt

public void setInt(String p0,
                   int p1)
            throws SQLException


setLong

public void setLong(String p0,
                    long p1)
            throws SQLException


setNull

public void setNull(String p0,
                    int p1)
            throws SQLException


setNull

public void setNull(String p0,
                    int p1,
                    String p2)
            throws SQLException


setObject

public void setObject(String p0,
                      Object p1)
            throws SQLException


setObject

public void setObject(String p0,
                      Object p1,
                      int p2)
            throws SQLException


setObject

public void setObject(String p0,
                      Object p1,
                      int p2,
                      int p3)
            throws SQLException


setShort

public void setShort(String p0,
                     short p1)
            throws SQLException


setString

public void setString(String p0,
                      String p1)
            throws SQLException


setTime

public void setTime(String p0,
                    Time p1)
            throws SQLException


setTime

public void setTime(String p0,
                    Time p1,
                    Calendar p2)
            throws SQLException


setTimestamp

public void setTimestamp(String p0,
                         Timestamp p1)
            throws SQLException


setTimestamp

public void setTimestamp(String p0,
                         Timestamp p1,
                         Calendar p2)
            throws SQLException


setURL

public void setURL(String p0,
                   URL p1)
            throws SQLException


wasNull

public boolean wasNull()
            throws SQLException