org.objectweb.cjdbc.driver.DriverResultSet Class Reference

Collaboration diagram for org.objectweb.cjdbc.driver.DriverResultSet:

[legend]List of all members.

Public Member Functions
boolean	next () throws java.sql.SQLException
boolean	prev () throws SQLException
boolean	isBeforeFirst () throws SQLException
boolean	isAfterLast () throws SQLException
boolean	isFirst () throws SQLException
boolean	isLast () throws SQLException
void	beforeFirst () throws SQLException
void	afterLast () throws SQLException
boolean	first () throws SQLException
boolean	last () throws SQLException
int	getRow () throws SQLException
boolean	absolute (int row) throws SQLException
boolean	relative (int rows) throws SQLException
boolean	previous () throws SQLException
void	setFetchDirection (int direction) throws SQLException
int	getFetchDirection () throws SQLException
void	setFetchSize (int rows) throws SQLException
int	getFetchSize () throws SQLException
String	getString (int columnIndex) throws SQLException
boolean	getBoolean (int columnIndex) throws SQLException
short	getShort (int columnIndex) throws SQLException
int	getInt (int columnIndex) throws SQLException
long	getLong (int columnIndex) throws SQLException
float	getFloat (int columnIndex) throws SQLException
double	getDouble (int columnIndex) throws SQLException
BigDecimal	getBigDecimal (int columnIndex, int scale) throws SQLException
byte[]	getBytes (int columnIndex) throws SQLException
java.sql.Date	getDate (int columnIndex) throws SQLException
Time	getTime (int columnIndex) throws SQLException
Timestamp	getTimestamp (int columnIndex) throws SQLException
InputStream	getAsciiStream (int columnIndex) throws SQLException
InputStream	getUnicodeStream (int columnIndex) throws SQLException
InputStream	getBinaryStream (int columnIndex) throws SQLException
String	getString (String columnName) throws SQLException
boolean	getBoolean (String columnName) throws SQLException
byte	getByte (String columnName) throws SQLException
short	getShort (String columnName) throws SQLException
int	getInt (String columnName) throws SQLException
long	getLong (String columnName) throws SQLException
float	getFloat (String columnName) throws SQLException
double	getDouble (String columnName) throws SQLException
BigDecimal	getBigDecimal (String columnName, int scale) throws SQLException
byte[]	getBytes (String columnName) throws SQLException
java.sql.Date	getDate (String columnName) throws SQLException
Time	getTime (String columnName) throws SQLException
Timestamp	getTimestamp (String columnName) throws SQLException
InputStream	getAsciiStream (String columnName) throws SQLException
InputStream	getUnicodeStream (String columnName) throws SQLException
InputStream	getBinaryStream (String columnName) throws SQLException
java.sql.SQLWarning	getWarnings () throws SQLException
void	clearWarnings () throws SQLException
String	getCursorName () throws SQLException
Object	getObject (int columnIndex) throws SQLException
Object	getObject (String columnName) throws SQLException
java.io.Reader	getCharacterStream (int columnIndex) throws SQLException
java.io.Reader	getCharacterStream (String columnName) throws SQLException
BigDecimal	getBigDecimal (int columnIndex) throws SQLException
BigDecimal	getBigDecimal (String columnName) throws SQLException
Object	getObject (int i, java.util.Map map) throws SQLException
java.sql.Ref	getRef (int i) throws SQLException
java.sql.Blob	getBlob (int columnIndex) throws SQLException
java.sql.Clob	getClob (int columnIndex) throws SQLException
java.sql.Array	getArray (int columnIndex) throws SQLException
Object	getObject (String colName, java.util.Map map) throws SQLException
java.sql.Ref	getRef (String colName) throws SQLException
java.sql.Blob	getBlob (String colName) throws SQLException
java.sql.Clob	getClob (String colName) throws SQLException
java.sql.Array	getArray (String colName) throws SQLException
java.sql.Date	getDate (int columnIndex, Calendar cal) throws SQLException
java.sql.Date	getDate (String columnName, Calendar cal) throws SQLException
java.sql.Time	getTime (int columnIndex, Calendar cal) throws SQLException
java.sql.Time	getTime (String columnName, Calendar cal) throws SQLException
java.sql.Timestamp	getTimestamp (int columnIndex, Calendar cal) throws SQLException
java.sql.Timestamp	getTimestamp (String columnName, Calendar cal) throws SQLException
boolean	rowUpdated () throws SQLException
boolean	rowInserted () throws SQLException
boolean	rowDeleted () throws SQLException
void	updateNull (int columnIndex) throws SQLException
void	updateBoolean (int columnIndex, boolean x) throws SQLException
void	updateByte (int columnIndex, byte x) throws SQLException
void	updateShort (int columnIndex, short x) throws SQLException
void	updateInt (int columnIndex, int x) throws SQLException
void	updateLong (int columnIndex, long x) throws SQLException
void	updateFloat (int columnIndex, float x) throws SQLException
void	updateDouble (int columnIndex, double x) throws SQLException
void	updateBigDecimal (int columnIndex, BigDecimal x) throws SQLException
void	updateString (int columnIndex, String x) throws SQLException
void	updateBytes (int columnIndex, byte x[]) throws SQLException
void	updateDate (int columnIndex, java.sql.Date x) throws SQLException
void	updateTime (int columnIndex, java.sql.Time x) throws SQLException
void	updateTimestamp (int columnIndex, java.sql.Timestamp x) throws SQLException
void	updateAsciiStream (int columnIndex, java.io.InputStream x, int length) throws SQLException
void	updateBinaryStream (int columnIndex, java.io.InputStream x, int length) throws SQLException
void	updateCharacterStream (int columnIndex, java.io.Reader x, int length) throws SQLException
void	updateObject (int columnIndex, Object x, int scale) throws SQLException
void	updateObject (int columnIndex, Object x) throws SQLException
void	updateNull (String columnName) throws SQLException
void	updateBoolean (String columnName, boolean x) throws SQLException
void	updateByte (String columnName, byte x) throws SQLException
void	updateShort (String columnName, short x) throws SQLException
void	updateInt (String columnName, int x) throws SQLException
void	updateLong (String columnName, long x) throws SQLException
void	updateFloat (String columnName, float x) throws SQLException
void	updateDouble (String columnName, double x) throws SQLException
void	updateBigDecimal (String columnName, BigDecimal x) throws SQLException
void	updateString (String columnName, String x) throws SQLException
void	updateBytes (String columnName, byte x[]) throws SQLException
void	updateDate (String columnName, java.sql.Date x) throws SQLException
void	updateTime (String columnName, java.sql.Time x) throws SQLException
void	updateTimestamp (String columnName, java.sql.Timestamp x) throws SQLException
void	updateAsciiStream (String columnName, java.io.InputStream x, int length) throws SQLException
void	updateBinaryStream (String columnName, java.io.InputStream x, int length) throws SQLException
void	updateCharacterStream (String columnName, java.io.Reader reader, int length) throws SQLException
void	updateObject (String columnName, Object x, int scale) throws SQLException
void	updateObject (String columnName, Object x) throws SQLException
void	insertRow () throws SQLException
void	updateRow () throws SQLException
void	deleteRow () throws SQLException
void	refreshRow () throws SQLException
void	cancelRowUpdates () throws SQLException
void	moveToInsertRow () throws SQLException
void	moveToCurrentRow () throws SQLException
int	getType () throws SQLException
int	getConcurrency () throws SQLException
void	close () throws SQLException
boolean	wasNull () throws SQLException
java.sql.Statement	getStatement () throws SQLException
java.sql.ResultSetMetaData	getMetaData () throws SQLException
int	findColumn (String columnName) throws SQLException
	DriverResultSet (Field[] fields, ArrayList resultData)
	DriverResultSet (Field[] fields, ArrayList resultData, boolean crsHasMoreData, String cursorName)
java.net.URL	getURL (int columnIndex) throws SQLException
java.net.URL	getURL (String columnName) throws SQLException
void	updateRef (int columnIndex, java.sql.Ref x) throws SQLException
void	updateRef (String columnName, java.sql.Ref x) throws SQLException
void	updateBlob (int columnIndex, java.sql.Blob x) throws SQLException
void	updateBlob (String columnName, java.sql.Blob x) throws SQLException
void	updateClob (int columnIndex, java.sql.Clob x) throws SQLException
void	updateClob (String columnName, java.sql.Clob x) throws SQLException
void	updateArray (int columnIndex, java.sql.Array x) throws SQLException
void	updateArray (String columnName, java.sql.Array x) throws SQLException
byte	getByte (int columnIndex) throws SQLException
String	toString ()
Protected Member Functions
void	setData (ArrayList newData)
void	setHasMoreData (boolean hasMore)
void	setStatement (Statement stmt) throws SQLException
Protected Attributes
int	currentRow = -1
int	nbOfRows = -1
int	nbOfColumns = -1
ArrayList	data
int	fetchDirection = FETCH_FORWARD
int	fetchSize = 0
Field[]	fields
boolean	wasNullFlag = false
transient Hashtable	columnNameToIndex = null
transient Hashtable	fullColumnNameToIndex = null
int	resultSetType = 0
int	resultSetConcurrency = 0
SQLWarning	warnings = null
transient Statement	owningStatement

---

Detailed Description

A ResultSet provides access to a table of data generated by executing a Statement. The table rows are retrieved in sequence. Within a row its column values can be accessed in any order.

A ResultSet maintains a cursor pointing to its current row of data. Initially the cursor is positioned before the first row. The 'next' method moves the cursor to the next row.

The getXXX methods retrieve column values for the current row. You can retrieve values either using the index number of the column, or by using the name of the column. In general using the column index will be more efficient. Columns are numbered from 1.

For maximum portability, ResultSet columns within each row should be read in left-to-right order and each column should be read only once.

For the getXXX methods, the JDBC driver attempts to convert the underlying data to the specified Java type and returns a suitable Java value. See the JDBC specification for allowable mappings from SQL types to Java types with the ResultSet getXXX methods.

Column names used as input to getXXX methods are case insenstive. When performing a getXXX using a column name, if several columns have the same name, then the value of the first matching column will be returned. The column name option is designed to be used when column names are used in the SQL Query. For columns that are NOT explicitly named in the query, it is best to use column numbers. If column names were used there is no way for the programmer to guarentee that they actually refer to the intended columns.

A ResultSet is automatically closed by the Statement that generated it when that Statement is closed, re-executed, or is used to retrieve the next result from a sequence of multiple results.

The number, types and properties of a ResultSet's columns are provided by the ResultSetMetaData object returned by the getMetaData method.

See also:

java.sql.ResultSetMetaData

java.sql.ResultSet

Author:

Mark Matthews <mmatthew@worldserver.com>

Emmanuel Cecchet

Alexander Laamanen

Nicolas Modrzyk

Jean-Bernard van Zuylen

Version:

1.0

Definition at line 97 of file DriverResultSet.java.

---

Constructor & Destructor Documentation

org.objectweb.cjdbc.driver.DriverResultSet.DriverResultSet (  Field[]  fields, ArrayList  resultData )

Creates a new DriverResultSet. Parameters: fields  an array of Field objects (basically, the ResultSet meta data) resultData  array of the actual data (data[row][column]) Definition at line 3104 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.currentRow, org.objectweb.cjdbc.driver.DriverResultSet.data, org.objectweb.cjdbc.driver.DriverResultSet.nbOfColumns, and org.objectweb.cjdbc.driver.DriverResultSet.nbOfRows. { currentRow = -1; this.fields = fields; data = resultData; if (data == null) nbOfRows = 0; else nbOfRows = data.size(); nbOfColumns = fields.length; isClosed = false; }

org.objectweb.cjdbc.driver.DriverResultSet.DriverResultSet (  Field[]  fields, ArrayList  resultData, boolean  crsHasMoreData, String  cursorName )

Creates a new DriverResultSet object from information we get back from a ControllerResultSet. Parameters: fields  an array of Field objects (basically, the ResultSet meta data) resultData  array of the actual data (data[row][column]) crsHasMoreData  true if remote ControllerResultSet has more data to fetch cursorName  cursor name for a streamable ResultSet Definition at line 3128 of file DriverResultSet.java. { this(fields, resultData); this.cursorName = cursorName; hasMoreData = crsHasMoreData; }

---

Member Function Documentation

boolean org.objectweb.cjdbc.driver.DriverResultSet.absolute (  int  row  )  throws SQLException

JDBC 2.0 Move to an absolute row number in the result set. If row is positive, moves to an absolute row with respect to the beginning of the result set. The first row is row 1, the second is row 2, etc. If row is negative, moves to an absolute row position with respect to the end of result set. For example, calling absolute(-1) positions the cursor on the last row, absolute(-2) indicates the next-to-last row, etc. An attempt to position the cursor beyond the first/last row in the result set, leaves the cursor before/after the first/last row, respectively. Note: Calling absolute(1) is the same as calling first(). Calling absolute(-1) is the same as calling last(). Parameters: row  the row to move to Returns: true if on the result set, false if off. Exceptions: SQLException  if a database-access error occurs, or row is 0, or result set type is TYPE_FORWARD_ONLY. Definition at line 491 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.afterLast(), org.objectweb.cjdbc.driver.DriverResultSet.beforeFirst(), org.objectweb.cjdbc.driver.DriverResultSet.cancelRowUpdates(), org.objectweb.cjdbc.driver.PreparedStatement.clearParameters(), org.objectweb.cjdbc.driver.DriverResultSet.currentRow, org.objectweb.cjdbc.driver.DriverResultSet.first(), org.objectweb.cjdbc.driver.DriverResultSet.last(), and org.objectweb.cjdbc.driver.DriverResultSet.nbOfRows. Referenced by org.objectweb.cjdbc.driver.DriverResultSet.relative(). { checkIfClosed(); if (inserting) { insertStatement.clearParameters(); tempRow = null; inserting = false; } if (updating) cancelRowUpdates(); if (nbOfRows == 0) return false; if (row == 0) throw new SQLException("Cannot absolute position to row 0"); if (row == 1) return first(); if (row == -1) return last(); if (row > nbOfRows) { afterLast(); return false; } if (row < 0) { // adjust to reflect after end of result set int newRowPosition = nbOfRows + row + 1; if (newRowPosition <= 0) { beforeFirst(); return false; } return absolute(newRowPosition); } else { row--; // adjust for index difference currentRow = row; return true; } }

void org.objectweb.cjdbc.driver.DriverResultSet.afterLast (   )  throws SQLException

JDBC 2.0 Moves to the end of the result set, just after the last row. Has no effect if the result set contains no rows. Exceptions: SQLException  if a database-access error occurs, or result set type is TYPE_FORWARD_ONLY. Definition at line 370 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.cancelRowUpdates(), org.objectweb.cjdbc.driver.PreparedStatement.clearParameters(), org.objectweb.cjdbc.driver.DriverResultSet.currentRow, and org.objectweb.cjdbc.driver.DriverResultSet.nbOfRows. Referenced by org.objectweb.cjdbc.driver.DriverResultSet.absolute(). { checkIfClosed(); if (inserting) { insertStatement.clearParameters(); tempRow = null; inserting = false; } if (updating) cancelRowUpdates(); if (nbOfRows != 0) currentRow = nbOfRows; }

void org.objectweb.cjdbc.driver.DriverResultSet.beforeFirst (   )  throws SQLException

JDBC 2.0 Moves to the front of the result set, just before the first row. Has no effect if the result set contains no rows. Exceptions: SQLException  if a database-access error occurs, or result set type is TYPE_FORWARD_ONLY Definition at line 344 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.cancelRowUpdates(), org.objectweb.cjdbc.driver.PreparedStatement.clearParameters(), and org.objectweb.cjdbc.driver.DriverResultSet.currentRow. Referenced by org.objectweb.cjdbc.driver.DriverResultSet.absolute(). { checkIfClosed(); if (inserting) { insertStatement.clearParameters(); tempRow = null; inserting = false; } if (updating) cancelRowUpdates(); currentRow = -1; }

void org.objectweb.cjdbc.driver.DriverResultSet.cancelRowUpdates (   )  throws SQLException

JDBC 2.0 The cancelRowUpdates() method may be called after calling an updateXXX() method(s) and before calling updateRow() to rollback the updates made to a row. If no updates have been made or updateRow() has already been called, then this method has no effect. Exceptions: SQLException  if a database-access error occurs, or if called when on the insert row. Definition at line 2883 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.PreparedStatement.clearParameters(). Referenced by org.objectweb.cjdbc.driver.DriverResultSet.absolute(), org.objectweb.cjdbc.driver.DriverResultSet.afterLast(), org.objectweb.cjdbc.driver.DriverResultSet.beforeFirst(), org.objectweb.cjdbc.driver.DriverResultSet.first(), org.objectweb.cjdbc.driver.DriverResultSet.last(), org.objectweb.cjdbc.driver.DriverResultSet.next(), org.objectweb.cjdbc.driver.DriverResultSet.prev(), org.objectweb.cjdbc.driver.DriverResultSet.refreshRow(), and org.objectweb.cjdbc.driver.DriverResultSet.relative(). { checkIfClosed(); if (inserting) throw new SQLException("cancelRowUpdates cannot be " + "called when the cursor is on the insert row"); if (!updating) return; updateStatement.clearParameters(); tempRow = null; updating = false; }

void org.objectweb.cjdbc.driver.DriverResultSet.clearWarnings (   )  throws SQLException

After this call, getWarnings returns null until a new warning is reported for this ResultSet Exceptions: SQLException  if a database access error occurs Definition at line 1384 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.warnings. Referenced by org.objectweb.cjdbc.driver.DriverResultSet.next(). { warnings = null; }

void org.objectweb.cjdbc.driver.DriverResultSet.close (   )  throws SQLException

Closes the remote ResultSet if the ResultSet was streamed else just closes the ResultSet locally. Exceptions: SQLException  if a database access error occurs Definition at line 2984 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.Connection.closeRemoteResultSet(), org.objectweb.cjdbc.driver.Statement.connection, and org.objectweb.cjdbc.driver.DriverResultSet.owningStatement. Referenced by org.objectweb.cjdbc.driver.DriverResultSet.refreshRow(). { if (hasMoreData) owningStatement.connection.closeRemoteResultSet(cursorName); isClosed = true; }

void org.objectweb.cjdbc.driver.DriverResultSet.deleteRow (   )  throws SQLException

JDBC 2.0 Delete the current row from the result set and the underlying database. Cannot be called when on the insert row. Exceptions: SQLException  if a database-access error occurs, or if called when on the insert row. Definition at line 2765 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.PreparedStatement.clearParameters(), org.objectweb.cjdbc.driver.DriverResultSet.currentRow, org.objectweb.cjdbc.driver.DriverResultSet.data, org.objectweb.cjdbc.driver.PreparedStatement.executeUpdate(), org.objectweb.cjdbc.driver.DriverResultSet.findColumn(), org.objectweb.cjdbc.driver.DriverResultSet.nbOfRows, and org.objectweb.cjdbc.driver.PreparedStatement.setObject(). { checkIfClosed(); if (inserting) throw new SQLException("deleteRow cannot be called " + "when the cursor is on the insert row"); this.checkRowPos(); if (deleteStatement == null) this.buildDeleteStatement(); // Add primary key info from current row for (int i = 0; i < primaryKeyColumns.length; ++i) deleteStatement .setObject( i + 1, ((Object[]) data.get(currentRow))[findColumn(primaryKeyColumns[i]) - 1]); // Delete row from underlying database try { deleteStatement.executeUpdate(); } finally { // Clean up deleteStatement.clearParameters(); } // Delete row from this ResultSet data.remove(currentRow); nbOfRows--; // Deleting cancels all updates on the row if (updating) this.cancelRowUpdates(); }

int org.objectweb.cjdbc.driver.DriverResultSet.findColumn (  String  columnName  )  throws SQLException

Map a ResultSet column name to a ResultSet column index Parameters: columnName  the name of the column Returns: the column index Exceptions: SQLException  if a database access error occurs Definition at line 3064 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.columnNameToIndex, org.objectweb.cjdbc.driver.DriverResultSet.fields, org.objectweb.cjdbc.driver.DriverResultSet.fullColumnNameToIndex, org.objectweb.cjdbc.driver.Field.getFieldName(), and org.objectweb.cjdbc.driver.Field.getFullName(). Referenced by org.objectweb.cjdbc.driver.DriverResultSet.deleteRow(), org.objectweb.cjdbc.driver.DriverResultSet.getArray(), org.objectweb.cjdbc.driver.DriverResultSet.getAsciiStream(), org.objectweb.cjdbc.driver.DriverResultSet.getBigDecimal(), org.objectweb.cjdbc.driver.DriverResultSet.getBinaryStream(), org.objectweb.cjdbc.driver.DriverResultSet.getBlob(), org.objectweb.cjdbc.driver.DriverResultSet.getBoolean(), org.objectweb.cjdbc.driver.DriverResultSet.getByte(), org.objectweb.cjdbc.driver.DriverResultSet.getBytes(), org.objectweb.cjdbc.driver.DriverResultSet.getCharacterStream(), org.objectweb.cjdbc.driver.DriverResultSet.getClob(), org.objectweb.cjdbc.driver.DriverResultSet.getDate(), org.objectweb.cjdbc.driver.DriverResultSet.getDouble(), org.objectweb.cjdbc.driver.DriverResultSet.getFloat(), org.objectweb.cjdbc.driver.DriverResultSet.getInt(), org.objectweb.cjdbc.driver.DriverResultSet.getLong(), org.objectweb.cjdbc.driver.DriverResultSet.getObject(), org.objectweb.cjdbc.driver.DriverResultSet.getShort(), org.objectweb.cjdbc.driver.DriverResultSet.getString(), org.objectweb.cjdbc.driver.DriverResultSet.getTime(), org.objectweb.cjdbc.driver.DriverResultSet.getTimestamp(), org.objectweb.cjdbc.driver.DriverResultSet.getUnicodeStream(), org.objectweb.cjdbc.driver.DriverResultSet.refreshRow(), org.objectweb.cjdbc.driver.DriverResultSet.updateAsciiStream(), org.objectweb.cjdbc.driver.DriverResultSet.updateBigDecimal(), org.objectweb.cjdbc.driver.DriverResultSet.updateBinaryStream(), org.objectweb.cjdbc.driver.DriverResultSet.updateBoolean(), org.objectweb.cjdbc.driver.DriverResultSet.updateByte(), org.objectweb.cjdbc.driver.DriverResultSet.updateBytes(), org.objectweb.cjdbc.driver.DriverResultSet.updateCharacterStream(), org.objectweb.cjdbc.driver.DriverResultSet.updateDate(), org.objectweb.cjdbc.driver.DriverResultSet.updateDouble(), org.objectweb.cjdbc.driver.DriverResultSet.updateFloat(), org.objectweb.cjdbc.driver.DriverResultSet.updateInt(), org.objectweb.cjdbc.driver.DriverResultSet.updateLong(), org.objectweb.cjdbc.driver.DriverResultSet.updateNull(), org.objectweb.cjdbc.driver.DriverResultSet.updateObject(), org.objectweb.cjdbc.driver.DriverResultSet.updateRow(), org.objectweb.cjdbc.driver.DriverResultSet.updateShort(), org.objectweb.cjdbc.driver.DriverResultSet.updateString(), org.objectweb.cjdbc.driver.DriverResultSet.updateTime(), and org.objectweb.cjdbc.driver.DriverResultSet.updateTimestamp(). { if (columnNameToIndex == null) buildIndexMapping(); Integer index = (Integer) columnNameToIndex.get(columnName); if (index == null) index = (Integer) fullColumnNameToIndex.get(columnName); if (index != null) return index.intValue() + 1; else { // Try this inefficient way, now String columnNameUC = columnName.toUpperCase(); for (int i = 0; i < nbOfColumns; i++) { if (fields[i].getFieldName().toUpperCase().equals(columnNameUC)) return i + 1; else if (fields[i].getFullName().toUpperCase().equals(columnNameUC)) return i + 1; } throw new java.sql.SQLException("Column '" + columnName + "' not found."); } }

boolean org.objectweb.cjdbc.driver.DriverResultSet.first (   )  throws SQLException

JDBC 2.0 Moves to the first row in the result set. Returns: true if on a valid row, false if no rows in the result set. Exceptions: SQLException  if a database-access error occurs, or result set type is TYPE_FORWARD_ONLY. Definition at line 398 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.cancelRowUpdates(), org.objectweb.cjdbc.driver.PreparedStatement.clearParameters(), org.objectweb.cjdbc.driver.DriverResultSet.currentRow, and org.objectweb.cjdbc.driver.DriverResultSet.nbOfRows. Referenced by org.objectweb.cjdbc.driver.DriverResultSet.absolute(). { checkIfClosed(); if (inserting) { insertStatement.clearParameters(); tempRow = null; inserting = false; } if (updating) cancelRowUpdates(); if (nbOfRows == 0) return false; currentRow = 0; return true; }

java.sql.Array org.objectweb.cjdbc.driver.DriverResultSet.getArray (  String  colName  )  throws SQLException

JDBC 2.0 Get an array column. Parameters: colName  the column name Returns: an object representing an SQL array Exceptions: SQLException  if a database-access error occurs. Definition at line 1748 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(), and org.objectweb.cjdbc.driver.DriverResultSet.getArray(). { return getArray(findColumn(colName)); }

java.sql.Array org.objectweb.cjdbc.driver.DriverResultSet.getArray (  int  columnIndex  )  throws SQLException

JDBC 2.0 Gets an array column. Parameters: columnIndex  the first column is 1, the second is 2, ... Returns: an object representing an SQL array Exceptions: SQLException  if a database-access error occurs. Definition at line 1676 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.currentRow, and org.objectweb.cjdbc.driver.DriverResultSet.data. Referenced by org.objectweb.cjdbc.driver.DriverResultSet.getArray(). { checkRowAndColPosAndSetNullFlag(columnIndex); if (wasNullFlag) return null; if (inserting || updating) return (java.sql.Array) tempRow[columnIndex - 1]; else return (java.sql.Array) (((Object[]) data.get(currentRow))[columnIndex - 1]); }

InputStream org.objectweb.cjdbc.driver.DriverResultSet.getAsciiStream (  String  columnName  )  throws SQLException

See also: java.sql.ResultSet#getAsciiStream(java.lang.String) Definition at line 1337 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(), and org.objectweb.cjdbc.driver.DriverResultSet.getAsciiStream(). { return getAsciiStream(findColumn(columnName)); }

InputStream org.objectweb.cjdbc.driver.DriverResultSet.getAsciiStream (  int  columnIndex  )  throws SQLException

A column value can be retrieved as a stream of ASCII characters and then read in chunks from the stream. This method is particulary suitable for retrieving large LONGVARCHAR values. The JDBC driver will do any necessary conversion from the database format into ASCII. Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream. Also, a stream may return 0 for available() whether there is data available or not. Parameters: columnIndex  the first column is 1, the second is 2, ... Returns: a Java InputStream that delivers the database column value as a stream of one byte ASCII characters. If the value is SQL NULL then the result is null Exceptions: SQLException  if a database access error occurs See also: getBinaryStream(int) Definition at line 1173 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.getBinaryStream(). Referenced by org.objectweb.cjdbc.driver.DriverResultSet.getAsciiStream(). { checkRowAndColPosAndSetNullFlag(columnIndex); return getBinaryStream(columnIndex); }

BigDecimal org.objectweb.cjdbc.driver.DriverResultSet.getBigDecimal (  String  columnName  )  throws SQLException

See also: java.sql.ResultSet#getBigDecimal(java.lang.String) Definition at line 1579 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(), and org.objectweb.cjdbc.driver.DriverResultSet.getBigDecimal(). { return getBigDecimal(findColumn(columnName)); }

BigDecimal org.objectweb.cjdbc.driver.DriverResultSet.getBigDecimal (  int  columnIndex  )  throws SQLException

JDBC 2.0 Get the value of a column in the current row as a java.math.BigDecimal object. Parameters: columnIndex  the first column is 1, the second is 2, ... Returns: the column value (full precision); if the value is SQL NULL, the result is null Exceptions: SQLException  if a database-access error occurs. Definition at line 1514 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.currentRow, and org.objectweb.cjdbc.driver.DriverResultSet.data. { checkRowAndColPosAndSetNullFlag(columnIndex); if (wasNullFlag) return null; Object obj; if (inserting || updating) obj = tempRow[columnIndex - 1]; else obj = ((Object[]) data.get(currentRow))[columnIndex - 1]; if (obj instanceof BigDecimal) return (BigDecimal) obj; else if (obj instanceof Long) { return new BigDecimal(((Long) obj).longValue()); } else if (obj instanceof BigInteger) { return new BigDecimal(((BigInteger) obj)); } else if (obj instanceof Short) { return new BigDecimal(((Short) obj).shortValue()); } else if (obj instanceof Integer) { return new BigDecimal(((Integer) obj).intValue()); } else if (obj instanceof String) { return new BigDecimal((String) obj); } else if (obj instanceof Number) { // float and double have to be converted via string // othwerwise we produce errors // javadoc for BigDecimal : // Note: the results of this constructor can be somewhat unpredictable. // One might assume that new BigDecimal(.1) is exactly equal to .1, but // it is actually equal to // .1000000000000000055511151231257827021181583404541015625. This is so // because .1 cannot be represented exactly as a double (or, for that // matter, as a binary fraction of any finite length). Thus, the long // value that is being passed in to the constructor is not exactly equal // to .1, appearances nonwithstanding. // The (String) constructor, on the other hand, is perfectly // predictable: new BigDecimal(".1") is exactly equal to .1, as one // would expect. Therefore, it is generally recommended that the // (String) constructor be used in preference to this one. return new BigDecimal(obj.toString()); } else { throw new SQLException("Type " + obj.getClass().getName() + " is not compatible with BigDecimal"); } }

BigDecimal org.objectweb.cjdbc.driver.DriverResultSet.getBigDecimal (  String  columnName, int  scale )  throws SQLException

See also: java.sql.ResultSet#getBigDecimal(String, int) Deprecated: Definition at line 1296 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(), and org.objectweb.cjdbc.driver.DriverResultSet.getBigDecimal(). { return getBigDecimal(findColumn(columnName), scale); }

BigDecimal org.objectweb.cjdbc.driver.DriverResultSet.getBigDecimal (  int  columnIndex, int  scale )  throws SQLException

Get the value of a column in the current row as a java.lang.BigDecimal object Parameters: columnIndex  the first column is 1, the second is 2... scale  the number of digits to the right of the decimal Returns: the column value; if the value is SQL NULL, null Exceptions: SQLException  if a database access error occurs Deprecated: Definition at line 980 of file DriverResultSet.java. Referenced by org.objectweb.cjdbc.driver.DriverResultSet.getBigDecimal(). { BigDecimal bigDecimal = getBigDecimal(columnIndex); if (bigDecimal == null) return null; else return bigDecimal.setScale(scale); }

InputStream org.objectweb.cjdbc.driver.DriverResultSet.getBinaryStream (  String  columnName  )  throws SQLException

See also: java.sql.ResultSet#getBinaryStream(java.lang.String) Definition at line 1354 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(), and org.objectweb.cjdbc.driver.DriverResultSet.getBinaryStream(). { return getBinaryStream(findColumn(columnName)); }

InputStream org.objectweb.cjdbc.driver.DriverResultSet.getBinaryStream (  int  columnIndex  )  throws SQLException

A column value can also be retrieved as a binary strea. This method is suitable for retrieving LONGVARBINARY values. Parameters: columnIndex  the first column is 1, the second is 2... Returns: a Java InputStream that delivers the database column value as a stream of bytes. If the value is SQL NULL, then the result is null Exceptions: SQLException  if a database access error occurs See also: getAsciiStream(int) getUnicodeStream(int) Definition at line 1212 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.getBytes(). Referenced by org.objectweb.cjdbc.driver.DriverResultSet.getAsciiStream(), org.objectweb.cjdbc.driver.DriverResultSet.getBinaryStream(), and org.objectweb.cjdbc.driver.DriverResultSet.getUnicodeStream(). { checkRowAndColPosAndSetNullFlag(columnIndex); byte b[] = getBytes(columnIndex); if (b != null) return new ByteArrayInputStream(b); else return null; // SQL NULL }

java.sql.Blob org.objectweb.cjdbc.driver.DriverResultSet.getBlob (  String  colName  )  throws SQLException

JDBC 2.0 Get a BLOB column. Parameters: colName  the column name Returns: an object representing a BLOB Exceptions: SQLException  if a database-access error occurs. Definition at line 1724 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(), and org.objectweb.cjdbc.driver.DriverResultSet.getBlob(). { return getBlob(findColumn(colName)); }

java.sql.Blob org.objectweb.cjdbc.driver.DriverResultSet.getBlob (  int  columnIndex  )  throws SQLException

JDBC 2.0 Gets a BLOB column. Parameters: columnIndex  the first column is 1, the second is 2, ... Returns: an object representing a BLOB Exceptions: SQLException  if a database-access error occurs. Definition at line 1618 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.currentRow, org.objectweb.cjdbc.driver.DriverResultSet.data, and org.objectweb.cjdbc.driver.DriverResultSet.getBytes(). Referenced by org.objectweb.cjdbc.driver.DriverResultSet.getBlob(). { checkRowAndColPosAndSetNullFlag(columnIndex); if (wasNullFlag) return null; Object o; if (inserting || updating) o = tempRow[columnIndex - 1]; else o = (((Object[]) data.get(currentRow))[columnIndex - 1]); // Test if the type of the Blob is indeed a Blob else we assume these are // just bytes. if (o instanceof Blob) return (java.sql.Blob) o; else return new Blob(getBytes(columnIndex)); }

boolean org.objectweb.cjdbc.driver.DriverResultSet.getBoolean (  String  columnName  )  throws SQLException

See also: java.sql.ResultSet#getBoolean(java.lang.String) Definition at line 1239 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(), and org.objectweb.cjdbc.driver.DriverResultSet.getBoolean(). { return getBoolean(findColumn(columnName)); }

boolean org.objectweb.cjdbc.driver.DriverResultSet.getBoolean (  int  columnIndex  )  throws SQLException

Get the value of a column in the current row as a Java boolean Parameters: columnIndex  the first column is 1, the second is 2... Returns: the column value, false for SQL NULL Exceptions: SQLException  if a database access error occurs Definition at line 693 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.Statement.connection, org.objectweb.cjdbc.driver.DriverResultSet.currentRow, org.objectweb.cjdbc.driver.DriverResultSet.data, org.objectweb.cjdbc.driver.Connection.getPreparedStatementBooleanFalse(), org.objectweb.cjdbc.driver.Connection.getPreparedStatementBooleanTrue(), org.objectweb.cjdbc.driver.DriverResultSet.owningStatement, and org.objectweb.cjdbc.driver.PreparedStatement.toString(). Referenced by org.objectweb.cjdbc.driver.DriverResultSet.getBoolean(). { checkRowAndColPosAndSetNullFlag(columnIndex); if (wasNullFlag) return false; Object object; if (inserting || updating) object = tempRow[columnIndex - 1]; else object = (((Object[]) data.get(currentRow))[columnIndex - 1]); String stringVal = object.toString(); if ((stringVal != null) && (stringVal.length() > 0)) { stringVal = stringVal.toLowerCase(); // first we check the connection values to be consistent if (owningStatement.connection.getPreparedStatementBooleanTrue().equals( stringVal)) { return true; } else if (owningStatement.connection.getPreparedStatementBooleanFalse() .equals(stringVal)) { return false; } // now we check some other possible string representations of boolean else if ("t".equals(stringVal)) { return true; } else if ("f".equals(stringVal)) { return false; } else if ("true".equals(stringVal)) { return true; } else if ("false".equals(stringVal)) { return false; } else if ("1".equals(stringVal)) { return true; } else if ("0".equals(stringVal)) { return false; } else if ("y".equals(stringVal)) { return true; } else if ("n".equals(stringVal)) { return false; } else if ("yes".equals(stringVal)) { return true; } else if ("no".equals(stringVal)) { return false; } // we didn't find anything reasonable and throw an exception throw new SQLException("column value " + stringVal + " could not be converted to boolean"); } else { return false; } }

byte org.objectweb.cjdbc.driver.DriverResultSet.getByte (  int  columnIndex  )  throws SQLException

Get the value of a column in the current row as a Java byte. Parameters: columnIndex  the first column is 1, the second is 2,... Returns: the column value; 0 if SQL NULL Exceptions: SQLException  if a database access error occurs Definition at line 3657 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.currentRow, org.objectweb.cjdbc.driver.DriverResultSet.data, and org.objectweb.cjdbc.driver.Field.toString(). { checkRowAndColPosAndSetNullFlag(columnIndex); if (wasNullFlag) return 0; Object obj; if (inserting || updating) obj = tempRow[columnIndex - 1]; else obj = ((Object[]) data.get(currentRow))[columnIndex - 1]; if (obj instanceof Number) { return ((Number) obj).byteValue(); } // the object is not of type number we parse the string representation try { String string = obj.toString(); string = string.trim(); return Byte.parseByte(string); } catch (NumberFormatException e) { throw new SQLException("the value " + obj.toString() + " is not a valid byte"); } }

byte org.objectweb.cjdbc.driver.DriverResultSet.getByte (  String  columnName  )  throws SQLException

See also: java.sql.ResultSet#getByte(java.lang.String) Definition at line 1247 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(). { return getByte(findColumn(columnName)); }

byte [] org.objectweb.cjdbc.driver.DriverResultSet.getBytes (  String  columnName  )  throws SQLException

See also: java.sql.ResultSet#getBytes(java.lang.String) Definition at line 1305 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(), and org.objectweb.cjdbc.driver.DriverResultSet.getBytes(). { return getBytes(findColumn(columnName)); }

byte [] org.objectweb.cjdbc.driver.DriverResultSet.getBytes (  int  columnIndex  )  throws SQLException

Get the value of a column in the current row as a Java byte array. Be warned If the blob is huge, then you may run out of memory. Parameters: columnIndex  the first column is 1, the second is 2, ... Returns: the column value; if the value is SQL NULL, the result is null Exceptions: SQLException  if a database access error occurs Definition at line 999 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.Statement.connection, org.objectweb.cjdbc.driver.DriverResultSet.currentRow, org.objectweb.cjdbc.driver.DriverResultSet.data, org.objectweb.cjdbc.common.sql.filters.AbstractBlobFilter.decode(), org.objectweb.cjdbc.driver.Connection.getBlobFilter(), org.objectweb.cjdbc.driver.Statement.getConnection(), and org.objectweb.cjdbc.driver.DriverResultSet.owningStatement. Referenced by org.objectweb.cjdbc.driver.DriverResultSet.getBinaryStream(), org.objectweb.cjdbc.driver.DriverResultSet.getBlob(), and org.objectweb.cjdbc.driver.DriverResultSet.getBytes(). { checkRowAndColPosAndSetNullFlag(columnIndex); if (wasNullFlag) return null; Object o; if (inserting || updating) o = tempRow[columnIndex - 1]; else o = ((Object[]) data.get(currentRow))[columnIndex - 1]; byte[] tmp; if (o instanceof java.lang.String) { tmp = ((String) o).getBytes(); } else { tmp = (byte[]) o; } if (((Connection) owningStatement.getConnection()).isDriverProcessed()) return owningStatement.connection.getBlobFilter().decode(tmp); else return tmp; }

java.io.Reader org.objectweb.cjdbc.driver.DriverResultSet.getCharacterStream (  String  columnName  )  throws SQLException

See also: java.sql.ResultSet#getCharacterStream(java.lang.String) Definition at line 1499 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(), and org.objectweb.cjdbc.driver.DriverResultSet.getCharacterStream(). { return getCharacterStream(findColumn(columnName)); }

java.io.Reader org.objectweb.cjdbc.driver.DriverResultSet.getCharacterStream (  int  columnIndex  )  throws SQLException

See also: java.sql.ResultSet#getCharacterStream(int) Definition at line 1487 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.data, and org.objectweb.cjdbc.driver.DriverResultSet.getString(). Referenced by org.objectweb.cjdbc.driver.DriverResultSet.getCharacterStream(). { String s = getString(columnIndex); if (s == null) return null; char[] data = s.toCharArray(); return new java.io.CharArrayReader(data); }

java.sql.Clob org.objectweb.cjdbc.driver.DriverResultSet.getClob (  String  colName  )  throws SQLException

JDBC 2.0 Get a CLOB column. Parameters: colName  the column name Returns: an object representing a CLOB Exceptions: SQLException  if a database-access error occurs. Definition at line 1736 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(), and org.objectweb.cjdbc.driver.DriverResultSet.getClob(). { return getClob(findColumn(colName)); }

java.sql.Clob org.objectweb.cjdbc.driver.DriverResultSet.getClob (  int  columnIndex  )  throws SQLException

JDBC 2.0 Gets a CLOB column. Parameters: columnIndex  the first column is 1, the second is 2, ... Returns: an object representing a CLOB Exceptions: SQLException  if a database-access error occurs. Definition at line 1646 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.currentRow, and org.objectweb.cjdbc.driver.DriverResultSet.data. Referenced by org.objectweb.cjdbc.driver.DriverResultSet.getClob(). { checkRowAndColPosAndSetNullFlag(columnIndex); if (wasNullFlag) return null; Object o; if (inserting || updating) o = tempRow[columnIndex - 1]; else o = (((Object[]) data.get(currentRow))[columnIndex - 1]); // Test if the type of the Clob is indeed a Clob or just a String //throw new SQLException("Class:"+o.getClass()); if (o instanceof String) return new Clob((String) o); else if (o instanceof Clob) return (java.sql.Clob) o; else return new Clob(new String(o.toString())); }

int org.objectweb.cjdbc.driver.DriverResultSet.getConcurrency (   )  throws SQLException

JDBC 2.0 Return the concurrency of this result set. The concurrency used is determined by the statement that created the result set. Returns: CONCUR_READ_ONLY or CONCUR_UPDATABLE Exceptions: SQLException  if a database-access error occurs Definition at line 2973 of file DriverResultSet.java. { return resultSetConcurrency; }

String org.objectweb.cjdbc.driver.DriverResultSet.getCursorName (   )  throws SQLException

Get the name of the SQL cursor used by this ResultSet In SQL, a result table is retrieved though a cursor that is named. The current row of a result can be updated or deleted using a positioned update/delete statement that references the cursor name. JDBC supports this SQL feature by providing the name of the SQL cursor used by a ResultSet. The current row of a ResulSet is also the current row of this SQL cursor. Note: If positioned update is not supported, a java.sql.SQLException is thrown. Returns: the ResultSet's SQL cursor name. Exceptions: SQLException  if a database access error occurs Definition at line 1406 of file DriverResultSet.java. { throw new NotImplementedException("getCursorName()"); }

java.sql.Date org.objectweb.cjdbc.driver.DriverResultSet.getDate (  String  columnName, Calendar  cal )  throws SQLException

Get the value of a column in the current row as a java.sql.Date object. Use the calendar to construct an appropriate millisecond value for the Date, if the underlying database doesn't store timezone information. Parameters: columnName  is the SQL name of the column cal  the calendar to use in constructing the date Returns: the column value; if the value is SQL NULL, the result is null Exceptions: SQLException  if a database-access error occurs. Definition at line 1779 of file DriverResultSet.java. { throw new NotImplementedException("getDate(String, Calendar)"); }

java.sql.Date org.objectweb.cjdbc.driver.DriverResultSet.getDate (  int  columnIndex, Calendar  cal )  throws SQLException

JDBC 2.0 Get the value of a column in the current row as a java.sql.Date object. Use the calendar to construct an appropriate millisecond value for the Date, if the underlying database doesn't store timezone information. Parameters: columnIndex  the first column is 1, the second is 2, ... cal  the calendar to use in constructing the date Returns: the column value; if the value is SQL NULL, the result is null Exceptions: SQLException  if a database-access error occurs. Definition at line 1763 of file DriverResultSet.java. { throw new NotImplementedException("getDate(int, Calendar)"); }

java.sql.Date org.objectweb.cjdbc.driver.DriverResultSet.getDate (  String  columnName  )  throws SQLException

See also: java.sql.ResultSet#getDate(java.lang.String) Definition at line 1313 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(), and org.objectweb.cjdbc.driver.DriverResultSet.getDate(). { return getDate(findColumn(columnName)); }

java.sql.Date org.objectweb.cjdbc.driver.DriverResultSet.getDate (  int  columnIndex  )  throws SQLException

Get the value of a column in the current row as a java.sql.Date object Parameters: columnIndex  the first column is 1, the second is 2... Returns: the column value; null if SQL NULL Exceptions: SQLException  if a database access error occurs Definition at line 1035 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.currentRow, and org.objectweb.cjdbc.driver.DriverResultSet.data. Referenced by org.objectweb.cjdbc.driver.DriverResultSet.getDate(). { checkRowAndColPosAndSetNullFlag(columnIndex); if (wasNullFlag) return null; // we may be reading a timestamp column and have to convert it to date // the client is asking for the date field only, we have to make sure // hour,minutes,... are cleared String dateString; if (inserting || updating) dateString = tempRow[columnIndex - 1].toString(); else dateString = ((Object[]) data.get(currentRow))[columnIndex - 1] .toString(); if (dateString.length() == 10) return java.sql.Date.valueOf(dateString); else return java.sql.Date.valueOf(dateString.substring(0, 10)); }

double org.objectweb.cjdbc.driver.DriverResultSet.getDouble (  String  columnName  )  throws SQLException

See also: java.sql.ResultSet#getDouble(java.lang.String) Definition at line 1287 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(), and org.objectweb.cjdbc.driver.DriverResultSet.getDouble(). { return getDouble(findColumn(columnName)); }

double org.objectweb.cjdbc.driver.DriverResultSet.getDouble (  int  columnIndex  )  throws SQLException

Get the value of a column in the current row as a Java double. Parameters: columnIndex  the first column is 1, the second is 2,... Returns: the column value; 0 if SQL NULL Exceptions: SQLException  if a database access error occurs Definition at line 938 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.currentRow, org.objectweb.cjdbc.driver.DriverResultSet.data, and org.objectweb.cjdbc.driver.PreparedStatement.toString(). Referenced by org.objectweb.cjdbc.driver.DriverResultSet.getDouble(). { checkRowAndColPosAndSetNullFlag(columnIndex); if (wasNullFlag) return 0; Object obj; if (inserting || updating) obj = tempRow[columnIndex - 1]; else obj = ((Object[]) data.get(currentRow))[columnIndex - 1]; if (obj instanceof Number) { return ((Number) obj).doubleValue(); } // the object is not of type number we parse the string representation try { String string = obj.toString(); string = string.trim(); return Double.parseDouble(string); } catch (NumberFormatException e) { throw new SQLException("the value " + obj.toString() + " is not a valid double number"); } }

int org.objectweb.cjdbc.driver.DriverResultSet.getFetchDirection (   )  throws SQLException

JDBC 2.0 Return the fetch direction for this result set. Returns: the fetch direction Exceptions: SQLException  if a database-access error occurs Definition at line 624 of file DriverResultSet.java. { return fetchDirection; }

int org.objectweb.cjdbc.driver.DriverResultSet.getFetchSize (   )  throws SQLException

JDBC 2.0 Return the fetch size for this result set. Returns: the fetch size Exceptions: SQLException  if a database-access error occurs Definition at line 655 of file DriverResultSet.java. { return fetchSize; }

float org.objectweb.cjdbc.driver.DriverResultSet.getFloat (  String  columnName  )  throws SQLException

See also: java.sql.ResultSet#getFloat(java.lang.String) Definition at line 1279 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(), and org.objectweb.cjdbc.driver.DriverResultSet.getFloat(). { return getFloat(findColumn(columnName)); }

float org.objectweb.cjdbc.driver.DriverResultSet.getFloat (  int  columnIndex  )  throws SQLException

Get the value of a column in the current row as a Java float. Parameters: columnIndex  the first column is 1, the second is 2,... Returns: the column value; 0 if SQL NULL Exceptions: SQLException  if a database access error occurs Definition at line 899 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.currentRow, org.objectweb.cjdbc.driver.DriverResultSet.data, and org.objectweb.cjdbc.driver.PreparedStatement.toString(). Referenced by org.objectweb.cjdbc.driver.DriverResultSet.getFloat(). { checkRowAndColPosAndSetNullFlag(columnIndex); if (wasNullFlag) return 0; Object obj; if (inserting || updating) obj = tempRow[columnIndex - 1]; else obj = ((Object[]) data.get(currentRow))[columnIndex - 1]; if (obj instanceof Number) { return ((Number) obj).floatValue(); } // the object is not of type number we parse the string representation try { String string = obj.toString(); string = string.trim(); return Float.parseFloat(string); } catch (NumberFormatException e) { throw new SQLException("the value " + obj.toString() + " is not a valid float number"); } }

int org.objectweb.cjdbc.driver.DriverResultSet.getInt (  String  columnName  )  throws SQLException

See also: java.sql.ResultSet#getInt(java.lang.String) Definition at line 1263 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(), and org.objectweb.cjdbc.driver.DriverResultSet.getInt(). { return getInt(findColumn(columnName)); }

int org.objectweb.cjdbc.driver.DriverResultSet.getInt (  int  columnIndex  )  throws SQLException

Get the value of a column in the current row as a Java int. Parameters: columnIndex  the first column is 1, the second is 2,... Returns: the column value; 0 if SQL NULL Exceptions: SQLException  if a database access error occurs Definition at line 821 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.currentRow, org.objectweb.cjdbc.driver.DriverResultSet.data, and org.objectweb.cjdbc.driver.PreparedStatement.toString(). Referenced by org.objectweb.cjdbc.driver.DriverResultSet.getInt(). { checkRowAndColPosAndSetNullFlag(columnIndex); if (wasNullFlag) return 0; Object obj; if (inserting || updating) obj = tempRow[columnIndex - 1]; else obj = ((Object[]) data.get(currentRow))[columnIndex - 1]; if (obj instanceof Number) { return ((Number) obj).intValue(); } // the object is not of type number we parse the string representation try { String string = obj.toString(); string = string.trim(); return Integer.parseInt(string); } catch (NumberFormatException e) { throw new SQLException("the value " + obj.toString() + " is not a valid int number"); } }

long org.objectweb.cjdbc.driver.DriverResultSet.getLong (  String  columnName  )  throws SQLException

See also: java.sql.ResultSet#getLong(java.lang.String) Definition at line 1271 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(), and org.objectweb.cjdbc.driver.DriverResultSet.getLong(). { return getLong(findColumn(columnName)); }

long org.objectweb.cjdbc.driver.DriverResultSet.getLong (  int  columnIndex  )  throws SQLException

Get the value of a column in the current row as a Java long. Parameters: columnIndex  the first column is 1, the second is 2,... Returns: the column value; 0 if SQL NULL Exceptions: SQLException  if a database access error occurs Definition at line 860 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.currentRow, org.objectweb.cjdbc.driver.DriverResultSet.data, and org.objectweb.cjdbc.driver.PreparedStatement.toString(). Referenced by org.objectweb.cjdbc.driver.DriverResultSet.getLong(). { checkRowAndColPosAndSetNullFlag(columnIndex); if (wasNullFlag) return 0; Object obj; if (inserting || updating) obj = tempRow[columnIndex - 1]; else obj = ((Object[]) data.get(currentRow))[columnIndex - 1]; if (obj instanceof Number) { return ((Number) obj).longValue(); } // the object is not of type number we parse the string representation try { String string = obj.toString(); string = string.trim(); return Long.parseLong(string); } catch (NumberFormatException e) { throw new SQLException("the value " + obj.toString() + " is not a valid long number"); } }

java.sql.ResultSetMetaData org.objectweb.cjdbc.driver.DriverResultSet.getMetaData (   )  throws SQLException

The numbers, types and properties of a ResultSet's columns are provided by the getMetaData method Returns: a description of the ResultSet's columns Exceptions: SQLException  if a database access error occurs Definition at line 3051 of file DriverResultSet.java. { return new ResultSetMetaData(this); }

Object org.objectweb.cjdbc.driver.DriverResultSet.getObject (  String  colName, java.util.Map  map )  throws SQLException

JDBC 2.0 Returns the value of column as a Java object. Use the map to determine the class from which to construct data of SQL structured and distinct types. Parameters: colName  the column name map  the mapping from SQL type names to Java classes Returns: an object representing the SQL value Exceptions: SQLException  if a database-access error occurs. Definition at line 1699 of file DriverResultSet.java. { throw new NotImplementedException("getObject(String, java.util.Map)"); }

Object org.objectweb.cjdbc.driver.DriverResultSet.getObject (  int  i, java.util.Map  map )  throws SQLException

JDBC 2.0 Returns the value of column as a Java object. Use the map to determine the class from which to construct data of SQL structured and distinct types. Parameters: i  the first column is 1, the second is 2, ... map  the mapping from SQL type names to Java classes Returns: an object representing the SQL value Exceptions: SQLException  if a database-access error occurs. Definition at line 1594 of file DriverResultSet.java. { throw new NotImplementedException("getObject(int, java.util.Map)"); }

Object org.objectweb.cjdbc.driver.DriverResultSet.getObject (  String  columnName  )  throws SQLException

Get the value of a column in the current row as a Java object This method will return the value of the given column as a Java object. The type of the Java object will be the default Java Object type corresponding to the column's SQL type, following the mapping specified in the JDBC specification. This method may also be used to read database specific abstract data types. Parameters: columnName  is the SQL name of the column Returns: a Object holding the column value Exceptions: SQLException  if a database access error occurs Definition at line 1477 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(), and org.objectweb.cjdbc.driver.DriverResultSet.getObject(). { return getObject(findColumn(columnName)); }

Object org.objectweb.cjdbc.driver.DriverResultSet.getObject (  int  columnIndex  )  throws SQLException

Get the value of a column in the current row as a Java object This method will return the value of the given column as a Java object. The type of the Java object will be the default Java Object type corresponding to the column's SQL type, following the mapping specified in the JDBC specification. This method may also be used to read database specific abstract data types. Parameters: columnIndex  the first column is 1, the second is 2... Returns: a Object holding the column value Exceptions: SQLException  if a database access error occurs Definition at line 1425 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.Statement.connection, org.objectweb.cjdbc.driver.DriverResultSet.currentRow, org.objectweb.cjdbc.driver.DriverResultSet.data, org.objectweb.cjdbc.common.sql.filters.AbstractBlobFilter.decode(), org.objectweb.cjdbc.driver.Connection.getBlobFilter(), and org.objectweb.cjdbc.driver.DriverResultSet.owningStatement. Referenced by org.objectweb.cjdbc.driver.DriverResultSet.getObject(). { checkRowAndColPosAndSetNullFlag(columnIndex); if (wasNullFlag) return null; Object o; if (inserting || updating) o = tempRow[columnIndex]; else o = ((Object[]) data.get(currentRow))[columnIndex - 1]; if (o instanceof byte[]) { try { byte[] b = owningStatement.connection.getBlobFilter() .decode((byte[]) o); return new ObjectInputStream(new ByteArrayInputStream(b)).readObject(); } catch (ClassNotFoundException e) { e.printStackTrace(); throw new SQLException("Missing class while deserializing Blob" + e); } catch (IOException e) { e.printStackTrace(); throw new SQLException("IOException while deserializing Blob" + e); } } else { return o; } }

java.sql.Ref org.objectweb.cjdbc.driver.DriverResultSet.getRef (  String  colName  )  throws SQLException

JDBC 2.0 Get a REF(<structured-type>) column. Parameters: colName  the column name Returns: an object representing data of an SQL REF type Exceptions: SQLException  if a database-access error occurs. Definition at line 1712 of file DriverResultSet.java. { throw new NotImplementedException("getRef(String)"); }

java.sql.Ref org.objectweb.cjdbc.driver.DriverResultSet.getRef (  int  i  )  throws SQLException

JDBC 2.0 Get a REF(<structured-type>) column. Parameters: i  the first column is 1, the second is 2, ... Returns: an object representing data of an SQL REF type Exceptions: SQLException  if a database-access error occurs. Definition at line 1606 of file DriverResultSet.java. { throw new NotImplementedException("getRef"); }

int org.objectweb.cjdbc.driver.DriverResultSet.getRow (   )  throws SQLException

JDBC 2.0 Determine the current row number. The first row is number 1, the second number 2, etc. Returns: the current row number, else return 0 if there is no current row Exceptions: SQLException  if a database-access error occurs. Definition at line 459 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.currentRow, and org.objectweb.cjdbc.driver.DriverResultSet.nbOfRows. { checkIfClosed(); if (currentRow < 0 || currentRow >= nbOfRows || nbOfRows == 0) return 0; else return currentRow + 1; }

short org.objectweb.cjdbc.driver.DriverResultSet.getShort (  String  columnName  )  throws SQLException

See also: java.sql.ResultSet#getShort(java.lang.String) Definition at line 1255 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(), and org.objectweb.cjdbc.driver.DriverResultSet.getShort(). { return getShort(findColumn(columnName)); }

short org.objectweb.cjdbc.driver.DriverResultSet.getShort (  int  columnIndex  )  throws SQLException

Get the value of a column in the current row as a Java short. Parameters: columnIndex  the first column is 1, the second is 2,... Returns: the column value; 0 if SQL NULL Exceptions: SQLException  if a database access error occurs Definition at line 782 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.currentRow, org.objectweb.cjdbc.driver.DriverResultSet.data, and org.objectweb.cjdbc.driver.PreparedStatement.toString(). Referenced by org.objectweb.cjdbc.driver.DriverResultSet.getShort(). { checkRowAndColPosAndSetNullFlag(columnIndex); if (wasNullFlag) return 0; Object obj; if (inserting || updating) obj = tempRow[columnIndex - 1]; else obj = ((Object[]) data.get(currentRow))[columnIndex - 1]; if (obj instanceof Number) { return ((Number) obj).shortValue(); } // the object is not of type number we parse the string representation try { String string = obj.toString(); string = string.trim(); return Short.parseShort(string); } catch (NumberFormatException e) { throw new SQLException("the value " + obj.toString() + " is not a valid short number"); } }

java.sql.Statement org.objectweb.cjdbc.driver.DriverResultSet.getStatement (   )  throws SQLException

JDBC 2.0 Return the Statement that produced the ResultSet. Returns: the Statement that produced the ResultSet, or null if the result was produced some other way. Exceptions: SQLException  if a database-access error occurs Definition at line 3015 of file DriverResultSet.java. { return owningStatement; }

String org.objectweb.cjdbc.driver.DriverResultSet.getString (  String  columnName  )  throws SQLException

The following routines simply convert the columnName into a columnIndex and then call the appropriate routine above. Parameters: columnName  is the SQL name of the column Returns: the column value Exceptions: SQLException  if a database access error occurs Definition at line 1231 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(). { return this.getString(findColumn(columnName)); }

String org.objectweb.cjdbc.driver.DriverResultSet.getString (  int  columnIndex  )  throws SQLException

Get the value of a column in the current row as a Java String Parameters: columnIndex  the first column is 1, the second is 2... Returns: the column value, null for SQL NULL Exceptions: SQLException  if a database access error occurs Definition at line 673 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.currentRow, org.objectweb.cjdbc.driver.DriverResultSet.data, and org.objectweb.cjdbc.driver.PreparedStatement.toString(). Referenced by org.objectweb.cjdbc.driver.DriverResultSet.getCharacterStream(). { checkRowAndColPosAndSetNullFlag(columnIndex); if (wasNullFlag) return null; if (inserting || updating) return tempRow[columnIndex - 1].toString(); else return (((Object[]) data.get(currentRow))[columnIndex - 1]).toString(); }

java.sql.Time org.objectweb.cjdbc.driver.DriverResultSet.getTime (  String  columnName, Calendar  cal )  throws SQLException

Get the value of a column in the current row as a java.sql.Time object. Use the calendar to construct an appropriate millisecond value for the Time, if the underlying database doesn't store timezone information. Parameters: columnName  is the SQL name of the column cal  the calendar to use in constructing the time Returns: the column value; if the value is SQL NULL, the result is null Exceptions: SQLException  if a database-access error occurs. Definition at line 1811 of file DriverResultSet.java. { throw new NotImplementedException("getTime(String, Calendar)"); }

java.sql.Time org.objectweb.cjdbc.driver.DriverResultSet.getTime (  int  columnIndex, Calendar  cal )  throws SQLException

Get the value of a column in the current row as a java.sql.Time object. Use the calendar to construct an appropriate millisecond value for the Time, if the underlying database doesn't store timezone information. Parameters: columnIndex  the first column is 1, the second is 2, ... cal  the calendar to use in constructing the time Returns: the column value; if the value is SQL NULL, the result is null Exceptions: SQLException  if a database-access error occurs. Definition at line 1795 of file DriverResultSet.java. { throw new NotImplementedException("getTime(int, Calendar)"); }

Time org.objectweb.cjdbc.driver.DriverResultSet.getTime (  String  columnName  )  throws SQLException

See also: java.sql.ResultSet#getTime(java.lang.String) Definition at line 1321 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(), and org.objectweb.cjdbc.driver.DriverResultSet.getTime(). { return getTime(findColumn(columnName)); }

Time org.objectweb.cjdbc.driver.DriverResultSet.getTime (  int  columnIndex  )  throws SQLException

Get the value of a column in the current row as a java.sql.Time object Parameters: columnIndex  the first column is 1, the second is 2... Returns: the column value; null if SQL NULL Exceptions: SQLException  if a database access error occurs Definition at line 1065 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.currentRow, and org.objectweb.cjdbc.driver.DriverResultSet.data. Referenced by org.objectweb.cjdbc.driver.DriverResultSet.getTime(). { checkRowAndColPosAndSetNullFlag(columnIndex); if (wasNullFlag) return null; Object obj; if (inserting || updating) obj = tempRow[columnIndex - 1]; else obj = ((Object[]) data.get(currentRow))[columnIndex - 1]; if (obj instanceof java.util.Date) { java.util.Date time = (java.util.Date) obj; // the driver returns the format of the column, but we are asking for // the time values only. String timeString = time.toString(); if (timeString.length() == 8) { // ok we have got a timefield of the format HH:mm:ss, exactly the way // we need it, no further processing is required return new Time(time.getTime()); } // we have got the date fields too and have to clear the year, month and // date field Calendar cal = Calendar.getInstance(); cal.setTime(time); cal.clear(Calendar.YEAR); cal.clear(Calendar.MONTH); cal.clear(Calendar.DATE); cal.clear(Calendar.MILLISECOND); return new Time(cal.getTimeInMillis()); } // the object is not of type date we parse the string representation try { String string = obj.toString(); string = string.trim(); return Time.valueOf(string); } catch (IllegalArgumentException e) { throw new SQLException("the value " + obj.toString() + " is not a valid time"); } }

java.sql.Timestamp org.objectweb.cjdbc.driver.DriverResultSet.getTimestamp (  String  columnName, Calendar  cal )  throws SQLException

Get the value of a column in the current row as a java.sql.Timestamp object. Use the calendar to construct an appropriate millisecond value for the Timestamp, if the underlying database doesn't store timezone information. Parameters: columnName  is the SQL name of the column cal  the calendar to use in constructing the timestamp Returns: the column value; if the value is SQL NULL, the result is null Exceptions: SQLException  if a database-access error occurs. Definition at line 1845 of file DriverResultSet.java. { throw new NotImplementedException("getTimestamp(String, Calendar)"); }

java.sql.Timestamp org.objectweb.cjdbc.driver.DriverResultSet.getTimestamp (  int  columnIndex, Calendar  cal )  throws SQLException

Get the value of a column in the current row as a java.sql.Timestamp object. Use the calendar to construct an appropriate millisecond value for the Timestamp, if the underlying database doesn't store timezone information. Parameters: columnIndex  the first column is 1, the second is 2, ... cal  the calendar to use in constructing the timestamp Returns: the column value; if the value is SQL NULL, the result is null Exceptions: SQLException  if a database-access error occurs. Definition at line 1828 of file DriverResultSet.java. { throw new NotImplementedException("getTimestamp(int, Calendar)"); }

Timestamp org.objectweb.cjdbc.driver.DriverResultSet.getTimestamp (  String  columnName  )  throws SQLException

See also: java.sql.ResultSet#getTimestamp(java.lang.String) Definition at line 1329 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(), and org.objectweb.cjdbc.driver.DriverResultSet.getTimestamp(). { return getTimestamp(findColumn(columnName)); }

Timestamp org.objectweb.cjdbc.driver.DriverResultSet.getTimestamp (  int  columnIndex  )  throws SQLException

Get the value of a column in the current row as a java.sql.Timestamp object Parameters: columnIndex  the first column is 1, the second is 2... Returns: the column value; null if SQL NULL Exceptions: SQLException  if a database access error occurs Definition at line 1123 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.currentRow, and org.objectweb.cjdbc.driver.DriverResultSet.data. Referenced by org.objectweb.cjdbc.driver.DriverResultSet.getTimestamp(). { checkRowAndColPosAndSetNullFlag(columnIndex); if (wasNullFlag) return null; Object obj; if (inserting || updating) obj = tempRow[columnIndex - 1]; else obj = ((Object[]) data.get(currentRow))[columnIndex - 1]; if (obj instanceof java.util.Date) { return new Timestamp(((java.util.Date) obj).getTime()); } // the object is not of type timestamp we parse the string representation try { String string = obj.toString(); string = string.trim(); return Timestamp.valueOf(string); } catch (IllegalArgumentException e) { throw new SQLException("the value " + obj.toString() + " is not a valid timestamp"); } }

int org.objectweb.cjdbc.driver.DriverResultSet.getType (   )  throws SQLException

JDBC 2.0 Return the type of this result set. The type is determined based on the statement that created the result set. Returns: TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, or TYPE_SCROLL_SENSITIVE Exceptions: SQLException  if a database-access error occurs Definition at line 2960 of file DriverResultSet.java. { return resultSetType; }

InputStream org.objectweb.cjdbc.driver.DriverResultSet.getUnicodeStream (  String  columnName  )  throws SQLException

See also: java.sql.ResultSet#getUnicodeStream(String) Deprecated: Definition at line 1346 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(), and org.objectweb.cjdbc.driver.DriverResultSet.getUnicodeStream(). { return getUnicodeStream(findColumn(columnName)); }

InputStream org.objectweb.cjdbc.driver.DriverResultSet.getUnicodeStream (  int  columnIndex  )  throws SQLException

A column value can also be retrieved as a stream of Unicode characters. We implement this as a binary stream. Parameters: columnIndex  the first column is 1, the second is 2... Returns: a Java InputStream that delivers the database column value as a stream of two byte Unicode characters. If the value is SQL NULL, then the result is null Exceptions: SQLException  if a database access error occurs Deprecated: See also: getAsciiStream getBinaryStream(int) Definition at line 1193 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.getBinaryStream(). Referenced by org.objectweb.cjdbc.driver.DriverResultSet.getUnicodeStream(). { checkRowAndColPosAndSetNullFlag(columnIndex); return getBinaryStream(columnIndex); }

java.net.URL org.objectweb.cjdbc.driver.DriverResultSet.getURL (  String  columnName  )  throws SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL object in the Java programming language. Parameters: columnName  the SQL name of the column Returns: the column value as a java.net.URL object; if the value is SQL NULL, the value returned is null in the Java programming language Exceptions: SQLException  if a database access error occurs or if a URL is malformed Since: JDK 1.4 Definition at line 3505 of file DriverResultSet.java. { throw new NotImplementedException("getURL"); }

java.net.URL org.objectweb.cjdbc.driver.DriverResultSet.getURL (  int  columnIndex  )  throws SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL object in the Java programming language. Parameters: columnIndex  the index of the column 1 is the first, 2 is the second,... Returns: the column value as a java.net.URL object; if the value is SQL NULL, the value returned is null in the Java programming language Exceptions: SQLException  if a database access error occurs, or if a URL is malformed Since: JDK 1.4 Definition at line 3487 of file DriverResultSet.java. { throw new NotImplementedException("getURL"); }

java.sql.SQLWarning org.objectweb.cjdbc.driver.DriverResultSet.getWarnings (   )  throws SQLException

The first warning reported by calls on this ResultSet is returned. Subsequent ResultSet warnings will be chained to this java.sql.SQLWarning. The warning chain is automatically cleared each time a new row is read. Note: This warning chain only covers warnings caused by ResultSet methods. Any warnings caused by statement methods (such as reading OUT parameters) will be chained on the Statement object. Returns: the first java.sql.SQLWarning or null; Exceptions: SQLException  if a database access error occurs. Definition at line 1372 of file DriverResultSet.java. { return warnings; }

void org.objectweb.cjdbc.driver.DriverResultSet.insertRow (   )  throws SQLException

JDBC 2.0 Insert the contents of the insert row into the result set and the database. Must be on the insert row when this method is called. Exceptions: SQLException  if a database-access error occurs, if called when not on the insert row, or if all non-nullable columns in the insert row have not been given a value Definition at line 2687 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.PreparedStatement.clearParameters(), org.objectweb.cjdbc.driver.DriverResultSet.data, org.objectweb.cjdbc.driver.PreparedStatement.executeUpdate(), and org.objectweb.cjdbc.driver.DriverResultSet.nbOfRows. { checkIfClosed(); if (!inserting) throw new SQLException("insertRow cannot be called " + "when the cursor is not on the insert row"); // Insert row in underlying database try { insertStatement.executeUpdate(); } finally { // Clean up insertStatement.clearParameters(); } // Insert row in this ResultSet if (data == null) data = new ArrayList(); data.add(tempRow); nbOfRows++; // Prepare for a new insert tempRow = new Object[nbOfColumns]; }

boolean org.objectweb.cjdbc.driver.DriverResultSet.isAfterLast (   )  throws SQLException

JDBC 2.0 Determine if the cursor is after the last row in the result set. Returns: true if after the last row, false otherwise. Returns false when the result set contains no rows. Exceptions: SQLException  if a database-access error occurs. Definition at line 287 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.currentRow, and org.objectweb.cjdbc.driver.DriverResultSet.nbOfRows. { checkIfClosed(); if (nbOfRows == 0) return false; else return (currentRow >= nbOfRows); }

boolean org.objectweb.cjdbc.driver.DriverResultSet.isBeforeFirst (   )  throws SQLException

JDBC 2.0. Determine if the cursor is before the first row in the result set. Returns: true if before the first row, false otherwise. Returns false when the result set contains no rows. Exceptions: SQLException  if a database-access error occurs. Definition at line 268 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.currentRow, and org.objectweb.cjdbc.driver.DriverResultSet.nbOfRows. { checkIfClosed(); if (nbOfRows == 0) return false; else return (currentRow == -1); }

boolean org.objectweb.cjdbc.driver.DriverResultSet.isFirst (   )  throws SQLException

JDBC 2.0 Determine if the cursor is on the first row of the result set. Returns: true if on the first row, false otherwise. Exceptions: SQLException  if a database-access error occurs. Definition at line 305 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.currentRow, and org.objectweb.cjdbc.driver.DriverResultSet.nbOfRows. { checkIfClosed(); if (nbOfRows == 0) return false; else return (currentRow == 0); }

boolean org.objectweb.cjdbc.driver.DriverResultSet.isLast (   )  throws SQLException

JDBC 2.0 Determine if the cursor is on the last row of the result set. Note: Calling isLast() may be expensive since the JDBC driver might need to fetch ahead one row in order to determine whether the current row is the last row in the result set. Returns: true if on the last row, false otherwise. Exceptions: SQLException  if a database-access error occurs. Definition at line 326 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.currentRow, and org.objectweb.cjdbc.driver.DriverResultSet.nbOfRows. { checkIfClosed(); if (nbOfRows == 0) return false; else return (currentRow == nbOfRows - 1); }

boolean org.objectweb.cjdbc.driver.DriverResultSet.last (   )  throws SQLException

JDBC 2.0 Moves to the last row in the result set. Returns: true if on a valid row, false if no rows in the result set. Exceptions: SQLException  if a database-access error occurs, or result set type is TYPE_FORWARD_ONLY. Definition at line 429 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.cancelRowUpdates(), org.objectweb.cjdbc.driver.PreparedStatement.clearParameters(), org.objectweb.cjdbc.driver.DriverResultSet.currentRow, and org.objectweb.cjdbc.driver.DriverResultSet.nbOfRows. Referenced by org.objectweb.cjdbc.driver.DriverResultSet.absolute(). { checkIfClosed(); if (inserting) { insertStatement.clearParameters(); tempRow = null; inserting = false; } if (updating) cancelRowUpdates(); if (nbOfRows == 0) return false; currentRow = nbOfRows - 1; return true; }

void org.objectweb.cjdbc.driver.DriverResultSet.moveToCurrentRow (   )  throws SQLException

JDBC 2.0 Move the cursor to the remembered cursor position, usually the current row. Has no effect unless the cursor is on the insert row. Exceptions: SQLException  if a database-access error occurs, or the result set is not updatable Definition at line 2934 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.PreparedStatement.clearParameters(). { checkIfClosed(); if (!inserting) return; insertStatement.clearParameters(); tempRow = null; inserting = false; }

void org.objectweb.cjdbc.driver.DriverResultSet.moveToInsertRow (   )  throws SQLException

JDBC 2.0 Move to the insert row. The current cursor position is remembered while the cursor is positioned on the insert row. The insert row is a special row associated with an updatable result set. It is essentially a buffer where a new row may be constructed by calling the updateXXX() methods prior to inserting the row into the result set. Only the updateXXX(), getXXX(), and insertRow() methods may be called when the cursor is on the insert row. All of the columns in a result set must be given a value each time this method is called before calling insertRow(). UpdateXXX()must be called before getXXX() on a column. Exceptions: SQLException  if a database-access error occurs, or the result set is not updatable Definition at line 2913 of file DriverResultSet.java. { checkIfClosed(); if (inserting) return; if (insertStatement == null) this.buildInsertStatement(); tempRow = new Object[nbOfColumns]; inserting = true; }

boolean org.objectweb.cjdbc.driver.DriverResultSet.next (   )  throws java.sql.SQLException

A ResultSet is initially positioned before its first row, the first call to next makes the first row the current row; the second call makes the second row the current row, etc. If an input stream from the previous row is open, it is implicitly closed. The ResultSet's warning chain is cleared when a new row is read Returns: true if the new current is valid; false if there are no more rows Exceptions: java.sql.SQLException  if a database access error occurs Definition at line 178 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.cancelRowUpdates(), org.objectweb.cjdbc.driver.PreparedStatement.clearParameters(), org.objectweb.cjdbc.driver.DriverResultSet.clearWarnings(), org.objectweb.cjdbc.driver.Statement.connection, org.objectweb.cjdbc.driver.DriverResultSet.currentRow, org.objectweb.cjdbc.driver.DriverResultSet.data, org.objectweb.cjdbc.driver.Connection.fetchNextData(), org.objectweb.cjdbc.driver.DriverResultSet.fetchSize, org.objectweb.cjdbc.driver.DriverResultSet.nbOfRows, and org.objectweb.cjdbc.driver.DriverResultSet.owningStatement. { checkIfClosed(); if (inserting) { insertStatement.clearParameters(); tempRow = null; inserting = false; } if (updating) cancelRowUpdates(); if (nbOfRows == 0) return false; if (currentRow + 1 >= nbOfRows) { if (hasMoreData) { owningStatement.connection.fetchNextData(cursorName, fetchSize, this); currentRow = 0; if (data == null) { nbOfRows = 0; return false; } else { nbOfRows = data.size(); return true; } } // force scroll past end currentRow = nbOfRows; return false; } clearWarnings(); currentRow++; return true; }

boolean org.objectweb.cjdbc.driver.DriverResultSet.prev (   )  throws SQLException

The prev method is not part of JDBC, but because of the architecture of this driver it is possible to move both forward and backward within the result set. If an input stream from the previous row is open, it is implicitly closed. The ResultSet's warning chain is cleared when a new row is read Returns: true if the new current is valid; false if there are no more rows Exceptions: SQLException  if a database access error occurs Definition at line 235 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.cancelRowUpdates(), org.objectweb.cjdbc.driver.PreparedStatement.clearParameters(), and org.objectweb.cjdbc.driver.DriverResultSet.currentRow. Referenced by org.objectweb.cjdbc.driver.DriverResultSet.previous(). { checkIfClosed(); if (inserting) { insertStatement.clearParameters(); tempRow = null; inserting = false; } if (updating) cancelRowUpdates(); if (currentRow - 1 >= 0) { currentRow--; return true; } return false; }

boolean org.objectweb.cjdbc.driver.DriverResultSet.previous (   )  throws SQLException

JDBC 2.0 Moves to the previous row in the result set. Note: previous() is not the same as relative(-1) since it makes sense to call previous() when there is no current row. Returns: true if on a valid row, false if off the result set. Exceptions: SQLException  if a database-access error occurs, or result set type is TYPE_FORWAR_DONLY. Definition at line 593 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.prev(). { return prev(); }

void org.objectweb.cjdbc.driver.DriverResultSet.refreshRow (   )  throws SQLException

JDBC 2.0 Refresh the value of the current row with its current value in the database. Cannot be called when on the insert row. The refreshRow() method provides a way for an application to explicitly tell the JDBC driver to refetch a row(s) from the database. An application may want to call refreshRow() when caching or prefetching is being done by the JDBC driver to fetch the latest value of a row from the database. The JDBC driver may actually refresh multiple rows at once if the fetch size is greater than one. All values are refetched subject to the transaction isolation level and cursor sensitivity. If refreshRow() is called after calling updateXXX(), but before calling updateRow() then the updates made to the row are lost. Calling refreshRow() frequently will likely slow performance. Exceptions: SQLException  if a database-access error occurs, or if called when on the insert row. Definition at line 2821 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.cancelRowUpdates(), org.objectweb.cjdbc.driver.PreparedStatement.clearParameters(), org.objectweb.cjdbc.driver.DriverResultSet.close(), org.objectweb.cjdbc.driver.DriverResultSet.currentRow, org.objectweb.cjdbc.driver.DriverResultSet.data, org.objectweb.cjdbc.driver.PreparedStatement.executeQuery(), org.objectweb.cjdbc.driver.DriverResultSet.findColumn(), org.objectweb.cjdbc.driver.PreparedStatement.set(), and org.objectweb.cjdbc.driver.PreparedStatement.setObject(). { checkIfClosed(); if (inserting) throw new SQLException("refreshRow cannot be called " + "when the cursor is on the insert row"); this.checkRowPos(); if (refreshStatement == null) this.buildRefreshStatement(); // Add primary key info from current row for (int i = 0; i < primaryKeyColumns.length; ++i) refreshStatement .setObject( i + 1, ((Object[]) data.get(currentRow))[findColumn(primaryKeyColumns[i]) - 1]); // Retrieve row from underlying database DriverResultSet res; try { res = (DriverResultSet) refreshStatement.executeQuery(); } finally { // Clean up refreshStatement.clearParameters(); } // Refresh row in this ResultSet try { data.set(currentRow, res.data.get(0)); } catch (NullPointerException e) { throw new SQLException("The current row has been " + "removed from the database"); } finally { // Clean up res.close(); } // Refreshing cancels all updates on the row if (updating) this.cancelRowUpdates(); }

boolean org.objectweb.cjdbc.driver.DriverResultSet.relative (  int  rows  )  throws SQLException

JDBC 2.0 Moves a relative number of rows, either positive or negative. Attempting to move beyond the first/last row in the result set positions the cursor before/after the the first/last row. Calling relative(0) is valid, but does not change the cursor position. Note: Calling relative(1) is different than calling next() since is makes sense to call next() when there is no current row, for example, when the cursor is positioned before the first row or after the last row of the result set. Parameters: rows  the number of rows Returns: true if on a row, false otherwise. Exceptions: SQLException  if a database-access error occurs, or there is no current row, or result set type is TYPE_FORWARD_ONLY. Definition at line 561 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.absolute(), org.objectweb.cjdbc.driver.DriverResultSet.cancelRowUpdates(), org.objectweb.cjdbc.driver.PreparedStatement.clearParameters(), org.objectweb.cjdbc.driver.DriverResultSet.currentRow, and org.objectweb.cjdbc.driver.DriverResultSet.nbOfRows. { checkIfClosed(); if (inserting) { insertStatement.clearParameters(); tempRow = null; inserting = false; } if (updating) cancelRowUpdates(); if (nbOfRows == 0) return false; return absolute(currentRow + rows + 1); }

boolean org.objectweb.cjdbc.driver.DriverResultSet.rowDeleted (   )  throws SQLException

JDBC 2.0 Determine if this row has been deleted. A deleted row may leave a visible "hole" in a result set. This method can be used to detect holes in a result set. The value returned depends on whether or not the result set can detect deletions. Returns: true if deleted and deletes are detected Exceptions: SQLException  if a database-access error occurs See also: DatabaseMetaData.deletesAreDetected Definition at line 1892 of file DriverResultSet.java. { throw new NotImplementedException("rowDeleted"); }

boolean org.objectweb.cjdbc.driver.DriverResultSet.rowInserted (   )  throws SQLException

JDBC 2.0 Determine if the current row has been inserted. The value returned depends on whether or not the result set can detect visible inserts. Returns: true if inserted and inserts are detected Exceptions: SQLException  if a database-access error occurs See also: DatabaseMetaData.insertsAreDetected Definition at line 1877 of file DriverResultSet.java. { throw new NotImplementedException("rowInserted"); }

boolean org.objectweb.cjdbc.driver.DriverResultSet.rowUpdated (   )  throws SQLException

JDBC 2.0 Determine if the current row has been updated. The value returned depends on whether or not the result set can detect updates. Returns: true if the row has been visibly updated by the owner or another, and updates are detected Exceptions: SQLException  if a database-access error occurs See also: DatabaseMetaData.updatesAreDetected Definition at line 1864 of file DriverResultSet.java. { throw new NotImplementedException("rowUpdated"); }

void org.objectweb.cjdbc.driver.DriverResultSet.setData (  ArrayList  newData  )  [protected]

Set the ResultSet data with the given ArrayList. This function is used by the ResultSet streaming feature. Note that metadata (currentRow, nbOfRows, ...) are not updated. Parameters: newData  new ResultSet data Definition at line 3028 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.data. { data = newData; }

void org.objectweb.cjdbc.driver.DriverResultSet.setFetchDirection (  int  direction  )  throws SQLException

JDBC 2.0 Give a hint as to the direction in which the rows in this result set will be processed. The initial value is determined by the statement that produced the result set. The fetch direction may be changed at any time. Parameters: direction  the fetch direction Exceptions: SQLException  if a database-access error occurs, or the result set type is TYPE_FORWARD_ONLY and direction is not FETCH_FORWARD. MM.MySQL actually ignores this, because it has the whole result set anyway, so the direction is immaterial. Definition at line 610 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.fetchDirection. { if (direction != FETCH_FORWARD && direction != FETCH_REVERSE) throw new SQLException("Illegal value for fetch direction"); else fetchDirection = direction; }

void org.objectweb.cjdbc.driver.DriverResultSet.setFetchSize (  int  rows  )  throws SQLException

JDBC 2.0 Give the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this result set. If the fetch size specified is zero, then the JDBC driver ignores the value, and is free to make its own best guess as to what the fetch size should be. The default value is set by the statement that creates the result set. The fetch size may be changed at any time. Parameters: rows  the number of rows to fetch Exceptions: SQLException  if a database-access error occurs, or the condition 0 <= rows <= this.getMaxRows() is not satisfied. Currently ignored by this driver. Definition at line 642 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.fetchSize. { if (rows < 0 || rows > nbOfRows) throw new SQLException("Value must be between 0 and getMaxRows()"); fetchSize = rows; }

void org.objectweb.cjdbc.driver.DriverResultSet.setHasMoreData (  boolean  hasMore  )  [protected]

Set the hasMoreData boolean (is there more data to fetch from the controller). This function is used by the ResultSet streaming feature. Parameters: hasMore  new value for hasMoreData Definition at line 3039 of file DriverResultSet.java. { hasMoreData = hasMore; }

void org.objectweb.cjdbc.driver.DriverResultSet.setStatement (  Statement  stmt  )  throws SQLException [protected]

Set the statement. Parameters: stmt  The statement to set Exceptions: SQLException  if an error occurs Definition at line 3142 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.fetchSize, org.objectweb.cjdbc.driver.Statement.getFetchSize(), org.objectweb.cjdbc.driver.Statement.getResultSetConcurrency(), org.objectweb.cjdbc.driver.Statement.getResultSetType(), org.objectweb.cjdbc.driver.DriverResultSet.owningStatement, org.objectweb.cjdbc.driver.DriverResultSet.resultSetConcurrency, and org.objectweb.cjdbc.driver.DriverResultSet.resultSetType. { owningStatement = stmt; fetchSize = stmt.getFetchSize(); resultSetConcurrency = stmt.getResultSetConcurrency(); resultSetType = stmt.getResultSetType(); }

String org.objectweb.cjdbc.driver.DriverResultSet.toString (   )

See also: java.lang.Object#toString() Definition at line 3692 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.currentRow, and org.objectweb.cjdbc.driver.DriverResultSet.nbOfRows. { return nbOfRows + " rows - " + nbOfColumns + " columns - current row:" + currentRow + " - hasMoreData:" + hasMoreData + " - isClosed:" + isClosed; }

void org.objectweb.cjdbc.driver.DriverResultSet.updateArray (  String  columnName, java.sql.Array  x )  throws SQLException

Updates the designated column with a java.sql.Array value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database. Parameters: columnName  the name of the column x  the new column value Exceptions: SQLException  if a database access error occurs Since: JDK 1.4 Definition at line 3644 of file DriverResultSet.java. { throw new NotImplementedException("updateArray"); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateArray (  int  columnIndex, java.sql.Array  x )  throws SQLException

Updates the designated column with a java.sql.Array value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database. Parameters: columnIndex  the first column is 1, the second is 2, ... x  the new column value Exceptions: SQLException  if a database access error occurs Since: JDK 1.4 Definition at line 3626 of file DriverResultSet.java. { throw new NotImplementedException("updateArray"); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateAsciiStream (  String  columnName, java.io.InputStream  x, int  length )  throws SQLException

JDBC 2.0 Update a column with an ascii stream value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnName  the name of the column x  the new column value length  of the stream Exceptions: SQLException  if a database-access error occurs Definition at line 2605 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(). { this.updateAsciiStream(findColumn(columnName), x, length); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateAsciiStream (  int  columnIndex, java.io.InputStream  x, int  length )  throws SQLException

JDBC 2.0 Update a column with an ascii stream value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnIndex  the first column is 1, the second is 2, ... x  the new column value length  the length of the stream Exceptions: SQLException  if a database-access error occurs Definition at line 2262 of file DriverResultSet.java. { this.updateBinaryStream(columnIndex, x, length); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateBigDecimal (  String  columnName, BigDecimal  x )  throws SQLException

JDBC 2.0 Update a column with a BigDecimal value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnName  the name of the column x  the new column value Exceptions: SQLException  if a database-access error occurs Definition at line 2510 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(). { this.updateBigDecimal(findColumn(columnName), x); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateBigDecimal (  int  columnIndex, BigDecimal  x )  throws SQLException

JDBC 2.0 Update a column with a BigDecimal value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnIndex  the first column is 1, the second is 2, ... x  the new column value Exceptions: SQLException  if a database-access error occurs Definition at line 2109 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.PreparedStatement.setBigDecimal(). { checkIfClosed(); if (inserting) insertStatement.setBigDecimal(columnIndex, x); else { checkUpdateFlagAndPrepareUpdateIfNeeded(); updateStatement.setBigDecimal(columnIndex, x); } tempRow[columnIndex - 1] = x; }

void org.objectweb.cjdbc.driver.DriverResultSet.updateBinaryStream (  String  columnName, java.io.InputStream  x, int  length )  throws SQLException

JDBC 2.0 Update a column with a binary stream value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnName  the name of the column x  the new column value length  of the stream Exceptions: SQLException  if a database-access error occurs Definition at line 2622 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(). { this.updateBinaryStream(findColumn(columnName), x, length); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateBinaryStream (  int  columnIndex, java.io.InputStream  x, int  length )  throws SQLException

JDBC 2.0 Update a column with a binary stream value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnIndex  the first column is 1, the second is 2, ... x  the new column value length  the length of the stream Exceptions: SQLException  if a database-access error occurs Definition at line 2279 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.data. { checkIfClosed(); byte[] data = new byte[length]; try { x.read(data, 0, length); } catch (Exception ioe) { throw new SQLException("Problem with streaming of data"); } this.updateBytes(columnIndex, data); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateBlob (  String  columnName, java.sql.Blob  x )  throws SQLException

Updates the designated column with a java.sql.Blob value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database. Parameters: columnName  the name of the column x  the new column value Exceptions: SQLException  if a database access error occurs Since: JDK 1.4 Definition at line 3573 of file DriverResultSet.java. { throw new NotImplementedException("updateBlob"); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateBlob (  int  columnIndex, java.sql.Blob  x )  throws SQLException

Updates the designated column with a java.sql.Blob value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database. Parameters: columnIndex  the first column is 1, the second is 2, ... x  the new column value Exceptions: SQLException  if a database access error occurs Since: JDK 1.4 Definition at line 3556 of file DriverResultSet.java. { throw new NotImplementedException("updateBlob"); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateBoolean (  String  columnName, boolean  x )  throws SQLException

JDBC 2.0 Update a column with a boolean value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnName  the name of the column x  the new column value Exceptions: SQLException  if a database-access error occurs Definition at line 2405 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(). { this.updateBoolean(findColumn(columnName), x); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateBoolean (  int  columnIndex, boolean  x )  throws SQLException

JDBC 2.0 Update a column with a boolean value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnIndex  the first column is 1, the second is 2, ... x  the new column value Exceptions: SQLException  if a database-access error occurs Definition at line 1934 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.PreparedStatement.setBoolean(). { checkIfClosed(); if (inserting) insertStatement.setBoolean(columnIndex, x); else { checkUpdateFlagAndPrepareUpdateIfNeeded(); updateStatement.setBoolean(columnIndex, x); } tempRow[columnIndex - 1] = Boolean.valueOf(x); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateByte (  String  columnName, byte  x )  throws SQLException

JDBC 2.0 Update a column with a byte value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnName  the name of the column x  the new column value Exceptions: SQLException  if a database-access error occurs Definition at line 2420 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(). { this.updateByte(findColumn(columnName), x); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateByte (  int  columnIndex, byte  x )  throws SQLException

JDBC 2.0 Update a column with a byte value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnIndex  the first column is 1, the second is 2, ... x  the new column value Exceptions: SQLException  if a database-access error occurs Definition at line 1959 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.PreparedStatement.setByte(). { checkIfClosed(); if (inserting) insertStatement.setByte(columnIndex, x); else { checkUpdateFlagAndPrepareUpdateIfNeeded(); updateStatement.setByte(columnIndex, x); } tempRow[columnIndex - 1] = new Byte(x); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateBytes (  String  columnName, byte  x[] )  throws SQLException

JDBC 2.0 Update a column with a byte array value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnName  the name of the column x  the new column value Exceptions: SQLException  if a database-access error occurs Definition at line 2541 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(). { this.updateBytes(findColumn(columnName), x); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateBytes (  int  columnIndex, byte  x[] )  throws SQLException

JDBC 2.0 Update a column with a byte array value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnIndex  the first column is 1, the second is 2, ... x  the new column value Exceptions: SQLException  if a database-access error occurs Definition at line 2160 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.PreparedStatement.setBytes(). { checkIfClosed(); if (inserting) insertStatement.setBytes(columnIndex, x); else { checkUpdateFlagAndPrepareUpdateIfNeeded(); updateStatement.setBytes(columnIndex, x); } tempRow[columnIndex - 1] = x; }

void org.objectweb.cjdbc.driver.DriverResultSet.updateCharacterStream (  String  columnName, java.io.Reader  reader, int  length )  throws SQLException

JDBC 2.0 Update a column with a character stream value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnName  the name of the column reader  the stream length  of the stream Exceptions: SQLException  if a database-access error occurs Definition at line 2639 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(). { this.updateCharacterStream(findColumn(columnName), reader, length); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateCharacterStream (  int  columnIndex, java.io.Reader  x, int  length )  throws SQLException

JDBC 2.0 Update a column with a character stream value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnIndex  the first column is 1, the second is 2, ... x  the new column value length  the length of the stream Exceptions: SQLException  if a database-access error occurs Definition at line 2308 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.data. { checkIfClosed(); char[] data = new char[length]; try { x.read(data, 0, length); } catch (Exception ioe) { throw new SQLException("Problem with streaming of data"); } this.updateString(columnIndex, new String(data)); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateClob (  String  columnName, java.sql.Clob  x )  throws SQLException

Updates the designated column with a java.sql.Clob value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database. Parameters: columnName  the name of the column x  the new column value Exceptions: SQLException  if a database access error occurs Since: JDK 1.4 Definition at line 3608 of file DriverResultSet.java. { throw new NotImplementedException("updateClob"); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateClob (  int  columnIndex, java.sql.Clob  x )  throws SQLException

Updates the designated column with a java.sql.Clob value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database. Parameters: columnIndex  the first column is 1, the second is 2, ... x  the new column value Exceptions: SQLException  if a database access error occurs Since: JDK 1.4 Definition at line 3591 of file DriverResultSet.java. { throw new NotImplementedException("updateClob"); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateDate (  String  columnName, java.sql.Date  x )  throws SQLException

JDBC 2.0 Update a column with a Date value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnName  the name of the column x  the new column value Exceptions: SQLException  if a database-access error occurs Definition at line 2556 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(). { this.updateDate(findColumn(columnName), x); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateDate (  int  columnIndex, java.sql.Date  x )  throws SQLException

JDBC 2.0 Update a column with a Date value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnIndex  the first column is 1, the second is 2, ... x  the new column value Exceptions: SQLException  if a database-access error occurs Definition at line 2185 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.PreparedStatement.setDate(). { checkIfClosed(); if (inserting) insertStatement.setDate(columnIndex, x); else { checkUpdateFlagAndPrepareUpdateIfNeeded(); updateStatement.setDate(columnIndex, x); } tempRow[columnIndex - 1] = x; }

void org.objectweb.cjdbc.driver.DriverResultSet.updateDouble (  String  columnName, double  x )  throws SQLException

JDBC 2.0 Update a column with a double value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnName  the name of the column x  the new column value Exceptions: SQLException  if a database-access error occurs Definition at line 2495 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(). { this.updateDouble(findColumn(columnName), x); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateDouble (  int  columnIndex, double  x )  throws SQLException

JDBC 2.0 Update a column with a Double value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnIndex  the first column is 1, the second is 2, ... x  the new column value Exceptions: SQLException  if a database-access error occurs Definition at line 2084 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.PreparedStatement.setDouble(). { checkIfClosed(); if (inserting) insertStatement.setDouble(columnIndex, x); else { checkUpdateFlagAndPrepareUpdateIfNeeded(); updateStatement.setDouble(columnIndex, x); } tempRow[columnIndex - 1] = new Double(x); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateFloat (  String  columnName, float  x )  throws SQLException

JDBC 2.0 Update a column with a float value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnName  the name of the column x  the new column value Exceptions: SQLException  if a database-access error occurs Definition at line 2480 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(). { this.updateFloat(findColumn(columnName), x); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateFloat (  int  columnIndex, float  x )  throws SQLException

JDBC 2.0 Update a column with a float value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnIndex  the first column is 1, the second is 2, ... x  the new column value Exceptions: SQLException  if a database-access error occurs Definition at line 2059 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.PreparedStatement.setFloat(). { checkIfClosed(); if (inserting) insertStatement.setFloat(columnIndex, x); else { checkUpdateFlagAndPrepareUpdateIfNeeded(); updateStatement.setFloat(columnIndex, x); } tempRow[columnIndex - 1] = new Float(x); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateInt (  String  columnName, int  x )  throws SQLException

JDBC 2.0 Update a column with an integer value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnName  the name of the column x  the new column value Exceptions: SQLException  if a database-access error occurs Definition at line 2450 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(). { this.updateInt(findColumn(columnName), x); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateInt (  int  columnIndex, int  x )  throws SQLException

JDBC 2.0 Update a column with an integer value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnIndex  the first column is 1, the second is 2, ... x  the new column value Exceptions: SQLException  if a database-access error occurs Definition at line 2009 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.PreparedStatement.setInt(). { checkIfClosed(); if (inserting) insertStatement.setInt(columnIndex, x); else { checkUpdateFlagAndPrepareUpdateIfNeeded(); updateStatement.setInt(columnIndex, x); } tempRow[columnIndex - 1] = new Integer(x); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateLong (  String  columnName, long  x )  throws SQLException

JDBC 2.0 Update a column with a long value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnName  the name of the column x  the new column value Exceptions: SQLException  if a database-access error occurs Definition at line 2465 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(). { this.updateLong(findColumn(columnName), x); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateLong (  int  columnIndex, long  x )  throws SQLException

JDBC 2.0 Update a column with a long value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnIndex  the first column is 1, the second is 2, ... x  the new column value Exceptions: SQLException  if a database-access error occurs Definition at line 2034 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.PreparedStatement.setLong(). { checkIfClosed(); if (inserting) insertStatement.setLong(columnIndex, x); else { checkUpdateFlagAndPrepareUpdateIfNeeded(); updateStatement.setLong(columnIndex, x); } tempRow[columnIndex - 1] = new Long(x); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateNull (  String  columnName  )  throws SQLException

JDBC 2.0 Update a column with a null value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnName  the name of the column Exceptions: SQLException  if a database-access error occurs Definition at line 2390 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(). { this.updateNull(findColumn(columnName)); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateNull (  int  columnIndex  )  throws SQLException

JDBC 2.0 Give a nullable column a null value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnIndex  the first column is 1, the second is 2, ... Exceptions: SQLException  if a database-access error occurs Definition at line 1906 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.fields, and org.objectweb.cjdbc.driver.PreparedStatement.setNull(). { checkIfClosed(); if (inserting) insertStatement .setNull(columnIndex, fields[columnIndex - 1].getSqlType()); else { checkUpdateFlagAndPrepareUpdateIfNeeded(); updateStatement .setNull(columnIndex, fields[columnIndex - 1].getSqlType()); } tempRow[columnIndex - 1] = null; }

void org.objectweb.cjdbc.driver.DriverResultSet.updateObject (  String  columnName, Object  x )  throws SQLException

JDBC 2.0 Update a column with an Object value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnName  the name of the column x  the new column value Exceptions: SQLException  if a database-access error occurs Definition at line 2674 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(). { this.updateObject(findColumn(columnName), x); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateObject (  String  columnName, Object  x, int  scale )  throws SQLException

JDBC 2.0 Update a column with an Object value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnName  the name of the column x  the new column value scale  For java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types this is the number of digits after the decimal. For all other types this value will be ignored. Exceptions: SQLException  if a database-access error occurs Definition at line 2658 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(). { this.updateObject(findColumn(columnName), x, scale); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateObject (  int  columnIndex, Object  x )  throws SQLException

JDBC 2.0 Update a column with an Object value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnIndex  the first column is 1, the second is 2, ... x  the new column value Exceptions: SQLException  if a database-access error occurs Definition at line 2365 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.PreparedStatement.setObject(). { checkIfClosed(); if (inserting) insertStatement.setObject(columnIndex, x); else { checkUpdateFlagAndPrepareUpdateIfNeeded(); updateStatement.setObject(columnIndex, x); } tempRow[columnIndex - 1] = x; }

void org.objectweb.cjdbc.driver.DriverResultSet.updateObject (  int  columnIndex, Object  x, int  scale )  throws SQLException

JDBC 2.0 Update a column with an Object value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnIndex  the first column is 1, the second is 2, ... x  the new column value scale  For java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types this is the number of digits after the decimal. For all other types this value will be ignored. Exceptions: SQLException  if a database-access error occurs Definition at line 2339 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.PreparedStatement.setObject(). { checkIfClosed(); if (inserting) insertStatement.setObject(columnIndex, x, scale); else { checkUpdateFlagAndPrepareUpdateIfNeeded(); updateStatement.setObject(columnIndex, x, scale); } tempRow[columnIndex - 1] = x; }

void org.objectweb.cjdbc.driver.DriverResultSet.updateRef (  String  columnName, java.sql.Ref  x )  throws SQLException

Updates the designated column with a java.sql.Ref value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database. Parameters: columnName  the name of the column x  the new column value Exceptions: SQLException  if a database access error occurs Since: JDK 1.4 Definition at line 3539 of file DriverResultSet.java. { throw new NotImplementedException("updateRef"); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateRef (  int  columnIndex, java.sql.Ref  x )  throws SQLException

Updates the designated column with a java.sql.Ref value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database. Parameters: columnIndex  the first column is 1, the second is 2, ... x  the new column value Exceptions: SQLException  if a database access error occurs Since: JDK 1.4 Definition at line 3522 of file DriverResultSet.java. { throw new NotImplementedException("updateRef"); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateRow (   )  throws SQLException

JDBC 2.0 Update the underlying database with the new contents of the current row. Cannot be called when on the insert row. Exceptions: SQLException  if a database-access error occurs, or if called when on the insert row Definition at line 2723 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.PreparedStatement.clearParameters(), org.objectweb.cjdbc.driver.DriverResultSet.currentRow, org.objectweb.cjdbc.driver.DriverResultSet.data, org.objectweb.cjdbc.driver.PreparedStatement.executeUpdate(), org.objectweb.cjdbc.driver.DriverResultSet.findColumn(), org.objectweb.cjdbc.driver.DriverResultSet.nbOfColumns, org.objectweb.cjdbc.driver.PreparedStatement.set(), and org.objectweb.cjdbc.driver.PreparedStatement.setObject(). { checkIfClosed(); if (inserting) throw new SQLException("updateRow cannot be called " + "when the cursor is on the insert row"); if (!updating) return; // Add primary key info from current row for (int i = 0; i < primaryKeyColumns.length; ++i) updateStatement.setObject(nbOfColumns + i + 1, ((Object[]) data .get(currentRow))[findColumn(primaryKeyColumns[i]) - 1]); // Update row in underlying database try { updateStatement.executeUpdate(); } finally { // Clean up updateStatement.clearParameters(); } // Update row in this ResultSet data.set(currentRow, tempRow); // Clean up tempRow = null; updating = false; }

void org.objectweb.cjdbc.driver.DriverResultSet.updateShort (  String  columnName, short  x )  throws SQLException

JDBC 2.0 Update a column with a short value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnName  the name of the column x  the new column value Exceptions: SQLException  if a database-access error occurs Definition at line 2435 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(). { this.updateShort(findColumn(columnName), x); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateShort (  int  columnIndex, short  x )  throws SQLException

JDBC 2.0 Update a column with a short value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnIndex  the first column is 1, the second is 2, ... x  the new column value Exceptions: SQLException  if a database-access error occurs Definition at line 1984 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.PreparedStatement.setShort(). { checkIfClosed(); if (inserting) insertStatement.setShort(columnIndex, x); else { checkUpdateFlagAndPrepareUpdateIfNeeded(); updateStatement.setShort(columnIndex, x); } tempRow[columnIndex - 1] = new Short(x); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateString (  String  columnName, String  x )  throws SQLException

JDBC 2.0 Update a column with a String value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnName  the name of the column x  the new column value Exceptions: SQLException  if a database-access error occurs Definition at line 2526 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(). { this.updateString(findColumn(columnName), x); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateString (  int  columnIndex, String  x )  throws SQLException

JDBC 2.0 Update a column with a String value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnIndex  the first column is 1, the second is 2, ... x  the new column value Exceptions: SQLException  if a database-access error occurs Definition at line 2135 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.PreparedStatement.setString(). { checkIfClosed(); if (inserting) insertStatement.setString(columnIndex, x); else { checkUpdateFlagAndPrepareUpdateIfNeeded(); updateStatement.setString(columnIndex, x); } tempRow[columnIndex - 1] = x; }

void org.objectweb.cjdbc.driver.DriverResultSet.updateTime (  String  columnName, java.sql.Time  x )  throws SQLException

JDBC 2.0 Update a column with a Time value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnName  the name of the column x  the new column value Exceptions: SQLException  if a database-access error occurs Definition at line 2572 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(). { this.updateTime(findColumn(columnName), x); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateTime (  int  columnIndex, java.sql.Time  x )  throws SQLException

JDBC 2.0 Update a column with a Time value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnIndex  the first column is 1, the second is 2, ... x  the new column value Exceptions: SQLException  if a database-access error occurs Definition at line 2210 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.PreparedStatement.setTime(). { checkIfClosed(); if (inserting) insertStatement.setTime(columnIndex, x); else { checkUpdateFlagAndPrepareUpdateIfNeeded(); updateStatement.setTime(columnIndex, x); } tempRow[columnIndex - 1] = x; }

void org.objectweb.cjdbc.driver.DriverResultSet.updateTimestamp (  String  columnName, java.sql.Timestamp  x )  throws SQLException

JDBC 2.0 Update a column with a Timestamp value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnName  the name of the column x  the new column value Exceptions: SQLException  if a database-access error occurs Definition at line 2588 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.DriverResultSet.findColumn(). { this.updateTimestamp(findColumn(columnName), x); }

void org.objectweb.cjdbc.driver.DriverResultSet.updateTimestamp (  int  columnIndex, java.sql.Timestamp  x )  throws SQLException

JDBC 2.0 Update a column with a Timestamp value. The updateXXX() methods are used to update column values in the current row, or the insert row. The updateXXX() methods do not update the underlying database, instead the updateRow() or insertRow() methods are called to update the database. Parameters: columnIndex  the first column is 1, the second is 2, ... x  the new column value Exceptions: SQLException  if a database-access error occurs Definition at line 2235 of file DriverResultSet.java. References org.objectweb.cjdbc.driver.PreparedStatement.setTimestamp(). { checkIfClosed(); if (inserting) insertStatement.setTimestamp(columnIndex, x); else { checkUpdateFlagAndPrepareUpdateIfNeeded(); updateStatement.setTimestamp(columnIndex, x); } tempRow[columnIndex - 1] = x; }

boolean org.objectweb.cjdbc.driver.DriverResultSet.wasNull (   )  throws SQLException

A column may have the value of SQL NULL; wasNull() reports whether the last column read had this special value. Note that you must first call getXXX on a column to try to read its value and then call wasNull() to find if the value was SQL NULL Returns: true if the last column read was SQL NULL Exceptions: SQLException  if a database access error occurred Definition at line 3001 of file DriverResultSet.java. { return wasNullFlag; }

---

Member Data Documentation

transient Hashtable org.objectweb.cjdbc.driver.DriverResultSet.columnNameToIndex = null [protected]

column name -> index in ResultSet data array Definition at line 125 of file DriverResultSet.java. Referenced by org.objectweb.cjdbc.driver.DriverResultSet.findColumn().

int org.objectweb.cjdbc.driver.DriverResultSet.currentRow = -1 [protected]

Cursor to current row Definition at line 104 of file DriverResultSet.java. Referenced by org.objectweb.cjdbc.driver.DriverResultSet.absolute(), org.objectweb.cjdbc.driver.DriverResultSet.afterLast(), org.objectweb.cjdbc.driver.DriverResultSet.beforeFirst(), org.objectweb.cjdbc.driver.DriverResultSet.deleteRow(), org.objectweb.cjdbc.driver.DriverResultSet.DriverResultSet(), org.objectweb.cjdbc.driver.DriverResultSet.first(), org.objectweb.cjdbc.driver.DriverResultSet.getArray(), org.objectweb.cjdbc.driver.DriverResultSet.getBigDecimal(), org.objectweb.cjdbc.driver.DriverResultSet.getBlob(), org.objectweb.cjdbc.driver.DriverResultSet.getBoolean(), org.objectweb.cjdbc.driver.DriverResultSet.getByte(), org.objectweb.cjdbc.driver.DriverResultSet.getBytes(), org.objectweb.cjdbc.driver.DriverResultSet.getClob(), org.objectweb.cjdbc.driver.DriverResultSet.getDate(), org.objectweb.cjdbc.driver.DriverResultSet.getDouble(), org.objectweb.cjdbc.driver.DriverResultSet.getFloat(), org.objectweb.cjdbc.driver.DriverResultSet.getInt(), org.objectweb.cjdbc.driver.DriverResultSet.getLong(), org.objectweb.cjdbc.driver.DriverResultSet.getObject(), org.objectweb.cjdbc.driver.DriverResultSet.getRow(), org.objectweb.cjdbc.driver.DriverResultSet.getShort(), org.objectweb.cjdbc.driver.DriverResultSet.getString(), org.objectweb.cjdbc.driver.DriverResultSet.getTime(), org.objectweb.cjdbc.driver.DriverResultSet.getTimestamp(), org.objectweb.cjdbc.driver.DriverResultSet.isAfterLast(), org.objectweb.cjdbc.driver.DriverResultSet.isBeforeFirst(), org.objectweb.cjdbc.driver.DriverResultSet.isFirst(), org.objectweb.cjdbc.driver.DriverResultSet.isLast(), org.objectweb.cjdbc.driver.DriverResultSet.last(), org.objectweb.cjdbc.driver.DriverResultSet.next(), org.objectweb.cjdbc.driver.DriverResultSet.prev(), org.objectweb.cjdbc.driver.DriverResultSet.refreshRow(), org.objectweb.cjdbc.driver.DriverResultSet.relative(), org.objectweb.cjdbc.driver.DriverResultSet.toString(), and org.objectweb.cjdbc.driver.DriverResultSet.updateRow().

ArrayList org.objectweb.cjdbc.driver.DriverResultSet.data [protected]

The results Definition at line 110 of file DriverResultSet.java. Referenced by org.objectweb.cjdbc.driver.DriverResultSet.deleteRow(), org.objectweb.cjdbc.driver.DriverResultSet.DriverResultSet(), org.objectweb.cjdbc.driver.DriverResultSet.getArray(), org.objectweb.cjdbc.driver.DriverResultSet.getBigDecimal(), org.objectweb.cjdbc.driver.DriverResultSet.getBlob(), org.objectweb.cjdbc.driver.DriverResultSet.getBoolean(), org.objectweb.cjdbc.driver.DriverResultSet.getByte(), org.objectweb.cjdbc.driver.DriverResultSet.getBytes(), org.objectweb.cjdbc.driver.DriverResultSet.getCharacterStream(), org.objectweb.cjdbc.driver.DriverResultSet.getClob(), org.objectweb.cjdbc.driver.DriverResultSet.getDate(), org.objectweb.cjdbc.driver.DriverResultSet.getDouble(), org.objectweb.cjdbc.driver.DriverResultSet.getFloat(), org.objectweb.cjdbc.driver.DriverResultSet.getInt(), org.objectweb.cjdbc.driver.DriverResultSet.getLong(), org.objectweb.cjdbc.driver.DriverResultSet.getObject(), org.objectweb.cjdbc.driver.DriverResultSet.getShort(), org.objectweb.cjdbc.driver.DriverResultSet.getString(), org.objectweb.cjdbc.driver.DriverResultSet.getTime(), org.objectweb.cjdbc.driver.DriverResultSet.getTimestamp(), org.objectweb.cjdbc.driver.DriverResultSet.insertRow(), org.objectweb.cjdbc.driver.DriverResultSet.next(), org.objectweb.cjdbc.driver.DriverResultSet.refreshRow(), org.objectweb.cjdbc.driver.DriverResultSet.setData(), org.objectweb.cjdbc.driver.DriverResultSet.updateBinaryStream(), org.objectweb.cjdbc.driver.DriverResultSet.updateCharacterStream(), and org.objectweb.cjdbc.driver.DriverResultSet.updateRow().

int org.objectweb.cjdbc.driver.DriverResultSet.fetchDirection = FETCH_FORWARD [protected]

The fetch direction (not used yet) Definition at line 114 of file DriverResultSet.java. Referenced by org.objectweb.cjdbc.driver.DriverResultSet.setFetchDirection().

int org.objectweb.cjdbc.driver.DriverResultSet.fetchSize = 0 [protected]

The fetch size Definition at line 116 of file DriverResultSet.java. Referenced by org.objectweb.cjdbc.driver.DriverResultSet.next(), org.objectweb.cjdbc.driver.DriverResultSet.setFetchSize(), and org.objectweb.cjdbc.driver.DriverResultSet.setStatement().

Field [] org.objectweb.cjdbc.driver.DriverResultSet.fields [protected]

The fields Definition at line 121 of file DriverResultSet.java. Referenced by org.objectweb.cjdbc.driver.DriverResultSet.findColumn(), org.objectweb.cjdbc.driver.ResultSetMetaData.getColumnClassName(), org.objectweb.cjdbc.driver.ResultSetMetaData.getColumnDisplaySize(), org.objectweb.cjdbc.driver.ResultSetMetaData.getColumnLabel(), org.objectweb.cjdbc.driver.ResultSetMetaData.getColumnName(), org.objectweb.cjdbc.driver.ResultSetMetaData.getColumnType(), org.objectweb.cjdbc.driver.ResultSetMetaData.getColumnTypeName(), org.objectweb.cjdbc.driver.ResultSetMetaData.getPrecision(), org.objectweb.cjdbc.driver.ResultSetMetaData.getScale(), org.objectweb.cjdbc.driver.ResultSetMetaData.getSchemaName(), org.objectweb.cjdbc.driver.ResultSetMetaData.getTableName(), org.objectweb.cjdbc.driver.ResultSetMetaData.isAutoIncrement(), org.objectweb.cjdbc.driver.ResultSetMetaData.isCaseSensitive(), org.objectweb.cjdbc.driver.ResultSetMetaData.isCurrency(), org.objectweb.cjdbc.driver.ResultSetMetaData.isDefinitelyWritable(), org.objectweb.cjdbc.driver.ResultSetMetaData.isNullable(), org.objectweb.cjdbc.driver.ResultSetMetaData.isReadOnly(), org.objectweb.cjdbc.driver.ResultSetMetaData.isSearchable(), org.objectweb.cjdbc.driver.ResultSetMetaData.isSigned(), org.objectweb.cjdbc.driver.ResultSetMetaData.isWritable(), and org.objectweb.cjdbc.driver.DriverResultSet.updateNull().

transient Hashtable org.objectweb.cjdbc.driver.DriverResultSet.fullColumnNameToIndex = null [protected]

full column name -> index in ResultSet data array Definition at line 127 of file DriverResultSet.java. Referenced by org.objectweb.cjdbc.driver.DriverResultSet.findColumn().

int org.objectweb.cjdbc.driver.DriverResultSet.nbOfColumns = -1 [protected]

Number of columns Definition at line 108 of file DriverResultSet.java. Referenced by org.objectweb.cjdbc.driver.DriverResultSet.DriverResultSet(), org.objectweb.cjdbc.driver.ResultSetMetaData.getCatalogName(), org.objectweb.cjdbc.driver.ResultSetMetaData.getColumnClassName(), org.objectweb.cjdbc.driver.ResultSetMetaData.getColumnCount(), org.objectweb.cjdbc.driver.ResultSetMetaData.getColumnDisplaySize(), org.objectweb.cjdbc.driver.ResultSetMetaData.getColumnLabel(), org.objectweb.cjdbc.driver.ResultSetMetaData.getColumnName(), org.objectweb.cjdbc.driver.ResultSetMetaData.getColumnType(), org.objectweb.cjdbc.driver.ResultSetMetaData.getColumnTypeName(), org.objectweb.cjdbc.driver.ResultSetMetaData.getPrecision(), org.objectweb.cjdbc.driver.ResultSetMetaData.getScale(), org.objectweb.cjdbc.driver.ResultSetMetaData.getSchemaName(), org.objectweb.cjdbc.driver.ResultSetMetaData.getTableName(), org.objectweb.cjdbc.driver.ResultSetMetaData.isAutoIncrement(), org.objectweb.cjdbc.driver.ResultSetMetaData.isCaseSensitive(), org.objectweb.cjdbc.driver.ResultSetMetaData.isCurrency(), org.objectweb.cjdbc.driver.ResultSetMetaData.isDefinitelyWritable(), org.objectweb.cjdbc.driver.ResultSetMetaData.isNullable(), org.objectweb.cjdbc.driver.ResultSetMetaData.isReadOnly(), org.objectweb.cjdbc.driver.ResultSetMetaData.isSearchable(), org.objectweb.cjdbc.driver.ResultSetMetaData.isSigned(), org.objectweb.cjdbc.driver.ResultSetMetaData.isWritable(), and org.objectweb.cjdbc.driver.DriverResultSet.updateRow().

int org.objectweb.cjdbc.driver.DriverResultSet.nbOfRows = -1 [protected]

Number of rows Definition at line 106 of file DriverResultSet.java. Referenced by org.objectweb.cjdbc.driver.DriverResultSet.absolute(), org.objectweb.cjdbc.driver.DriverResultSet.afterLast(), org.objectweb.cjdbc.driver.DriverResultSet.deleteRow(), org.objectweb.cjdbc.driver.DriverResultSet.DriverResultSet(), org.objectweb.cjdbc.driver.DriverResultSet.first(), org.objectweb.cjdbc.driver.DriverResultSet.getRow(), org.objectweb.cjdbc.driver.DriverResultSet.insertRow(), org.objectweb.cjdbc.driver.DriverResultSet.isAfterLast(), org.objectweb.cjdbc.driver.DriverResultSet.isBeforeFirst(), org.objectweb.cjdbc.driver.DriverResultSet.isFirst(), org.objectweb.cjdbc.driver.DriverResultSet.isLast(), org.objectweb.cjdbc.driver.DriverResultSet.last(), org.objectweb.cjdbc.driver.DriverResultSet.next(), org.objectweb.cjdbc.driver.DriverResultSet.relative(), and org.objectweb.cjdbc.driver.DriverResultSet.toString().

transient Statement org.objectweb.cjdbc.driver.DriverResultSet.owningStatement [protected]

Statement corresponding to this ResultSet Definition at line 136 of file DriverResultSet.java. Referenced by org.objectweb.cjdbc.driver.DriverResultSet.close(), org.objectweb.cjdbc.driver.DriverResultSet.getBoolean(), org.objectweb.cjdbc.driver.DriverResultSet.getBytes(), org.objectweb.cjdbc.driver.DriverResultSet.getObject(), org.objectweb.cjdbc.driver.DriverResultSet.next(), and org.objectweb.cjdbc.driver.DriverResultSet.setStatement().

int org.objectweb.cjdbc.driver.DriverResultSet.resultSetConcurrency = 0 [protected]

Concurrency for this ResultSet Definition at line 132 of file DriverResultSet.java. Referenced by org.objectweb.cjdbc.driver.DriverResultSet.setStatement().

int org.objectweb.cjdbc.driver.DriverResultSet.resultSetType = 0 [protected]

Type of ResultSet Definition at line 130 of file DriverResultSet.java. Referenced by org.objectweb.cjdbc.driver.DriverResultSet.setStatement().

SQLWarning org.objectweb.cjdbc.driver.DriverResultSet.warnings = null [protected]

the warning chain Definition at line 134 of file DriverResultSet.java. Referenced by org.objectweb.cjdbc.driver.DriverResultSet.clearWarnings().

boolean org.objectweb.cjdbc.driver.DriverResultSet.wasNullFlag = false [protected]

for wasNull() Definition at line 123 of file DriverResultSet.java.

---

The documentation for this class was generated from the following file:

• DriverResultSet.java

---