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.


Constructor Index

 o EITResult(Connection, PreparedStatement)
Constructs the ResultSet by executing the query.

Method Index

 o clearWarnings()
 o close()
Closes the ResultSet.
 o deleteRow()
 o findColumn(String)
 o getBigDecimal(int)
 o getBigDecimal(int, int)
 o getBigDecimal(String)
 o getBoolean(int)
 o getBoolean(String)
 o getByte(int)
 o getByte(String)
 o getBytes(int)
 o getBytes(String)
 o getConcurrency()
Must return ResultSet.CONCUR_UPDATABLE
 o getCursorName()
 o getDate(int)
 o getDate(String)
 o getDouble(int)
 o getDouble(String)
 o getFloat(int)
 o getFloat(String)
 o getInt(int)
 o getInt(String)
 o getLong(int)
 o getLong(String)
 o getMetaData()
get the metadata from this query.
 o getObject(int)
 o getObject(String)
 o getShort(int)
 o getShort(String)
 o getString(int)
 o getString(String)
 o getTime(int)
 o getTime(String)
 o getTimestamp(int)
 o getTimestamp(String)
 o getWarnings()
 o insertRow()
 o moveToInsertRow()
 o next()
 o updateObject(int, Object)
 o wasNull()

Constructors

 o 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

Methods

 o getMetaData
 public ResultSetMetaData getMetaData() throws SQLException
get the metadata from this query.

Throws: SQLException
on unexpected JDBC error
Overrides:
getMetaData in class VTITemplate
 o 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
 o next
 public boolean next() throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
next in class VTITemplate
 o moveToInsertRow
 public void moveToInsertRow() throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
moveToInsertRow in class VTITemplate
 o updateObject
 public void updateObject(int columnIndex,
                          Object x) throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
updateObject in class VTITemplate
 o insertRow
 public void insertRow() throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
insertRow in class VTITemplate
 o deleteRow
 public void deleteRow() throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
deleteRow in class VTITemplate
 o wasNull
 public boolean wasNull() throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
wasNull in class VTITemplate
 o getString
 public String getString(int columnIndex) throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
getString in class VTITemplate
 o getBoolean
 public boolean getBoolean(int columnIndex) throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
getBoolean in class VTITemplate
 o getByte
 public byte getByte(int columnIndex) throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
getByte in class VTITemplate
 o getShort
 public short getShort(int columnIndex) throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
getShort in class VTITemplate
 o getInt
 public int getInt(int columnIndex) throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
getInt in class VTITemplate
 o getLong
 public long getLong(int columnIndex) throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
getLong in class VTITemplate
 o getFloat
 public float getFloat(int columnIndex) throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
getFloat in class VTITemplate
 o getDouble
 public double getDouble(int columnIndex) throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
getDouble in class VTITemplate
 o getBigDecimal
 public BigDecimal getBigDecimal(int columnIndex) throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
getBigDecimal in class VTITemplate
 o getBytes
 public byte[] getBytes(int columnIndex) throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
getBytes in class VTITemplate
 o getDate
 public Date getDate(int columnIndex) throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
getDate in class VTITemplate
 o getTime
 public Time getTime(int columnIndex) throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
getTime in class VTITemplate
 o getTimestamp
 public Timestamp getTimestamp(int columnIndex) throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
getTimestamp in class VTITemplate
 o getString
 public String getString(String columnName) throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
getString in class VTITemplate
 o getBoolean
 public boolean getBoolean(String columnName) throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
getBoolean in class VTITemplate
 o getByte
 public byte getByte(String columnName) throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
getByte in class VTITemplate
 o getShort
 public short getShort(String columnName) throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
getShort in class VTITemplate
 o getInt
 public int getInt(String columnName) throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
getInt in class VTITemplate
 o getLong
 public long getLong(String columnName) throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
getLong in class VTITemplate
 o getFloat
 public float getFloat(String columnName) throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
getFloat in class VTITemplate
 o getDouble
 public double getDouble(String columnName) throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
getDouble in class VTITemplate
 o getBigDecimal
 public BigDecimal getBigDecimal(String columnName) throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
getBigDecimal in class VTITemplate
 o getBytes
 public byte[] getBytes(String columnName) throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
getBytes in class VTITemplate
 o getDate
 public Date getDate(String columnName) throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
getDate in class VTITemplate
 o getTime
 public Time getTime(String columnName) throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
getTime in class VTITemplate
 o getTimestamp
 public Timestamp getTimestamp(String columnName) throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
getTimestamp in class VTITemplate
 o getWarnings
 public SQLWarning getWarnings() throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
getWarnings in class VTITemplate
 o clearWarnings
 public void clearWarnings() throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
clearWarnings in class VTITemplate
 o getCursorName
 public String getCursorName() throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
getCursorName in class VTITemplate
 o getObject
 public Object getObject(int columnIndex) throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
getObject in class VTITemplate
 o getObject
 public Object getObject(String columnName) throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
getObject in class VTITemplate
 o findColumn
 public int findColumn(String columnName) throws SQLException
Throws: SQLException
on unexpected JDBC error
Overrides:
findColumn in class VTITemplate
 o getConcurrency
 public int getConcurrency() throws SQLException
Must return ResultSet.CONCUR_UPDATABLE

Throws: SQLException
on unexpected JDBC error
Overrides:
getConcurrency in class VTITemplate
 o 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