public class QueryResultSet extends AbstractConnectionResult implements Iterable
Modifier and Type | Method and Description |
---|---|
boolean |
checkBooleanIsNull(int column,
int row)
Tests if a boolean in the result set is a null value.
|
void |
close()
Close the result set.
|
protected void |
closeResultImplementation()
Close the result set internally.
|
QueryResultRowSet |
fetchAllRowValues()
Fetches all rows from the result set.
|
QueryResultRowSet |
fetchFirstNRowValues(int n)
Fetches the first N rows from the result set.
|
QueryResultRowSet |
fetchResultSetRows(int startIndex,
int endIndex)
Fetch rows from the result set.
|
byte[] |
getBlobByColumnIndexAndRow(int column,
int row)
Retrieves a single byte[] value (BLOB) in the result set.
|
byte[] |
getBlobByColumnNameAndRow(String columnName,
int row)
Retrieves a single byte[] (BLOB) value in the result set by name.
|
void |
getBlobColumnByIndex(int column,
byte[][] input)
Retrieves a byte[] (BLOB) column by index.
|
void |
getBlobColumnByIndex(int column,
byte[][] input,
int offset,
int length)
Retrieves a byte[] (BLOB) column by index.
|
void |
getBlobColumnByName(String columnName,
byte[][] input)
Retrieves a byte[] (BLOB) column by name.
|
void |
getBlobColumnByName(String columnName,
byte[][] input,
int offset,
int length)
Retrieves a byte[] (BLOB) column by name.
|
boolean |
getBooleanByColumnIndexAndRow(int column,
int row)
Retrieves a single boolean value in the result set.
|
boolean |
getBooleanByColumnNameAndRow(String columnName,
int row)
Retrieves a single boolean value in the result set by name.
|
void |
getBooleanColumnByIndex(int column,
boolean[] input)
Retrieves a boolean column by index.
|
void |
getBooleanColumnByIndex(int column,
boolean[] input,
int offset,
int length)
Retrieves a boolean column by index.
|
void |
getBooleanColumnByName(String columnName,
boolean[] input)
Retrieves a boolean column by name.
|
void |
getBooleanColumnByName(String columnName,
boolean[] input,
int offset,
int length)
Retrieves a boolean column by name.
|
byte |
getByteByColumnIndexAndRow(int column,
int row)
Retrieves a single byte value in the result set.
|
byte |
getByteByColumnNameAndRow(String columnName,
int row)
Retrieves a single byte value in the result set by name.
|
void |
getByteColumnByIndex(int column,
byte[] input)
Retrieves a byte column by index.
|
void |
getByteColumnByIndex(int column,
byte[] input,
int offset,
int length)
Retrieves a byte column by index.
|
void |
getByteColumnByName(String columnName,
byte[] input)
Retrieves a byte column by name.
|
void |
getByteColumnByName(String columnName,
byte[] input,
int offset,
int length)
Retrieves a byte column by name.
|
void |
getColumnDigits(int[] input)
Gets the column digits as an integer array.
|
int |
getColumnIndexByName(String columnName)
Gets a column index from the result set by name
|
void |
getColumnNames(String[] input)
Gets the columns names as a string array.
|
void |
getColumnNullMappingsByIndex(int column,
boolean[] input)
Gets the null mapping of a column by index.
|
void |
getColumnScales(int[] input)
Gets the column scales as an integer array.
|
void |
getColumnTypes(String[] input)
Gets the columns types as a string array.
|
Date |
getDateByColumnIndexAndRow(int column,
int row)
Retrieves a single Date value in the result set.
|
Date |
getDateByColumnNameAndRow(String columnName,
int row)
Retrieves a single Date value in the result set by name.
|
void |
getDateColumnByIndex(int column,
Date[] input)
Retrieves a Date column by index.
|
void |
getDateColumnByIndex(int column,
Date[] input,
int offset,
int length)
Retrieves a Date column by index.
|
void |
getDateColumnByName(String columnName,
Date[] input)
Retrieves a Date column by name.
|
void |
getDateColumnByName(String columnName,
Date[] input,
int offset,
int length)
Retrieves a Date column by name.
|
BigDecimal |
getDecimalByColumnIndexAndRow(int column,
int row)
Retrieves a single BigDecimal value in the result set.
|
BigDecimal |
getDecimalByColumnNameAndRow(String columnName,
int row)
Retrieves a single decimal value in the result set by name.
|
void |
getDecimalColumnByIndex(int column,
BigDecimal[] input)
Retrieves a BigDecimal column by index.
|
void |
getDecimalColumnByIndex(int column,
BigDecimal[] input,
int offset,
int length)
Retrieves a BigDecimal column by index.
|
void |
getDecimalColumnByName(String columnName,
BigDecimal[] input)
Retrieves an BigDecimal column by name.
|
void |
getDecimalColumnByName(String columnName,
BigDecimal[] input,
int offset,
int length)
Retrieves a BigDecimal column by name.
|
double |
getDoubleByColumnIndexAndRow(int column,
int row)
Retrieves a single double value in the result set.
|
double |
getDoubleByColumnNameAndRow(String columnName,
int row)
Retrieves a single double value in the result set by name.
|
void |
getDoubleColumnByIndex(int column,
double[] input)
Retrieves a double column by index.
|
void |
getDoubleColumnByIndex(int column,
double[] input,
int offset,
int length)
Retrieves a double column by index.
|
void |
getDoubleColumnByName(String columnName,
double[] input)
Retrieves a double column by name.
|
void |
getDoubleColumnByName(String columnName,
double[] input,
int offset,
int length)
Retrieves a double column by name.
|
float |
getFloatByColumnIndexAndRow(int column,
int row)
Retrieves a single float value in the result set.
|
float |
getFloatByColumnNameAndRow(String columnName,
int row)
Retrieves a single float value in the result set by name.
|
void |
getFloatColumnByIndex(int column,
float[] input)
Retrieves a float column by index.
|
void |
getFloatColumnByIndex(int column,
float[] input,
int offset,
int length)
Retrieves a float column by index.
|
void |
getFloatColumnByName(String columnName,
float[] input)
Retrieves a float column by name.
|
void |
getFloatColumnByName(String columnName,
float[] input,
int offset,
int length)
Retrieves a float column by name.
|
void |
getIntColumnByIndex(int column,
int[] input)
Retrieves an integer column by index.
|
void |
getIntColumnByIndex(int column,
int[] input,
int offset,
int length)
Retrieves an integer column by index.
|
void |
getIntColumnByName(String columnName,
int[] input)
Retrieves an integer column by name.
|
void |
getIntColumnByName(String columnName,
int[] input,
int offset,
int length)
Retrieves an integer column by name.
|
int |
getIntegerByColumnIndexAndRow(int column,
int row)
Retrieves a single integer value in the result set.
|
int |
getIntegerByColumnNameAndRow(String columnName,
int row)
Retrieves a single integer value in the result set by name.
|
long |
getLongByColumnIndexAndRow(int column,
int row)
Retrieves a single long value in the result set.
|
long |
getLongByColumnNameAndRow(String columnName,
int row)
Retrieves a single long value in the result set by name.
|
void |
getLongColumnByIndex(int column,
long[] input)
Retrieves a long column by index.
|
void |
getLongColumnByIndex(int column,
long[] input,
int offset,
int length)
Retrieves a long column by index.
|
void |
getLongColumnByName(String columnName,
long[] input)
Retrieves a long column by name.
|
void |
getLongColumnByName(String columnName,
long[] input,
int offset,
int length)
Retrieves a long column by name.
|
void |
getMappings(MonetDBToJavaMapping[] input)
Gets the Java mappings as a MonetDBToJavaMapping array.
|
void |
getNullMappingByName(String columnName,
boolean[] input)
Gets the null mapping of a column by name
|
int |
getNumberOfColumns()
Returns the number of columns in the result set.
|
int |
getNumberOfRows()
Returns the number of rows in the result set.
|
short |
getShortByColumnIndexAndRow(int column,
int row)
Retrieves a single short value in the result set.
|
short |
getShortByColumnNameAndRow(String columnName,
int row)
Retrieves a single short value in the result set by name.
|
void |
getShortColumnByIndex(int column,
short[] input)
Retrieves a short column by index.
|
void |
getShortColumnByIndex(int column,
short[] input,
int offset,
int length)
Retrieves a short column by index.
|
void |
getShortColumnByName(String columnName,
short[] input)
Retrieves a short column by name.
|
void |
getShortColumnByName(String columnName,
short[] input,
int offset,
int length)
Retrieves a short column by name.
|
String |
getStringByColumnIndexAndRow(int column,
int row)
Retrieves a single String value in the result set.
|
String |
getStringByColumnNameAndRow(String columnName,
int row)
Retrieves a single String value in the result set by name.
|
void |
getStringColumnByIndex(int column,
String[] input)
Retrieves a String column by index.
|
void |
getStringColumnByIndex(int column,
String[] input,
int offset,
int length)
Retrieves a String column by index.
|
void |
getStringColumnByName(String columnName,
String[] input)
Retrieves a String column by name.
|
void |
getStringColumnByName(String columnName,
String[] input,
int offset,
int length)
Retrieves a String column by name.
|
Time |
getTimeByColumnIndexAndRow(int column,
int row)
Retrieves a single Time value in the result set.
|
Time |
getTimeByColumnNameAndRow(String columnName,
int row)
Retrieves a single Time value in the result set by name.
|
void |
getTimeColumnByIndex(int column,
Time[] input)
Retrieves a Time column by index.
|
void |
getTimeColumnByIndex(int column,
Time[] input,
int offset,
int length)
Retrieves a Time column by index.
|
void |
getTimeColumnByName(String columnName,
Time[] input)
Retrieves a Time column by name.
|
void |
getTimeColumnByName(String columnName,
Time[] input,
int offset,
int length)
Retrieves a Time column by name.
|
Timestamp |
getTimestampByColumnIndexAndRow(int column,
int row)
Retrieves a single Timestamp value in the result set.
|
Timestamp |
getTimestampByColumnNameAndRow(String columnName,
int row)
Retrieves a single Timestamp value in the result set by name.
|
void |
getTimestampColumnByIndex(int column,
Timestamp[] input)
Retrieves a Timestamp column by index.
|
void |
getTimestampColumnByIndex(int column,
Timestamp[] input,
int offset,
int length)
Retrieves a Timestamp column by index.
|
void |
getTimestampColumnByName(String columnName,
Timestamp[] input)
Retrieves a Timestamp column by name.
|
void |
getTimestampColumnByName(String columnName,
Timestamp[] input,
int offset,
int length)
Retrieves a Timestamp column by name.
|
boolean |
isQueryResultSetClosed()
Tells if the connection of this statement result has been closed or not.
|
ListIterator<MonetDBRow> |
iterator() |
void |
mapColumnToObjectByIndex(int column,
Object[] input)
Maps a column to a Java Object representation of the array by index.
|
void |
mapColumnToObjectByName(String columnName,
Object[] input)
Maps a column to a Java Object representation of the array by name.
|
checkMetadataArrayLength, finalize, getConnection, getRandomIdentifier
clone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
forEach, spliterator
public boolean isQueryResultSetClosed()
public int getNumberOfRows()
AbstractConnectionResult
getNumberOfRows
in class AbstractConnectionResult
public int getNumberOfColumns()
AbstractConnectionResult
getNumberOfColumns
in class AbstractConnectionResult
public void getColumnNames(String[] input) throws MonetDBEmbeddedException
AbstractConnectionResult
getColumnNames
in class AbstractConnectionResult
input
- The columns names array to fill.MonetDBEmbeddedException
- If an error in the database occurred.public void getColumnTypes(String[] input) throws MonetDBEmbeddedException
AbstractConnectionResult
getColumnTypes
in class AbstractConnectionResult
input
- The columns types array to fill.MonetDBEmbeddedException
- If an error in the database occurred.public void getMappings(MonetDBToJavaMapping[] input) throws MonetDBEmbeddedException
AbstractConnectionResult
getMappings
in class AbstractConnectionResult
input
- The columns mappings array to fill.MonetDBEmbeddedException
- If an error in the database occurred..public void getColumnDigits(int[] input) throws MonetDBEmbeddedException
AbstractConnectionResult
getColumnDigits
in class AbstractConnectionResult
input
- The columns digits array to fill.MonetDBEmbeddedException
- If an error in the database occurred.public void getColumnScales(int[] input) throws MonetDBEmbeddedException
AbstractConnectionResult
getColumnScales
in class AbstractConnectionResult
input
- The columns scales array to fill.MonetDBEmbeddedException
- If an error in the database occurred.public int getColumnIndexByName(String columnName)
columnName
- AbstractQueryResultSetColumn namepublic boolean getBooleanByColumnIndexAndRow(int column, int row) throws MonetDBEmbeddedException
column
- The column index starting from 1row
- The row index starting from 1MonetDBEmbeddedException
- If an error in the database occurred.public byte getByteByColumnIndexAndRow(int column, int row) throws MonetDBEmbeddedException
column
- The column index starting from 1row
- The row index starting from 1MonetDBEmbeddedException
- If an error in the database occurred.public short getShortByColumnIndexAndRow(int column, int row) throws MonetDBEmbeddedException
column
- The column index starting from 1row
- The row index starting from 1MonetDBEmbeddedException
- If an error in the database occurred.public int getIntegerByColumnIndexAndRow(int column, int row) throws MonetDBEmbeddedException
column
- The column index starting from 1row
- The row index starting from 1MonetDBEmbeddedException
- If an error in the database occurred.public long getLongByColumnIndexAndRow(int column, int row) throws MonetDBEmbeddedException
column
- The column index starting from 1row
- The row index starting from 1MonetDBEmbeddedException
- If an error in the database occurred.public float getFloatByColumnIndexAndRow(int column, int row) throws MonetDBEmbeddedException
column
- The column index starting from 1row
- The row index starting from 1MonetDBEmbeddedException
- If an error in the database occurred.public double getDoubleByColumnIndexAndRow(int column, int row) throws MonetDBEmbeddedException
column
- The column index starting from 1row
- The row index starting from 1MonetDBEmbeddedException
- If an error in the database occurred.public String getStringByColumnIndexAndRow(int column, int row) throws MonetDBEmbeddedException
column
- The column index starting from 1row
- The row index starting from 1MonetDBEmbeddedException
- If an error in the database occurred.public Date getDateByColumnIndexAndRow(int column, int row) throws MonetDBEmbeddedException
column
- The column index starting from 1row
- The row index starting from 1MonetDBEmbeddedException
- If an error in the database occurred.public Timestamp getTimestampByColumnIndexAndRow(int column, int row) throws MonetDBEmbeddedException
column
- The column index starting from 1row
- The row index starting from 1MonetDBEmbeddedException
- If an error in the database occurred.public Time getTimeByColumnIndexAndRow(int column, int row) throws MonetDBEmbeddedException
column
- The column index starting from 1row
- The row index starting from 1MonetDBEmbeddedException
- If an error in the database occurred.public byte[] getBlobByColumnIndexAndRow(int column, int row) throws MonetDBEmbeddedException
column
- The column index starting from 1row
- The row index starting from 1MonetDBEmbeddedException
- If an error in the database occurred.public BigDecimal getDecimalByColumnIndexAndRow(int column, int row) throws MonetDBEmbeddedException
column
- The column index starting from 1row
- The row index starting from 1MonetDBEmbeddedException
- If an error in the database occurred.public boolean getBooleanByColumnNameAndRow(String columnName, int row) throws MonetDBEmbeddedException
columnName
- The column namerow
- The row index starting from 1MonetDBEmbeddedException
- If an error in the database occurred.public byte getByteByColumnNameAndRow(String columnName, int row) throws MonetDBEmbeddedException
columnName
- The column namerow
- The row index starting from 1MonetDBEmbeddedException
- If an error in the database occurred.public short getShortByColumnNameAndRow(String columnName, int row) throws MonetDBEmbeddedException
columnName
- The column namerow
- The row index starting from 1MonetDBEmbeddedException
- If an error in the database occurred.public int getIntegerByColumnNameAndRow(String columnName, int row) throws MonetDBEmbeddedException
columnName
- The column namerow
- The row index starting from 1MonetDBEmbeddedException
- If an error in the database occurred.public long getLongByColumnNameAndRow(String columnName, int row) throws MonetDBEmbeddedException
columnName
- The column namerow
- The row index starting from 1MonetDBEmbeddedException
- If an error in the database occurred.public float getFloatByColumnNameAndRow(String columnName, int row) throws MonetDBEmbeddedException
columnName
- The column namerow
- The row index starting from 1MonetDBEmbeddedException
- If an error in the database occurred.public double getDoubleByColumnNameAndRow(String columnName, int row) throws MonetDBEmbeddedException
columnName
- The column namerow
- The row index starting from 1MonetDBEmbeddedException
- If an error in the database occurred.public String getStringByColumnNameAndRow(String columnName, int row) throws MonetDBEmbeddedException
columnName
- The column namerow
- The row index starting from 1MonetDBEmbeddedException
- If an error in the database occurred.public Date getDateByColumnNameAndRow(String columnName, int row) throws MonetDBEmbeddedException
columnName
- The column namerow
- The row index starting from 1MonetDBEmbeddedException
- If an error in the database occurred.public Timestamp getTimestampByColumnNameAndRow(String columnName, int row) throws MonetDBEmbeddedException
columnName
- The column namerow
- The row index starting from 1MonetDBEmbeddedException
- If an error in the database occurred.public Time getTimeByColumnNameAndRow(String columnName, int row) throws MonetDBEmbeddedException
columnName
- The column namerow
- The row index starting from 1MonetDBEmbeddedException
- If an error in the database occurred.public byte[] getBlobByColumnNameAndRow(String columnName, int row) throws MonetDBEmbeddedException
columnName
- The column namerow
- The row index starting from 1MonetDBEmbeddedException
- If an error in the database occurred.public BigDecimal getDecimalByColumnNameAndRow(String columnName, int row) throws MonetDBEmbeddedException
columnName
- The column namerow
- The row index starting from 1MonetDBEmbeddedException
- If an error in the database occurred.public void getBooleanColumnByIndex(int column, boolean[] input, int offset, int length) throws MonetDBEmbeddedException
column
- - The index of the column starting from 1.input
- - The input boolean array where the result will be copied to.offset
- - The starting offset of the array.length
- - The number of elements to copy.MonetDBEmbeddedException
- If an error in the database occurred.public void getByteColumnByIndex(int column, byte[] input, int offset, int length) throws MonetDBEmbeddedException
column
- - The index of the column starting from 1.input
- - The input byte array where the result will be copied to.offset
- - The starting offset of the array.length
- - The number of elements to copy.MonetDBEmbeddedException
- If an error in the database occurred.public void getShortColumnByIndex(int column, short[] input, int offset, int length) throws MonetDBEmbeddedException
column
- - The index of the column starting from 1.input
- - The input short array where the result will be copied to.offset
- - The starting offset of the array.length
- - The number of elements to copy.MonetDBEmbeddedException
- If an error in the database occurred.public void getIntColumnByIndex(int column, int[] input, int offset, int length) throws MonetDBEmbeddedException
column
- - The index of the column starting from 1.input
- - The input integer array where the result will be copied to.offset
- - The starting offset of the array.length
- - The number of elements to copy.MonetDBEmbeddedException
- If an error in the database occurred.public void getLongColumnByIndex(int column, long[] input, int offset, int length) throws MonetDBEmbeddedException
column
- - The index of the column starting from 1.input
- - The input long array where the result will be copied to.offset
- - The starting offset of the array.length
- - The number of elements to copy.MonetDBEmbeddedException
- If an error in the database occurred.public void getFloatColumnByIndex(int column, float[] input, int offset, int length) throws MonetDBEmbeddedException
column
- - The index of the column starting from 1.input
- - The input float array where the result will be copied to.offset
- - The starting offset of the array.length
- - The number of elements to copy.MonetDBEmbeddedException
- If an error in the database occurred.public void getDoubleColumnByIndex(int column, double[] input, int offset, int length) throws MonetDBEmbeddedException
column
- - The index of the column starting from 1.input
- - The input double array where the result will be copied to.offset
- - The starting offset of the array.length
- - The number of elements to copy.MonetDBEmbeddedException
- If an error in the database occurred.public void getStringColumnByIndex(int column, String[] input, int offset, int length) throws MonetDBEmbeddedException
column
- - The index of the column starting from 1.input
- - The input String array where the result will be copied to.offset
- - The starting offset of the array.length
- - The number of elements to copy.MonetDBEmbeddedException
- If an error in the database occurred.public void getDateColumnByIndex(int column, Date[] input, int offset, int length) throws MonetDBEmbeddedException
column
- - The index of the column starting from 1.input
- - The input Date array where the result will be copied to.offset
- - The starting offset of the array.length
- - The number of elements to copy.MonetDBEmbeddedException
- If an error in the database occurred.public void getTimestampColumnByIndex(int column, Timestamp[] input, int offset, int length) throws MonetDBEmbeddedException
column
- - The index of the column starting from 1.input
- - The input Timestamp array where the result will be copied to.offset
- - The starting offset of the array.length
- - The number of elements to copy.MonetDBEmbeddedException
- If an error in the database occurred.public void getTimeColumnByIndex(int column, Time[] input, int offset, int length) throws MonetDBEmbeddedException
column
- - The index of the column starting from 1.input
- - The input Time array where the result will be copied to.offset
- - The starting offset of the array.length
- - The number of elements to copy.MonetDBEmbeddedException
- If an error in the database occurred.public void getBlobColumnByIndex(int column, byte[][] input, int offset, int length) throws MonetDBEmbeddedException
column
- - The index of the column starting from 1.input
- - The input byte[] (BLOB) array where the result will be copied to.offset
- - The starting offset of the array.length
- - The number of elements to copy.MonetDBEmbeddedException
- If an error in the database occurred.public void getDecimalColumnByIndex(int column, BigDecimal[] input, int offset, int length) throws MonetDBEmbeddedException
column
- - The index of the column starting from 1.input
- - The input BigDecimal array where the result will be copied to.offset
- - The starting offset of the array.length
- - The number of elements to copy.MonetDBEmbeddedException
- If an error in the database occurred.public void getBooleanColumnByName(String columnName, boolean[] input, int offset, int length) throws MonetDBEmbeddedException
columnName
- - The name of the column.input
- - The input boolean array where the result will be copied to.offset
- - The starting offset of the array.length
- - The number of elements to copy.MonetDBEmbeddedException
- If an error in the database occurred.public void getByteColumnByName(String columnName, byte[] input, int offset, int length) throws MonetDBEmbeddedException
columnName
- - The name of the column.input
- - The input byte array where the result will be copied to.offset
- - The starting offset of the array.length
- - The number of elements to copy.MonetDBEmbeddedException
- If an error in the database occurred.public void getShortColumnByName(String columnName, short[] input, int offset, int length) throws MonetDBEmbeddedException
columnName
- - The name of the column.input
- - The input short array where the result will be copied to.offset
- - The starting offset of the array.length
- - The number of elements to copy.MonetDBEmbeddedException
- If an error in the database occurred.public void getIntColumnByName(String columnName, int[] input, int offset, int length) throws MonetDBEmbeddedException
columnName
- - The name of the column.input
- - The input integer array where the result will be copied to.offset
- - The starting offset of the array.length
- - The number of elements to copy.MonetDBEmbeddedException
- If an error in the database occurred.public void getLongColumnByName(String columnName, long[] input, int offset, int length) throws MonetDBEmbeddedException
columnName
- - The name of the column.input
- - The input long array where the result will be copied to.offset
- - The starting offset of the array.length
- - The number of elements to copy.MonetDBEmbeddedException
- If an error in the database occurred.public void getFloatColumnByName(String columnName, float[] input, int offset, int length) throws MonetDBEmbeddedException
columnName
- - The name of the column.input
- - The input float array where the result will be copied to.offset
- - The starting offset of the array.length
- - The number of elements to copy.MonetDBEmbeddedException
- If an error in the database occurred.public void getDoubleColumnByName(String columnName, double[] input, int offset, int length) throws MonetDBEmbeddedException
columnName
- - The name of the column.input
- - The input double array where the result will be copied to.offset
- - The starting offset of the array.length
- - The number of elements to copy.MonetDBEmbeddedException
- If an error in the database occurred.public void getStringColumnByName(String columnName, String[] input, int offset, int length) throws MonetDBEmbeddedException
columnName
- - The name of the column.input
- - The input String array where the result will be copied to.offset
- - The starting offset of the array.length
- - The number of elements to copy.MonetDBEmbeddedException
- If an error in the database occurred.public void getDateColumnByName(String columnName, Date[] input, int offset, int length) throws MonetDBEmbeddedException
columnName
- - The name of the column.input
- - The input Date array where the result will be copied to.offset
- - The starting offset of the array.length
- - The number of elements to copy.MonetDBEmbeddedException
- If an error in the database occurred.public void getTimestampColumnByName(String columnName, Timestamp[] input, int offset, int length) throws MonetDBEmbeddedException
columnName
- - The name of the column.input
- - The input Timestamp array where the result will be copied to.offset
- - The starting offset of the array.length
- - The number of elements to copy.MonetDBEmbeddedException
- If an error in the database occurred.public void getTimeColumnByName(String columnName, Time[] input, int offset, int length) throws MonetDBEmbeddedException
columnName
- - The name of the column.input
- - The input Time array where the result will be copied to.offset
- - The starting offset of the array.length
- - The number of elements to copy.MonetDBEmbeddedException
- If an error in the database occurred.public void getBlobColumnByName(String columnName, byte[][] input, int offset, int length) throws MonetDBEmbeddedException
columnName
- - The name of the column.input
- - The input byte[] (BLOB) array where the result will be copied to.offset
- - The starting offset of the array.length
- - The number of elements to copy.MonetDBEmbeddedException
- If an error in the database occurred.public void getDecimalColumnByName(String columnName, BigDecimal[] input, int offset, int length) throws MonetDBEmbeddedException
columnName
- - The name of the column.input
- - The input BigDecimal array where the result will be copied to.offset
- - The starting offset of the array.length
- - The number of elements to copy.MonetDBEmbeddedException
- If an error in the database occurred.public void getBooleanColumnByIndex(int column, boolean[] input) throws MonetDBEmbeddedException
column
- - The index of the column starting from 1.input
- - The input boolean array where the result will be copied to.MonetDBEmbeddedException
- If an error in the database occurred.public void getByteColumnByIndex(int column, byte[] input) throws MonetDBEmbeddedException
column
- - The index of the column starting from 1.input
- - The input byte array where the result will be copied to.MonetDBEmbeddedException
- If an error in the database occurred.public void getShortColumnByIndex(int column, short[] input) throws MonetDBEmbeddedException
column
- - The index of the column starting from 1.input
- - The input short array where the result will be copied to.MonetDBEmbeddedException
- If an error in the database occurred.public void getIntColumnByIndex(int column, int[] input) throws MonetDBEmbeddedException
column
- - The index of the column starting from 1.input
- - The input integer array where the result will be copied to.MonetDBEmbeddedException
- If an error in the database occurred.public void getLongColumnByIndex(int column, long[] input) throws MonetDBEmbeddedException
column
- - The index of the column starting from 1.input
- - The input long array where the result will be copied to.MonetDBEmbeddedException
- If an error in the database occurred.public void getFloatColumnByIndex(int column, float[] input) throws MonetDBEmbeddedException
column
- - The index of the column starting from 1.input
- - The input float array where the result will be copied to.MonetDBEmbeddedException
- If an error in the database occurred.public void getDoubleColumnByIndex(int column, double[] input) throws MonetDBEmbeddedException
column
- - The index of the column starting from 1.input
- - The input double array where the result will be copied to.MonetDBEmbeddedException
- If an error in the database occurred.public void getStringColumnByIndex(int column, String[] input) throws MonetDBEmbeddedException
column
- - The index of the column starting from 1.input
- - The input String array where the result will be copied to.MonetDBEmbeddedException
- If an error in the database occurred.public void getDateColumnByIndex(int column, Date[] input) throws MonetDBEmbeddedException
column
- - The index of the column starting from 1.input
- - The input Date array where the result will be copied to.MonetDBEmbeddedException
- If an error in the database occurred.public void getTimestampColumnByIndex(int column, Timestamp[] input) throws MonetDBEmbeddedException
column
- - The index of the column starting from 1.input
- - The input Timestamp array where the result will be copied to.MonetDBEmbeddedException
- If an error in the database occurred.public void getTimeColumnByIndex(int column, Time[] input) throws MonetDBEmbeddedException
column
- - The index of the column starting from 1.input
- - The input Time array where the result will be copied to.MonetDBEmbeddedException
- If an error in the database occurred.public void getBlobColumnByIndex(int column, byte[][] input) throws MonetDBEmbeddedException
column
- - The index of the column starting from 1.input
- - The input byte[] (BLOB) array where the result will be copied to.MonetDBEmbeddedException
- If an error in the database occurred.public void getDecimalColumnByIndex(int column, BigDecimal[] input) throws MonetDBEmbeddedException
column
- - The index of the column starting from 1.input
- - The input BigDecimal array where the result will be copied to.MonetDBEmbeddedException
- If an error in the database occurred.public void getBooleanColumnByName(String columnName, boolean[] input) throws MonetDBEmbeddedException
columnName
- - The name of the column.input
- - The input boolean array where the result will be copied to.MonetDBEmbeddedException
- If an error in the database occurred.public void getByteColumnByName(String columnName, byte[] input) throws MonetDBEmbeddedException
columnName
- - The name of the column.input
- - The input byte array where the result will be copied to.MonetDBEmbeddedException
- If an error in the database occurred.public void getShortColumnByName(String columnName, short[] input) throws MonetDBEmbeddedException
columnName
- - The name of the column.input
- - The input short array where the result will be copied to.MonetDBEmbeddedException
- If an error in the database occurred.public void getIntColumnByName(String columnName, int[] input) throws MonetDBEmbeddedException
columnName
- - The name of the column.input
- - The input integer array where the result will be copied to.MonetDBEmbeddedException
- If an error in the database occurred.public void getLongColumnByName(String columnName, long[] input) throws MonetDBEmbeddedException
columnName
- - The name of the column.input
- - The input long array where the result will be copied to.MonetDBEmbeddedException
- If an error in the database occurred.public void getFloatColumnByName(String columnName, float[] input) throws MonetDBEmbeddedException
columnName
- - The name of the column.input
- - The input float array where the result will be copied to.MonetDBEmbeddedException
- If an error in the database occurred.public void getDoubleColumnByName(String columnName, double[] input) throws MonetDBEmbeddedException
columnName
- - The name of the column.input
- - The input double array where the result will be copied to.MonetDBEmbeddedException
- If an error in the database occurred.public void getStringColumnByName(String columnName, String[] input) throws MonetDBEmbeddedException
columnName
- - The name of the column.input
- - The input String array where the result will be copied to.MonetDBEmbeddedException
- If an error in the database occurred.public void getDateColumnByName(String columnName, Date[] input) throws MonetDBEmbeddedException
columnName
- - The name of the column.input
- - The input Date array where the result will be copied to.MonetDBEmbeddedException
- If an error in the database occurred.public void getTimestampColumnByName(String columnName, Timestamp[] input) throws MonetDBEmbeddedException
columnName
- - The name of the column.input
- - The input Timestamp array where the result will be copied to.MonetDBEmbeddedException
- If an error in the database occurred.public void getTimeColumnByName(String columnName, Time[] input) throws MonetDBEmbeddedException
columnName
- - The name of the column.input
- - The input Time array where the result will be copied to.MonetDBEmbeddedException
- If an error in the database occurred.public void getBlobColumnByName(String columnName, byte[][] input) throws MonetDBEmbeddedException
columnName
- - The name of the column.input
- - The input byte[] (BLOB) array where the result will be copied to.MonetDBEmbeddedException
- If an error in the database occurred.public void getDecimalColumnByName(String columnName, BigDecimal[] input) throws MonetDBEmbeddedException
columnName
- - The name of the column.input
- - The input BigDecimal array where the result will be copied to.MonetDBEmbeddedException
- If an error in the database occurred.public boolean checkBooleanIsNull(int column, int row) throws MonetDBEmbeddedException
column
- The column index starting from 1row
- The row index in the column starting from 1MonetDBEmbeddedException
- If an error in the database occurred.public void getColumnNullMappingsByIndex(int column, boolean[] input) throws MonetDBEmbeddedException
column
- The column index starting from 1input
- An array of booleans, indicating if the values of the column are null or not.MonetDBEmbeddedException
- If an error in the database occurred.public void getNullMappingByName(String columnName, boolean[] input) throws MonetDBEmbeddedException
columnName
- The column nameinput
- An array of booleans, indicating if the values of the column are null or not.MonetDBEmbeddedException
- If an error in the database occurred.public void mapColumnToObjectByIndex(int column, Object[] input) throws MonetDBEmbeddedException
column
- The column index starting from 1input
- An Object array representation of the column.MonetDBEmbeddedException
- If an error in the database occurred.public void mapColumnToObjectByName(String columnName, Object[] input) throws MonetDBEmbeddedException
columnName
- The column nameinput
- An Object array representation of the column.MonetDBEmbeddedException
- If an error in the database occurred.public QueryResultRowSet fetchResultSetRows(int startIndex, int endIndex) throws MonetDBEmbeddedException
startIndex
- The first row index to retrieve starting from 1endIndex
- The last row index to retrieveQueryResultRowSet
MonetDBEmbeddedException
- If an error in the database occurred.public QueryResultRowSet fetchFirstNRowValues(int n) throws MonetDBEmbeddedException
n
- The last row index to retrieveQueryResultRowSet
MonetDBEmbeddedException
- If an error in the database occurred.public QueryResultRowSet fetchAllRowValues() throws MonetDBEmbeddedException
QueryResultRowSet
MonetDBEmbeddedException
- If an error in the database occurred.public ListIterator<MonetDBRow> iterator()
public void close()
AbstractConnectionResult
close
in interface Closeable
close
in interface AutoCloseable
close
in class AbstractConnectionResult
protected void closeResultImplementation()
AbstractConnectionResult
closeResultImplementation
in class AbstractConnectionResult
Copyright © 2018. All rights reserved.