I have the following scenario to execute using the JDBC adapter:
1) INSERT several hundred records into a database
2) COMMIT the records; only one commit after all records have been inserted.
3) Run a stored procedure that will process the records in the database, including those just committed.
The crucial thing here is running the COMMIT between the INSERT statements and the Stored procedure. I now know how to do points 1) and 3), but how to make sure that a COMMIT is performed between the inserts and execution of the stored procedure?
Can anybody tell me how to do this?