Connector Xpress Guide › Creating Connectors › Operation Bindings › Bind Operations to Stored Procedures

Bind Operations to Stored Procedures

You can bind operations to stored procedures on JDBC databases to specify actions that you want to occur, before, after, or instead of, standard account CRUD operations. For example, Add, Modify, and Delete. Other types of operations are available, depending on the type of operation binding you select.

Follow these steps:

1. Create a Connector Xpress JDBC Project.
2. Map the user account class, and any other class as required.
3. Click the Operations Bindings node.

   The Operation Bindings Editor appears.

4. In the Object Classes Filtering list, select an object class.

   You have specified the object class you want to create the operation binding for.

5. Click Create.

   The Create Operation Binding dialog appears.

6. Select a class in the Available object classes list and add it to the Added object classes list.

   You have specified the object classes you want to apply the operation binding to.

7. Under Type, select Stored Procedure.
8. In the Available Operations list, select an operation.

   You have specified the type of operation that you want to bind the operation to.

9. In the Timing list, select a timing.

   You have specified when the operation binding is executed.

10. Click OK.

    A node is added to the mapping tree which displays the type of operation, the timing you selected and the name of class you want the operation binding to apply to.

11. Click the node that displays the information about the operation binding you created.

    The Stored Procedure dialog appears.

12. In the Procedure list, select a stored procedure.

    You have bound the procedure to the operation you specified in step 8.

    Note: If the procedure list fails to populate verify that your database does not have outstanding transactions or locks on the schema metadata.

13. Edit any other details of the stored procedure as required.

    You have specified the parameters for a stored procedure style operation binding.

14. Save the project.

More Information:

Operations Bindings Editor

Operation Bindings – Stored Procedure Editor

Create Operation Binding Dialog