borland Packages Class Hierarchy sql.dataset Package Index
java.lang.Object +----borland.jbcl.dataset.Provider +----borland.sql.dataset.JdbcProvider +----borland.sql.dataset.ProcedureProvider +----borland.sql.dataset.OracleProcedureProvider
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.
public ProcedureProvider()Constructs a ProcedureProvider component.
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.
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:
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:
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.
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.