Package org.apache.derby.vti
Class UpdatableVTITemplate
java.lang.Object
org.apache.derby.vti.UpdatableVTITemplate
- All Implemented Interfaces:
AutoCloseable
,PreparedStatement
,Statement
,Wrapper
- Direct Known Subclasses:
TriggerNewTransitionRows
,TriggerOldTransitionRows
An abstract implementation of PreparedStatement (JDBC 3.0) that is useful
when writing a read-write (updatable) virtual table interface (VTI).
This class implements
the methods of the JDBC3.0 version of PreparedStatement
each one throwing a SQLException
with the name of the method. A concrete subclass can then just implement
the methods not implemented here and override any methods it needs
to implement for correct functionality.
-
Field Summary
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 -
Method Summary
Modifier and TypeMethodDescriptionvoid
addBatch()
void
void
cancel()
void
void
void
void
close()
void
boolean
execute()
boolean
boolean
boolean
boolean
int[]
executeQuery
(String sql) int
int
executeUpdate
(String sql) int
executeUpdate
(String arg0, int arg1) int
executeUpdate
(String arg0, int[] arg1) int
executeUpdate
(String arg0, String[] arg1) int
int
int
int
boolean
boolean
getMoreResults
(int arg0) int
int
int
int
int
boolean
isClosed()
boolean
boolean
boolean
isWrapperFor
(Class<?> iface) void
void
setAsciiStream
(int parameterIndex, InputStream x) void
setAsciiStream
(int parameterIndex, InputStream x, int length) void
setAsciiStream
(int parameterIndex, InputStream x, long length) 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 parameterIndex, InputStream is) void
setBlob
(int parameterIndex, InputStream is, long length) void
void
setBoolean
(int parameterIndex, boolean x) void
setByte
(int parameterIndex, byte x) void
setBytes
(int parameterIndex, byte[] x) void
setCharacterStream
(int parameterIndex, Reader value) void
setCharacterStream
(int parameterIndex, Reader reader, int length) void
setCharacterStream
(int parameterIndex, Reader value, long length) void
void
void
void
setCursorName
(String name) void
void
void
setDouble
(int parameterIndex, double x) void
setEscapeProcessing
(boolean enable) void
setFetchDirection
(int direction) void
setFetchSize
(int rows) void
setFloat
(int parameterIndex, float x) void
setInt
(int parameterIndex, int x) void
setLong
(int parameterIndex, 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
void
void
void
setNString
(int parameterIndex, String value) void
setNull
(int parameterIndex, int jdbcType) void
void
void
void
void
setPoolable
(boolean poolable) void
setQueryTimeout
(int seconds) void
void
void
setShort
(int parameterIndex, short x) void
void
void
void
void
setTimestamp
(int parameterIndex, Timestamp x) void
setTimestamp
(int parameterIndex, Timestamp x, Calendar cal) void
setUnicodeStream
(int parameterIndex, InputStream x, int length) Deprecated.void
<T> T
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
executeLargeUpdate, setObject, setObject
Methods inherited from interface java.sql.Statement
enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, getLargeMaxRows, getLargeUpdateCount, isSimpleIdentifier, setLargeMaxRows
-
Constructor Details
-
UpdatableVTITemplate
protected UpdatableVTITemplate()
-
-
Method Details
-
executeQuery
- Specified by:
executeQuery
in interfaceStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
executeUpdate
- Specified by:
executeUpdate
in interfaceStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
close
- Specified by:
close
in interfaceAutoCloseable
- Specified by:
close
in interfaceStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
getWarnings
- Specified by:
getWarnings
in interfaceStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
clearWarnings
- Specified by:
clearWarnings
in interfaceStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
getMaxFieldSize
- Specified by:
getMaxFieldSize
in interfaceStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
setMaxFieldSize
- Specified by:
setMaxFieldSize
in interfaceStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
getMaxRows
- Specified by:
getMaxRows
in interfaceStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
setMaxRows
- Specified by:
setMaxRows
in interfaceStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
setEscapeProcessing
- Specified by:
setEscapeProcessing
in interfaceStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
getQueryTimeout
- Specified by:
getQueryTimeout
in interfaceStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
setQueryTimeout
- Specified by:
setQueryTimeout
in interfaceStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
addBatch
- Specified by:
addBatch
in interfaceStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
clearBatch
- Specified by:
clearBatch
in interfaceStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
executeBatch
- Specified by:
executeBatch
in interfaceStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
cancel
- Specified by:
cancel
in interfaceStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
setCursorName
- Specified by:
setCursorName
in interfaceStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
execute
- Specified by:
execute
in interfaceStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
getResultSet
- Specified by:
getResultSet
in interfaceStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
getUpdateCount
- Specified by:
getUpdateCount
in interfaceStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
getMoreResults
- Specified by:
getMoreResults
in interfaceStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
getResultSetConcurrency
- Specified by:
getResultSetConcurrency
in interfaceStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
executeQuery
- Specified by:
executeQuery
in interfacePreparedStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
executeUpdate
- Specified by:
executeUpdate
in interfacePreparedStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
setNull
- Specified by:
setNull
in interfacePreparedStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
setNull
- Specified by:
setNull
in interfacePreparedStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
setBoolean
- Specified by:
setBoolean
in interfacePreparedStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
setByte
- Specified by:
setByte
in interfacePreparedStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
setShort
- Specified by:
setShort
in interfacePreparedStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
setInt
- Specified by:
setInt
in interfacePreparedStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
setLong
- Specified by:
setLong
in interfacePreparedStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
setFloat
- Specified by:
setFloat
in interfacePreparedStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
setDouble
- Specified by:
setDouble
in interfacePreparedStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
setBigDecimal
- Specified by:
setBigDecimal
in interfacePreparedStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
setString
- Specified by:
setString
in interfacePreparedStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
setBytes
- Specified by:
setBytes
in interfacePreparedStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
setDate
- Specified by:
setDate
in interfacePreparedStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
setTime
- Specified by:
setTime
in interfacePreparedStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
setTimestamp
- Specified by:
setTimestamp
in interfacePreparedStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
setAsciiStream
- Specified by:
setAsciiStream
in interfacePreparedStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
setUnicodeStream
Deprecated.- Specified by:
setUnicodeStream
in interfacePreparedStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
setBinaryStream
- Specified by:
setBinaryStream
in interfacePreparedStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
clearParameters
- Specified by:
clearParameters
in interfacePreparedStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
setObject
public void setObject(int parameterIndex, Object x, int targetJdbcType, int scale) throws SQLException - Specified by:
setObject
in interfacePreparedStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
setObject
- Specified by:
setObject
in interfacePreparedStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
setObject
- Specified by:
setObject
in interfacePreparedStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
execute
- Specified by:
execute
in interfacePreparedStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
getMetaData
- Specified by:
getMetaData
in interfacePreparedStatement
- Throws:
SQLException
- on unexpected JDBC error- See Also:
-
getResultSetType
- Specified by:
getResultSetType
in interfaceStatement
- Throws:
SQLException
- Always thrown- See Also:
-
setBlob
- Specified by:
setBlob
in interfacePreparedStatement
- Throws:
SQLException
- Always thrown- See Also:
-
setFetchDirection
- Specified by:
setFetchDirection
in interfaceStatement
- Throws:
SQLException
- Always thrown- See Also:
-
setFetchSize
- Specified by:
setFetchSize
in interfaceStatement
- Throws:
SQLException
- Always thrown- See Also:
-
addBatch
- Specified by:
addBatch
in interfacePreparedStatement
- Throws:
SQLException
- Always thrown- See Also:
-
setCharacterStream
- Specified by:
setCharacterStream
in interfacePreparedStatement
- Throws:
SQLException
- Always thrown- See Also:
-
getConnection
- Specified by:
getConnection
in interfaceStatement
- Throws:
SQLException
- Always thrown- See Also:
-
getFetchDirection
- Specified by:
getFetchDirection
in interfaceStatement
- Throws:
SQLException
- Always thrown- See Also:
-
setTime
- Specified by:
setTime
in interfacePreparedStatement
- Throws:
SQLException
- Always thrown- See Also:
-
setTimestamp
- Specified by:
setTimestamp
in interfacePreparedStatement
- Throws:
SQLException
- Always thrown- See Also:
-
getFetchSize
- Specified by:
getFetchSize
in interfaceStatement
- Throws:
SQLException
- Always thrown- See Also:
-
setRef
- Specified by:
setRef
in interfacePreparedStatement
- Throws:
SQLException
- Always thrown- See Also:
-
setDate
- Specified by:
setDate
in interfacePreparedStatement
- Throws:
SQLException
- Always thrown- See Also:
-
setClob
- Specified by:
setClob
in interfacePreparedStatement
- Throws:
SQLException
- Always thrown- See Also:
-
setArray
- Specified by:
setArray
in interfacePreparedStatement
- Throws:
SQLException
- Always thrown- See Also:
-
setURL
- Specified by:
setURL
in interfacePreparedStatement
- Throws:
SQLException
-
getMoreResults
- Specified by:
getMoreResults
in interfaceStatement
- Throws:
SQLException
-
getGeneratedKeys
- Specified by:
getGeneratedKeys
in interfaceStatement
- Throws:
SQLException
-
executeUpdate
- Specified by:
executeUpdate
in interfaceStatement
- Throws:
SQLException
-
executeUpdate
- Specified by:
executeUpdate
in interfaceStatement
- Throws:
SQLException
-
executeUpdate
- Specified by:
executeUpdate
in interfaceStatement
- Throws:
SQLException
-
execute
- Specified by:
execute
in interfaceStatement
- Throws:
SQLException
-
execute
- Specified by:
execute
in interfaceStatement
- Throws:
SQLException
-
execute
- Specified by:
execute
in interfaceStatement
- Throws:
SQLException
-
getResultSetHoldability
- Specified by:
getResultSetHoldability
in interfaceStatement
- Throws:
SQLException
-
getParameterMetaData
- Specified by:
getParameterMetaData
in interfacePreparedStatement
- Throws:
SQLException
-
isWrapperFor
- Specified by:
isWrapperFor
in interfaceWrapper
- Throws:
SQLException
-
unwrap
- Specified by:
unwrap
in interfaceWrapper
- Throws:
SQLException
-
isClosed
- Specified by:
isClosed
in interfaceStatement
- Throws:
SQLException
-
isPoolable
- Specified by:
isPoolable
in interfaceStatement
- Throws:
SQLException
-
setPoolable
- Specified by:
setPoolable
in interfaceStatement
- Throws:
SQLException
-
setAsciiStream
- Specified by:
setAsciiStream
in interfacePreparedStatement
- Throws:
SQLException
-
setAsciiStream
- Specified by:
setAsciiStream
in interfacePreparedStatement
- Throws:
SQLException
-
setBinaryStream
- Specified by:
setBinaryStream
in interfacePreparedStatement
- Throws:
SQLException
-
setBinaryStream
- Specified by:
setBinaryStream
in interfacePreparedStatement
- Throws:
SQLException
-
setBlob
- Specified by:
setBlob
in interfacePreparedStatement
- Throws:
SQLException
-
setBlob
- Specified by:
setBlob
in interfacePreparedStatement
- Throws:
SQLException
-
setClob
- Specified by:
setClob
in interfacePreparedStatement
- Throws:
SQLException
-
setClob
- Specified by:
setClob
in interfacePreparedStatement
- Throws:
SQLException
-
setCharacterStream
- Specified by:
setCharacterStream
in interfacePreparedStatement
- Throws:
SQLException
-
setCharacterStream
- Specified by:
setCharacterStream
in interfacePreparedStatement
- Throws:
SQLException
-
setNCharacterStream
- Specified by:
setNCharacterStream
in interfacePreparedStatement
- Throws:
SQLException
-
setNCharacterStream
- Specified by:
setNCharacterStream
in interfacePreparedStatement
- Throws:
SQLException
-
setNClob
- Specified by:
setNClob
in interfacePreparedStatement
- Throws:
SQLException
-
setNClob
- Specified by:
setNClob
in interfacePreparedStatement
- Throws:
SQLException
-
setNClob
- Specified by:
setNClob
in interfacePreparedStatement
- Throws:
SQLException
-
setNString
- Specified by:
setNString
in interfacePreparedStatement
- Throws:
SQLException
-
setRowId
- Specified by:
setRowId
in interfacePreparedStatement
- Throws:
SQLException
-
setSQLXML
- Specified by:
setSQLXML
in interfacePreparedStatement
- Throws:
SQLException
-
isCloseOnCompletion
- Specified by:
isCloseOnCompletion
in interfaceStatement
- Throws:
SQLException
-
closeOnCompletion
- Specified by:
closeOnCompletion
in interfaceStatement
- Throws:
SQLException
-