org.apache.derby.vti
Class UpdatableVTITemplate
java.lang.Object
org.apache.derby.vti.UpdatableVTITemplate
- All Implemented Interfaces:
- java.sql.PreparedStatement, java.sql.Statement
- public abstract class UpdatableVTITemplate
- extends java.lang.Object
- implements java.sql.PreparedStatement
An abstract implementation of PreparedStatement (JDK1.1/JDBC 1.2) that is useful
when writing a read-write (updatable) virtual table interface (VTI).
This class implements
the methods of the JDBC1.2 version of PreparedStatement plus the
JDBC2.0 getMetaData() method, 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.
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 |
UpdatableVTITemplate()
Deprecated. Cloudscape 5.1 no longer supports read-write VTI's with JDBC 1.2. Applications
can use the UpdatableVTITemplate to implement a read-write VTI. |
Method Summary |
void |
addBatch()
|
void |
addBatch(java.lang.String sql)
|
void |
cancel()
|
void |
clearBatch()
|
void |
clearParameters()
|
void |
clearWarnings()
|
void |
close()
|
boolean |
execute()
|
boolean |
execute(java.lang.String sql)
|
int[] |
executeBatch()
|
java.sql.ResultSet |
executeQuery()
|
java.sql.ResultSet |
executeQuery(java.lang.String sql)
|
int |
executeUpdate()
|
int |
executeUpdate(java.lang.String sql)
|
java.sql.Connection |
getConnection()
|
int |
getFetchDirection()
|
int |
getFetchSize()
|
int |
getMaxFieldSize()
|
int |
getMaxRows()
|
java.sql.ResultSetMetaData |
getMetaData()
|
boolean |
getMoreResults()
|
int |
getQueryTimeout()
|
java.sql.ResultSet |
getResultSet()
|
int |
getResultSetConcurrency()
|
int |
getResultSetType()
|
int |
getUpdateCount()
|
java.sql.SQLWarning |
getWarnings()
|
void |
setArray(int i,
java.sql.Array x)
|
void |
setAsciiStream(int parameterIndex,
java.io.InputStream x,
int length)
|
void |
setBigDecimal(int parameterIndex,
java.math.BigDecimal x)
|
void |
setBinaryStream(int parameterIndex,
java.io.InputStream x,
int length)
|
void |
setBlob(int i,
java.sql.Blob x)
|
void |
setBoolean(int parameterIndex,
boolean x)
|
void |
setByte(int parameterIndex,
byte x)
|
void |
setBytes(int parameterIndex,
byte[] x)
|
void |
setCharacterStream(int parameterIndex,
java.io.Reader reader,
int length)
|
void |
setClob(int i,
java.sql.Clob x)
|
void |
setCursorName(java.lang.String name)
|
void |
setDate(int parameterIndex,
java.sql.Date x)
|
void |
setDate(int parameterIndex,
java.sql.Date x,
java.util.Calendar cal)
|
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 |
setNull(int parameterIndex,
int jdbcType)
|
void |
setNull(int parameterIndex,
int jdbcType,
java.lang.String typeName)
|
void |
setObject(int parameterIndex,
java.lang.Object x)
|
void |
setObject(int parameterIndex,
java.lang.Object x,
int targetJdbcType)
|
void |
setObject(int parameterIndex,
java.lang.Object x,
int targetJdbcType,
int scale)
|
void |
setQueryTimeout(int seconds)
|
void |
setRef(int i,
java.sql.Ref x)
|
void |
setShort(int parameterIndex,
short x)
|
void |
setString(int parameterIndex,
java.lang.String x)
|
void |
setTime(int parameterIndex,
java.sql.Time x)
|
void |
setTime(int parameterIndex,
java.sql.Time x,
java.util.Calendar cal)
|
void |
setTimestamp(int parameterIndex,
java.sql.Timestamp x)
|
void |
setTimestamp(int parameterIndex,
java.sql.Timestamp x,
java.util.Calendar cal)
|
void |
setUnicodeStream(int parameterIndex,
java.io.InputStream x,
int length)
|
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 |
getParameterMetaData, setURL |
Methods inherited from interface java.sql.Statement |
execute, execute, execute, executeUpdate, executeUpdate, executeUpdate, getGeneratedKeys, getMoreResults, getResultSetHoldability |
UpdatableVTITemplate
public UpdatableVTITemplate()
- Deprecated. Cloudscape 5.1 no longer supports read-write VTI's with JDBC 1.2. Applications
can use the UpdatableVTITemplate to implement a read-write VTI.
executeQuery
public java.sql.ResultSet executeQuery(java.lang.String sql)
throws java.sql.SQLException
- Specified by:
executeQuery
in interface java.sql.Statement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
Statement
executeUpdate
public int executeUpdate(java.lang.String sql)
throws java.sql.SQLException
- Specified by:
executeUpdate
in interface java.sql.Statement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
Statement
close
public void close()
throws java.sql.SQLException
- Specified by:
close
in interface java.sql.Statement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
Statement
getWarnings
public java.sql.SQLWarning getWarnings()
throws java.sql.SQLException
- Specified by:
getWarnings
in interface java.sql.Statement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
Statement
clearWarnings
public void clearWarnings()
throws java.sql.SQLException
- Specified by:
clearWarnings
in interface java.sql.Statement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
Statement
getMaxFieldSize
public int getMaxFieldSize()
throws java.sql.SQLException
- Specified by:
getMaxFieldSize
in interface java.sql.Statement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
Statement
setMaxFieldSize
public void setMaxFieldSize(int max)
throws java.sql.SQLException
- Specified by:
setMaxFieldSize
in interface java.sql.Statement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
Statement
getMaxRows
public int getMaxRows()
throws java.sql.SQLException
- Specified by:
getMaxRows
in interface java.sql.Statement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
Statement
setMaxRows
public void setMaxRows(int max)
throws java.sql.SQLException
- Specified by:
setMaxRows
in interface java.sql.Statement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
Statement
setEscapeProcessing
public void setEscapeProcessing(boolean enable)
throws java.sql.SQLException
- Specified by:
setEscapeProcessing
in interface java.sql.Statement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
Statement
getQueryTimeout
public int getQueryTimeout()
throws java.sql.SQLException
- Specified by:
getQueryTimeout
in interface java.sql.Statement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
Statement
setQueryTimeout
public void setQueryTimeout(int seconds)
throws java.sql.SQLException
- Specified by:
setQueryTimeout
in interface java.sql.Statement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
Statement
addBatch
public void addBatch(java.lang.String sql)
throws java.sql.SQLException
- Specified by:
addBatch
in interface java.sql.Statement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
Statement
clearBatch
public void clearBatch()
throws java.sql.SQLException
- Specified by:
clearBatch
in interface java.sql.Statement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
Statement
executeBatch
public int[] executeBatch()
throws java.sql.SQLException
- Specified by:
executeBatch
in interface java.sql.Statement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
Statement
cancel
public void cancel()
throws java.sql.SQLException
- Specified by:
cancel
in interface java.sql.Statement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
Statement
setCursorName
public void setCursorName(java.lang.String name)
throws java.sql.SQLException
- Specified by:
setCursorName
in interface java.sql.Statement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
Statement
execute
public boolean execute(java.lang.String sql)
throws java.sql.SQLException
- Specified by:
execute
in interface java.sql.Statement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
Statement
getResultSet
public java.sql.ResultSet getResultSet()
throws java.sql.SQLException
- Specified by:
getResultSet
in interface java.sql.Statement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
Statement
getUpdateCount
public int getUpdateCount()
throws java.sql.SQLException
- Specified by:
getUpdateCount
in interface java.sql.Statement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
Statement
getMoreResults
public boolean getMoreResults()
throws java.sql.SQLException
- Specified by:
getMoreResults
in interface java.sql.Statement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
Statement
getResultSetConcurrency
public int getResultSetConcurrency()
throws java.sql.SQLException
- Specified by:
getResultSetConcurrency
in interface java.sql.Statement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
Statement
executeQuery
public java.sql.ResultSet executeQuery()
throws java.sql.SQLException
- Specified by:
executeQuery
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
PreparedStatement
executeUpdate
public int executeUpdate()
throws java.sql.SQLException
- Specified by:
executeUpdate
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
PreparedStatement
setNull
public void setNull(int parameterIndex,
int jdbcType)
throws java.sql.SQLException
- Specified by:
setNull
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
PreparedStatement
setNull
public void setNull(int parameterIndex,
int jdbcType,
java.lang.String typeName)
throws java.sql.SQLException
- Specified by:
setNull
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
PreparedStatement
setBoolean
public void setBoolean(int parameterIndex,
boolean x)
throws java.sql.SQLException
- Specified by:
setBoolean
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
PreparedStatement
setByte
public void setByte(int parameterIndex,
byte x)
throws java.sql.SQLException
- Specified by:
setByte
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
PreparedStatement
setShort
public void setShort(int parameterIndex,
short x)
throws java.sql.SQLException
- Specified by:
setShort
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
PreparedStatement
setInt
public void setInt(int parameterIndex,
int x)
throws java.sql.SQLException
- Specified by:
setInt
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
PreparedStatement
setLong
public void setLong(int parameterIndex,
long x)
throws java.sql.SQLException
- Specified by:
setLong
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
PreparedStatement
setFloat
public void setFloat(int parameterIndex,
float x)
throws java.sql.SQLException
- Specified by:
setFloat
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
PreparedStatement
setDouble
public void setDouble(int parameterIndex,
double x)
throws java.sql.SQLException
- Specified by:
setDouble
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
PreparedStatement
setBigDecimal
public void setBigDecimal(int parameterIndex,
java.math.BigDecimal x)
throws java.sql.SQLException
- Specified by:
setBigDecimal
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
PreparedStatement
setString
public void setString(int parameterIndex,
java.lang.String x)
throws java.sql.SQLException
- Specified by:
setString
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
PreparedStatement
setBytes
public void setBytes(int parameterIndex,
byte[] x)
throws java.sql.SQLException
- Specified by:
setBytes
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
PreparedStatement
setDate
public void setDate(int parameterIndex,
java.sql.Date x)
throws java.sql.SQLException
- Specified by:
setDate
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
PreparedStatement
setTime
public void setTime(int parameterIndex,
java.sql.Time x)
throws java.sql.SQLException
- Specified by:
setTime
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
PreparedStatement
setTimestamp
public void setTimestamp(int parameterIndex,
java.sql.Timestamp x)
throws java.sql.SQLException
- Specified by:
setTimestamp
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
PreparedStatement
setAsciiStream
public void setAsciiStream(int parameterIndex,
java.io.InputStream x,
int length)
throws java.sql.SQLException
- Specified by:
setAsciiStream
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
PreparedStatement
setUnicodeStream
public void setUnicodeStream(int parameterIndex,
java.io.InputStream x,
int length)
throws java.sql.SQLException
- Specified by:
setUnicodeStream
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
PreparedStatement
setBinaryStream
public void setBinaryStream(int parameterIndex,
java.io.InputStream x,
int length)
throws java.sql.SQLException
- Specified by:
setBinaryStream
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
PreparedStatement
clearParameters
public void clearParameters()
throws java.sql.SQLException
- Specified by:
clearParameters
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
PreparedStatement
setObject
public void setObject(int parameterIndex,
java.lang.Object x,
int targetJdbcType,
int scale)
throws java.sql.SQLException
- Specified by:
setObject
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
PreparedStatement
setObject
public void setObject(int parameterIndex,
java.lang.Object x,
int targetJdbcType)
throws java.sql.SQLException
- Specified by:
setObject
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
PreparedStatement
setObject
public void setObject(int parameterIndex,
java.lang.Object x)
throws java.sql.SQLException
- Specified by:
setObject
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
PreparedStatement
execute
public boolean execute()
throws java.sql.SQLException
- Specified by:
execute
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
PreparedStatement
getMetaData
public java.sql.ResultSetMetaData getMetaData()
throws java.sql.SQLException
- Specified by:
getMetaData
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- on unexpected JDBC error- See Also:
PreparedStatement
getResultSetType
public int getResultSetType()
throws java.sql.SQLException
- Specified by:
getResultSetType
in interface java.sql.Statement
- Throws:
java.sql.SQLException
- Always thrown- See Also:
PreparedStatement
setBlob
public void setBlob(int i,
java.sql.Blob x)
throws java.sql.SQLException
- Specified by:
setBlob
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- Always thrown- See Also:
PreparedStatement
setFetchDirection
public void setFetchDirection(int direction)
throws java.sql.SQLException
- Specified by:
setFetchDirection
in interface java.sql.Statement
- Throws:
java.sql.SQLException
- Always thrown- See Also:
PreparedStatement
setFetchSize
public void setFetchSize(int rows)
throws java.sql.SQLException
- Specified by:
setFetchSize
in interface java.sql.Statement
- Throws:
java.sql.SQLException
- Always thrown- See Also:
PreparedStatement
addBatch
public void addBatch()
throws java.sql.SQLException
- Specified by:
addBatch
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- Always thrown- See Also:
PreparedStatement
setCharacterStream
public void setCharacterStream(int parameterIndex,
java.io.Reader reader,
int length)
throws java.sql.SQLException
- Specified by:
setCharacterStream
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- Always thrown- See Also:
PreparedStatement
getConnection
public java.sql.Connection getConnection()
throws java.sql.SQLException
- Specified by:
getConnection
in interface java.sql.Statement
- Throws:
java.sql.SQLException
- Always thrown- See Also:
PreparedStatement
getFetchDirection
public int getFetchDirection()
throws java.sql.SQLException
- Specified by:
getFetchDirection
in interface java.sql.Statement
- Throws:
java.sql.SQLException
- Always thrown- See Also:
PreparedStatement
setTime
public void setTime(int parameterIndex,
java.sql.Time x,
java.util.Calendar cal)
throws java.sql.SQLException
- Specified by:
setTime
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- Always thrown- See Also:
PreparedStatement
setTimestamp
public void setTimestamp(int parameterIndex,
java.sql.Timestamp x,
java.util.Calendar cal)
throws java.sql.SQLException
- Specified by:
setTimestamp
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- Always thrown- See Also:
PreparedStatement
getFetchSize
public int getFetchSize()
throws java.sql.SQLException
- Specified by:
getFetchSize
in interface java.sql.Statement
- Throws:
java.sql.SQLException
- Always thrown- See Also:
PreparedStatement
setRef
public void setRef(int i,
java.sql.Ref x)
throws java.sql.SQLException
- Specified by:
setRef
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- Always thrown- See Also:
PreparedStatement
setDate
public void setDate(int parameterIndex,
java.sql.Date x,
java.util.Calendar cal)
throws java.sql.SQLException
- Specified by:
setDate
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- Always thrown- See Also:
PreparedStatement
setClob
public void setClob(int i,
java.sql.Clob x)
throws java.sql.SQLException
- Specified by:
setClob
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- Always thrown- See Also:
PreparedStatement
setArray
public void setArray(int i,
java.sql.Array x)
throws java.sql.SQLException
- Specified by:
setArray
in interface java.sql.PreparedStatement
- Throws:
java.sql.SQLException
- Always thrown- See Also:
PreparedStatement
Apache Derby V10.1 Engine Documentation - Copyright © 1997,2005 The Apache Software Foundation or its licensors, as applicable.