Skip to Content
Former Member
Sep 08, 2009 at 06:24 AM

Two stage COMMIT needed with JDBC adapter


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?