|
log4jdbc4 1.1 | ||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||
java.lang.Objectnet.sf.log4jdbc.StatementSpy
net.sf.log4jdbc.PreparedStatementSpy
public class PreparedStatementSpy
Wraps a PreparedStatement and reports method calls, returns and exceptions.
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
| Field Summary | |
|---|---|
protected List |
argTrace
holds list of bind variables for tracing |
protected net.sf.log4jdbc.RdbmsSpecifics |
rdbmsSpecifics
RdbmsSpecifics for formatting SQL for the given RDBMS. |
protected PreparedStatement |
realPreparedStatement
The real PreparedStatement that this PreparedStatementSpy wraps. |
| Fields inherited from class net.sf.log4jdbc.StatementSpy |
|---|
connectionSpy, currentBatch, realStatement |
| 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 | |
|---|---|
PreparedStatementSpy(String sql,
ConnectionSpy connectionSpy,
PreparedStatement realPreparedStatement)
Create a PreparedStatementSpy (JDBC 4.0 version) for logging activity of another PreparedStatement. |
|
| Method Summary | ||
|---|---|---|
void |
addBatch()
|
|
protected void |
argTraceSet(int i,
String typeHelper,
Object arg)
Store an argument (bind variable) into the argTrace list (above) for later dumping. |
|
void |
clearParameters()
|
|
protected String |
dumpedSql()
|
|
boolean |
execute()
|
|
ResultSet |
executeQuery()
|
|
int |
executeUpdate()
|
|
String |
getClassType()
Get the type of class being spied upon. |
|
ResultSetMetaData |
getMetaData()
|
|
ParameterMetaData |
getParameterMetaData()
|
|
boolean |
isWrapperFor(Class<?> iface)
|
|
protected void |
reportAllReturns(String methodCall,
String msg)
Report (for logging) that a method returned. |
|
void |
setArray(int i,
Array x)
|
|
void |
setAsciiStream(int parameterIndex,
InputStream x)
|
|
void |
setAsciiStream(int parameterIndex,
InputStream x,
int length)
|
|
void |
setAsciiStream(int parameterIndex,
InputStream x,
long length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
|
void |
setBigDecimal(int parameterIndex,
BigDecimal x)
|
|
void |
setBinaryStream(int parameterIndex,
InputStream x)
|
|
void |
setBinaryStream(int parameterIndex,
InputStream x,
int length)
|
|
void |
setBinaryStream(int parameterIndex,
InputStream x,
long length)
|
|
void |
setBlob(int i,
Blob x)
|
|
void |
setBlob(int parameterIndex,
InputStream inputStream)
|
|
void |
setBlob(int parameterIndex,
InputStream inputStream,
long length)
|
|
void |
setBoolean(int parameterIndex,
boolean x)
|
|
void |
setByte(int parameterIndex,
byte x)
|
|
void |
setBytes(int parameterIndex,
byte[] x)
|
|
void |
setCharacterStream(int parameterIndex,
Reader reader)
|
|
void |
setCharacterStream(int parameterIndex,
Reader reader,
int length)
|
|
void |
setCharacterStream(int parameterIndex,
Reader reader,
long length)
|
|
void |
setClob(int i,
Clob x)
|
|
void |
setClob(int parameterIndex,
Reader reader)
|
|
void |
setClob(int parameterIndex,
Reader reader,
long length)
|
|
void |
setDate(int parameterIndex,
Date x)
|
|
void |
setDate(int parameterIndex,
Date x,
Calendar cal)
|
|
void |
setDouble(int parameterIndex,
double x)
|
|
void |
setFloat(int parameterIndex,
float x)
|
|
void |
setInt(int parameterIndex,
int x)
|
|
void |
setLong(int parameterIndex,
long x)
|
|
void |
setNCharacterStream(int parameterIndex,
Reader reader)
|
|
void |
setNCharacterStream(int parameterIndex,
Reader value,
long length)
|
|
void |
setNClob(int parameterIndex,
NClob value)
|
|
void |
setNClob(int parameterIndex,
Reader reader)
|
|
void |
setNClob(int parameterIndex,
Reader reader,
long length)
|
|
void |
setNString(int parameterIndex,
String value)
|
|
void |
setNull(int parameterIndex,
int sqlType)
|
|
void |
setNull(int paramIndex,
int sqlType,
String typeName)
|
|
void |
setObject(int parameterIndex,
Object x)
|
|
void |
setObject(int parameterIndex,
Object x,
int targetSqlType)
|
|
void |
setObject(int parameterIndex,
Object x,
int targetSqlType,
int scale)
|
|
void |
setRef(int i,
Ref x)
|
|
void |
setRowId(int parameterIndex,
RowId x)
|
|
void |
setShort(int parameterIndex,
short x)
|
|
void |
setSQLXML(int parameterIndex,
SQLXML xmlObject)
|
|
void |
setString(int parameterIndex,
String x)
|
|
void |
setTime(int parameterIndex,
Time x)
|
|
void |
setTime(int parameterIndex,
Time x,
Calendar cal)
|
|
void |
setTimestamp(int parameterIndex,
Timestamp x)
|
|
void |
setTimestamp(int parameterIndex,
Timestamp x,
Calendar cal)
|
|
void |
setUnicodeStream(int parameterIndex,
InputStream x,
int length)
Deprecated. |
|
void |
setURL(int parameterIndex,
URL x)
|
|
|
unwrap(Class<T> iface)
|
|
| Methods inherited from class java.lang.Object |
|---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
| Field Detail |
|---|
protected final List argTrace
protected PreparedStatement realPreparedStatement
protected net.sf.log4jdbc.RdbmsSpecifics rdbmsSpecifics
| Constructor Detail |
|---|
public PreparedStatementSpy(String sql,
ConnectionSpy connectionSpy,
PreparedStatement realPreparedStatement)
sql - SQL for the prepared statement that is being spied upon.connectionSpy - ConnectionSpy that was called to produce this PreparedStatement.realPreparedStatement - The actual PreparedStatement that is being spied upon.| Method Detail |
|---|
protected void argTraceSet(int i,
String typeHelper,
Object arg)
i - index of argument being set.typeHelper - optional additional info about the type that is being set in the argarg - argument being bound.protected String dumpedSql()
protected void reportAllReturns(String methodCall,
String msg)
StatementSpy
reportAllReturns in class StatementSpymethodCall - description of method call and arguments passed to it that returned.msg - description of what the return value that was returned. may be an empty String for void return types.public String getClassType()
Spy
getClassType in interface SpygetClassType in class StatementSpy
public void setTime(int parameterIndex,
Time x)
throws SQLException
setTime in interface PreparedStatementSQLException
public void setTime(int parameterIndex,
Time x,
Calendar cal)
throws SQLException
setTime in interface PreparedStatementSQLException
public void setCharacterStream(int parameterIndex,
Reader reader,
int length)
throws SQLException
setCharacterStream in interface PreparedStatementSQLException
public void setNull(int parameterIndex,
int sqlType)
throws SQLException
setNull in interface PreparedStatementSQLException
public void setNull(int paramIndex,
int sqlType,
String typeName)
throws SQLException
setNull in interface PreparedStatementSQLException
public void setRef(int i,
Ref x)
throws SQLException
setRef in interface PreparedStatementSQLException
public void setBoolean(int parameterIndex,
boolean x)
throws SQLException
setBoolean in interface PreparedStatementSQLException
public void setBlob(int i,
Blob x)
throws SQLException
setBlob in interface PreparedStatementSQLException
public void setClob(int i,
Clob x)
throws SQLException
setClob in interface PreparedStatementSQLException
public void setArray(int i,
Array x)
throws SQLException
setArray in interface PreparedStatementSQLException
public void setByte(int parameterIndex,
byte x)
throws SQLException
setByte in interface PreparedStatementSQLException
public void setUnicodeStream(int parameterIndex,
InputStream x,
int length)
throws SQLException
setUnicodeStream in interface PreparedStatementSQLException
public void setShort(int parameterIndex,
short x)
throws SQLException
setShort in interface PreparedStatementSQLException
public boolean execute()
throws SQLException
execute in interface PreparedStatementSQLException
public void setInt(int parameterIndex,
int x)
throws SQLException
setInt in interface PreparedStatementSQLException
public void setLong(int parameterIndex,
long x)
throws SQLException
setLong in interface PreparedStatementSQLException
public void setFloat(int parameterIndex,
float x)
throws SQLException
setFloat in interface PreparedStatementSQLException
public void setDouble(int parameterIndex,
double x)
throws SQLException
setDouble in interface PreparedStatementSQLException
public void setBigDecimal(int parameterIndex,
BigDecimal x)
throws SQLException
setBigDecimal in interface PreparedStatementSQLException
public void setURL(int parameterIndex,
URL x)
throws SQLException
setURL in interface PreparedStatementSQLException
public void setString(int parameterIndex,
String x)
throws SQLException
setString in interface PreparedStatementSQLException
public void setBytes(int parameterIndex,
byte[] x)
throws SQLException
setBytes in interface PreparedStatementSQLException
public void setDate(int parameterIndex,
Date x)
throws SQLException
setDate in interface PreparedStatementSQLException
public ParameterMetaData getParameterMetaData()
throws SQLException
getParameterMetaData in interface PreparedStatementSQLException
public void setRowId(int parameterIndex,
RowId x)
throws SQLException
setRowId in interface PreparedStatementSQLException
public void setNString(int parameterIndex,
String value)
throws SQLException
setNString in interface PreparedStatementSQLException
public void setNCharacterStream(int parameterIndex,
Reader value,
long length)
throws SQLException
setNCharacterStream in interface PreparedStatementSQLException
public void setNClob(int parameterIndex,
NClob value)
throws SQLException
setNClob in interface PreparedStatementSQLException
public void setClob(int parameterIndex,
Reader reader,
long length)
throws SQLException
setClob in interface PreparedStatementSQLException
public void setBlob(int parameterIndex,
InputStream inputStream,
long length)
throws SQLException
setBlob in interface PreparedStatementSQLException
public void setNClob(int parameterIndex,
Reader reader,
long length)
throws SQLException
setNClob in interface PreparedStatementSQLException
public void setSQLXML(int parameterIndex,
SQLXML xmlObject)
throws SQLException
setSQLXML in interface PreparedStatementSQLException
public void setDate(int parameterIndex,
Date x,
Calendar cal)
throws SQLException
setDate in interface PreparedStatementSQLException
public ResultSet executeQuery()
throws SQLException
executeQuery in interface PreparedStatementSQLException
public void setObject(int parameterIndex,
Object x,
int targetSqlType,
int scale)
throws SQLException
setObject in interface PreparedStatementSQLException
public void setAsciiStream(int parameterIndex,
InputStream x,
long length)
throws SQLException
LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.InputStream. Data will be read from the stream
as needed until end-of-file is reached. The JDBC driver will
do any necessary conversion from ASCII to the database char format.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
setAsciiStream in interface PreparedStatementSQLException - if parameterIndex does not correspond to a parameter
marker in the SQL statement; if a database access error occurs or
this method is called on a closed PreparedStatementparameterIndex - the first parameter is 1, the second is 2, ...x - the Java input stream that contains the ASCII parameter valuelength - the number of bytes in the stream
public void setBinaryStream(int parameterIndex,
InputStream x,
long length)
throws SQLException
setBinaryStream in interface PreparedStatementSQLException
public void setCharacterStream(int parameterIndex,
Reader reader,
long length)
throws SQLException
setCharacterStream in interface PreparedStatementSQLException
public void setAsciiStream(int parameterIndex,
InputStream x)
throws SQLException
setAsciiStream in interface PreparedStatementSQLException
public void setBinaryStream(int parameterIndex,
InputStream x)
throws SQLException
setBinaryStream in interface PreparedStatementSQLException
public void setCharacterStream(int parameterIndex,
Reader reader)
throws SQLException
setCharacterStream in interface PreparedStatementSQLException
public void setNCharacterStream(int parameterIndex,
Reader reader)
throws SQLException
setNCharacterStream in interface PreparedStatementSQLException
public void setClob(int parameterIndex,
Reader reader)
throws SQLException
setClob in interface PreparedStatementSQLException
public void setBlob(int parameterIndex,
InputStream inputStream)
throws SQLException
setBlob in interface PreparedStatementSQLException
public void setNClob(int parameterIndex,
Reader reader)
throws SQLException
setNClob in interface PreparedStatementSQLException
public void setObject(int parameterIndex,
Object x,
int targetSqlType)
throws SQLException
setObject in interface PreparedStatementSQLException
public void setObject(int parameterIndex,
Object x)
throws SQLException
setObject in interface PreparedStatementSQLException
public void setTimestamp(int parameterIndex,
Timestamp x)
throws SQLException
setTimestamp in interface PreparedStatementSQLException
public void setTimestamp(int parameterIndex,
Timestamp x,
Calendar cal)
throws SQLException
setTimestamp in interface PreparedStatementSQLException
public int executeUpdate()
throws SQLException
executeUpdate in interface PreparedStatementSQLException
public void setAsciiStream(int parameterIndex,
InputStream x,
int length)
throws SQLException
setAsciiStream in interface PreparedStatementSQLException
public void setBinaryStream(int parameterIndex,
InputStream x,
int length)
throws SQLException
setBinaryStream in interface PreparedStatementSQLException
public void clearParameters()
throws SQLException
clearParameters in interface PreparedStatementSQLException
public ResultSetMetaData getMetaData()
throws SQLException
getMetaData in interface PreparedStatementSQLException
public void addBatch()
throws SQLException
addBatch in interface PreparedStatementSQLException
public <T> T unwrap(Class<T> iface)
throws SQLException
unwrap in interface Wrapperunwrap in class StatementSpySQLException
public boolean isWrapperFor(Class<?> iface)
throws SQLException
isWrapperFor in interface WrapperisWrapperFor in class StatementSpySQLException
|
log4jdbc4 1.1 | ||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||