Class Hierarchy Previous Next Index
Class COM.cloudscape.vti.UpdatableVTITemplate
java.lang.Object
|
+----COM.cloudscape.vti.UpdatableVTITemplate
- public class UpdatableVTITemplate
- extends java.lang.Object
- implements java.sql.PreparedStatement
Copyright © 1998-2000, Informix Software, Inc. All rights reserved.
An abstract implementation of PreparedStatement (JDK1.1/JDBC 1.2) that is useful
when writing an updatable VTI (virtual table interface). 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 sub-class can then just implement
the methods not implemented here and override any methods it needs
to implement for correct functionality.
Use this class with JDK 1.1. It does not implement methods that are
defined in the JDBC 2.0 PreparedStatement interface. For JDK 1.2 or
higher, it is easier to use the class
COM.cloudscape.vti20.UpdatableVTITemplate.
VTI implementation must provide an
implementation of the methods in this class.
UpdatableVTITemplate()
-
addBatch(String)
-
cancel()
-
clearBatch()
-
clearParameters()
-
clearWarnings()
-
close()
-
execute()
-
execute(String)
-
executeBatch()
-
executeQuery()
-
executeQuery(String)
-
executeUpdate()
-
executeUpdate(String)
-
getMaxFieldSize()
-
getMaxRows()
-
getMetaData()
-
getMoreResults()
-
getQueryTimeout()
-
getResultSet()
-
getResultSetConcurrency()
-
getUpdateCount()
-
getWarnings()
-
setAsciiStream(int, InputStream, int)
-
setBigDecimal(int, BigDecimal)
-
setBinaryStream(int, InputStream, int)
-
setBoolean(int, boolean)
-
setByte(int, byte)
-
setBytes(int, byte[])
-
setCursorName(String)
-
setDate(int, Date)
-
setDouble(int, double)
-
setEscapeProcessing(boolean)
-
setFloat(int, float)
-
setInt(int, int)
-
setLong(int, long)
-
setMaxFieldSize(int)
-
setMaxRows(int)
-
setNull(int, int)
-
setNull(int, int, String)
-
setObject(int, Object)
-
setObject(int, Object, int)
-
setObject(int, Object, int, int)
-
setQueryTimeout(int)
-
setShort(int, short)
-
setString(int, String)
-
setTime(int, Time)
-
setTimestamp(int, Timestamp)
-
setUnicodeStream(int, InputStream, int)
-
UpdatableVTITemplate
public UpdatableVTITemplate()
executeQuery
public java.sql.ResultSet executeQuery(java.lang.String sql) throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.Statement
executeUpdate
public int executeUpdate(java.lang.String sql) throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.Statement
close
public void close() throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.Statement
getWarnings
public java.sql.SQLWarning getWarnings() throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.Statement
clearWarnings
public void clearWarnings() throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.Statement
getMaxFieldSize
public int getMaxFieldSize() throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.Statement
setMaxFieldSize
public void setMaxFieldSize(int max) throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.Statement
getMaxRows
public int getMaxRows() throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.Statement
setMaxRows
public void setMaxRows(int max) throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.Statement
setEscapeProcessing
public void setEscapeProcessing(boolean enable) throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.Statement
getQueryTimeout
public int getQueryTimeout() throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.Statement
setQueryTimeout
public void setQueryTimeout(int seconds) throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.Statement
addBatch
public void addBatch(java.lang.String sql) throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.Statement
clearBatch
public void clearBatch() throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.Statement
executeBatch
public int[] executeBatch() throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.Statement
cancel
public void cancel() throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.Statement
setCursorName
public void setCursorName(java.lang.String name) throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.Statement
execute
public boolean execute(java.lang.String sql) throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.Statement
getResultSet
public java.sql.ResultSet getResultSet() throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.Statement
getUpdateCount
public int getUpdateCount() throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.Statement
getMoreResults
public boolean getMoreResults() throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.Statement
getResultSetConcurrency
public int getResultSetConcurrency() throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.Statement
executeQuery
public java.sql.ResultSet executeQuery() throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.PreparedStatement
executeUpdate
public int executeUpdate() throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.PreparedStatement
setNull
public void setNull(int parameterIndex,
int jdbcType) throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.PreparedStatement
setNull
public void setNull(int parameterIndex,
int jdbcType,
java.lang.String typeName) throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.PreparedStatement
setBoolean
public void setBoolean(int parameterIndex,
boolean x) throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.PreparedStatement
setByte
public void setByte(int parameterIndex,
byte x) throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.PreparedStatement
setShort
public void setShort(int parameterIndex,
short x) throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.PreparedStatement
setInt
public void setInt(int parameterIndex,
int x) throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.PreparedStatement
setLong
public void setLong(int parameterIndex,
long x) throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.PreparedStatement
setFloat
public void setFloat(int parameterIndex,
float x) throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.PreparedStatement
setDouble
public void setDouble(int parameterIndex,
double x) throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.PreparedStatement
setBigDecimal
public void setBigDecimal(int parameterIndex,
java.math.BigDecimal x) throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.PreparedStatement
setString
public void setString(int parameterIndex,
java.lang.String x) throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.PreparedStatement
setBytes
public void setBytes(int parameterIndex,
byte x[]) throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.PreparedStatement
setDate
public void setDate(int parameterIndex,
java.sql.Date x) throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.PreparedStatement
setTime
public void setTime(int parameterIndex,
java.sql.Time x) throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.PreparedStatement
setTimestamp
public void setTimestamp(int parameterIndex,
java.sql.Timestamp x) throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.PreparedStatement
setAsciiStream
public void setAsciiStream(int parameterIndex,
java.io.InputStream x,
int length) throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.PreparedStatement
setUnicodeStream
public void setUnicodeStream(int parameterIndex,
java.io.InputStream x,
int length) throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.PreparedStatement
setBinaryStream
public void setBinaryStream(int parameterIndex,
java.io.InputStream x,
int length) throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.PreparedStatement
clearParameters
public void clearParameters() throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.PreparedStatement
setObject
public void setObject(int parameterIndex,
java.lang.Object x,
int targetJdbcType,
int scale) throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.PreparedStatement
setObject
public void setObject(int parameterIndex,
java.lang.Object x,
int targetJdbcType) throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.PreparedStatement
setObject
public void setObject(int parameterIndex,
java.lang.Object x) throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.PreparedStatement
execute
public boolean execute() throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.PreparedStatement
getMetaData
public java.sql.ResultSetMetaData getMetaData() throws java.sql.SQLException
- Throws:
- java.sql.SQLException - on unexpected JDBC error
- See Also:
- java.sql.PreparedStatement
Class Hierarchy Previous Next Index