Package org.jivesoftware.database
Class CallableStatementWrapper
- java.lang.Object
-
- org.jivesoftware.database.StatementWrapper
-
- org.jivesoftware.database.CallableStatementWrapper
-
- All Implemented Interfaces:
AutoCloseable
,CallableStatement
,PreparedStatement
,Statement
,Wrapper
public abstract class CallableStatementWrapper extends StatementWrapper implements CallableStatement
An implementation of the CallableStatement interface that wraps an underlying CallableStatement object.- Author:
- Gaston Dombiak
-
-
Field Summary
Fields Modifier and Type Field Description protected CallableStatement
cstmt
-
Fields inherited from class org.jivesoftware.database.StatementWrapper
stmt
-
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
Constructors Constructor Description CallableStatementWrapper(CallableStatement cstmt)
-
Method Summary
All Methods Instance Methods Concrete Methods Deprecated Methods Modifier and Type Method Description void
addBatch()
void
addBatch(String sql)
void
cancel()
void
clearBatch()
void
clearParameters()
void
clearWarnings()
void
close()
boolean
execute()
boolean
execute(String sql)
boolean
execute(String sql, int autoGeneratedKeys)
boolean
execute(String sql, int[] columnIndexes)
boolean
execute(String sql, String[] columnNames)
int[]
executeBatch()
ResultSet
executeQuery()
ResultSet
executeQuery(String sql)
int
executeUpdate()
int
executeUpdate(String sql)
int
executeUpdate(String sql, int autoGeneratedKeys)
int
executeUpdate(String sql, int[] columnIndexes)
int
executeUpdate(String sql, String[] columnNames)
Array
getArray(int parameterIndex)
Array
getArray(String parameterName)
BigDecimal
getBigDecimal(int parameterIndex)
BigDecimal
getBigDecimal(int parameterIndex, int scale)
Deprecated.BigDecimal
getBigDecimal(String parameterName)
Blob
getBlob(int parameterIndex)
Blob
getBlob(String parameterName)
boolean
getBoolean(int parameterIndex)
boolean
getBoolean(String parameterName)
byte
getByte(int parameterIndex)
byte
getByte(String parameterName)
byte[]
getBytes(int parameterIndex)
byte[]
getBytes(String parameterName)
Reader
getCharacterStream(int parameterIndex)
Reader
getCharacterStream(String parameterName)
Clob
getClob(int parameterIndex)
Clob
getClob(String parameterName)
Connection
getConnection()
Date
getDate(int parameterIndex)
Date
getDate(int parameterIndex, Calendar cal)
Date
getDate(String parameterName)
Date
getDate(String parameterName, Calendar cal)
double
getDouble(int parameterIndex)
double
getDouble(String parameterName)
int
getFetchDirection()
int
getFetchSize()
float
getFloat(int parameterIndex)
float
getFloat(String parameterName)
ResultSet
getGeneratedKeys()
int
getInt(int parameterIndex)
int
getInt(String parameterName)
long
getLong(int parameterIndex)
long
getLong(String parameterName)
int
getMaxFieldSize()
int
getMaxRows()
ResultSetMetaData
getMetaData()
boolean
getMoreResults()
boolean
getMoreResults(int current)
Reader
getNCharacterStream(int parameterIndex)
Reader
getNCharacterStream(String parameterName)
NClob
getNClob(int parameterIndex)
NClob
getNClob(String parameterName)
String
getNString(int parameterIndex)
String
getNString(String parameterName)
Object
getObject(int parameterIndex)
<T> T
getObject(int parameterIndex, Class<T> type)
Object
getObject(int parameterIndex, Map<String,Class<?>> map)
Object
getObject(String parameterName)
<T> T
getObject(String parameterName, Class<T> type)
Object
getObject(String parameterName, Map<String,Class<?>> map)
ParameterMetaData
getParameterMetaData()
int
getQueryTimeout()
Ref
getRef(int parameterIndex)
Ref
getRef(String parameterName)
ResultSet
getResultSet()
int
getResultSetConcurrency()
int
getResultSetHoldability()
int
getResultSetType()
RowId
getRowId(int parameterIndex)
RowId
getRowId(String parameterName)
short
getShort(int parameterIndex)
short
getShort(String parameterName)
SQLXML
getSQLXML(int parameterIndex)
SQLXML
getSQLXML(String parameterName)
String
getString(int parameterIndex)
String
getString(String parameterName)
Time
getTime(int parameterIndex)
Time
getTime(int parameterIndex, Calendar cal)
Time
getTime(String parameterName)
Time
getTime(String parameterName, Calendar cal)
Timestamp
getTimestamp(int parameterIndex)
Timestamp
getTimestamp(int parameterIndex, Calendar cal)
Timestamp
getTimestamp(String parameterName)
Timestamp
getTimestamp(String parameterName, Calendar cal)
int
getUpdateCount()
URL
getURL(int parameterIndex)
URL
getURL(String parameterName)
SQLWarning
getWarnings()
boolean
isClosed()
boolean
isPoolable()
boolean
isWrapperFor(Class<?> iface)
void
registerOutParameter(int parameterIndex, int sqlType)
void
registerOutParameter(int parameterIndex, int sqlType, int scale)
void
registerOutParameter(int parameterIndex, int sqlType, String typeName)
void
registerOutParameter(String parameterName, int sqlType)
void
registerOutParameter(String parameterName, int sqlType, int scale)
void
registerOutParameter(String parameterName, int sqlType, String typeName)
void
setArray(int parameterIndex, Array x)
void
setAsciiStream(int parameterIndex, InputStream x)
void
setAsciiStream(int parameterIndex, InputStream x, int length)
void
setAsciiStream(int parameterIndex, InputStream x, long length)
void
setAsciiStream(String parameterName, InputStream x)
void
setAsciiStream(String parameterName, InputStream x, int length)
void
setAsciiStream(String parameterName, InputStream x, long length)
void
setBigDecimal(int parameterIndex, BigDecimal x)
void
setBigDecimal(String parameterName, 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
setBinaryStream(String parameterName, InputStream x)
void
setBinaryStream(String parameterName, InputStream x, int length)
void
setBinaryStream(String parameterName, InputStream x, long length)
void
setBlob(int parameterIndex, InputStream inputStream)
void
setBlob(int parameterIndex, InputStream inputStream, long length)
void
setBlob(int parameterIndex, Blob x)
void
setBlob(String parameterName, InputStream inputStream)
void
setBlob(String parameterName, InputStream inputStream, long length)
void
setBlob(String parameterName, Blob x)
void
setBoolean(int parameterIndex, boolean x)
void
setBoolean(String parameterName, boolean x)
void
setByte(int parameterIndex, byte x)
void
setByte(String parameterName, byte x)
void
setBytes(int parameterIndex, byte[] x)
void
setBytes(String parameterName, 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
setCharacterStream(String parameterName, Reader reader)
void
setCharacterStream(String parameterName, Reader reader, int length)
void
setCharacterStream(String parameterName, Reader reader, long length)
void
setClob(int parameterIndex, Reader reader)
void
setClob(int parameterIndex, Reader reader, long length)
void
setClob(int parameterIndex, Clob x)
void
setClob(String parameterName, Reader reader)
void
setClob(String parameterName, Reader reader, long length)
void
setClob(String parameterName, Clob x)
void
setCursorName(String name)
void
setDate(int parameterIndex, Date x)
void
setDate(int parameterIndex, Date x, Calendar cal)
void
setDate(String parameterName, Date x)
void
setDate(String parameterName, Date x, Calendar cal)
void
setDouble(int parameterIndex, double x)
void
setDouble(String parameterName, double x)
void
setEscapeProcessing(boolean enable)
void
setFetchDirection(int direction)
void
setFetchSize(int rows)
void
setFloat(int parameterIndex, float x)
void
setFloat(String parameterName, float x)
void
setInt(int parameterIndex, int x)
void
setInt(String parameterName, int x)
void
setLong(int parameterIndex, long x)
void
setLong(String parameterName, long x)
void
setMaxFieldSize(int max)
void
setMaxRows(int max)
void
setNCharacterStream(int parameterIndex, Reader value)
void
setNCharacterStream(int parameterIndex, Reader value, long length)
void
setNCharacterStream(String parameterName, Reader value)
void
setNCharacterStream(String parameterName, Reader value, long length)
void
setNClob(int parameterIndex, Reader reader)
void
setNClob(int parameterIndex, Reader reader, long length)
void
setNClob(int parameterIndex, NClob value)
void
setNClob(String parameterName, Reader reader)
void
setNClob(String parameterName, Reader reader, long length)
void
setNClob(String parameterName, NClob value)
void
setNString(int parameterIndex, String value)
void
setNString(String parameterName, String value)
void
setNull(int parameterIndex, int sqlType)
void
setNull(int parameterIndex, int sqlType, String typeName)
void
setNull(String parameterName, int sqlType)
void
setNull(String parameterName, 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 scaleOrLength)
void
setObject(String parameterName, Object x)
void
setObject(String parameterName, Object x, int targetSqlType)
void
setObject(String parameterName, Object x, int targetSqlType, int scale)
void
setPoolable(boolean poolable)
void
setQueryTimeout(int seconds)
void
setRef(int parameterIndex, Ref x)
void
setRowId(int parameterIndex, RowId x)
void
setRowId(String parameterName, RowId x)
void
setShort(int parameterIndex, short x)
void
setShort(String parameterName, short x)
void
setSQLXML(int parameterIndex, SQLXML xmlObject)
void
setSQLXML(String parameterName, SQLXML xmlObject)
void
setString(int parameterIndex, String x)
void
setString(String parameterName, String x)
void
setTime(int parameterIndex, Time x)
void
setTime(int parameterIndex, Time x, Calendar cal)
void
setTime(String parameterName, Time x)
void
setTime(String parameterName, Time x, Calendar cal)
void
setTimestamp(int parameterIndex, Timestamp x)
void
setTimestamp(int parameterIndex, Timestamp x, Calendar cal)
void
setTimestamp(String parameterName, Timestamp x)
void
setTimestamp(String parameterName, Timestamp x, Calendar cal)
void
setUnicodeStream(int parameterIndex, InputStream x, int length)
Deprecated.void
setURL(int parameterIndex, URL x)
void
setURL(String parameterName, URL val)
<T> T
unwrap(Class<T> iface)
boolean
wasNull()
-
Methods inherited from class org.jivesoftware.database.StatementWrapper
closeOnCompletion, isCloseOnCompletion
-
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
-
Methods inherited from interface java.sql.CallableStatement
registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, setObject, setObject
-
Methods inherited from interface java.sql.PreparedStatement
executeLargeUpdate, setObject, setObject
-
Methods inherited from interface java.sql.Statement
closeOnCompletion, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, getLargeMaxRows, getLargeUpdateCount, isCloseOnCompletion, isSimpleIdentifier, setLargeMaxRows
-
-
-
-
Field Detail
-
cstmt
protected CallableStatement cstmt
-
-
Constructor Detail
-
CallableStatementWrapper
public CallableStatementWrapper(CallableStatement cstmt)
-
-
Method Detail
-
executeQuery
public ResultSet executeQuery(String sql) throws SQLException
- Specified by:
executeQuery
in interfaceStatement
- Overrides:
executeQuery
in classStatementWrapper
- Throws:
SQLException
-
unwrap
public <T> T unwrap(Class<T> iface) throws SQLException
- Specified by:
unwrap
in interfaceWrapper
- Overrides:
unwrap
in classStatementWrapper
- Throws:
SQLException
-
executeQuery
public ResultSet executeQuery() throws SQLException
- Specified by:
executeQuery
in interfacePreparedStatement
- Throws:
SQLException
-
executeUpdate
public int executeUpdate(String sql) throws SQLException
- Specified by:
executeUpdate
in interfaceStatement
- Overrides:
executeUpdate
in classStatementWrapper
- Throws:
SQLException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, int sqlType) throws SQLException
- Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLException
-
isWrapperFor
public boolean isWrapperFor(Class<?> iface) throws SQLException
- Specified by:
isWrapperFor
in interfaceWrapper
- Overrides:
isWrapperFor
in classStatementWrapper
- Throws:
SQLException
-
executeUpdate
public int executeUpdate() throws SQLException
- Specified by:
executeUpdate
in interfacePreparedStatement
- Throws:
SQLException
-
close
public void close() throws SQLException
- Specified by:
close
in interfaceAutoCloseable
- Specified by:
close
in interfaceStatement
- Overrides:
close
in classStatementWrapper
- Throws:
SQLException
-
setNull
public void setNull(int parameterIndex, int sqlType) throws SQLException
- Specified by:
setNull
in interfacePreparedStatement
- Throws:
SQLException
-
getMaxFieldSize
public int getMaxFieldSize() throws SQLException
- Specified by:
getMaxFieldSize
in interfaceStatement
- Overrides:
getMaxFieldSize
in classStatementWrapper
- Throws:
SQLException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, int sqlType, int scale) throws SQLException
- Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLException
-
setBoolean
public void setBoolean(int parameterIndex, boolean x) throws SQLException
- Specified by:
setBoolean
in interfacePreparedStatement
- Throws:
SQLException
-
setMaxFieldSize
public void setMaxFieldSize(int max) throws SQLException
- Specified by:
setMaxFieldSize
in interfaceStatement
- Overrides:
setMaxFieldSize
in classStatementWrapper
- Throws:
SQLException
-
setByte
public void setByte(int parameterIndex, byte x) throws SQLException
- Specified by:
setByte
in interfacePreparedStatement
- Throws:
SQLException
-
setShort
public void setShort(int parameterIndex, short x) throws SQLException
- Specified by:
setShort
in interfacePreparedStatement
- Throws:
SQLException
-
getMaxRows
public int getMaxRows() throws SQLException
- Specified by:
getMaxRows
in interfaceStatement
- Overrides:
getMaxRows
in classStatementWrapper
- Throws:
SQLException
-
wasNull
public boolean wasNull() throws SQLException
- Specified by:
wasNull
in interfaceCallableStatement
- Throws:
SQLException
-
setInt
public void setInt(int parameterIndex, int x) throws SQLException
- Specified by:
setInt
in interfacePreparedStatement
- Throws:
SQLException
-
setMaxRows
public void setMaxRows(int max) throws SQLException
- Specified by:
setMaxRows
in interfaceStatement
- Overrides:
setMaxRows
in classStatementWrapper
- Throws:
SQLException
-
getString
public String getString(int parameterIndex) throws SQLException
- Specified by:
getString
in interfaceCallableStatement
- Throws:
SQLException
-
setLong
public void setLong(int parameterIndex, long x) throws SQLException
- Specified by:
setLong
in interfacePreparedStatement
- Throws:
SQLException
-
setEscapeProcessing
public void setEscapeProcessing(boolean enable) throws SQLException
- Specified by:
setEscapeProcessing
in interfaceStatement
- Overrides:
setEscapeProcessing
in classStatementWrapper
- Throws:
SQLException
-
getBoolean
public boolean getBoolean(int parameterIndex) throws SQLException
- Specified by:
getBoolean
in interfaceCallableStatement
- Throws:
SQLException
-
setFloat
public void setFloat(int parameterIndex, float x) throws SQLException
- Specified by:
setFloat
in interfacePreparedStatement
- Throws:
SQLException
-
getQueryTimeout
public int getQueryTimeout() throws SQLException
- Specified by:
getQueryTimeout
in interfaceStatement
- Overrides:
getQueryTimeout
in classStatementWrapper
- Throws:
SQLException
-
setDouble
public void setDouble(int parameterIndex, double x) throws SQLException
- Specified by:
setDouble
in interfacePreparedStatement
- Throws:
SQLException
-
getByte
public byte getByte(int parameterIndex) throws SQLException
- Specified by:
getByte
in interfaceCallableStatement
- Throws:
SQLException
-
setQueryTimeout
public void setQueryTimeout(int seconds) throws SQLException
- Specified by:
setQueryTimeout
in interfaceStatement
- Overrides:
setQueryTimeout
in classStatementWrapper
- Throws:
SQLException
-
setBigDecimal
public void setBigDecimal(int parameterIndex, BigDecimal x) throws SQLException
- Specified by:
setBigDecimal
in interfacePreparedStatement
- Throws:
SQLException
-
getShort
public short getShort(int parameterIndex) throws SQLException
- Specified by:
getShort
in interfaceCallableStatement
- Throws:
SQLException
-
cancel
public void cancel() throws SQLException
- Specified by:
cancel
in interfaceStatement
- Overrides:
cancel
in classStatementWrapper
- Throws:
SQLException
-
setString
public void setString(int parameterIndex, String x) throws SQLException
- Specified by:
setString
in interfacePreparedStatement
- Throws:
SQLException
-
getInt
public int getInt(int parameterIndex) throws SQLException
- Specified by:
getInt
in interfaceCallableStatement
- Throws:
SQLException
-
getWarnings
public SQLWarning getWarnings() throws SQLException
- Specified by:
getWarnings
in interfaceStatement
- Overrides:
getWarnings
in classStatementWrapper
- Throws:
SQLException
-
getLong
public long getLong(int parameterIndex) throws SQLException
- Specified by:
getLong
in interfaceCallableStatement
- Throws:
SQLException
-
setBytes
public void setBytes(int parameterIndex, byte[] x) throws SQLException
- Specified by:
setBytes
in interfacePreparedStatement
- Throws:
SQLException
-
getFloat
public float getFloat(int parameterIndex) throws SQLException
- Specified by:
getFloat
in interfaceCallableStatement
- Throws:
SQLException
-
clearWarnings
public void clearWarnings() throws SQLException
- Specified by:
clearWarnings
in interfaceStatement
- Overrides:
clearWarnings
in classStatementWrapper
- Throws:
SQLException
-
setDate
public void setDate(int parameterIndex, Date x) throws SQLException
- Specified by:
setDate
in interfacePreparedStatement
- Throws:
SQLException
-
setCursorName
public void setCursorName(String name) throws SQLException
- Specified by:
setCursorName
in interfaceStatement
- Overrides:
setCursorName
in classStatementWrapper
- Throws:
SQLException
-
getDouble
public double getDouble(int parameterIndex) throws SQLException
- Specified by:
getDouble
in interfaceCallableStatement
- Throws:
SQLException
-
setTime
public void setTime(int parameterIndex, Time x) throws SQLException
- Specified by:
setTime
in interfacePreparedStatement
- Throws:
SQLException
-
getBigDecimal
@Deprecated public BigDecimal getBigDecimal(int parameterIndex, int scale) throws SQLException
Deprecated.- Specified by:
getBigDecimal
in interfaceCallableStatement
- Throws:
SQLException
-
setTimestamp
public void setTimestamp(int parameterIndex, Timestamp x) throws SQLException
- Specified by:
setTimestamp
in interfacePreparedStatement
- Throws:
SQLException
-
execute
public boolean execute(String sql) throws SQLException
- Specified by:
execute
in interfaceStatement
- Overrides:
execute
in classStatementWrapper
- Throws:
SQLException
-
setAsciiStream
public void setAsciiStream(int parameterIndex, InputStream x, int length) throws SQLException
- Specified by:
setAsciiStream
in interfacePreparedStatement
- Throws:
SQLException
-
getBytes
public byte[] getBytes(int parameterIndex) throws SQLException
- Specified by:
getBytes
in interfaceCallableStatement
- Throws:
SQLException
-
getDate
public Date getDate(int parameterIndex) throws SQLException
- Specified by:
getDate
in interfaceCallableStatement
- Throws:
SQLException
-
getResultSet
public ResultSet getResultSet() throws SQLException
- Specified by:
getResultSet
in interfaceStatement
- Overrides:
getResultSet
in classStatementWrapper
- Throws:
SQLException
-
setUnicodeStream
@Deprecated public void setUnicodeStream(int parameterIndex, InputStream x, int length) throws SQLException
Deprecated.- Specified by:
setUnicodeStream
in interfacePreparedStatement
- Throws:
SQLException
-
getTime
public Time getTime(int parameterIndex) throws SQLException
- Specified by:
getTime
in interfaceCallableStatement
- Throws:
SQLException
-
getUpdateCount
public int getUpdateCount() throws SQLException
- Specified by:
getUpdateCount
in interfaceStatement
- Overrides:
getUpdateCount
in classStatementWrapper
- Throws:
SQLException
-
getTimestamp
public Timestamp getTimestamp(int parameterIndex) throws SQLException
- Specified by:
getTimestamp
in interfaceCallableStatement
- Throws:
SQLException
-
getMoreResults
public boolean getMoreResults() throws SQLException
- Specified by:
getMoreResults
in interfaceStatement
- Overrides:
getMoreResults
in classStatementWrapper
- Throws:
SQLException
-
setBinaryStream
public void setBinaryStream(int parameterIndex, InputStream x, int length) throws SQLException
- Specified by:
setBinaryStream
in interfacePreparedStatement
- Throws:
SQLException
-
getObject
public Object getObject(int parameterIndex) throws SQLException
- Specified by:
getObject
in interfaceCallableStatement
- Throws:
SQLException
-
setFetchDirection
public void setFetchDirection(int direction) throws SQLException
- Specified by:
setFetchDirection
in interfaceStatement
- Overrides:
setFetchDirection
in classStatementWrapper
- Throws:
SQLException
-
clearParameters
public void clearParameters() throws SQLException
- Specified by:
clearParameters
in interfacePreparedStatement
- Throws:
SQLException
-
getBigDecimal
public BigDecimal getBigDecimal(int parameterIndex) throws SQLException
- Specified by:
getBigDecimal
in interfaceCallableStatement
- Throws:
SQLException
-
getFetchDirection
public int getFetchDirection() throws SQLException
- Specified by:
getFetchDirection
in interfaceStatement
- Overrides:
getFetchDirection
in classStatementWrapper
- Throws:
SQLException
-
setObject
public void setObject(int parameterIndex, Object x, int targetSqlType) throws SQLException
- Specified by:
setObject
in interfacePreparedStatement
- Throws:
SQLException
-
getObject
public Object getObject(int parameterIndex, Map<String,Class<?>> map) throws SQLException
- Specified by:
getObject
in interfaceCallableStatement
- Throws:
SQLException
-
setFetchSize
public void setFetchSize(int rows) throws SQLException
- Specified by:
setFetchSize
in interfaceStatement
- Overrides:
setFetchSize
in classStatementWrapper
- Throws:
SQLException
-
getFetchSize
public int getFetchSize() throws SQLException
- Specified by:
getFetchSize
in interfaceStatement
- Overrides:
getFetchSize
in classStatementWrapper
- Throws:
SQLException
-
setObject
public void setObject(int parameterIndex, Object x) throws SQLException
- Specified by:
setObject
in interfacePreparedStatement
- Throws:
SQLException
-
getRef
public Ref getRef(int parameterIndex) throws SQLException
- Specified by:
getRef
in interfaceCallableStatement
- Throws:
SQLException
-
getResultSetConcurrency
public int getResultSetConcurrency() throws SQLException
- Specified by:
getResultSetConcurrency
in interfaceStatement
- Overrides:
getResultSetConcurrency
in classStatementWrapper
- Throws:
SQLException
-
getBlob
public Blob getBlob(int parameterIndex) throws SQLException
- Specified by:
getBlob
in interfaceCallableStatement
- Throws:
SQLException
-
getResultSetType
public int getResultSetType() throws SQLException
- Specified by:
getResultSetType
in interfaceStatement
- Overrides:
getResultSetType
in classStatementWrapper
- Throws:
SQLException
-
addBatch
public void addBatch(String sql) throws SQLException
- Specified by:
addBatch
in interfaceStatement
- Overrides:
addBatch
in classStatementWrapper
- Throws:
SQLException
-
getClob
public Clob getClob(int parameterIndex) throws SQLException
- Specified by:
getClob
in interfaceCallableStatement
- Throws:
SQLException
-
clearBatch
public void clearBatch() throws SQLException
- Specified by:
clearBatch
in interfaceStatement
- Overrides:
clearBatch
in classStatementWrapper
- Throws:
SQLException
-
execute
public boolean execute() throws SQLException
- Specified by:
execute
in interfacePreparedStatement
- Throws:
SQLException
-
getArray
public Array getArray(int parameterIndex) throws SQLException
- Specified by:
getArray
in interfaceCallableStatement
- Throws:
SQLException
-
executeBatch
public int[] executeBatch() throws SQLException
- Specified by:
executeBatch
in interfaceStatement
- Overrides:
executeBatch
in classStatementWrapper
- Throws:
SQLException
-
getDate
public Date getDate(int parameterIndex, Calendar cal) throws SQLException
- Specified by:
getDate
in interfaceCallableStatement
- Throws:
SQLException
-
addBatch
public void addBatch() throws SQLException
- Specified by:
addBatch
in interfacePreparedStatement
- Throws:
SQLException
-
setCharacterStream
public void setCharacterStream(int parameterIndex, Reader reader, int length) throws SQLException
- Specified by:
setCharacterStream
in interfacePreparedStatement
- Throws:
SQLException
-
getTime
public Time getTime(int parameterIndex, Calendar cal) throws SQLException
- Specified by:
getTime
in interfaceCallableStatement
- Throws:
SQLException
-
setRef
public void setRef(int parameterIndex, Ref x) throws SQLException
- Specified by:
setRef
in interfacePreparedStatement
- Throws:
SQLException
-
getConnection
public Connection getConnection() throws SQLException
- Specified by:
getConnection
in interfaceStatement
- Overrides:
getConnection
in classStatementWrapper
- Throws:
SQLException
-
getTimestamp
public Timestamp getTimestamp(int parameterIndex, Calendar cal) throws SQLException
- Specified by:
getTimestamp
in interfaceCallableStatement
- Throws:
SQLException
-
setBlob
public void setBlob(int parameterIndex, Blob x) throws SQLException
- Specified by:
setBlob
in interfacePreparedStatement
- Throws:
SQLException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, int sqlType, String typeName) throws SQLException
- Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLException
-
setClob
public void setClob(int parameterIndex, Clob x) throws SQLException
- Specified by:
setClob
in interfacePreparedStatement
- Throws:
SQLException
-
getMoreResults
public boolean getMoreResults(int current) throws SQLException
- Specified by:
getMoreResults
in interfaceStatement
- Overrides:
getMoreResults
in classStatementWrapper
- Throws:
SQLException
-
setArray
public void setArray(int parameterIndex, Array x) throws SQLException
- Specified by:
setArray
in interfacePreparedStatement
- Throws:
SQLException
-
getMetaData
public ResultSetMetaData getMetaData() throws SQLException
- Specified by:
getMetaData
in interfacePreparedStatement
- Throws:
SQLException
-
registerOutParameter
public void registerOutParameter(String parameterName, int sqlType) throws SQLException
- Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLException
-
getGeneratedKeys
public ResultSet getGeneratedKeys() throws SQLException
- Specified by:
getGeneratedKeys
in interfaceStatement
- Overrides:
getGeneratedKeys
in classStatementWrapper
- Throws:
SQLException
-
setDate
public void setDate(int parameterIndex, Date x, Calendar cal) throws SQLException
- Specified by:
setDate
in interfacePreparedStatement
- Throws:
SQLException
-
executeUpdate
public int executeUpdate(String sql, int autoGeneratedKeys) throws SQLException
- Specified by:
executeUpdate
in interfaceStatement
- Overrides:
executeUpdate
in classStatementWrapper
- Throws:
SQLException
-
setTime
public void setTime(int parameterIndex, Time x, Calendar cal) throws SQLException
- Specified by:
setTime
in interfacePreparedStatement
- Throws:
SQLException
-
registerOutParameter
public void registerOutParameter(String parameterName, int sqlType, int scale) throws SQLException
- Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLException
-
executeUpdate
public int executeUpdate(String sql, int[] columnIndexes) throws SQLException
- Specified by:
executeUpdate
in interfaceStatement
- Overrides:
executeUpdate
in classStatementWrapper
- Throws:
SQLException
-
setTimestamp
public void setTimestamp(int parameterIndex, Timestamp x, Calendar cal) throws SQLException
- Specified by:
setTimestamp
in interfacePreparedStatement
- Throws:
SQLException
-
registerOutParameter
public void registerOutParameter(String parameterName, int sqlType, String typeName) throws SQLException
- Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLException
-
setNull
public void setNull(int parameterIndex, int sqlType, String typeName) throws SQLException
- Specified by:
setNull
in interfacePreparedStatement
- Throws:
SQLException
-
executeUpdate
public int executeUpdate(String sql, String[] columnNames) throws SQLException
- Specified by:
executeUpdate
in interfaceStatement
- Overrides:
executeUpdate
in classStatementWrapper
- Throws:
SQLException
-
execute
public boolean execute(String sql, int autoGeneratedKeys) throws SQLException
- Specified by:
execute
in interfaceStatement
- Overrides:
execute
in classStatementWrapper
- Throws:
SQLException
-
getURL
public URL getURL(int parameterIndex) throws SQLException
- Specified by:
getURL
in interfaceCallableStatement
- Throws:
SQLException
-
setURL
public void setURL(int parameterIndex, URL x) throws SQLException
- Specified by:
setURL
in interfacePreparedStatement
- Throws:
SQLException
-
setURL
public void setURL(String parameterName, URL val) throws SQLException
- Specified by:
setURL
in interfaceCallableStatement
- Throws:
SQLException
-
getParameterMetaData
public ParameterMetaData getParameterMetaData() throws SQLException
- Specified by:
getParameterMetaData
in interfacePreparedStatement
- Throws:
SQLException
-
setNull
public void setNull(String parameterName, int sqlType) throws SQLException
- Specified by:
setNull
in interfaceCallableStatement
- Throws:
SQLException
-
setRowId
public void setRowId(int parameterIndex, RowId x) throws SQLException
- Specified by:
setRowId
in interfacePreparedStatement
- Throws:
SQLException
-
execute
public boolean execute(String sql, int[] columnIndexes) throws SQLException
- Specified by:
execute
in interfaceStatement
- Overrides:
execute
in classStatementWrapper
- Throws:
SQLException
-
setBoolean
public void setBoolean(String parameterName, boolean x) throws SQLException
- Specified by:
setBoolean
in interfaceCallableStatement
- Throws:
SQLException
-
setNString
public void setNString(int parameterIndex, String value) throws SQLException
- Specified by:
setNString
in interfacePreparedStatement
- Throws:
SQLException
-
setByte
public void setByte(String parameterName, byte x) throws SQLException
- Specified by:
setByte
in interfaceCallableStatement
- Throws:
SQLException
-
setNCharacterStream
public void setNCharacterStream(int parameterIndex, Reader value, long length) throws SQLException
- Specified by:
setNCharacterStream
in interfacePreparedStatement
- Throws:
SQLException
-
setShort
public void setShort(String parameterName, short x) throws SQLException
- Specified by:
setShort
in interfaceCallableStatement
- Throws:
SQLException
-
setInt
public void setInt(String parameterName, int x) throws SQLException
- Specified by:
setInt
in interfaceCallableStatement
- Throws:
SQLException
-
execute
public boolean execute(String sql, String[] columnNames) throws SQLException
- Specified by:
execute
in interfaceStatement
- Overrides:
execute
in classStatementWrapper
- Throws:
SQLException
-
setNClob
public void setNClob(int parameterIndex, NClob value) throws SQLException
- Specified by:
setNClob
in interfacePreparedStatement
- Throws:
SQLException
-
setLong
public void setLong(String parameterName, long x) throws SQLException
- Specified by:
setLong
in interfaceCallableStatement
- Throws:
SQLException
-
setClob
public void setClob(int parameterIndex, Reader reader, long length) throws SQLException
- Specified by:
setClob
in interfacePreparedStatement
- Throws:
SQLException
-
setFloat
public void setFloat(String parameterName, float x) throws SQLException
- Specified by:
setFloat
in interfaceCallableStatement
- Throws:
SQLException
-
setDouble
public void setDouble(String parameterName, double x) throws SQLException
- Specified by:
setDouble
in interfaceCallableStatement
- Throws:
SQLException
-
getResultSetHoldability
public int getResultSetHoldability() throws SQLException
- Specified by:
getResultSetHoldability
in interfaceStatement
- Overrides:
getResultSetHoldability
in classStatementWrapper
- Throws:
SQLException
-
setBlob
public void setBlob(int parameterIndex, InputStream inputStream, long length) throws SQLException
- Specified by:
setBlob
in interfacePreparedStatement
- Throws:
SQLException
-
isClosed
public boolean isClosed() throws SQLException
- Specified by:
isClosed
in interfaceStatement
- Overrides:
isClosed
in classStatementWrapper
- Throws:
SQLException
-
setBigDecimal
public void setBigDecimal(String parameterName, BigDecimal x) throws SQLException
- Specified by:
setBigDecimal
in interfaceCallableStatement
- Throws:
SQLException
-
setPoolable
public void setPoolable(boolean poolable) throws SQLException
- Specified by:
setPoolable
in interfaceStatement
- Overrides:
setPoolable
in classStatementWrapper
- Throws:
SQLException
-
setString
public void setString(String parameterName, String x) throws SQLException
- Specified by:
setString
in interfaceCallableStatement
- Throws:
SQLException
-
setNClob
public void setNClob(int parameterIndex, Reader reader, long length) throws SQLException
- Specified by:
setNClob
in interfacePreparedStatement
- Throws:
SQLException
-
isPoolable
public boolean isPoolable() throws SQLException
- Specified by:
isPoolable
in interfaceStatement
- Overrides:
isPoolable
in classStatementWrapper
- Throws:
SQLException
-
setBytes
public void setBytes(String parameterName, byte[] x) throws SQLException
- Specified by:
setBytes
in interfaceCallableStatement
- Throws:
SQLException
-
setDate
public void setDate(String parameterName, Date x) throws SQLException
- Specified by:
setDate
in interfaceCallableStatement
- Throws:
SQLException
-
setSQLXML
public void setSQLXML(int parameterIndex, SQLXML xmlObject) throws SQLException
- Specified by:
setSQLXML
in interfacePreparedStatement
- Throws:
SQLException
-
setTime
public void setTime(String parameterName, Time x) throws SQLException
- Specified by:
setTime
in interfaceCallableStatement
- Throws:
SQLException
-
setObject
public void setObject(int parameterIndex, Object x, int targetSqlType, int scaleOrLength) throws SQLException
- Specified by:
setObject
in interfacePreparedStatement
- Throws:
SQLException
-
setTimestamp
public void setTimestamp(String parameterName, Timestamp x) throws SQLException
- Specified by:
setTimestamp
in interfaceCallableStatement
- Throws:
SQLException
-
setAsciiStream
public void setAsciiStream(String parameterName, InputStream x, int length) throws SQLException
- Specified by:
setAsciiStream
in interfaceCallableStatement
- Throws:
SQLException
-
setBinaryStream
public void setBinaryStream(String parameterName, InputStream x, int length) throws SQLException
- Specified by:
setBinaryStream
in interfaceCallableStatement
- Throws:
SQLException
-
setAsciiStream
public void setAsciiStream(int parameterIndex, InputStream x, long length) throws SQLException
- Specified by:
setAsciiStream
in interfacePreparedStatement
- Throws:
SQLException
-
setObject
public void setObject(String parameterName, Object x, int targetSqlType, int scale) throws SQLException
- Specified by:
setObject
in interfaceCallableStatement
- Throws:
SQLException
-
setBinaryStream
public void setBinaryStream(int parameterIndex, InputStream x, long length) throws SQLException
- Specified by:
setBinaryStream
in interfacePreparedStatement
- Throws:
SQLException
-
setCharacterStream
public void setCharacterStream(int parameterIndex, Reader reader, long length) throws SQLException
- Specified by:
setCharacterStream
in interfacePreparedStatement
- Throws:
SQLException
-
setObject
public void setObject(String parameterName, Object x, int targetSqlType) throws SQLException
- Specified by:
setObject
in interfaceCallableStatement
- Throws:
SQLException
-
setAsciiStream
public void setAsciiStream(int parameterIndex, InputStream x) throws SQLException
- Specified by:
setAsciiStream
in interfacePreparedStatement
- Throws:
SQLException
-
setObject
public void setObject(String parameterName, Object x) throws SQLException
- Specified by:
setObject
in interfaceCallableStatement
- Throws:
SQLException
-
setBinaryStream
public void setBinaryStream(int parameterIndex, InputStream x) throws SQLException
- Specified by:
setBinaryStream
in interfacePreparedStatement
- Throws:
SQLException
-
setCharacterStream
public void setCharacterStream(String parameterName, Reader reader, int length) throws SQLException
- Specified by:
setCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
setCharacterStream
public void setCharacterStream(int parameterIndex, Reader reader) throws SQLException
- Specified by:
setCharacterStream
in interfacePreparedStatement
- Throws:
SQLException
-
setDate
public void setDate(String parameterName, Date x, Calendar cal) throws SQLException
- Specified by:
setDate
in interfaceCallableStatement
- Throws:
SQLException
-
setNCharacterStream
public void setNCharacterStream(int parameterIndex, Reader value) throws SQLException
- Specified by:
setNCharacterStream
in interfacePreparedStatement
- Throws:
SQLException
-
setTime
public void setTime(String parameterName, Time x, Calendar cal) throws SQLException
- Specified by:
setTime
in interfaceCallableStatement
- Throws:
SQLException
-
setClob
public void setClob(int parameterIndex, Reader reader) throws SQLException
- Specified by:
setClob
in interfacePreparedStatement
- Throws:
SQLException
-
setTimestamp
public void setTimestamp(String parameterName, Timestamp x, Calendar cal) throws SQLException
- Specified by:
setTimestamp
in interfaceCallableStatement
- Throws:
SQLException
-
setBlob
public void setBlob(int parameterIndex, InputStream inputStream) throws SQLException
- Specified by:
setBlob
in interfacePreparedStatement
- Throws:
SQLException
-
setNull
public void setNull(String parameterName, int sqlType, String typeName) throws SQLException
- Specified by:
setNull
in interfaceCallableStatement
- Throws:
SQLException
-
setNClob
public void setNClob(int parameterIndex, Reader reader) throws SQLException
- Specified by:
setNClob
in interfacePreparedStatement
- Throws:
SQLException
-
getString
public String getString(String parameterName) throws SQLException
- Specified by:
getString
in interfaceCallableStatement
- Throws:
SQLException
-
getBoolean
public boolean getBoolean(String parameterName) throws SQLException
- Specified by:
getBoolean
in interfaceCallableStatement
- Throws:
SQLException
-
getByte
public byte getByte(String parameterName) throws SQLException
- Specified by:
getByte
in interfaceCallableStatement
- Throws:
SQLException
-
getShort
public short getShort(String parameterName) throws SQLException
- Specified by:
getShort
in interfaceCallableStatement
- Throws:
SQLException
-
getInt
public int getInt(String parameterName) throws SQLException
- Specified by:
getInt
in interfaceCallableStatement
- Throws:
SQLException
-
getLong
public long getLong(String parameterName) throws SQLException
- Specified by:
getLong
in interfaceCallableStatement
- Throws:
SQLException
-
getFloat
public float getFloat(String parameterName) throws SQLException
- Specified by:
getFloat
in interfaceCallableStatement
- Throws:
SQLException
-
getDouble
public double getDouble(String parameterName) throws SQLException
- Specified by:
getDouble
in interfaceCallableStatement
- Throws:
SQLException
-
getBytes
public byte[] getBytes(String parameterName) throws SQLException
- Specified by:
getBytes
in interfaceCallableStatement
- Throws:
SQLException
-
getDate
public Date getDate(String parameterName) throws SQLException
- Specified by:
getDate
in interfaceCallableStatement
- Throws:
SQLException
-
getTime
public Time getTime(String parameterName) throws SQLException
- Specified by:
getTime
in interfaceCallableStatement
- Throws:
SQLException
-
getTimestamp
public Timestamp getTimestamp(String parameterName) throws SQLException
- Specified by:
getTimestamp
in interfaceCallableStatement
- Throws:
SQLException
-
getObject
public Object getObject(String parameterName) throws SQLException
- Specified by:
getObject
in interfaceCallableStatement
- Throws:
SQLException
-
getBigDecimal
public BigDecimal getBigDecimal(String parameterName) throws SQLException
- Specified by:
getBigDecimal
in interfaceCallableStatement
- Throws:
SQLException
-
getObject
public Object getObject(String parameterName, Map<String,Class<?>> map) throws SQLException
- Specified by:
getObject
in interfaceCallableStatement
- Throws:
SQLException
-
getRef
public Ref getRef(String parameterName) throws SQLException
- Specified by:
getRef
in interfaceCallableStatement
- Throws:
SQLException
-
getBlob
public Blob getBlob(String parameterName) throws SQLException
- Specified by:
getBlob
in interfaceCallableStatement
- Throws:
SQLException
-
getClob
public Clob getClob(String parameterName) throws SQLException
- Specified by:
getClob
in interfaceCallableStatement
- Throws:
SQLException
-
getArray
public Array getArray(String parameterName) throws SQLException
- Specified by:
getArray
in interfaceCallableStatement
- Throws:
SQLException
-
getDate
public Date getDate(String parameterName, Calendar cal) throws SQLException
- Specified by:
getDate
in interfaceCallableStatement
- Throws:
SQLException
-
getTime
public Time getTime(String parameterName, Calendar cal) throws SQLException
- Specified by:
getTime
in interfaceCallableStatement
- Throws:
SQLException
-
getTimestamp
public Timestamp getTimestamp(String parameterName, Calendar cal) throws SQLException
- Specified by:
getTimestamp
in interfaceCallableStatement
- Throws:
SQLException
-
getURL
public URL getURL(String parameterName) throws SQLException
- Specified by:
getURL
in interfaceCallableStatement
- Throws:
SQLException
-
getRowId
public RowId getRowId(int parameterIndex) throws SQLException
- Specified by:
getRowId
in interfaceCallableStatement
- Throws:
SQLException
-
getRowId
public RowId getRowId(String parameterName) throws SQLException
- Specified by:
getRowId
in interfaceCallableStatement
- Throws:
SQLException
-
setRowId
public void setRowId(String parameterName, RowId x) throws SQLException
- Specified by:
setRowId
in interfaceCallableStatement
- Throws:
SQLException
-
setNString
public void setNString(String parameterName, String value) throws SQLException
- Specified by:
setNString
in interfaceCallableStatement
- Throws:
SQLException
-
setNCharacterStream
public void setNCharacterStream(String parameterName, Reader value, long length) throws SQLException
- Specified by:
setNCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
setNClob
public void setNClob(String parameterName, NClob value) throws SQLException
- Specified by:
setNClob
in interfaceCallableStatement
- Throws:
SQLException
-
setClob
public void setClob(String parameterName, Reader reader, long length) throws SQLException
- Specified by:
setClob
in interfaceCallableStatement
- Throws:
SQLException
-
setBlob
public void setBlob(String parameterName, InputStream inputStream, long length) throws SQLException
- Specified by:
setBlob
in interfaceCallableStatement
- Throws:
SQLException
-
setNClob
public void setNClob(String parameterName, Reader reader, long length) throws SQLException
- Specified by:
setNClob
in interfaceCallableStatement
- Throws:
SQLException
-
getNClob
public NClob getNClob(int parameterIndex) throws SQLException
- Specified by:
getNClob
in interfaceCallableStatement
- Throws:
SQLException
-
getNClob
public NClob getNClob(String parameterName) throws SQLException
- Specified by:
getNClob
in interfaceCallableStatement
- Throws:
SQLException
-
setSQLXML
public void setSQLXML(String parameterName, SQLXML xmlObject) throws SQLException
- Specified by:
setSQLXML
in interfaceCallableStatement
- Throws:
SQLException
-
getSQLXML
public SQLXML getSQLXML(int parameterIndex) throws SQLException
- Specified by:
getSQLXML
in interfaceCallableStatement
- Throws:
SQLException
-
getSQLXML
public SQLXML getSQLXML(String parameterName) throws SQLException
- Specified by:
getSQLXML
in interfaceCallableStatement
- Throws:
SQLException
-
getNString
public String getNString(int parameterIndex) throws SQLException
- Specified by:
getNString
in interfaceCallableStatement
- Throws:
SQLException
-
getNString
public String getNString(String parameterName) throws SQLException
- Specified by:
getNString
in interfaceCallableStatement
- Throws:
SQLException
-
getNCharacterStream
public Reader getNCharacterStream(int parameterIndex) throws SQLException
- Specified by:
getNCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
getNCharacterStream
public Reader getNCharacterStream(String parameterName) throws SQLException
- Specified by:
getNCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
getCharacterStream
public Reader getCharacterStream(int parameterIndex) throws SQLException
- Specified by:
getCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
getCharacterStream
public Reader getCharacterStream(String parameterName) throws SQLException
- Specified by:
getCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
setBlob
public void setBlob(String parameterName, Blob x) throws SQLException
- Specified by:
setBlob
in interfaceCallableStatement
- Throws:
SQLException
-
setClob
public void setClob(String parameterName, Clob x) throws SQLException
- Specified by:
setClob
in interfaceCallableStatement
- Throws:
SQLException
-
setAsciiStream
public void setAsciiStream(String parameterName, InputStream x, long length) throws SQLException
- Specified by:
setAsciiStream
in interfaceCallableStatement
- Throws:
SQLException
-
setBinaryStream
public void setBinaryStream(String parameterName, InputStream x, long length) throws SQLException
- Specified by:
setBinaryStream
in interfaceCallableStatement
- Throws:
SQLException
-
setCharacterStream
public void setCharacterStream(String parameterName, Reader reader, long length) throws SQLException
- Specified by:
setCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
setAsciiStream
public void setAsciiStream(String parameterName, InputStream x) throws SQLException
- Specified by:
setAsciiStream
in interfaceCallableStatement
- Throws:
SQLException
-
setBinaryStream
public void setBinaryStream(String parameterName, InputStream x) throws SQLException
- Specified by:
setBinaryStream
in interfaceCallableStatement
- Throws:
SQLException
-
setCharacterStream
public void setCharacterStream(String parameterName, Reader reader) throws SQLException
- Specified by:
setCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
setNCharacterStream
public void setNCharacterStream(String parameterName, Reader value) throws SQLException
- Specified by:
setNCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
setClob
public void setClob(String parameterName, Reader reader) throws SQLException
- Specified by:
setClob
in interfaceCallableStatement
- Throws:
SQLException
-
setBlob
public void setBlob(String parameterName, InputStream inputStream) throws SQLException
- Specified by:
setBlob
in interfaceCallableStatement
- Throws:
SQLException
-
setNClob
public void setNClob(String parameterName, Reader reader) throws SQLException
- Specified by:
setNClob
in interfaceCallableStatement
- Throws:
SQLException
-
getObject
public <T> T getObject(int parameterIndex, Class<T> type) throws SQLException
- Specified by:
getObject
in interfaceCallableStatement
- Throws:
SQLException
-
getObject
public <T> T getObject(String parameterName, Class<T> type) throws SQLException
- Specified by:
getObject
in interfaceCallableStatement
- Throws:
SQLException
-
-