All Packages Class Hierarchy This Package Previous Next Index
Class JBMSTours.vti.jdbc2_0.EITResult
java.lang.Object
|
+----COM.cloudscape.vti.VTITemplate
|
+----COM.cloudscape.vti20.VTITemplate
|
+----JBMSTours.vti.jdbc2_0.EITResult
- public class EITResult
- extends VTITemplate
Wrapper class for an updatable ResultSet against table in an
Informix database. Supports only simple data types.
We need the wrapper because we need to be able to explicitly commit
the connection (or rollback, if an error occured)
every time the ResultSet is closed.
DO NOT compile or run this class in a JDK1.1 environment. It
require JDK 1.2 or above.
-
EITResult(Connection, PreparedStatement)
- Constructs the ResultSet by executing the query.
-
clearWarnings()
-
-
close()
- Closes the ResultSet.
-
deleteRow()
-
-
findColumn(String)
-
-
getBigDecimal(int)
-
-
getBigDecimal(int, int)
-
-
getBigDecimal(String)
-
-
getBoolean(int)
-
-
getBoolean(String)
-
-
getByte(int)
-
-
getByte(String)
-
-
getBytes(int)
-
-
getBytes(String)
-
-
getConcurrency()
- Must return ResultSet.CONCUR_UPDATABLE
-
getCursorName()
-
-
getDate(int)
-
-
getDate(String)
-
-
getDouble(int)
-
-
getDouble(String)
-
-
getFloat(int)
-
-
getFloat(String)
-
-
getInt(int)
-
-
getInt(String)
-
-
getLong(int)
-
-
getLong(String)
-
-
getMetaData()
- get the metadata from this query.
-
getObject(int)
-
-
getObject(String)
-
-
getShort(int)
-
-
getShort(String)
-
-
getString(int)
-
-
getString(String)
-
-
getTime(int)
-
-
getTime(String)
-
-
getTimestamp(int)
-
-
getTimestamp(String)
-
-
getWarnings()
-
-
insertRow()
-
-
moveToInsertRow()
-
-
next()
-
-
updateObject(int, Object)
-
-
wasNull()
-
EITResult
public EITResult(Connection conn,
PreparedStatement ps) throws SQLException
- Constructs the ResultSet by executing the query.
- Parameters:
- conn - The connection to the Informix database
- ps - The PreparedStatement querying the table
- Throws: SQLException
- on unexpected JDBC error
getMetaData
public ResultSetMetaData getMetaData() throws SQLException
- get the metadata from this query.
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getMetaData in class VTITemplate
close
public void close() throws SQLException
- Closes the ResultSet. We also use the method to commit the transaction.
We keep track of whether an error occured in insertRow() or deleteRow().
If an error occurred, we call rollback instead.
Cloudscape calls this method when it has finished executing the SQL-J
statement that uses the VTI class.
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- close in class VTITemplate
next
public boolean next() throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- next in class VTITemplate
moveToInsertRow
public void moveToInsertRow() throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- moveToInsertRow in class VTITemplate
updateObject
public void updateObject(int columnIndex,
Object x) throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- updateObject in class VTITemplate
insertRow
public void insertRow() throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- insertRow in class VTITemplate
deleteRow
public void deleteRow() throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- deleteRow in class VTITemplate
wasNull
public boolean wasNull() throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- wasNull in class VTITemplate
getString
public String getString(int columnIndex) throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getString in class VTITemplate
getBoolean
public boolean getBoolean(int columnIndex) throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getBoolean in class VTITemplate
getByte
public byte getByte(int columnIndex) throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getByte in class VTITemplate
getShort
public short getShort(int columnIndex) throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getShort in class VTITemplate
getInt
public int getInt(int columnIndex) throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getInt in class VTITemplate
getLong
public long getLong(int columnIndex) throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getLong in class VTITemplate
getFloat
public float getFloat(int columnIndex) throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getFloat in class VTITemplate
getDouble
public double getDouble(int columnIndex) throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getDouble in class VTITemplate
getBigDecimal
public BigDecimal getBigDecimal(int columnIndex) throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getBigDecimal in class VTITemplate
getBytes
public byte[] getBytes(int columnIndex) throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getBytes in class VTITemplate
getDate
public Date getDate(int columnIndex) throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getDate in class VTITemplate
getTime
public Time getTime(int columnIndex) throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getTime in class VTITemplate
getTimestamp
public Timestamp getTimestamp(int columnIndex) throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getTimestamp in class VTITemplate
getString
public String getString(String columnName) throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getString in class VTITemplate
getBoolean
public boolean getBoolean(String columnName) throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getBoolean in class VTITemplate
getByte
public byte getByte(String columnName) throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getByte in class VTITemplate
getShort
public short getShort(String columnName) throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getShort in class VTITemplate
getInt
public int getInt(String columnName) throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getInt in class VTITemplate
getLong
public long getLong(String columnName) throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getLong in class VTITemplate
getFloat
public float getFloat(String columnName) throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getFloat in class VTITemplate
getDouble
public double getDouble(String columnName) throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getDouble in class VTITemplate
getBigDecimal
public BigDecimal getBigDecimal(String columnName) throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getBigDecimal in class VTITemplate
getBytes
public byte[] getBytes(String columnName) throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getBytes in class VTITemplate
getDate
public Date getDate(String columnName) throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getDate in class VTITemplate
getTime
public Time getTime(String columnName) throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getTime in class VTITemplate
getTimestamp
public Timestamp getTimestamp(String columnName) throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getTimestamp in class VTITemplate
getWarnings
public SQLWarning getWarnings() throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getWarnings in class VTITemplate
clearWarnings
public void clearWarnings() throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- clearWarnings in class VTITemplate
getCursorName
public String getCursorName() throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getCursorName in class VTITemplate
getObject
public Object getObject(int columnIndex) throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getObject in class VTITemplate
getObject
public Object getObject(String columnName) throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getObject in class VTITemplate
findColumn
public int findColumn(String columnName) throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- findColumn in class VTITemplate
getConcurrency
public int getConcurrency() throws SQLException
- Must return ResultSet.CONCUR_UPDATABLE
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getConcurrency in class VTITemplate
getBigDecimal
public BigDecimal getBigDecimal(int columnIndex,
int scale) throws SQLException
- Throws: SQLException
- on unexpected JDBC error
- Overrides:
- getBigDecimal in class VTITemplate
All Packages Class Hierarchy This Package Previous Next Index