borland.jbcl Packages  borland.jbcl Class Hierarchy  borland.jbcl.dataset 

ProcedureDataSet component

java.lang.Object
   +----borland.jbcl.dataset.ReadRow
           +----borland.jbcl.dataset.ReadWriteRow
                   +----borland.jbcl.dataset.DataSet
                           +----borland.jbcl.dataset.StorageDataSet
                                   +----borland.jbcl.dataset.ProcedureDataSet

About the ProcedureDataSet component

Variables  Constructors  Properties  Methods  Event Listeners

Implements AccessListener, MasterNavigateListener, StatusListener, EventListener

The ProcedureDataSet component is an extension of its superclass (StorageDataSet) and provides functionality to run a stored procedure against data stored in a SQL database. This component is recommended for advanced users only as it has no associated JBCL resolver component.

In any application that uses the ProcedureDataSet, the following components are also required:

The data contained in a ProcedureDataSet is the result of the most recent execution of the stored procedure. Storing the "result set" from the execution of the stored procedure in a ProcedureDataSet allows for greater flexibility in navigation of the resulting data.

The ProcedureDataSet inherits the maxRows property which allows you to set the maximum number of rows stored initially in the ProcedureDataSet as a result of the stored procedure execution.

Once the data is stored in the ProcedureDataSet, you manipulate it and connect it to UI controls in exactly the same way as you would other StorageDataSet components, without regard to which JBCL component is storing the data.

This component is used with servers whose JDBC driver supports executing stored procedures via an SQL query. Not all JDBC drivers support this; some vendor libraries require special API calls to invoke stored procedures. Refer to your server documentation for more information on whether it meets this requirement.


ProcedureDataSet variables

Variables implemented in borland.jbcl.dataset.ReadRow

ProcedureDataSet constructors

ProcedureDataSet properties

*Read-only properties **Write-only properties

Properties implemented in this class

Properties implemented in borland.jbcl.dataset.DataSet

Properties implemented in borland.jbcl.dataset.ReadRow

Properties implemented in borland.jbcl.dataset.ReadWriteRow

Properties implemented in borland.jbcl.dataset.StorageDataSet

Properties implemented in java.lang.Object

ProcedureDataSet methods

Methods implemented in this class

Methods implemented in borland.jbcl.dataset.DataSet

Methods implemented in borland.jbcl.dataset.ReadRow

Methods implemented in borland.jbcl.dataset.ReadWriteRow

Methods implemented in borland.jbcl.dataset.StorageDataSet

Methods implemented in java.lang.Object

ProcedureDataSet event listeners


ProcedureDataSet constructors

ProcedureDataSet()

  public ProcedureDataSet()
Constructs a ProcedureDataSet component.

ProcedureDataSet properties

accumulateResults

 public final boolean isAccumulateResults()
 public final void setAccumulateResults(boolean accumulate)
If true, the provided data is accumulated over consecutive calls to executeQuery. If false, subsequent executeQuery calls overwrite the existing DataSet.

database

 public final Database getDatabase()

parameterRow

 public ParameterRow getParameterRow()

procedure

 public final ProcedureDescriptor getProcedure()
 public final void setProcedure(borland.jbcl.dataset.ProcedureDescriptor procedureDescriptor)

queryString

 public final String getQueryString()

ProcedureDataSet methods

executeQuery()

  public final void executeQuery()
Executes the query with the specified Database and query properties, and populates the DataSet.

loadDetailRows(borland.jbcl.dataset.DataSet, borland.jbcl.dataset.DataSet)

  public final void loadDetailRows(borland.jbcl.dataset.DataSet detailDataSet, borland.jbcl.dataset.DataSet masterDataSet)

Overrides: borland.jbcl.dataset.StorageDataSet.loadDetailRows(DataSet, DataSet)

openStorage(borland.jbcl.dataset.DataSet, borland.jbcl.dataset.AccessEvent)

  protected final boolean openStorage(borland.jbcl.dataset.DataSet dataSet, borland.jbcl.dataset.AccessEvent event)
This method is used internally by other classes in the JBCL. You should never use this method directly.

Overrides: borland.jbcl.dataset.StorageDataSet.openStorage(DataSet, AccessEvent)

refresh()

  public void refresh()

Overrides: borland.jbcl.dataset.StorageDataSet.refresh()

refreshSupported()

  public boolean refreshSupported()

Overrides: borland.jbcl.dataset.StorageDataSet.refreshSupported()

saveChanges(borland.jbcl.dataset.DataSet)

  public void saveChanges(borland.jbcl.dataset.DataSet dataSet)

Overrides: borland.jbcl.dataset.StorageDataSet.saveChanges(borland.jbcl.dataset.DataSet)

saveChangesSupported()

  public boolean saveChangesSupported()

Overrides: borland.jbcl.dataset.StorageDataSet.saveChangesSupported()

startResolution()

  public synchronized void startResolution()

Overrides: borland.jbcl.dataset.StorageDataSet.startResolution()

usesStoredProcedure()

  public boolean usesStoredProcedure()

Overrides: borland.jbcl.dataset.StorageDataSet.usesStoredProcedure()


ProcedureDataSet event listeners

This component is a source for the following event sets. For information on the JBCL event sets, see Events in JBCL.

access

 public final void addAccessListener(borland.jbcl.dataset.AccessListener listener)
 public final void removeAccessListener(borland.jbcl.dataset.AccessListener listener)

calcAggFields

 public synchronized void addCalcAggFieldsListener(borland.jbcl.dataset.CalcAggFieldsListener listener)
 public synchronized void removeCalcAggFieldsListener(borland.jbcl.dataset.CalcAggFieldsListener listener)

calcFields

 public synchronized void addCalcFieldsListener(borland.jbcl.dataset.CalcFieldsListener listener)
 public synchronized void removeCalcFieldsListener(borland.jbcl.dataset.CalcFieldsListener listener)

dataChange

 public final void addDataChangeListener(borland.jbcl.dataset.DataChangeListener listener)
 public final void removeDataChangeListener(borland.jbcl.dataset.DataChangeListener listener)

edit

 public void addEditListener(borland.jbcl.dataset.EditListener listener)
 public synchronized void removeEditListener(borland.jbcl.dataset.EditListener listener)

load

 public final void addLoadListener(borland.jbcl.dataset.LoadListener listener)
 public final void removeLoadListener(borland.jbcl.dataset.LoadListener listener)

masterNavigate

 public final void addMasterNavigateListener(borland.jbcl.dataset.MasterNavigateListener listener)
 public final void removeMasterNavigateListener(borland.jbcl.dataset.MasterNavigateListener listener)

navigation

 public final void addNavigationListener(borland.jbcl.dataset.NavigationListener listener)
 public final void removeNavigationListener(borland.jbcl.dataset.NavigationListener listener)

open

 public final void addOpenListener(borland.jbcl.dataset.OpenListener listener)
 public final void removeOpenListener(borland.jbcl.dataset.OpenListener listener)

rowFilter

 public final void addRowFilterListener(borland.jbcl.dataset.RowFilterListener listener)
 public final void removeRowFilterListener(borland.jbcl.dataset.RowFilterListener listener)

status

 public final void addStatusListener(borland.jbcl.dataset.StatusListener listener)
 public final void removeStatusListener(borland.jbcl.dataset.StatusListener listener)

storageAccess

 public final void removeStorageAccessListener(borland.jbcl.dataset.AccessListener listener)