com.p6spy.engine.spy
Class P6CallableStatement

java.lang.Object
  extended by com.p6spy.engine.spy.P6Base
      extended by com.p6spy.engine.spy.P6Statement
          extended by com.p6spy.engine.spy.P6PreparedStatement
              extended by com.p6spy.engine.spy.P6CallableStatement
All Implemented Interfaces:
CallableStatement, PreparedStatement, Statement
Direct Known Subclasses:
P6LogCallableStatement, P6OutageCallableStatement

public class P6CallableStatement
extends P6PreparedStatement
implements CallableStatement


Field Summary
protected  String callableQuery
           
protected  CallableStatement callStmtPassthru
           
 
Fields inherited from class com.p6spy.engine.spy.P6PreparedStatement
isString, P6_GROW_MAX, P6_MAX_FIELDS, preparedQuery, prepStmtPassthru, values
 
Fields inherited from class com.p6spy.engine.spy.P6Statement
connection, passthru, statementQuery
 
Fields inherited from class com.p6spy.engine.spy.P6Base
factory
 
Fields inherited from interface java.sql.Statement
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO
 
Constructor Summary
P6CallableStatement(P6Factory factory, CallableStatement statement, P6Connection conn, String query)
           
 
Method Summary
 Array getArray(int p0)
           
 Array getArray(String p0)
           
 BigDecimal getBigDecimal(int p0)
           
 BigDecimal getBigDecimal(int p0, int p1)
           
 BigDecimal getBigDecimal(String p0)
           
 Blob getBlob(int p0)
           
 Blob getBlob(String p0)
           
 boolean getBoolean(int p0)
           
 boolean getBoolean(String p0)
           
 byte getByte(int p0)
           
 byte getByte(String p0)
           
 byte[] getBytes(int p0)
           
 byte[] getBytes(String p0)
           
 Clob getClob(int p0)
           
 Clob getClob(String p0)
           
 Date getDate(int p0)
           
 Date getDate(int p0, Calendar calendar)
           
 Date getDate(String p0)
           
 Date getDate(String p0, Calendar p1)
           
 double getDouble(int p0)
           
 double getDouble(String p0)
           
 float getFloat(int p0)
           
 float getFloat(String p0)
           
 int getInt(int p0)
           
 int getInt(String p0)
           
 Statement getJDBC()
          Returns the underlying JDBC object (in this case, a java.sql.CallableStatement).
 long getLong(int p0)
           
 long getLong(String p0)
           
 Object getObject(int p0)
           
 Object getObject(int p0, Map p1)
           
 Object getObject(String p0)
           
 Object getObject(String p0, Map p1)
           
 Ref getRef(int p0)
           
 Ref getRef(String p0)
           
 short getShort(int p0)
           
 short getShort(String p0)
           
 String getString(int p0)
           
 String getString(String p0)
           
 Time getTime(int p0)
           
 Time getTime(int p0, Calendar p1)
           
 Time getTime(String p0)
           
 Time getTime(String p0, Calendar p1)
           
 Timestamp getTimestamp(int p0)
           
 Timestamp getTimestamp(int p0, Calendar p1)
           
 Timestamp getTimestamp(String p0)
           
 Timestamp getTimestamp(String p0, Calendar p1)
           
 URL getURL(int p0)
           
 URL getURL(String p0)
           
 void registerOutParameter(int p0, int p1)
           
 void registerOutParameter(int p0, int p1, int p2)
           
 void registerOutParameter(int p0, int p1, String p2)
           
 void registerOutParameter(String p0, int p1)
           
 void registerOutParameter(String p0, int p1, int p2)
           
 void registerOutParameter(String p0, int p1, String 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, byte[] 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, 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, setUnicodeStream, setURL
 
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, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout
 
Methods inherited from class com.p6spy.engine.spy.P6Base
getP6Factory, setP6Factory
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 
Methods inherited from interface java.sql.PreparedStatement
addBatch, clearParameters, execute, executeQuery, executeUpdate, getMetaData, getParameterMetaData, setArray, setAsciiStream, setBigDecimal, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setRef, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL
 
Methods inherited from interface java.sql.Statement
addBatch, cancel, clearBatch, clearWarnings, close, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout
 

Field Detail

callStmtPassthru

protected CallableStatement callStmtPassthru

callableQuery

protected String callableQuery
Constructor Detail

P6CallableStatement

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

getString

public String getString(int p0)
                 throws SQLException
Specified by:
getString in interface CallableStatement
Throws:
SQLException

registerOutParameter

public void registerOutParameter(int p0,
                                 int p1)
                          throws SQLException
Specified by:
registerOutParameter in interface CallableStatement
Throws:
SQLException

registerOutParameter

public void registerOutParameter(int p0,
                                 int p1,
                                 int p2)
                          throws SQLException
Specified by:
registerOutParameter in interface CallableStatement
Throws:
SQLException

registerOutParameter

public void registerOutParameter(int p0,
                                 int p1,
                                 String p2)
                          throws SQLException
Specified by:
registerOutParameter in interface CallableStatement
Throws:
SQLException

wasNull

public boolean wasNull()
                throws SQLException
Specified by:
wasNull in interface CallableStatement
Throws:
SQLException

getArray

public Array getArray(int p0)
               throws SQLException
Specified by:
getArray in interface CallableStatement
Throws:
SQLException

getBigDecimal

public BigDecimal getBigDecimal(int p0)
                         throws SQLException
Specified by:
getBigDecimal in interface CallableStatement
Throws:
SQLException

getBigDecimal

public BigDecimal getBigDecimal(int p0,
                                int p1)
                         throws SQLException
Specified by:
getBigDecimal in interface CallableStatement
Throws:
SQLException

getBlob

public Blob getBlob(int p0)
             throws SQLException
Specified by:
getBlob in interface CallableStatement
Throws:
SQLException

getBoolean

public boolean getBoolean(int p0)
                   throws SQLException
Specified by:
getBoolean in interface CallableStatement
Throws:
SQLException

getByte

public byte getByte(int p0)
             throws SQLException
Specified by:
getByte in interface CallableStatement
Throws:
SQLException

getBytes

public byte[] getBytes(int p0)
                throws SQLException
Specified by:
getBytes in interface CallableStatement
Throws:
SQLException

getClob

public Clob getClob(int p0)
             throws SQLException
Specified by:
getClob in interface CallableStatement
Throws:
SQLException

getDate

public Date getDate(int p0)
             throws SQLException
Specified by:
getDate in interface CallableStatement
Throws:
SQLException

getDate

public Date getDate(int p0,
                    Calendar calendar)
             throws SQLException
Specified by:
getDate in interface CallableStatement
Throws:
SQLException

getDouble

public double getDouble(int p0)
                 throws SQLException
Specified by:
getDouble in interface CallableStatement
Throws:
SQLException

getFloat

public float getFloat(int p0)
               throws SQLException
Specified by:
getFloat in interface CallableStatement
Throws:
SQLException

getInt

public int getInt(int p0)
           throws SQLException
Specified by:
getInt in interface CallableStatement
Throws:
SQLException

getLong

public long getLong(int p0)
             throws SQLException
Specified by:
getLong in interface CallableStatement
Throws:
SQLException

getObject

public Object getObject(int p0)
                 throws SQLException
Specified by:
getObject in interface CallableStatement
Throws:
SQLException

getObject

public Object getObject(int p0,
                        Map p1)
                 throws SQLException
Specified by:
getObject in interface CallableStatement
Throws:
SQLException

getRef

public Ref getRef(int p0)
           throws SQLException
Specified by:
getRef in interface CallableStatement
Throws:
SQLException

getShort

public short getShort(int p0)
               throws SQLException
Specified by:
getShort in interface CallableStatement
Throws:
SQLException

getTime

public Time getTime(int p0)
             throws SQLException
Specified by:
getTime in interface CallableStatement
Throws:
SQLException

getTime

public Time getTime(int p0,
                    Calendar p1)
             throws SQLException
Specified by:
getTime in interface CallableStatement
Throws:
SQLException

getTimestamp

public Timestamp getTimestamp(int p0)
                       throws SQLException
Specified by:
getTimestamp in interface CallableStatement
Throws:
SQLException

getTimestamp

public Timestamp getTimestamp(int p0,
                              Calendar p1)
                       throws SQLException
Specified by:
getTimestamp in interface CallableStatement
Throws:
SQLException

registerOutParameter

public void registerOutParameter(String p0,
                                 int p1)
                          throws SQLException
Specified by:
registerOutParameter in interface CallableStatement
Throws:
SQLException

registerOutParameter

public void registerOutParameter(String p0,
                                 int p1,
                                 int p2)
                          throws SQLException
Specified by:
registerOutParameter in interface CallableStatement
Throws:
SQLException

registerOutParameter

public void registerOutParameter(String p0,
                                 int p1,
                                 String p2)
                          throws SQLException
Specified by:
registerOutParameter in interface CallableStatement
Throws:
SQLException

getURL

public URL getURL(int p0)
           throws SQLException
Specified by:
getURL in interface CallableStatement
Throws:
SQLException

setURL

public void setURL(String p0,
                   URL p1)
            throws SQLException
Specified by:
setURL in interface CallableStatement
Throws:
SQLException

setNull

public void setNull(String p0,
                    int p1)
             throws SQLException
Specified by:
setNull in interface CallableStatement
Throws:
SQLException

setBoolean

public void setBoolean(String p0,
                       boolean p1)
                throws SQLException
Specified by:
setBoolean in interface CallableStatement
Throws:
SQLException

setByte

public void setByte(String p0,
                    byte p1)
             throws SQLException
Specified by:
setByte in interface CallableStatement
Throws:
SQLException

setShort

public void setShort(String p0,
                     short p1)
              throws SQLException
Specified by:
setShort in interface CallableStatement
Throws:
SQLException

setInt

public void setInt(String p0,
                   int p1)
            throws SQLException
Specified by:
setInt in interface CallableStatement
Throws:
SQLException

setLong

public void setLong(String p0,
                    long p1)
             throws SQLException
Specified by:
setLong in interface CallableStatement
Throws:
SQLException

setFloat

public void setFloat(String p0,
                     float p1)
              throws SQLException
Specified by:
setFloat in interface CallableStatement
Throws:
SQLException

setDouble

public void setDouble(String p0,
                      double p1)
               throws SQLException
Specified by:
setDouble in interface CallableStatement
Throws:
SQLException

setBigDecimal

public void setBigDecimal(String p0,
                          BigDecimal p1)
                   throws SQLException
Specified by:
setBigDecimal in interface CallableStatement
Throws:
SQLException

setString

public void setString(String p0,
                      String p1)
               throws SQLException
Specified by:
setString in interface CallableStatement
Throws:
SQLException

setBytes

public void setBytes(String p0,
                     byte[] p1)
              throws SQLException
Specified by:
setBytes in interface CallableStatement
Throws:
SQLException

setDate

public void setDate(String p0,
                    Date p1)
             throws SQLException
Specified by:
setDate in interface CallableStatement
Throws:
SQLException

setTime

public void setTime(String p0,
                    Time p1)
             throws SQLException
Specified by:
setTime in interface CallableStatement
Throws:
SQLException

setTimestamp

public void setTimestamp(String p0,
                         Timestamp p1)
                  throws SQLException
Specified by:
setTimestamp in interface CallableStatement
Throws:
SQLException

setAsciiStream

public void setAsciiStream(String p0,
                           InputStream p1,
                           int p2)
                    throws SQLException
Specified by:
setAsciiStream in interface CallableStatement
Throws:
SQLException

setBinaryStream

public void setBinaryStream(String p0,
                            InputStream p1,
                            int p2)
                     throws SQLException
Specified by:
setBinaryStream in interface CallableStatement
Throws:
SQLException

setObject

public void setObject(String p0,
                      Object p1,
                      int p2,
                      int p3)
               throws SQLException
Specified by:
setObject in interface CallableStatement
Throws:
SQLException

setObject

public void setObject(String p0,
                      Object p1,
                      int p2)
               throws SQLException
Specified by:
setObject in interface CallableStatement
Throws:
SQLException

setObject

public void setObject(String p0,
                      Object p1)
               throws SQLException
Specified by:
setObject in interface CallableStatement
Throws:
SQLException

setCharacterStream

public void setCharacterStream(String p0,
                               Reader p1,
                               int p2)
                        throws SQLException
Specified by:
setCharacterStream in interface CallableStatement
Throws:
SQLException

setDate

public void setDate(String p0,
                    Date p1,
                    Calendar p2)
             throws SQLException
Specified by:
setDate in interface CallableStatement
Throws:
SQLException

setTime

public void setTime(String p0,
                    Time p1,
                    Calendar p2)
             throws SQLException
Specified by:
setTime in interface CallableStatement
Throws:
SQLException

setTimestamp

public void setTimestamp(String p0,
                         Timestamp p1,
                         Calendar p2)
                  throws SQLException
Specified by:
setTimestamp in interface CallableStatement
Throws:
SQLException

setNull

public void setNull(String p0,
                    int p1,
                    String p2)
             throws SQLException
Specified by:
setNull in interface CallableStatement
Throws:
SQLException

getString

public String getString(String p0)
                 throws SQLException
Specified by:
getString in interface CallableStatement
Throws:
SQLException

getBoolean

public boolean getBoolean(String p0)
                   throws SQLException
Specified by:
getBoolean in interface CallableStatement
Throws:
SQLException

getByte

public byte getByte(String p0)
             throws SQLException
Specified by:
getByte in interface CallableStatement
Throws:
SQLException

getShort

public short getShort(String p0)
               throws SQLException
Specified by:
getShort in interface CallableStatement
Throws:
SQLException

getInt

public int getInt(String p0)
           throws SQLException
Specified by:
getInt in interface CallableStatement
Throws:
SQLException

getLong

public long getLong(String p0)
             throws SQLException
Specified by:
getLong in interface CallableStatement
Throws:
SQLException

getFloat

public float getFloat(String p0)
               throws SQLException
Specified by:
getFloat in interface CallableStatement
Throws:
SQLException

getDouble

public double getDouble(String p0)
                 throws SQLException
Specified by:
getDouble in interface CallableStatement
Throws:
SQLException

getBytes

public byte[] getBytes(String p0)
                throws SQLException
Specified by:
getBytes in interface CallableStatement
Throws:
SQLException

getDate

public Date getDate(String p0)
             throws SQLException
Specified by:
getDate in interface CallableStatement
Throws:
SQLException

getTime

public Time getTime(String p0)
             throws SQLException
Specified by:
getTime in interface CallableStatement
Throws:
SQLException

getTimestamp

public Timestamp getTimestamp(String p0)
                       throws SQLException
Specified by:
getTimestamp in interface CallableStatement
Throws:
SQLException

getObject

public Object getObject(String p0)
                 throws SQLException
Specified by:
getObject in interface CallableStatement
Throws:
SQLException

getBigDecimal

public BigDecimal getBigDecimal(String p0)
                         throws SQLException
Specified by:
getBigDecimal in interface CallableStatement
Throws:
SQLException

getObject

public Object getObject(String p0,
                        Map p1)
                 throws SQLException
Specified by:
getObject in interface CallableStatement
Throws:
SQLException

getRef

public Ref getRef(String p0)
           throws SQLException
Specified by:
getRef in interface CallableStatement
Throws:
SQLException

getBlob

public Blob getBlob(String p0)
             throws SQLException
Specified by:
getBlob in interface CallableStatement
Throws:
SQLException

getClob

public Clob getClob(String p0)
             throws SQLException
Specified by:
getClob in interface CallableStatement
Throws:
SQLException

getArray

public Array getArray(String p0)
               throws SQLException
Specified by:
getArray in interface CallableStatement
Throws:
SQLException

getDate

public Date getDate(String p0,
                    Calendar p1)
             throws SQLException
Specified by:
getDate in interface CallableStatement
Throws:
SQLException

getTime

public Time getTime(String p0,
                    Calendar p1)
             throws SQLException
Specified by:
getTime in interface CallableStatement
Throws:
SQLException

getTimestamp

public Timestamp getTimestamp(String p0,
                              Calendar p1)
                       throws SQLException
Specified by:
getTimestamp in interface CallableStatement
Throws:
SQLException

getURL

public URL getURL(String p0)
           throws SQLException
Specified by:
getURL in interface CallableStatement
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 class P6PreparedStatement
Returns:
the wrapped JDBC object