JDBaccess API 1.0

com.jdbaccess.da
Interface CallResult


public interface CallResult

Results of procedure calls (in Oracle also of function calls). You get a call result for example by calling yourProcedure.getResult(n) with the appropriate result position. CallResult are like Result and have many methods of Result. But call results are not scrollable so that some methods like getPreviousElements are not available.


Method Summary
 java.util.ArrayList getAllElements()
          Get all the elements of the result.
 java.util.ArrayList getFields()
          This method delivers all fields (with type, sqlType, scale, precision etc.) as an Arraylist for that select.
 TransferObject getNextElement()
          Get the next element of the result from actual position forward.
 java.util.ArrayList getNextElements()
          Get the next elements of the result from actual position forward as the page size is defined.
 java.util.ArrayList getNextElements(long count)
          Get the next "count" elements of the result from actual position forward.
 long getPosition()
          Get the actual position of the result
 int getResultPosition()
          Get the result position of that call result in its call.
 void setPageSize(int pageSize)
          Set the page size of the result.
 void setReadLobsFull(boolean readLobsFull)
          if true, all lob fields are read completely from the database tables, else lob fields are read only to a default size because of performance reasons
 

Method Detail

getResultPosition

int getResultPosition()
Get the result position of that call result in its call.

Returns:
position of this call result in its call (procedure or function)

getNextElement

TransferObject getNextElement()
                              throws ApplicationException
Get the next element of the result from actual position forward.

Returns:
the next element from position forward, null if there is no more element
Throws:
ApplicationException

getNextElements

java.util.ArrayList getNextElements()
                                    throws ApplicationException
Get the next elements of the result from actual position forward as the page size is defined.

Returns:
next elements from actual position forward as page size is defined (default page size is 100). E.g. if page size is 100 and position is 200 it get the elements from position 200 to 300
Throws:
ApplicationException

getNextElements

java.util.ArrayList getNextElements(long count)
                                    throws ApplicationException
Get the next "count" elements of the result from actual position forward.

Parameters:
count - number of elements which should be fetched
Returns:
next "count" elements from actual position forward.
Throws:
ApplicationException

getAllElements

java.util.ArrayList getAllElements()
                                   throws ApplicationException
Get all the elements of the result. After this operation the size of the result is calculated so that a later call of getSize() is more performant. Be carefull: Do not call this method if the result size is very big because of performance and RAM consumption. After this operation the position of this result is at last position.

Returns:
all elements from first position to last position.
Throws:
ApplicationException

getPosition

long getPosition()
Get the actual position of the result

Returns:
position in result (0 == beforeFirst, 1 == first, 2 == second, ..., size == last)

setPageSize

void setPageSize(int pageSize)
Set the page size of the result. The page size is used in "getNextElements()" and "getPreviousElements()". If no page size is set the default the page size is used.

Parameters:
pageSize - page size of the result

setReadLobsFull

void setReadLobsFull(boolean readLobsFull)
if true, all lob fields are read completely from the database tables, else lob fields are read only to a default size because of performance reasons

Parameters:
readLobsFull -

getFields

java.util.ArrayList getFields()
This method delivers all fields (with type, sqlType, scale, precision etc.) as an Arraylist for that select.

Returns:
ArrayList of fields of type Field

JDBaccess API 1.0

Copyright © 2005-2006 JDBaccess.com, Königsweg 210, D-14129 Berlin, Germany. All Rights Reserved.