org.apache.derby.impl.jdbc

Class EmbedResultSet20

java.lang.Object

org.apache.derby.impl.jdbc.ConnectionChild

org.apache.derby.impl.jdbc.EmbedResultSet

org.apache.derby.impl.jdbc.EmbedResultSet20

All Implemented Interfaces:

java.lang.AutoCloseable, java.lang.Comparable, java.sql.ResultSet, java.sql.Wrapper, EngineResultSet

Direct Known Subclasses:

EmbedResultSet40

public class EmbedResultSet20
extends EmbedResultSet

This class extends the EmbedResultSet class in order to support new methods and classes that come with JDBC 2.0.

Supports

• JDBC 2.0/2.1
• JDBC 3.0

See Also:

EmbedResultSet

Field Summary

Fields inherited from class org.apache.derby.impl.jdbc.EmbedResultSet

ABSOLUTE, AFTERLAST, BEFOREFIRST, fetchedRowBase, FIRST, isClosed, LAST, NEXT, order, PREVIOUS, RELATIVE, singleUseActivation, wasNull

Fields inherited from class org.apache.derby.impl.jdbc.ConnectionChild

factory, localConn

Fields inherited from interface java.sql.ResultSet

CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE

Constructor Summary

Constructors

Constructor and Description
EmbedResultSet20(EmbedConnection conn, ResultSet resultsToWrap, boolean forMetaData, EmbedStatement stmt, boolean isAtomic) This class provides the glue between the Derby resultset and the JDBC resultset, mapping calls-to-calls.

Method Summary

Methods

Modifier and Type	Method and Description
java.sql.Array	getArray(int i) JDBC 2.0 Get an array column.
java.sql.Array	getArray(java.lang.String colName) JDBC 2.0 Get an array column.
java.math.BigDecimal	getBigDecimal(int columnIndex)
java.math.BigDecimal	getBigDecimal(int columnIndex, int scale) Deprecated.
java.math.BigDecimal	getBigDecimal(java.lang.String columnName) JDBC 2.0 Get the value of a column in the current row as a java.math.BigDecimal object.
java.math.BigDecimal	getBigDecimal(java.lang.String columnName, int scale) Deprecated.
java.lang.Object	getObject(int columnIndex, java.util.Map map) JDBC 2.0 Returns the value of column @i as a Java object.
java.lang.Object	getObject(java.lang.String colName, java.util.Map map) JDBC 2.0 Returns the value of column @i as a Java object.
java.sql.Ref	getRef(int i) JDBC 2.0 Get a REF(<structured-type>) column.
java.sql.Ref	getRef(java.lang.String colName) JDBC 2.0 Get a REF(<structured-type>) column.
java.io.InputStream	getUnicodeStream(int columnIndex) Deprecated.
java.io.InputStream	getUnicodeStream(java.lang.String columnName) Deprecated.
void	updateArray(int columnIndex, java.sql.Array x) JDBC 3.0 Updates the designated column with a java.sql.Array value.
void	updateArray(java.lang.String columnName, java.sql.Array x) JDBC 3.0 Updates the designated column with a java.sql.Array value.
void	updateBigDecimal(int columnIndex, java.math.BigDecimal x)
void	updateBigDecimal(java.lang.String columnName, java.math.BigDecimal x) JDBC 2.0 Update a column with a BigDecimal value.
void	updateObject(int columnIndex, java.lang.Object x) JDBC 2.0 Update a column with an Object value.
void	updateRef(int columnIndex, java.sql.Ref x) JDBC 3.0 Updates the designated column with a java.sql.Ref value.
void	updateRef(java.lang.String columnName, java.sql.Ref x) JDBC 3.0 Updates the designated column with a java.sql.Ref value.

Methods inherited from class org.apache.derby.impl.jdbc.EmbedResultSet

absolute, adjustScale, afterLast, beforeFirst, cancelRowUpdates, checkExecIfClosed, checkIfClosed, checkOnRow, checksBeforeInsert, checksBeforeUpdateOrDelete, checksBeforeUpdateXXX, clearWarnings, close, closeOnTransactionError, compareTo, deleteRow, findColumn, findColumnName, first, getAsciiStream, getAsciiStream, getBinaryStream, getBinaryStream, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getColumn, getColumnSQLType, getColumnType, getConcurrency, getCursorName, getDate, getDate, getDate, getDate, getDouble, getDouble, getDVDforColumnToBeUpdated, getFetchDirection, getFetchSize, getFloat, getFloat, getHoldability, getInt, getInt, getLength, getLong, getLong, getMetaData, getObject, getObject, getParameterValueSet, getRow, getShort, getShort, getSQLText, getStatement, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getType, getURL, getURL, getWarnings, insertRow, isAfterLast, isBeforeFirst, isClosed, isFirst, isForUpdate, isLast, isNull, last, movePosition, movePosition, moveToCurrentRow, moveToInsertRow, next, noStateChangeException, previous, refreshRow, relative, rowDeleted, rowInserted, rowUpdated, setApplicationStatement, setDynamicResultSet, setFetchDirection, setFetchSize, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBoolean, updateBoolean, updateByte, updateByte, updateBytes, updateBytes, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateClob, updateClob, updateClob, updateClob, updateDate, updateDate, updateDouble, updateDouble, updateFloat, updateFloat, updateInt, updateInt, updateLong, updateLong, updateNull, updateNull, updateObject, updateObject, updateObject, updateRow, updateShort, updateShort, updateString, updateString, updateTime, updateTime, updateTimestamp, updateTimestamp, useStreamOrLOB, wasNull

Methods inherited from class org.apache.derby.impl.jdbc.ConnectionChild

commitIfAutoCommit, commitIfNeeded, getCal, getConnectionSynchronization, getEmbedConnection, handleException, needCommit, newSQLException, newSQLException, newSQLException, restoreContextStack, restoreIntrFlagIfSeen, setupContextStack

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface java.sql.ResultSet

getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getRowId, getRowId, getSQLXML, getSQLXML, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateRowId, updateRowId, updateSQLXML, updateSQLXML

Methods inherited from interface java.sql.Wrapper

isWrapperFor, unwrap

Constructor Detail

EmbedResultSet20

public EmbedResultSet20(EmbedConnection conn,
                ResultSet resultsToWrap,
                boolean forMetaData,
                EmbedStatement stmt,
                boolean isAtomic)
                 throws java.sql.SQLException

This class provides the glue between the Derby resultset and the JDBC resultset, mapping calls-to-calls.

Throws:

java.sql.SQLException

Method Detail

getBigDecimal

public final java.math.BigDecimal getBigDecimal(int columnIndex,
                                 int scale)
                                         throws java.sql.SQLException

Deprecated.

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, the result is null

Throws:

java.sql.SQLException - thrown on failure.

getBigDecimal

public final java.math.BigDecimal getBigDecimal(int columnIndex)
                                         throws java.sql.SQLException

Throws:

java.sql.SQLException

getBigDecimal

public final java.math.BigDecimal getBigDecimal(java.lang.String columnName,
                                 int scale)
                                         throws java.sql.SQLException

Deprecated.

Get the value of a column in the current row as a java.lang.BigDecimal object.

Parameters:

columnName - is the SQL name of the column

scale - the number of digits to the right of the decimal

Returns:

the column value; if the value is SQL NULL, the result is null

Throws:

java.sql.SQLException - thrown on failure.

getUnicodeStream

public final java.io.InputStream getUnicodeStream(int columnIndex)
                                           throws java.sql.SQLException

Deprecated.

JDBC 2.0 Deprecated in JDBC 2.0, not supported by JCC.

Throws:

java.sql.SQLException - thrown on failure.

getUnicodeStream

public final java.io.InputStream getUnicodeStream(java.lang.String columnName)
                                           throws java.sql.SQLException

Deprecated.

Deprecated in JDBC 2.0, not supported by JCC.

Throws:

java.sql.SQLException - thrown on failure.

getBigDecimal

public final java.math.BigDecimal getBigDecimal(java.lang.String columnName)
                                         throws java.sql.SQLException

JDBC 2.0 Get the value of a column in the current row as a java.math.BigDecimal object.

Throws:

java.sql.SQLException - Feature not implemented for now.

updateBigDecimal

public void updateBigDecimal(int columnIndex,
                    java.math.BigDecimal x)
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

updateObject

public void updateObject(int columnIndex,
                java.lang.Object x)
                  throws java.sql.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.

Specified by:

updateObject in interface java.sql.ResultSet

Overrides:

updateObject in class EmbedResultSet

Parameters:

columnIndex - the first column is 1, the second is 2, ...

x - the new column value

Throws:

java.sql.SQLException - if a database-access error occurs

updateBigDecimal

public void updateBigDecimal(java.lang.String columnName,
                    java.math.BigDecimal x)
                      throws java.sql.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

Throws:

java.sql.SQLException - if a database-access error occurs

getObject

public java.lang.Object getObject(int columnIndex,
                         java.util.Map map)
                           throws java.sql.SQLException

JDBC 2.0 Returns the value of column @i as a Java object. Use the param map to determine the class from which to construct data of SQL structured and distinct types.

Parameters:

columnIndex - 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

Throws:

java.sql.SQLException - Feature not implemented for now.

getRef

public java.sql.Ref getRef(int i)
                    throws java.sql.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

Throws:

java.sql.SQLException - Feature not implemented for now.

getArray

public java.sql.Array getArray(int i)
                        throws java.sql.SQLException

JDBC 2.0 Get an array column.

Parameters:

i - the first column is 1, the second is 2, ...

Returns:

an object representing an SQL array

Throws:

java.sql.SQLException - Feature not implemented for now.

getObject

public java.lang.Object getObject(java.lang.String colName,
                         java.util.Map map)
                           throws java.sql.SQLException

JDBC 2.0 Returns the value of column @i as a Java object. Use the param 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

Throws:

java.sql.SQLException - Feature not implemented for now.

getRef

public java.sql.Ref getRef(java.lang.String colName)
                    throws java.sql.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

Throws:

java.sql.SQLException - Feature not implemented for now.

getArray

public java.sql.Array getArray(java.lang.String colName)
                        throws java.sql.SQLException

JDBC 2.0 Get an array column.

Parameters:

colName - the column name

Returns:

an object representing an SQL array

Throws:

java.sql.SQLException - Feature not implemented for now.

updateRef

public void updateRef(int columnIndex,
             java.sql.Ref x)
               throws java.sql.SQLException

JDBC 3.0 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

Throws:

java.sql.SQLException - Feature not implemented for now.

updateRef

public void updateRef(java.lang.String columnName,
             java.sql.Ref x)
               throws java.sql.SQLException

JDBC 3.0 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 SQL name of the column

x - - the new column value

Throws:

java.sql.SQLException - Feature not implemented for now.

updateArray

public void updateArray(int columnIndex,
               java.sql.Array x)
                 throws java.sql.SQLException

JDBC 3.0 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

Throws:

java.sql.SQLException - Feature not implemented for now.

updateArray

public void updateArray(java.lang.String columnName,
               java.sql.Array x)
                 throws java.sql.SQLException

JDBC 3.0 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 SQL name of the column

x - - the new column value

Throws:

java.sql.SQLException - Feature not implemented for now.