| java.lang.Object
 org.hsqldb.Result
| Result | | public class Result (Code) | | The primary unit of comunication between Connection, Server and Session
objects.
An HSQLDB Result object encapsulates all requests (such as to alter or
query session settings, to allocate and execute statements, etc.) and all
responses (such as exception indications, update counts, result sets and
result set metadata). It also implements the HSQL wire protocol for
comunicating all such requests and responses across the network.
Extensively rewritten and extended in successive versions of HSQLDB.
author:
Thomas Mueller (Hypersonic SQL Group)
version:
1.8.0
since:
Hypersonic SQL |
| Inner Class :public static class ResultMetaData | |
| Method Summary | |
| public void | add(Object[] d)
| | void | addAll(Result r)
| | void | append(Result a)
Append Result argument to this. | | public void | clear()
| | public int | getColumnCount()
| | int | getConnectionAttrType()
| | int | getEndTranType()
| | public Throwable | getException()
| | public String | getMainString()
| | Object[] | getParameterData()
| | public int | getSize()
| | public int | getStatementID()
| | public int | getStatementType()
| | public String | getSubString()
| | public int | getType()
| | public int | getUpdateCount()
| | public int[] | getUpdateCounts()
| | public boolean | isData()
| | public boolean | isEmpty()
| | public boolean | isError()
| | public boolean | isUpdateCount()
| | public Iterator | iterator()
| | static Result | newExecuteDirectRequest(String sql)
| | public static Result | newFreeStmtRequest(int statementID)
| | static Result | newParameterDescriptionResult(int len)
| | static Result | newPrepareResponse(int csid, Result rsmd, Result pmd)
| | public static Result | newReleaseSavepointRequest(String name)
| | public static Result | newRollbackToSavepointRequest(String name)
| | static Result | newSessionAttributesResult()
| | public static Result | newSetSavepointRequest(String name)
| | static Result | newSingleColumnResult(String colName, int colType)
| | public static Result | read(RowInputBinary rowin, DataInput datain)
Convenience method for reading, shared by Server side. | | void | readMultiResult(RowInputBinary in)
| | void | removeDifferent(Session session, Result r2, int columnCount)
Removes all duplicate rows then removes all rows that are not shared
between this and the other result, based on comparing the first
columnCount columns of each result. | | void | removeDuplicates(Session session)
Removes duplicate rows on the basis of comparing the singificant
columns of the rows in the result. | | void | removeDuplicates(Session session, int columnCount)
Removes duplicate rows on the basis of comparing the first columnCount
columns of rows in the result. | | void | removeSecond(Session session, Result minus, int columnCount)
Removes duplicates then removes the contents of the second result
from this one base on first columnCount of the rows in each result. | | void | setColumnCount(int columns)
| | void | setConnectionAttrType(int type)
| | void | setEndTranType(int type)
| | public void | setMainString(String sql)
| | public void | setMaxRows(int count)
| | public void | setParameterData(Object[] data)
| | public void | setResultType(int type)
| | void | setRows(Result a)
| | void | setStatementID(int id)
| | public void | setStatementType(int type)
| | void | sortResult(Session session, int[] order, int[] way)
| | void | trimResult(int limitstart, int limitcount)
| | void | write(RowOutputBinary out)
| | public static void | write(Result r, RowOutputBinary rowout, OutputStream dataout)
Convenience method for writing, shared by Server side. |
| databaseID | | int databaseID(Code) | | |
| metaData | | public ResultMetaData metaData(Code) | | |
| statementID | | int statementID(Code) | | |
| updateCount | | int updateCount(Code) | | |
| Result | | public Result(int type)(Code) | | General constructor
|
| Result | | Result(ResultMetaData md)(Code) | | |
| Result | | Result(String error, String state, int code)(Code) | | Constructor for errors
Parameters:
error - error message
Parameters:
state - sql state
Parameters:
code - vendor code |
| Result | | Result(int type, int columns)(Code) | | Only used with DATA and PARAM_META_DATA results
Parameters:
columns - |
| Result | | public Result(int type, int[] types, int id)(Code) | | For BATCHEXECUTE and BATCHEXECDIRECT
|
| add | | public void add(Object[] d)(Code) | | Method declaration
Parameters:
d - |
| append | | void append(Result a)(Code) | | Append Result argument to this.
Parameters:
a - |
| clear | | public void clear()(Code) | | |
| getColumnCount | | public int getColumnCount()(Code) | | Method declaration
|
| getConnectionAttrType | | int getConnectionAttrType()(Code) | | |
| getEndTranType | | int getEndTranType()(Code) | | |
| getSize | | public int getSize()(Code) | | Method declaration
|
| getStatementID | | public int getStatementID()(Code) | | |
| getStatementType | | public int getStatementType()(Code) | | |
| getType | | public int getType()(Code) | | |
| getUpdateCount | | public int getUpdateCount()(Code) | | |
| getUpdateCounts | | public int[] getUpdateCounts()(Code) | | |
| isData | | public boolean isData()(Code) | | |
| isEmpty | | public boolean isEmpty()(Code) | | |
| isError | | public boolean isError()(Code) | | |
| isUpdateCount | | public boolean isUpdateCount()(Code) | | |
| newFreeStmtRequest | | public static Result newFreeStmtRequest(int statementID)(Code) | | |
| newParameterDescriptionResult | | static Result newParameterDescriptionResult(int len)(Code) | | |
| newReleaseSavepointRequest | | public static Result newReleaseSavepointRequest(String name)(Code) | | |
| newRollbackToSavepointRequest | | public static Result newRollbackToSavepointRequest(String name)(Code) | | |
| newSessionAttributesResult | | static Result newSessionAttributesResult()(Code) | | Result structure used for set/get session attributes
|
| newSingleColumnResult | | static Result newSingleColumnResult(String colName, int colType)(Code) | | |
| removeDifferent | | void removeDifferent(Session session, Result r2, int columnCount) throws HsqlException(Code) | | Removes all duplicate rows then removes all rows that are not shared
between this and the other result, based on comparing the first
columnCount columns of each result.
Parameters:
r2 -
throws:
HsqlException - |
| removeDuplicates | | void removeDuplicates(Session session) throws HsqlException(Code) | | Removes duplicate rows on the basis of comparing the singificant
columns of the rows in the result.
throws:
HsqlException - |
| removeDuplicates | | void removeDuplicates(Session session, int columnCount) throws HsqlException(Code) | | Removes duplicate rows on the basis of comparing the first columnCount
columns of rows in the result.
throws:
HsqlException - |
| removeSecond | | void removeSecond(Session session, Result minus, int columnCount) throws HsqlException(Code) | | Removes duplicates then removes the contents of the second result
from this one base on first columnCount of the rows in each result.
Parameters:
minus -
throws:
HsqlException - |
| setColumnCount | | void setColumnCount(int columns)(Code) | | Method declaration
Parameters:
columns - |
| setConnectionAttrType | | void setConnectionAttrType(int type)(Code) | | |
| setEndTranType | | void setEndTranType(int type)(Code) | | |
| setMaxRows | | public void setMaxRows(int count)(Code) | | |
| setParameterData | | public void setParameterData(Object[] data)(Code) | | |
| setResultType | | public void setResultType(int type)(Code) | | |
| setRows | | void setRows(Result a)(Code) | | Method declaration
Parameters:
a - |
| setStatementID | | void setStatementID(int id)(Code) | | |
| setStatementType | | public void setStatementType(int type)(Code) | | |
| trimResult | | void trimResult(int limitstart, int limitcount)(Code) | | Method declaration
Parameters:
limitstart - number of records to discard at the head
Parameters:
limitcount - number of records to keep, all the rest if 0 |
|
|