borland Packages  Class Hierarchy  sql.dataset Package  Index 

ProcedureProvider component

java.lang.Object
   +----borland.jbcl.dataset.Provider
           +----borland.sql.dataset.JdbcProvider
                   +----borland.sql.dataset.ProcedureProvider
                           +----borland.sql.dataset.OracleProcedureProvider

About the ProcedureProvider component

Constructors  Properties  Methods  

Implements LoadCancel, ConnectionUpdateListener, Task, Serializable, EventListener

The ProcedureProvider component provides data to the StorageDataSet by executing the specified stored procedure through JDBC. You connect this component to the StorageDataSet component through the StorageDataSet's provider property.

This component provides the data to the StorageDataSet however it does not attempt to make the StorageDataSet updatable or editable; it is the developer's responsibility to ensure this prior to the start of the resolution phase.

The stored procedure is expected to return a result set. For stored procedures that don't return values, use either static form of the callProcedure() method to execute them.


ProcedureProvider constructors

ProcedureProvider properties

*Read-only properties **Write-only properties

Properties implemented in this class

Properties implemented in borland.sql.dataset.JdbcProvider

Properties implemented in java.lang.Object

ProcedureProvider methods

Methods implemented in this class

Methods implemented in borland.jbcl.dataset.Provider

Methods implemented in borland.sql.dataset.JdbcProvider

Methods implemented in java.lang.Object


ProcedureProvider constructors

ProcedureProvider()

  public ProcedureProvider()
Constructs a ProcedureProvider component.

ProcedureProvider properties

procedure

 public final ProcedureDescriptor getProcedure()
 public final void setProcedure(borland.sql.dataset.ProcedureDescriptor procedureDescriptor)
Stores the ProcedureDescriptor object that contains property settings for the stored procedure.

ProcedureProvider methods

callProcedure(borland.sql.dataset.Database, java.lang.String, borland.jbcl.dataset.ReadWriteRow)

  public static final int callProcedure(borland.sql.dataset.Database database, java.lang.String procedureSpecification, borland.jbcl.dataset.ReadWriteRow parameters)
Calls a stored procedure using the following parameters:

Parameters:

database
The associated Database object.
procedureSpecification
The procedure to call.
parameters
The ReadWriteRow implementation that stores the parameter values for the stored procedure.

callProcedure(borland.sql.dataset.Database, java.lang.String, borland.jbcl.dataset.ReadWriteRow[])

  public static final int callProcedure(borland.sql.dataset.Database database, java.lang.String procedureSpecification, borland.jbcl.dataset.ReadWriteRow[] parameters)
Calls a stored procedure with named access to multiple parameters using the following:

Parameters:

database
The associated Database object.
procedureSpecification
The procedure to call.
parameters
An array of ReadWriteRow objects containing the parameter values for the stored procedure. Parameters are accessed via an optional tag of the named parameters. The tag is the number of the passed ReadWriteRow starting with 1. For example, the following code passes the value of the 'Name' column from the parameter row 'param1' as the first parameter, and the value of the 'Name' column from the parameter row 'param2'.
callProcedure(db1,"call foo(:2.Name,:1.Name)", new ReadWriteRow[]{param1,param2});
If no tag is given, the parameter name is found by searching the parameter rows from left to right. Therefore, tags can be used to differentiate columns with idential names in different parameter rows.

ifBusy()

  public void ifBusy()
Tests whether the data is present. This method is used when providing data asynchronously to determine whether editing, resolving, and other such actions should be blocked until the data is available.