Package com.mckoi.database.jdbc
Class MResultSet
- java.lang.Object
-
- com.mckoi.database.jdbc.MResultSet
-
- All Implemented Interfaces:
java.lang.AutoCloseable
,java.sql.ResultSet
,java.sql.Wrapper
public final class MResultSet extends java.lang.Object implements java.sql.ResultSet
Implementation of a ResultSet.Multi-threaded issue: This class is not designed to be multi-thread safe. A ResultSet should not be accessed by concurrent threads.
-
-
Field Summary
Fields Modifier and Type Field Description private static BigNumber
BD_ZERO
BigNumber for 0.private int
block_row_count
The number of rows in 'result_block'private int
block_top_row
The row number of the first row of the 'result_block'private boolean
closed_on_server
Set to true if the result set is closed on the server.private ColumnDescription[]
col_list
The array of ColumnDescription that describes each column in the result set.private java.util.Hashtable
column_hash
A Hashtable that acts as a cache for column name/column number look ups.private MConnection
connection
The MConnection that this result set is in.private static int
DEFAULT_FETCH_SIZE
The default fetch size.private int
fetch_size
The number of rows to fetch each time we need to get rows from the database.private java.sql.SQLWarning
head_warning
SQL warnings for this result set.private boolean
last_was_null
Set to true if the last 'getxxx' method was a null.private int
max_row_count
The maximum row count as set in the Statement by the 'setMaxRows' method or 0 if the max row count is not important.private static int
MAXIMUM_FETCH_SIZE
The maximum fetch size.private int
query_time_ms
The length of time it took to execute this query in ms.private int
real_index
The real index of the result set we are currently at.private int
real_index_offset
The offset into 'result_block' where 'real_index' is.private java.util.Vector
result_block
The Vector that contains the Objects downloaded into this result set.private int
result_id
The current result_id for the information in the current result set.private int
result_row_count
The number of rows in the result set.private MStatement
statement
The MStatement that this result is from.private int
unique_id
A unique int that refers to this result set.private static int
unique_id_key
The current unique id key.
-
Constructor Summary
Constructors Constructor Description MResultSet(MConnection connection, MStatement statement)
Constructor.
-
Method Summary
All Methods Instance Methods Concrete Methods Deprecated Methods Modifier and Type Method Description boolean
absolute(int row)
(package private) void
addSQLWarning(java.sql.SQLWarning warning)
Adds a new SQLWarning to the chain.void
afterLast()
private java.sql.Blob
asBlob(java.lang.Object ob)
Returns the given object as a Blob instance.private java.sql.Clob
asClob(java.lang.Object ob)
Returns the given object as a Clob instance.void
beforeFirst()
void
cancelRowUpdates()
private boolean
canMakeString(java.lang.Object ob)
Returns true if the given object is either an instanceof StringObject or is an instanceof StreamableObject, and therefore can be made into a string.void
clearWarnings()
void
close()
(package private) void
closeCurrentResult()
Closes the current server side result for this result set ready for a new one.(package private) int
columnCount()
The column count of columns in the result set.(package private) void
connSetup(int result_id, ColumnDescription[] col_list, int total_row_count)
Called by the ConnectionThread when we have received the initial bag of the result set.(package private) boolean
containsLargeObjects()
Returns true if this ResultSet contains large objects.void
deleteRow()
(package private) void
dispose()
Disposes of all resources associated with this result set.(package private) void
ensureIndexLoaded()
Ensures that the row index pointed to by 'real_index' is actually loaded into the 'result_block'.java.util.Date
extGetDate(int columnIndex)
Access column as java.util.Date (which is the native object used in the mckoi database to handle time).java.util.Date
extGetDate(java.lang.String columnName)
Access column as java.util.Date (which is the native object used in the mckoi database to handle time).int
extQueryTimeMillis()
The number of milliseconds it took the server to execute this query.void
finalize()
int
findColumn(java.lang.String columnName)
(package private) int
findColumnIndex(java.lang.String name)
Searches for the index of the column with the given name.boolean
first()
java.sql.Array
getArray(int i)
java.sql.Array
getArray(java.lang.String colName)
java.io.InputStream
getAsciiStream(int columnIndex)
java.io.InputStream
getAsciiStream(java.lang.String columnName)
java.math.BigDecimal
getBigDecimal(int columnIndex)
java.math.BigDecimal
getBigDecimal(int columnIndex, int scale)
Deprecated.java.math.BigDecimal
getBigDecimal(java.lang.String columnName)
java.math.BigDecimal
getBigDecimal(java.lang.String columnName, int scale)
Deprecated.private BigNumber
getBigNumber(int columnIndex)
java.io.InputStream
getBinaryStream(int columnIndex)
java.io.InputStream
getBinaryStream(java.lang.String columnName)
java.sql.Blob
getBlob(int i)
java.sql.Blob
getBlob(java.lang.String colName)
boolean
getBoolean(int columnIndex)
boolean
getBoolean(java.lang.String columnName)
byte
getByte(int columnIndex)
byte
getByte(java.lang.String columnName)
byte[]
getBytes(int columnIndex)
byte[]
getBytes(java.lang.String columnName)
java.io.Reader
getCharacterStream(int columnIndex)
java.io.Reader
getCharacterStream(java.lang.String columnName)
java.sql.Clob
getClob(int i)
java.sql.Clob
getClob(java.lang.String colName)
(package private) ColumnDescription
getColumn(int column)
Returns the ColumnDescription of the given column (first column is 0, etc).int
getConcurrency()
java.lang.String
getCursorName()
java.sql.Date
getDate(int columnIndex)
java.sql.Date
getDate(int columnIndex, java.util.Calendar cal)
java.sql.Date
getDate(java.lang.String columnName)
java.sql.Date
getDate(java.lang.String columnName, java.util.Calendar cal)
double
getDouble(int columnIndex)
double
getDouble(java.lang.String columnName)
int
getFetchDirection()
int
getFetchSize()
float
getFloat(int columnIndex)
float
getFloat(java.lang.String columnName)
int
getHoldability()
int
getInt(int columnIndex)
int
getInt(java.lang.String columnName)
long
getLong(int columnIndex)
long
getLong(java.lang.String columnName)
java.sql.ResultSetMetaData
getMetaData()
java.io.Reader
getNCharacterStream(int columnIndex)
java.io.Reader
getNCharacterStream(java.lang.String columnLabel)
java.sql.NClob
getNClob(int columnIndex)
java.sql.NClob
getNClob(java.lang.String columnLabel)
java.lang.String
getNString(int columnIndex)
java.lang.String
getNString(java.lang.String columnLabel)
java.lang.Object
getObject(int columnIndex)
<T> T
getObject(int columnIndex, java.lang.Class<T> arg0)
java.lang.Object
getObject(int i, java.util.Map map)
java.lang.Object
getObject(java.lang.String columnName)
<T> T
getObject(java.lang.String columnLabel, java.lang.Class<T> arg0)
java.lang.Object
getObject(java.lang.String colName, java.util.Map map)
(package private) java.lang.Object
getRawColumn(int column)
Returns the column Object of the current index.(package private) java.lang.Object
getRawColumn(java.lang.String name)
Returns the column Object of the name of the current index.java.sql.Ref
getRef(int i)
java.sql.Ref
getRef(java.lang.String colName)
(package private) int
getResultID()
Returns the 'result_id' that is used as a key to refer to the result set on the server that is the result of the query.int
getRow()
java.sql.RowId
getRowId(int columnIndex)
java.sql.RowId
getRowId(java.lang.String columnLabel)
short
getShort(int columnIndex)
short
getShort(java.lang.String columnName)
java.sql.SQLXML
getSQLXML(int columnIndex)
java.sql.SQLXML
getSQLXML(java.lang.String columnLabel)
java.sql.Statement
getStatement()
java.lang.String
getString(int columnIndex)
java.lang.String
getString(java.lang.String columnName)
java.sql.Time
getTime(int columnIndex)
java.sql.Time
getTime(int columnIndex, java.util.Calendar cal)
java.sql.Time
getTime(java.lang.String columnName)
java.sql.Time
getTime(java.lang.String columnName, java.util.Calendar cal)
java.sql.Timestamp
getTimestamp(int columnIndex)
java.sql.Timestamp
getTimestamp(int columnIndex, java.util.Calendar cal)
java.sql.Timestamp
getTimestamp(java.lang.String columnName)
java.sql.Timestamp
getTimestamp(java.lang.String columnName, java.util.Calendar cal)
int
getType()
java.io.InputStream
getUnicodeStream(int columnIndex)
Deprecated.java.io.InputStream
getUnicodeStream(java.lang.String columnName)
Deprecated.java.net.URL
getURL(int columnIndex)
java.net.URL
getURL(java.lang.String columnName)
java.sql.SQLWarning
getWarnings()
void
insertRow()
(package private) int
intValue()
Returns this ResultSet as an 'int' value.boolean
isAfterLast()
boolean
isBeforeFirst()
boolean
isClosed()
boolean
isFirst()
boolean
isLast()
(package private) boolean
isUpdate()
Returns true if this result set contains 1 column and 1 row and the name of the column is 'result'.boolean
isWrapperFor(java.lang.Class iface)
private java.lang.Object
jdbcObjectCast(java.lang.Object ob, int sql_type)
Casts an internal object to the sql_type given for return by methods such as 'getObject'.boolean
last()
private java.lang.String
makeString(java.lang.Object ob)
If the object represents a String or is a form that can be readily translated to a String (such as a Clob, String, BigNumber, Boolean, etc) the string representation of the given Object is returned.void
moveToCurrentRow()
void
moveToInsertRow()
boolean
next()
boolean
previous()
private void
realIndexUpdate()
This should be called when the 'real_index' variable changes.void
refreshRow()
boolean
relative(int rows)
(package private) int
rowCount()
The total number of rows in the result set.boolean
rowDeleted()
boolean
rowInserted()
boolean
rowUpdated()
void
setAsciiStream(java.lang.String parameterName, java.io.InputStream x)
void
setAsciiStream(java.lang.String parameterName, java.io.InputStream x, long length)
void
setBinaryStream(java.lang.String parameterName, java.io.InputStream x)
void
setBinaryStream(java.lang.String parameterName, java.io.InputStream x, long length)
void
setBlob(java.lang.String parameterName, java.io.InputStream inputStream)
void
setBlob(java.lang.String parameterName, java.sql.Blob x)
void
setCharacterStream(java.lang.String parameterName, java.io.Reader reader)
void
setCharacterStream(java.lang.String parameterName, java.io.Reader reader, long length)
void
setClob(java.lang.String parameterName, java.io.Reader reader)
void
setClob(java.lang.String parameterName, java.sql.Clob x)
void
setFetchDirection(int direction)
void
setFetchSize(int rows)
(package private) void
setMaxRowCount(int row_count)
Sets the maximum number of rows that this ResultSet will return or 0 if the max number of rows is not important.void
setNCharacterStream(java.lang.String parameterName, java.io.Reader value)
void
setNClob(java.lang.String parameterName, java.io.Reader reader)
(package private) void
setQueryTime(int time_ms)
Sets the length of time in milliseconds (server-side) it took to execute this query.(package private) void
storeResultLocally()
Asks the server for all the rows in the result set and stores it locally within this object.java.lang.Object
unwrap(java.lang.Class iface)
void
updateArray(int columnIndex, java.sql.Array x)
void
updateArray(java.lang.String columnName, java.sql.Array x)
void
updateAsciiStream(int columnIndex, java.io.InputStream x)
void
updateAsciiStream(int columnIndex, java.io.InputStream x, int length)
void
updateAsciiStream(int columnIndex, java.io.InputStream x, long length)
void
updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x)
void
updateAsciiStream(java.lang.String columnName, java.io.InputStream x, int length)
void
updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x, long length)
void
updateBigDecimal(int columnIndex, java.math.BigDecimal x)
void
updateBigDecimal(java.lang.String columnName, java.math.BigDecimal x)
void
updateBinaryStream(int columnIndex, java.io.InputStream x)
void
updateBinaryStream(int columnIndex, java.io.InputStream x, int length)
void
updateBinaryStream(int columnIndex, java.io.InputStream x, long length)
void
updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x)
void
updateBinaryStream(java.lang.String columnName, java.io.InputStream x, int length)
void
updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x, long length)
void
updateBlob(int columnIndex, java.io.InputStream inputStream)
void
updateBlob(int columnIndex, java.io.InputStream inputStream, long length)
void
updateBlob(int columnIndex, java.sql.Blob x)
void
updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream)
void
updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream, long length)
void
updateBlob(java.lang.String columnName, java.sql.Blob x)
void
updateBoolean(int columnIndex, boolean x)
void
updateBoolean(java.lang.String columnName, boolean x)
void
updateByte(int columnIndex, byte x)
void
updateByte(java.lang.String columnName, byte x)
void
updateBytes(int columnIndex, byte[] x)
void
updateBytes(java.lang.String columnName, byte[] x)
void
updateCharacterStream(int columnIndex, java.io.Reader x)
void
updateCharacterStream(int columnIndex, java.io.Reader x, int length)
void
updateCharacterStream(int columnIndex, java.io.Reader x, long length)
void
updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader)
void
updateCharacterStream(java.lang.String columnName, java.io.Reader reader, int length)
void
updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length)
void
updateClob(int columnIndex, java.io.Reader reader)
void
updateClob(int columnIndex, java.io.Reader reader, long length)
void
updateClob(int columnIndex, java.sql.Clob x)
void
updateClob(java.lang.String columnLabel, java.io.Reader reader)
void
updateClob(java.lang.String columnLabel, java.io.Reader reader, long length)
void
updateClob(java.lang.String columnName, java.sql.Clob x)
void
updateDate(int columnIndex, java.sql.Date x)
void
updateDate(java.lang.String columnName, java.sql.Date x)
void
updateDouble(int columnIndex, double x)
void
updateDouble(java.lang.String columnName, double x)
void
updateFloat(int columnIndex, float x)
void
updateFloat(java.lang.String columnName, float x)
void
updateInt(int columnIndex, int x)
void
updateInt(java.lang.String columnName, int x)
void
updateLong(int columnIndex, long x)
void
updateLong(java.lang.String columnName, long x)
void
updateNCharacterStream(int columnIndex, java.io.Reader x)
void
updateNCharacterStream(int columnIndex, java.io.Reader x, long length)
void
updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader)
void
updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length)
void
updateNClob(int columnIndex, java.io.Reader reader)
void
updateNClob(int columnIndex, java.io.Reader reader, long length)
void
updateNClob(int columnIndex, java.sql.NClob nClob)
void
updateNClob(java.lang.String columnLabel, java.io.Reader reader)
void
updateNClob(java.lang.String columnLabel, java.io.Reader reader, long length)
void
updateNClob(java.lang.String columnLabel, java.sql.NClob nClob)
void
updateNString(int columnIndex, java.lang.String nString)
void
updateNString(java.lang.String columnLabel, java.lang.String nString)
void
updateNull(int columnIndex)
void
updateNull(java.lang.String columnName)
void
updateObject(int columnIndex, java.lang.Object x)
void
updateObject(int columnIndex, java.lang.Object x, int scale)
void
updateObject(java.lang.String columnName, java.lang.Object x)
void
updateObject(java.lang.String columnName, java.lang.Object x, int scale)
void
updateRef(int columnIndex, java.sql.Ref x)
void
updateRef(java.lang.String columnName, java.sql.Ref x)
(package private) void
updateResultPart(int row_index, int row_count)
Asks the server for more information about this result set to put into the 'result_block'.void
updateRow()
void
updateRowId(int columnIndex, java.sql.RowId x)
void
updateRowId(java.lang.String columnLabel, java.sql.RowId x)
void
updateShort(int columnIndex, short x)
void
updateShort(java.lang.String columnName, short x)
void
updateSQLXML(int columnIndex, java.sql.SQLXML xmlObject)
void
updateSQLXML(java.lang.String columnLabel, java.sql.SQLXML xmlObject)
void
updateString(int columnIndex, java.lang.String x)
void
updateString(java.lang.String columnName, java.lang.String x)
void
updateTime(int columnIndex, java.sql.Time x)
void
updateTime(java.lang.String columnName, java.sql.Time x)
void
updateTimestamp(int columnIndex, java.sql.Timestamp x)
void
updateTimestamp(java.lang.String columnName, java.sql.Timestamp x)
(package private) boolean
verboseColumnNames()
Returns true if verbose column names are enabled on the connection.boolean
wasNull()
-
-
-
Field Detail
-
DEFAULT_FETCH_SIZE
private static final int DEFAULT_FETCH_SIZE
The default fetch size.- See Also:
- Constant Field Values
-
MAXIMUM_FETCH_SIZE
private static final int MAXIMUM_FETCH_SIZE
The maximum fetch size.- See Also:
- Constant Field Values
-
unique_id_key
private static int unique_id_key
The current unique id key.
-
BD_ZERO
private static BigNumber BD_ZERO
BigNumber for 0.
-
unique_id
private int unique_id
A unique int that refers to this result set.
-
connection
private MConnection connection
The MConnection that this result set is in.
-
statement
private MStatement statement
The MStatement that this result is from.
-
head_warning
private java.sql.SQLWarning head_warning
SQL warnings for this result set. Cleared each time a new row accessed.
-
result_id
private int result_id
The current result_id for the information in the current result set.
-
col_list
private ColumnDescription[] col_list
The array of ColumnDescription that describes each column in the result set.
-
query_time_ms
private int query_time_ms
The length of time it took to execute this query in ms.
-
result_row_count
private int result_row_count
The number of rows in the result set.
-
max_row_count
private int max_row_count
The maximum row count as set in the Statement by the 'setMaxRows' method or 0 if the max row count is not important.
-
block_top_row
private int block_top_row
The row number of the first row of the 'result_block'
-
block_row_count
private int block_row_count
The number of rows in 'result_block'
-
fetch_size
private int fetch_size
The number of rows to fetch each time we need to get rows from the database.
-
result_block
private java.util.Vector result_block
The Vector that contains the Objects downloaded into this result set. It only contains the objects from the last block of rows downloaded.
-
real_index
private int real_index
The real index of the result set we are currently at.
-
real_index_offset
private int real_index_offset
The offset into 'result_block' where 'real_index' is. This is set up by 'ensureIndexLoaded'.
-
last_was_null
private boolean last_was_null
Set to true if the last 'getxxx' method was a null. Otherwise set to false.
-
column_hash
private java.util.Hashtable column_hash
A Hashtable that acts as a cache for column name/column number look ups.
-
closed_on_server
private boolean closed_on_server
Set to true if the result set is closed on the server.
-
-
Constructor Detail
-
MResultSet
MResultSet(MConnection connection, MStatement statement)
Constructor.
-
-
Method Detail
-
addSQLWarning
void addSQLWarning(java.sql.SQLWarning warning)
Adds a new SQLWarning to the chain.
-
verboseColumnNames
boolean verboseColumnNames()
Returns true if verbose column names are enabled on the connection. Returns false by default.
-
connSetup
void connSetup(int result_id, ColumnDescription[] col_list, int total_row_count)
Called by the ConnectionThread when we have received the initial bag of the result set. This contains information about the columns in the result, the number of rows in the entire set, etc. This sets up the result set to handle the result.
-
setQueryTime
void setQueryTime(int time_ms)
Sets the length of time in milliseconds (server-side) it took to execute this query. Useful as feedback for the server-side optimisation systems.VERY MINOR ISSUE: An int can 'only' contain 35 weeks worth of milliseconds. So if a query takes longer than that this number will overflow.
-
setMaxRowCount
void setMaxRowCount(int row_count)
Sets the maximum number of rows that this ResultSet will return or 0 if the max number of rows is not important. This is set by MStatement when a query is evaluated.
-
containsLargeObjects
boolean containsLargeObjects()
Returns true if this ResultSet contains large objects. This looks at the ColumnDescription object to determine this.
-
storeResultLocally
void storeResultLocally() throws java.sql.SQLException
Asks the server for all the rows in the result set and stores it locally within this object. It then disposes all resources associated with this result set on the server.- Throws:
java.sql.SQLException
-
updateResultPart
void updateResultPart(int row_index, int row_count) throws java.sql.SQLException
Asks the server for more information about this result set to put into the 'result_block'. This should be called when we need to request more information from the server.- Parameters:
row_index
- the top row index from the block of the result set to download.row_count
- the maximum number of rows to download (may be less if no more are available).- Throws:
java.sql.SQLException
-
closeCurrentResult
void closeCurrentResult() throws java.sql.SQLException
Closes the current server side result for this result set ready for a new one. This should be called before we execute a query. It sends a command to the server to despose of any resources associated with the current result_id.It's perfectly safe to call this method even if we haven't downloaded a result set from the server and you may also safely call it multiple times (it will only send one request to the server).
- Throws:
java.sql.SQLException
-
getResultID
int getResultID()
Returns the 'result_id' that is used as a key to refer to the result set on the server that is the result of the query. A 'resultID' of -1 means there is no server side result set associated with this object.
-
rowCount
int rowCount()
The total number of rows in the result set.
-
columnCount
int columnCount()
The column count of columns in the result set.
-
getColumn
ColumnDescription getColumn(int column)
Returns the ColumnDescription of the given column (first column is 0, etc).
-
isUpdate
boolean isUpdate()
Returns true if this result set contains 1 column and 1 row and the name of the column is 'result'. This indicates the result set is a DDL command ( UPDATE, INSERT, CREATE, ALTER, etc ).NOTE: This is a minor hack because there is no real indication that this is a DML statement. Theoretically a DQL query could be constructed that meets all these requirements and is processed incorrectly.
-
intValue
int intValue() throws java.sql.SQLException
Returns this ResultSet as an 'int' value. This is only valid if the result set has a single column and a single row of type 'BigNumber'.- Throws:
java.sql.SQLException
-
dispose
void dispose()
Disposes of all resources associated with this result set. This could either be called from the MStatement finalize or close method. Calls to this object are undefined after this method has finished.
-
ensureIndexLoaded
void ensureIndexLoaded() throws java.sql.SQLException
Ensures that the row index pointed to by 'real_index' is actually loaded into the 'result_block'. If not, we send a request to the database to get it.- Throws:
java.sql.SQLException
-
findColumnIndex
int findColumnIndex(java.lang.String name) throws java.sql.SQLException
Searches for the index of the column with the given name. First column index is 1, second is 2, etc.- Throws:
java.sql.SQLException
-
getRawColumn
java.lang.Object getRawColumn(int column) throws java.sql.SQLException
Returns the column Object of the current index. The first column is 1, the second is 2, etc.- Throws:
java.sql.SQLException
-
getRawColumn
java.lang.Object getRawColumn(java.lang.String name) throws java.sql.SQLException
Returns the column Object of the name of the current index.- Throws:
java.sql.SQLException
-
realIndexUpdate
private void realIndexUpdate() throws java.sql.SQLException
This should be called when the 'real_index' variable changes. It updates internal variables.- Throws:
java.sql.SQLException
-
canMakeString
private boolean canMakeString(java.lang.Object ob)
Returns true if the given object is either an instanceof StringObject or is an instanceof StreamableObject, and therefore can be made into a string.
-
makeString
private java.lang.String makeString(java.lang.Object ob) throws java.sql.SQLException
If the object represents a String or is a form that can be readily translated to a String (such as a Clob, String, BigNumber, Boolean, etc) the string representation of the given Object is returned. This method is a convenient way to convert objects such as Clobs into java.util.String objects. This will cause a ClassCastException if the given object represents a BLOB or ByteLongObject.- Throws:
java.sql.SQLException
-
asBlob
private java.sql.Blob asBlob(java.lang.Object ob)
Returns the given object as a Blob instance.
-
asClob
private java.sql.Clob asClob(java.lang.Object ob)
Returns the given object as a Clob instance.
-
jdbcObjectCast
private java.lang.Object jdbcObjectCast(java.lang.Object ob, int sql_type) throws java.sql.SQLException
Casts an internal object to the sql_type given for return by methods such as 'getObject'.- Throws:
java.sql.SQLException
-
extQueryTimeMillis
public int extQueryTimeMillis()
The number of milliseconds it took the server to execute this query. This is set after the call to 'connSetup' so is available as soon as the header information is received from the server.
-
extGetDate
public java.util.Date extGetDate(int columnIndex) throws java.sql.SQLException
Access column as java.util.Date (which is the native object used in the mckoi database to handle time).- Throws:
java.sql.SQLException
-
extGetDate
public java.util.Date extGetDate(java.lang.String columnName) throws java.sql.SQLException
Access column as java.util.Date (which is the native object used in the mckoi database to handle time).- Throws:
java.sql.SQLException
-
next
public boolean next() throws java.sql.SQLException
- Specified by:
next
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
close
public void close() throws java.sql.SQLException
- Specified by:
close
in interfacejava.lang.AutoCloseable
- Specified by:
close
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
wasNull
public boolean wasNull() throws java.sql.SQLException
- Specified by:
wasNull
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getString
public java.lang.String getString(int columnIndex) throws java.sql.SQLException
- Specified by:
getString
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getBoolean
public boolean getBoolean(int columnIndex) throws java.sql.SQLException
- Specified by:
getBoolean
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getByte
public byte getByte(int columnIndex) throws java.sql.SQLException
- Specified by:
getByte
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getShort
public short getShort(int columnIndex) throws java.sql.SQLException
- Specified by:
getShort
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getInt
public int getInt(int columnIndex) throws java.sql.SQLException
- Specified by:
getInt
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getLong
public long getLong(int columnIndex) throws java.sql.SQLException
- Specified by:
getLong
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getFloat
public float getFloat(int columnIndex) throws java.sql.SQLException
- Specified by:
getFloat
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getDouble
public double getDouble(int columnIndex) throws java.sql.SQLException
- Specified by:
getDouble
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getBigDecimal
public java.math.BigDecimal getBigDecimal(int columnIndex, int scale) throws java.sql.SQLException
Deprecated.- Specified by:
getBigDecimal
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getBytes
public byte[] getBytes(int columnIndex) throws java.sql.SQLException
- Specified by:
getBytes
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getDate
public java.sql.Date getDate(int columnIndex) throws java.sql.SQLException
- Specified by:
getDate
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getTime
public java.sql.Time getTime(int columnIndex) throws java.sql.SQLException
- Specified by:
getTime
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getTimestamp
public java.sql.Timestamp getTimestamp(int columnIndex) throws java.sql.SQLException
- Specified by:
getTimestamp
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getAsciiStream
public java.io.InputStream getAsciiStream(int columnIndex) throws java.sql.SQLException
- Specified by:
getAsciiStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getUnicodeStream
public java.io.InputStream getUnicodeStream(int columnIndex) throws java.sql.SQLException
Deprecated.- Specified by:
getUnicodeStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getBinaryStream
public java.io.InputStream getBinaryStream(int columnIndex) throws java.sql.SQLException
- Specified by:
getBinaryStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getString
public java.lang.String getString(java.lang.String columnName) throws java.sql.SQLException
- Specified by:
getString
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getBoolean
public boolean getBoolean(java.lang.String columnName) throws java.sql.SQLException
- Specified by:
getBoolean
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getByte
public byte getByte(java.lang.String columnName) throws java.sql.SQLException
- Specified by:
getByte
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getShort
public short getShort(java.lang.String columnName) throws java.sql.SQLException
- Specified by:
getShort
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getInt
public int getInt(java.lang.String columnName) throws java.sql.SQLException
- Specified by:
getInt
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getLong
public long getLong(java.lang.String columnName) throws java.sql.SQLException
- Specified by:
getLong
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getFloat
public float getFloat(java.lang.String columnName) throws java.sql.SQLException
- Specified by:
getFloat
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getDouble
public double getDouble(java.lang.String columnName) throws java.sql.SQLException
- Specified by:
getDouble
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getBigDecimal
public java.math.BigDecimal getBigDecimal(java.lang.String columnName, int scale) throws java.sql.SQLException
Deprecated.- Specified by:
getBigDecimal
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getBytes
public byte[] getBytes(java.lang.String columnName) throws java.sql.SQLException
- Specified by:
getBytes
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getDate
public java.sql.Date getDate(java.lang.String columnName) throws java.sql.SQLException
- Specified by:
getDate
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getTime
public java.sql.Time getTime(java.lang.String columnName) throws java.sql.SQLException
- Specified by:
getTime
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getTimestamp
public java.sql.Timestamp getTimestamp(java.lang.String columnName) throws java.sql.SQLException
- Specified by:
getTimestamp
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getAsciiStream
public java.io.InputStream getAsciiStream(java.lang.String columnName) throws java.sql.SQLException
- Specified by:
getAsciiStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getUnicodeStream
public java.io.InputStream getUnicodeStream(java.lang.String columnName) throws java.sql.SQLException
Deprecated.- Specified by:
getUnicodeStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getBinaryStream
public java.io.InputStream getBinaryStream(java.lang.String columnName) throws java.sql.SQLException
- Specified by:
getBinaryStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getWarnings
public java.sql.SQLWarning getWarnings() throws java.sql.SQLException
- Specified by:
getWarnings
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
clearWarnings
public void clearWarnings() throws java.sql.SQLException
- Specified by:
clearWarnings
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getCursorName
public java.lang.String getCursorName() throws java.sql.SQLException
- Specified by:
getCursorName
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getMetaData
public java.sql.ResultSetMetaData getMetaData() throws java.sql.SQLException
- Specified by:
getMetaData
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getObject
public java.lang.Object getObject(int columnIndex) throws java.sql.SQLException
- Specified by:
getObject
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getObject
public java.lang.Object getObject(java.lang.String columnName) throws java.sql.SQLException
- Specified by:
getObject
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
findColumn
public int findColumn(java.lang.String columnName) throws java.sql.SQLException
- Specified by:
findColumn
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getBigDecimal
public java.math.BigDecimal getBigDecimal(int columnIndex) throws java.sql.SQLException
- Specified by:
getBigDecimal
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getBigNumber
private BigNumber getBigNumber(int columnIndex) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
getBigDecimal
public java.math.BigDecimal getBigDecimal(java.lang.String columnName) throws java.sql.SQLException
- Specified by:
getBigDecimal
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
setFetchSize
public void setFetchSize(int rows) throws java.sql.SQLException
- Specified by:
setFetchSize
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getFetchSize
public int getFetchSize() throws java.sql.SQLException
- Specified by:
getFetchSize
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getCharacterStream
public java.io.Reader getCharacterStream(int columnIndex) throws java.sql.SQLException
- Specified by:
getCharacterStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getCharacterStream
public java.io.Reader getCharacterStream(java.lang.String columnName) throws java.sql.SQLException
- Specified by:
getCharacterStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
isBeforeFirst
public boolean isBeforeFirst() throws java.sql.SQLException
- Specified by:
isBeforeFirst
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
isAfterLast
public boolean isAfterLast() throws java.sql.SQLException
- Specified by:
isAfterLast
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
isFirst
public boolean isFirst() throws java.sql.SQLException
- Specified by:
isFirst
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
isLast
public boolean isLast() throws java.sql.SQLException
- Specified by:
isLast
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
beforeFirst
public void beforeFirst() throws java.sql.SQLException
- Specified by:
beforeFirst
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
afterLast
public void afterLast() throws java.sql.SQLException
- Specified by:
afterLast
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
first
public boolean first() throws java.sql.SQLException
- Specified by:
first
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
last
public boolean last() throws java.sql.SQLException
- Specified by:
last
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getRow
public int getRow() throws java.sql.SQLException
- Specified by:
getRow
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
absolute
public boolean absolute(int row) throws java.sql.SQLException
- Specified by:
absolute
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
relative
public boolean relative(int rows) throws java.sql.SQLException
- Specified by:
relative
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
previous
public boolean previous() throws java.sql.SQLException
- Specified by:
previous
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
setFetchDirection
public void setFetchDirection(int direction) throws java.sql.SQLException
- Specified by:
setFetchDirection
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getFetchDirection
public int getFetchDirection() throws java.sql.SQLException
- Specified by:
getFetchDirection
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getType
public int getType() throws java.sql.SQLException
- Specified by:
getType
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getConcurrency
public int getConcurrency() throws java.sql.SQLException
- Specified by:
getConcurrency
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
rowUpdated
public boolean rowUpdated() throws java.sql.SQLException
- Specified by:
rowUpdated
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
rowInserted
public boolean rowInserted() throws java.sql.SQLException
- Specified by:
rowInserted
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
rowDeleted
public boolean rowDeleted() throws java.sql.SQLException
- Specified by:
rowDeleted
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateNull
public void updateNull(int columnIndex) throws java.sql.SQLException
- Specified by:
updateNull
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateBoolean
public void updateBoolean(int columnIndex, boolean x) throws java.sql.SQLException
- Specified by:
updateBoolean
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateByte
public void updateByte(int columnIndex, byte x) throws java.sql.SQLException
- Specified by:
updateByte
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateShort
public void updateShort(int columnIndex, short x) throws java.sql.SQLException
- Specified by:
updateShort
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateInt
public void updateInt(int columnIndex, int x) throws java.sql.SQLException
- Specified by:
updateInt
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateLong
public void updateLong(int columnIndex, long x) throws java.sql.SQLException
- Specified by:
updateLong
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateFloat
public void updateFloat(int columnIndex, float x) throws java.sql.SQLException
- Specified by:
updateFloat
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateDouble
public void updateDouble(int columnIndex, double x) throws java.sql.SQLException
- Specified by:
updateDouble
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateBigDecimal
public void updateBigDecimal(int columnIndex, java.math.BigDecimal x) throws java.sql.SQLException
- Specified by:
updateBigDecimal
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateString
public void updateString(int columnIndex, java.lang.String x) throws java.sql.SQLException
- Specified by:
updateString
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateBytes
public void updateBytes(int columnIndex, byte[] x) throws java.sql.SQLException
- Specified by:
updateBytes
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateDate
public void updateDate(int columnIndex, java.sql.Date x) throws java.sql.SQLException
- Specified by:
updateDate
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateTime
public void updateTime(int columnIndex, java.sql.Time x) throws java.sql.SQLException
- Specified by:
updateTime
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateTimestamp
public void updateTimestamp(int columnIndex, java.sql.Timestamp x) throws java.sql.SQLException
- Specified by:
updateTimestamp
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateAsciiStream
public void updateAsciiStream(int columnIndex, java.io.InputStream x, int length) throws java.sql.SQLException
- Specified by:
updateAsciiStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateBinaryStream
public void updateBinaryStream(int columnIndex, java.io.InputStream x, int length) throws java.sql.SQLException
- Specified by:
updateBinaryStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateCharacterStream
public void updateCharacterStream(int columnIndex, java.io.Reader x, int length) throws java.sql.SQLException
- Specified by:
updateCharacterStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateObject
public void updateObject(int columnIndex, java.lang.Object x, int scale) throws java.sql.SQLException
- Specified by:
updateObject
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateObject
public void updateObject(int columnIndex, java.lang.Object x) throws java.sql.SQLException
- Specified by:
updateObject
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateNull
public void updateNull(java.lang.String columnName) throws java.sql.SQLException
- Specified by:
updateNull
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateBoolean
public void updateBoolean(java.lang.String columnName, boolean x) throws java.sql.SQLException
- Specified by:
updateBoolean
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateByte
public void updateByte(java.lang.String columnName, byte x) throws java.sql.SQLException
- Specified by:
updateByte
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateShort
public void updateShort(java.lang.String columnName, short x) throws java.sql.SQLException
- Specified by:
updateShort
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateInt
public void updateInt(java.lang.String columnName, int x) throws java.sql.SQLException
- Specified by:
updateInt
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateLong
public void updateLong(java.lang.String columnName, long x) throws java.sql.SQLException
- Specified by:
updateLong
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateFloat
public void updateFloat(java.lang.String columnName, float x) throws java.sql.SQLException
- Specified by:
updateFloat
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateDouble
public void updateDouble(java.lang.String columnName, double x) throws java.sql.SQLException
- Specified by:
updateDouble
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateBigDecimal
public void updateBigDecimal(java.lang.String columnName, java.math.BigDecimal x) throws java.sql.SQLException
- Specified by:
updateBigDecimal
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateString
public void updateString(java.lang.String columnName, java.lang.String x) throws java.sql.SQLException
- Specified by:
updateString
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateBytes
public void updateBytes(java.lang.String columnName, byte[] x) throws java.sql.SQLException
- Specified by:
updateBytes
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateDate
public void updateDate(java.lang.String columnName, java.sql.Date x) throws java.sql.SQLException
- Specified by:
updateDate
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateTime
public void updateTime(java.lang.String columnName, java.sql.Time x) throws java.sql.SQLException
- Specified by:
updateTime
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateTimestamp
public void updateTimestamp(java.lang.String columnName, java.sql.Timestamp x) throws java.sql.SQLException
- Specified by:
updateTimestamp
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateAsciiStream
public void updateAsciiStream(java.lang.String columnName, java.io.InputStream x, int length) throws java.sql.SQLException
- Specified by:
updateAsciiStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateBinaryStream
public void updateBinaryStream(java.lang.String columnName, java.io.InputStream x, int length) throws java.sql.SQLException
- Specified by:
updateBinaryStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateCharacterStream
public void updateCharacterStream(java.lang.String columnName, java.io.Reader reader, int length) throws java.sql.SQLException
- Specified by:
updateCharacterStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateObject
public void updateObject(java.lang.String columnName, java.lang.Object x, int scale) throws java.sql.SQLException
- Specified by:
updateObject
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateObject
public void updateObject(java.lang.String columnName, java.lang.Object x) throws java.sql.SQLException
- Specified by:
updateObject
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
insertRow
public void insertRow() throws java.sql.SQLException
- Specified by:
insertRow
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateRow
public void updateRow() throws java.sql.SQLException
- Specified by:
updateRow
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
deleteRow
public void deleteRow() throws java.sql.SQLException
- Specified by:
deleteRow
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
refreshRow
public void refreshRow() throws java.sql.SQLException
- Specified by:
refreshRow
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
cancelRowUpdates
public void cancelRowUpdates() throws java.sql.SQLException
- Specified by:
cancelRowUpdates
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
moveToInsertRow
public void moveToInsertRow() throws java.sql.SQLException
- Specified by:
moveToInsertRow
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
moveToCurrentRow
public void moveToCurrentRow() throws java.sql.SQLException
- Specified by:
moveToCurrentRow
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getStatement
public java.sql.Statement getStatement() throws java.sql.SQLException
- Specified by:
getStatement
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getObject
public java.lang.Object getObject(int i, java.util.Map map) throws java.sql.SQLException
- Specified by:
getObject
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getRef
public java.sql.Ref getRef(int i) throws java.sql.SQLException
- Specified by:
getRef
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getBlob
public java.sql.Blob getBlob(int i) throws java.sql.SQLException
- Specified by:
getBlob
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getClob
public java.sql.Clob getClob(int i) throws java.sql.SQLException
- Specified by:
getClob
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getArray
public java.sql.Array getArray(int i) throws java.sql.SQLException
- Specified by:
getArray
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getObject
public java.lang.Object getObject(java.lang.String colName, java.util.Map map) throws java.sql.SQLException
- Specified by:
getObject
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getRef
public java.sql.Ref getRef(java.lang.String colName) throws java.sql.SQLException
- Specified by:
getRef
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getBlob
public java.sql.Blob getBlob(java.lang.String colName) throws java.sql.SQLException
- Specified by:
getBlob
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getClob
public java.sql.Clob getClob(java.lang.String colName) throws java.sql.SQLException
- Specified by:
getClob
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getArray
public java.sql.Array getArray(java.lang.String colName) throws java.sql.SQLException
- Specified by:
getArray
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getDate
public java.sql.Date getDate(int columnIndex, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
getDate
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getDate
public java.sql.Date getDate(java.lang.String columnName, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
getDate
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getTime
public java.sql.Time getTime(int columnIndex, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
getTime
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getTime
public java.sql.Time getTime(java.lang.String columnName, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
getTime
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getTimestamp
public java.sql.Timestamp getTimestamp(int columnIndex, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
getTimestamp
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getTimestamp
public java.sql.Timestamp getTimestamp(java.lang.String columnName, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
getTimestamp
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getURL
public java.net.URL getURL(int columnIndex) throws java.sql.SQLException
- Specified by:
getURL
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getURL
public java.net.URL getURL(java.lang.String columnName) throws java.sql.SQLException
- Specified by:
getURL
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateRef
public void updateRef(int columnIndex, java.sql.Ref x) throws java.sql.SQLException
- Specified by:
updateRef
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateRef
public void updateRef(java.lang.String columnName, java.sql.Ref x) throws java.sql.SQLException
- Specified by:
updateRef
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateBlob
public void updateBlob(int columnIndex, java.sql.Blob x) throws java.sql.SQLException
- Specified by:
updateBlob
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateBlob
public void updateBlob(java.lang.String columnName, java.sql.Blob x) throws java.sql.SQLException
- Specified by:
updateBlob
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateClob
public void updateClob(int columnIndex, java.sql.Clob x) throws java.sql.SQLException
- Specified by:
updateClob
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateClob
public void updateClob(java.lang.String columnName, java.sql.Clob x) throws java.sql.SQLException
- Specified by:
updateClob
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateArray
public void updateArray(int columnIndex, java.sql.Array x) throws java.sql.SQLException
- Specified by:
updateArray
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateArray
public void updateArray(java.lang.String columnName, java.sql.Array x) throws java.sql.SQLException
- Specified by:
updateArray
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getRowId
public java.sql.RowId getRowId(int columnIndex) throws java.sql.SQLException
- Specified by:
getRowId
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getRowId
public java.sql.RowId getRowId(java.lang.String columnLabel) throws java.sql.SQLException
- Specified by:
getRowId
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateRowId
public void updateRowId(int columnIndex, java.sql.RowId x) throws java.sql.SQLException
- Specified by:
updateRowId
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateRowId
public void updateRowId(java.lang.String columnLabel, java.sql.RowId x) throws java.sql.SQLException
- Specified by:
updateRowId
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getHoldability
public int getHoldability() throws java.sql.SQLException
- Specified by:
getHoldability
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
isClosed
public boolean isClosed() throws java.sql.SQLException
- Specified by:
isClosed
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateNString
public void updateNString(int columnIndex, java.lang.String nString) throws java.sql.SQLException
- Specified by:
updateNString
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateNString
public void updateNString(java.lang.String columnLabel, java.lang.String nString) throws java.sql.SQLException
- Specified by:
updateNString
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateNClob
public void updateNClob(int columnIndex, java.sql.NClob nClob) throws java.sql.SQLException
- Specified by:
updateNClob
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateNClob
public void updateNClob(java.lang.String columnLabel, java.sql.NClob nClob) throws java.sql.SQLException
- Specified by:
updateNClob
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getNClob
public java.sql.NClob getNClob(int columnIndex) throws java.sql.SQLException
- Specified by:
getNClob
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getNClob
public java.sql.NClob getNClob(java.lang.String columnLabel) throws java.sql.SQLException
- Specified by:
getNClob
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getSQLXML
public java.sql.SQLXML getSQLXML(int columnIndex) throws java.sql.SQLException
- Specified by:
getSQLXML
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getSQLXML
public java.sql.SQLXML getSQLXML(java.lang.String columnLabel) throws java.sql.SQLException
- Specified by:
getSQLXML
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateSQLXML
public void updateSQLXML(int columnIndex, java.sql.SQLXML xmlObject) throws java.sql.SQLException
- Specified by:
updateSQLXML
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateSQLXML
public void updateSQLXML(java.lang.String columnLabel, java.sql.SQLXML xmlObject) throws java.sql.SQLException
- Specified by:
updateSQLXML
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getNString
public java.lang.String getNString(int columnIndex) throws java.sql.SQLException
- Specified by:
getNString
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getNString
public java.lang.String getNString(java.lang.String columnLabel) throws java.sql.SQLException
- Specified by:
getNString
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getNCharacterStream
public java.io.Reader getNCharacterStream(int columnIndex) throws java.sql.SQLException
- Specified by:
getNCharacterStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getNCharacterStream
public java.io.Reader getNCharacterStream(java.lang.String columnLabel) throws java.sql.SQLException
- Specified by:
getNCharacterStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateNCharacterStream
public void updateNCharacterStream(int columnIndex, java.io.Reader x, long length) throws java.sql.SQLException
- Specified by:
updateNCharacterStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateNCharacterStream
public void updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length) throws java.sql.SQLException
- Specified by:
updateNCharacterStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateAsciiStream
public void updateAsciiStream(int columnIndex, java.io.InputStream x, long length) throws java.sql.SQLException
- Specified by:
updateAsciiStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateBinaryStream
public void updateBinaryStream(int columnIndex, java.io.InputStream x, long length) throws java.sql.SQLException
- Specified by:
updateBinaryStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateCharacterStream
public void updateCharacterStream(int columnIndex, java.io.Reader x, long length) throws java.sql.SQLException
- Specified by:
updateCharacterStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateAsciiStream
public void updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x, long length) throws java.sql.SQLException
- Specified by:
updateAsciiStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateBinaryStream
public void updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x, long length) throws java.sql.SQLException
- Specified by:
updateBinaryStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateCharacterStream
public void updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length) throws java.sql.SQLException
- Specified by:
updateCharacterStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateBlob
public void updateBlob(int columnIndex, java.io.InputStream inputStream, long length) throws java.sql.SQLException
- Specified by:
updateBlob
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateBlob
public void updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream, long length) throws java.sql.SQLException
- Specified by:
updateBlob
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateClob
public void updateClob(int columnIndex, java.io.Reader reader, long length) throws java.sql.SQLException
- Specified by:
updateClob
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateClob
public void updateClob(java.lang.String columnLabel, java.io.Reader reader, long length) throws java.sql.SQLException
- Specified by:
updateClob
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateNClob
public void updateNClob(int columnIndex, java.io.Reader reader, long length) throws java.sql.SQLException
- Specified by:
updateNClob
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateNClob
public void updateNClob(java.lang.String columnLabel, java.io.Reader reader, long length) throws java.sql.SQLException
- Specified by:
updateNClob
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateNCharacterStream
public void updateNCharacterStream(int columnIndex, java.io.Reader x) throws java.sql.SQLException
- Specified by:
updateNCharacterStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateNCharacterStream
public void updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader) throws java.sql.SQLException
- Specified by:
updateNCharacterStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateAsciiStream
public void updateAsciiStream(int columnIndex, java.io.InputStream x) throws java.sql.SQLException
- Specified by:
updateAsciiStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateBinaryStream
public void updateBinaryStream(int columnIndex, java.io.InputStream x) throws java.sql.SQLException
- Specified by:
updateBinaryStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateCharacterStream
public void updateCharacterStream(int columnIndex, java.io.Reader x) throws java.sql.SQLException
- Specified by:
updateCharacterStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateAsciiStream
public void updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x) throws java.sql.SQLException
- Specified by:
updateAsciiStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateBinaryStream
public void updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x) throws java.sql.SQLException
- Specified by:
updateBinaryStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateCharacterStream
public void updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader) throws java.sql.SQLException
- Specified by:
updateCharacterStream
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateBlob
public void updateBlob(int columnIndex, java.io.InputStream inputStream) throws java.sql.SQLException
- Specified by:
updateBlob
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateBlob
public void updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream) throws java.sql.SQLException
- Specified by:
updateBlob
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateClob
public void updateClob(int columnIndex, java.io.Reader reader) throws java.sql.SQLException
- Specified by:
updateClob
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateClob
public void updateClob(java.lang.String columnLabel, java.io.Reader reader) throws java.sql.SQLException
- Specified by:
updateClob
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateNClob
public void updateNClob(int columnIndex, java.io.Reader reader) throws java.sql.SQLException
- Specified by:
updateNClob
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
updateNClob
public void updateNClob(java.lang.String columnLabel, java.io.Reader reader) throws java.sql.SQLException
- Specified by:
updateNClob
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
unwrap
public java.lang.Object unwrap(java.lang.Class iface) throws java.sql.SQLException
- Specified by:
unwrap
in interfacejava.sql.Wrapper
- Throws:
java.sql.SQLException
-
isWrapperFor
public boolean isWrapperFor(java.lang.Class iface) throws java.sql.SQLException
- Specified by:
isWrapperFor
in interfacejava.sql.Wrapper
- Throws:
java.sql.SQLException
-
getObject
public <T> T getObject(java.lang.String columnLabel, java.lang.Class<T> arg0) throws java.sql.SQLException
- Specified by:
getObject
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
getObject
public <T> T getObject(int columnIndex, java.lang.Class<T> arg0) throws java.sql.SQLException
- Specified by:
getObject
in interfacejava.sql.ResultSet
- Throws:
java.sql.SQLException
-
setNClob
public void setNClob(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
setBlob
public void setBlob(java.lang.String parameterName, java.io.InputStream inputStream) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
setClob
public void setClob(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
setNCharacterStream
public void setNCharacterStream(java.lang.String parameterName, java.io.Reader value) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
setCharacterStream
public void setCharacterStream(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
setBinaryStream
public void setBinaryStream(java.lang.String parameterName, java.io.InputStream x) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
setAsciiStream
public void setAsciiStream(java.lang.String parameterName, java.io.InputStream x) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
setCharacterStream
public void setCharacterStream(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
setBinaryStream
public void setBinaryStream(java.lang.String parameterName, java.io.InputStream x, long length) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
setAsciiStream
public void setAsciiStream(java.lang.String parameterName, java.io.InputStream x, long length) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
setClob
public void setClob(java.lang.String parameterName, java.sql.Clob x) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
setBlob
public void setBlob(java.lang.String parameterName, java.sql.Blob x) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
finalize
public void finalize()
- Overrides:
finalize
in classjava.lang.Object
-
-