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 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 TypeMethodDescriptionvoidaddBatch()voidvoidcancel()voidvoidvoidvoidclose()voidbooleanexecute()booleanbooleanbooleanbooleanint[]executeQuery(String sql) intintexecuteUpdate(String sql) intexecuteUpdate(String arg0, int arg1) intexecuteUpdate(String arg0, int[] arg1) intexecuteUpdate(String arg0, String[] arg1) intintintintbooleanbooleangetMoreResults(int arg0) intintintintintbooleanisClosed()booleanbooleanbooleanisWrapperFor(Class<?> iface) voidvoidsetAsciiStream(int parameterIndex, InputStream x) voidsetAsciiStream(int parameterIndex, InputStream x, int length) voidsetAsciiStream(int parameterIndex, InputStream x, long length) voidsetBigDecimal(int parameterIndex, BigDecimal x) voidsetBinaryStream(int parameterIndex, InputStream x) voidsetBinaryStream(int parameterIndex, InputStream x, int length) voidsetBinaryStream(int parameterIndex, InputStream x, long length) voidsetBlob(int parameterIndex, InputStream is) voidsetBlob(int parameterIndex, InputStream is, long length) voidvoidsetBoolean(int parameterIndex, boolean x) voidsetByte(int parameterIndex, byte x) voidsetBytes(int parameterIndex, byte[] x) voidsetCharacterStream(int parameterIndex, Reader value) voidsetCharacterStream(int parameterIndex, Reader reader, int length) voidsetCharacterStream(int parameterIndex, Reader value, long length) voidvoidvoidvoidsetCursorName(String name) voidvoidvoidsetDouble(int parameterIndex, double x) voidsetEscapeProcessing(boolean enable) voidsetFetchDirection(int direction) voidsetFetchSize(int rows) voidsetFloat(int parameterIndex, float x) voidsetInt(int parameterIndex, int x) voidsetLong(int parameterIndex, long x) voidsetMaxFieldSize(int max) voidsetMaxRows(int max) voidsetNCharacterStream(int parameterIndex, Reader value) voidsetNCharacterStream(int parameterIndex, Reader value, long length) voidvoidvoidvoidsetNString(int parameterIndex, String value) voidsetNull(int parameterIndex, int jdbcType) voidvoidvoidvoidvoidsetPoolable(boolean poolable) voidsetQueryTimeout(int seconds) voidvoidvoidsetShort(int parameterIndex, short x) voidvoidvoidvoidvoidsetTimestamp(int parameterIndex, Timestamp x) voidsetTimestamp(int parameterIndex, Timestamp x, Calendar cal) voidsetUnicodeStream(int parameterIndex, InputStream x, int length) Deprecated.void<T> TMethods inherited from class Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, waitMethods inherited from interface PreparedStatement
executeLargeUpdate, setObject, setObjectMethods inherited from interface Statement
enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, getLargeMaxRows, getLargeUpdateCount, isSimpleIdentifier, setLargeMaxRows
-
Constructor Details
-
UpdatableVTITemplate
protected UpdatableVTITemplate()
-
-
Method Details
-
executeQuery
- Specified by:
executeQueryin interfaceStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
executeUpdate
- Specified by:
executeUpdatein interfaceStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
close
- Specified by:
closein interfaceAutoCloseable- Specified by:
closein interfaceStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
getWarnings
- Specified by:
getWarningsin interfaceStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
clearWarnings
- Specified by:
clearWarningsin interfaceStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
getMaxFieldSize
- Specified by:
getMaxFieldSizein interfaceStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
setMaxFieldSize
- Specified by:
setMaxFieldSizein interfaceStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
getMaxRows
- Specified by:
getMaxRowsin interfaceStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
setMaxRows
- Specified by:
setMaxRowsin interfaceStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
setEscapeProcessing
- Specified by:
setEscapeProcessingin interfaceStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
getQueryTimeout
- Specified by:
getQueryTimeoutin interfaceStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
setQueryTimeout
- Specified by:
setQueryTimeoutin interfaceStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
addBatch
- Specified by:
addBatchin interfaceStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
clearBatch
- Specified by:
clearBatchin interfaceStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
executeBatch
- Specified by:
executeBatchin interfaceStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
cancel
- Specified by:
cancelin interfaceStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
setCursorName
- Specified by:
setCursorNamein interfaceStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
execute
- Specified by:
executein interfaceStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
getResultSet
- Specified by:
getResultSetin interfaceStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
getUpdateCount
- Specified by:
getUpdateCountin interfaceStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
getMoreResults
- Specified by:
getMoreResultsin interfaceStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
getResultSetConcurrency
- Specified by:
getResultSetConcurrencyin interfaceStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
executeQuery
- Specified by:
executeQueryin interfacePreparedStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
executeUpdate
- Specified by:
executeUpdatein interfacePreparedStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
setNull
- Specified by:
setNullin interfacePreparedStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
setNull
- Specified by:
setNullin interfacePreparedStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
setBoolean
- Specified by:
setBooleanin interfacePreparedStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
setByte
- Specified by:
setBytein interfacePreparedStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
setShort
- Specified by:
setShortin interfacePreparedStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
setInt
- Specified by:
setIntin interfacePreparedStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
setLong
- Specified by:
setLongin interfacePreparedStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
setFloat
- Specified by:
setFloatin interfacePreparedStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
setDouble
- Specified by:
setDoublein interfacePreparedStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
setBigDecimal
- Specified by:
setBigDecimalin interfacePreparedStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
setString
- Specified by:
setStringin interfacePreparedStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
setBytes
- Specified by:
setBytesin interfacePreparedStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
setDate
- Specified by:
setDatein interfacePreparedStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
setTime
- Specified by:
setTimein interfacePreparedStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
setTimestamp
- Specified by:
setTimestampin interfacePreparedStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
setAsciiStream
- Specified by:
setAsciiStreamin interfacePreparedStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
setUnicodeStream
Deprecated.- Specified by:
setUnicodeStreamin interfacePreparedStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
setBinaryStream
- Specified by:
setBinaryStreamin interfacePreparedStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
clearParameters
- Specified by:
clearParametersin 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:
setObjectin interfacePreparedStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
setObject
- Specified by:
setObjectin interfacePreparedStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
setObject
- Specified by:
setObjectin interfacePreparedStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
execute
- Specified by:
executein interfacePreparedStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
getMetaData
- Specified by:
getMetaDatain interfacePreparedStatement- Throws:
SQLException- on unexpected JDBC error- See Also:
-
getResultSetType
- Specified by:
getResultSetTypein interfaceStatement- Throws:
SQLException- Always thrown- See Also:
-
setBlob
- Specified by:
setBlobin interfacePreparedStatement- Throws:
SQLException- Always thrown- See Also:
-
setFetchDirection
- Specified by:
setFetchDirectionin interfaceStatement- Throws:
SQLException- Always thrown- See Also:
-
setFetchSize
- Specified by:
setFetchSizein interfaceStatement- Throws:
SQLException- Always thrown- See Also:
-
addBatch
- Specified by:
addBatchin interfacePreparedStatement- Throws:
SQLException- Always thrown- See Also:
-
setCharacterStream
- Specified by:
setCharacterStreamin interfacePreparedStatement- Throws:
SQLException- Always thrown- See Also:
-
getConnection
- Specified by:
getConnectionin interfaceStatement- Throws:
SQLException- Always thrown- See Also:
-
getFetchDirection
- Specified by:
getFetchDirectionin interfaceStatement- Throws:
SQLException- Always thrown- See Also:
-
setTime
- Specified by:
setTimein interfacePreparedStatement- Throws:
SQLException- Always thrown- See Also:
-
setTimestamp
- Specified by:
setTimestampin interfacePreparedStatement- Throws:
SQLException- Always thrown- See Also:
-
getFetchSize
- Specified by:
getFetchSizein interfaceStatement- Throws:
SQLException- Always thrown- See Also:
-
setRef
- Specified by:
setRefin interfacePreparedStatement- Throws:
SQLException- Always thrown- See Also:
-
setDate
- Specified by:
setDatein interfacePreparedStatement- Throws:
SQLException- Always thrown- See Also:
-
setClob
- Specified by:
setClobin interfacePreparedStatement- Throws:
SQLException- Always thrown- See Also:
-
setArray
- Specified by:
setArrayin interfacePreparedStatement- Throws:
SQLException- Always thrown- See Also:
-
setURL
- Specified by:
setURLin interfacePreparedStatement- Throws:
SQLException
-
getMoreResults
- Specified by:
getMoreResultsin interfaceStatement- Throws:
SQLException
-
getGeneratedKeys
- Specified by:
getGeneratedKeysin interfaceStatement- Throws:
SQLException
-
executeUpdate
- Specified by:
executeUpdatein interfaceStatement- Throws:
SQLException
-
executeUpdate
- Specified by:
executeUpdatein interfaceStatement- Throws:
SQLException
-
executeUpdate
- Specified by:
executeUpdatein interfaceStatement- Throws:
SQLException
-
execute
- Specified by:
executein interfaceStatement- Throws:
SQLException
-
execute
- Specified by:
executein interfaceStatement- Throws:
SQLException
-
execute
- Specified by:
executein interfaceStatement- Throws:
SQLException
-
getResultSetHoldability
- Specified by:
getResultSetHoldabilityin interfaceStatement- Throws:
SQLException
-
getParameterMetaData
- Specified by:
getParameterMetaDatain interfacePreparedStatement- Throws:
SQLException
-
isWrapperFor
- Specified by:
isWrapperForin interfaceWrapper- Throws:
SQLException
-
unwrap
- Specified by:
unwrapin interfaceWrapper- Throws:
SQLException
-
isClosed
- Specified by:
isClosedin interfaceStatement- Throws:
SQLException
-
isPoolable
- Specified by:
isPoolablein interfaceStatement- Throws:
SQLException
-
setPoolable
- Specified by:
setPoolablein interfaceStatement- Throws:
SQLException
-
setAsciiStream
- Specified by:
setAsciiStreamin interfacePreparedStatement- Throws:
SQLException
-
setAsciiStream
- Specified by:
setAsciiStreamin interfacePreparedStatement- Throws:
SQLException
-
setBinaryStream
- Specified by:
setBinaryStreamin interfacePreparedStatement- Throws:
SQLException
-
setBinaryStream
- Specified by:
setBinaryStreamin interfacePreparedStatement- Throws:
SQLException
-
setBlob
- Specified by:
setBlobin interfacePreparedStatement- Throws:
SQLException
-
setBlob
- Specified by:
setBlobin interfacePreparedStatement- Throws:
SQLException
-
setClob
- Specified by:
setClobin interfacePreparedStatement- Throws:
SQLException
-
setClob
- Specified by:
setClobin interfacePreparedStatement- Throws:
SQLException
-
setCharacterStream
- Specified by:
setCharacterStreamin interfacePreparedStatement- Throws:
SQLException
-
setCharacterStream
- Specified by:
setCharacterStreamin interfacePreparedStatement- Throws:
SQLException
-
setNCharacterStream
- Specified by:
setNCharacterStreamin interfacePreparedStatement- Throws:
SQLException
-
setNCharacterStream
- Specified by:
setNCharacterStreamin interfacePreparedStatement- Throws:
SQLException
-
setNClob
- Specified by:
setNClobin interfacePreparedStatement- Throws:
SQLException
-
setNClob
- Specified by:
setNClobin interfacePreparedStatement- Throws:
SQLException
-
setNClob
- Specified by:
setNClobin interfacePreparedStatement- Throws:
SQLException
-
setNString
- Specified by:
setNStringin interfacePreparedStatement- Throws:
SQLException
-
setRowId
- Specified by:
setRowIdin interfacePreparedStatement- Throws:
SQLException
-
setSQLXML
- Specified by:
setSQLXMLin interfacePreparedStatement- Throws:
SQLException
-
isCloseOnCompletion
- Specified by:
isCloseOnCompletionin interfaceStatement- Throws:
SQLException
-
closeOnCompletion
- Specified by:
closeOnCompletionin interfaceStatement- Throws:
SQLException
-