borland Packages Class Hierarchy sql.dataset Package Index
java.lang.Object +----borland.jbcl.dataset.Resolver +----borland.sql.dataset.SQLResolver +----borland.sql.dataset.ProcedureResolver
Constructors Properties Methods Event Listeners
Implements Serializable
The ProcedureResolver component is used to resolve (save) changes back to a JBDC data source by calling stored procedures in that database. The stored procedures must exist prior to using this component; this component will not generate them. These stored procedures must meet the requirements described in the following properties:
The database property of this component must be set to the Database component that this ProcedureResolver is associated with. Otherwise, a DataSetException is generated.
Sybase users: Stored procedures on Sybase servers are created in a "Chained" transaction mode. In order to call Sybase stored procedures as part of this component, the procedures must be modified to run in an unchained transaction mode. Use the Sybase stored system procedure sp_procxmode to change the transaction mode to either "anymore" or "unchained". See your Sybase documentation for additional information.
public ProcedureResolver()Constructs a ProcedureResolver component.
public Database getDatabase() public void setDatabase(borland.sql.dataset.Database database)The Database object associated with this component. If not set, a DataSetException of Cannot resolve data, since Database property is not set on Resolver is generated.
public ProcedureDescriptor getDeleteProcedure() public void setDeleteProcedure(borland.sql.dataset.ProcedureDescriptor deleteProcedure)The available parameters for invocation of a deleteProcedure call are:
public ProcedureDescriptor getInsertProcedure() public void setInsertProcedure(borland.sql.dataset.ProcedureDescriptor insertProcedure)The insertProcedure is invoked for every row, that was inserted in the DataSet. The available parameters for invocation of an insertProcedure are:
public ProcedureDescriptor getUpdateProcedure() public void setUpdateProcedure(borland.sql.dataset.ProcedureDescriptor updateProcedure)The updateProcedure is invoked for every row that was changed in the DataSet. The available parameters for invocation of an updateProcedure are:
The stored procedure should be designed to update a record in the appropriate table(s) given the original data, and the modified data. Since the original row and the modified row have the same column names, the named parameter syntax has been expanded with a way to indicate the designated data row.
The named parameter ":2.CUST_ID" indicates the CUST_ID of the original data row, where ":1.CUST_ID" indicates the CUST_ID of the modified row.
public void closeStatements(borland.jbcl.dataset.StorageDataSet dataSet)
Overrides: borland.sql.dataset.SQLResolver.closeStatements(borland.jbcl.dataset.StorageDataSet)
public synchronized void deleteRow(borland.jbcl.dataset.DataSet dataSet)Instructs the Resolver to delete the current row in the DataSet from the Database.
Overrides: borland.sql.dataset.SQLResolver.deleteRow(borland.jbcl.dataset.DataSet)
public synchronized void insertRow(borland.jbcl.dataset.DataSet dataSet)Instructs the Resolver to insert the current row of the DataSet into the Database.
Overrides: borland.sql.dataset.SQLResolver.insertRow(borland.jbcl.dataset.DataSet)
public synchronized void updateRow(borland.jbcl.dataset.DataSet dataSet, borland.jbcl.dataset.ReadWriteRow oldDataRow)Instructs the Resolver to update the current row of the DataSet in the Database.
public synchronized void addResolverListener(borland.jbcl.dataset.ResolverListener listener) public synchronized void removeResolverListener(borland.jbcl.dataset.ResolverListener listener)