Transaction Handling

Transfer objects are designed to bundle all data required for a single request so that the corresponding PL/SQL stored procedure can perform the complete business operation in the database. This can make individual PL/SQL calls more 'feature-rich', but it typically reduces the number of round-trips, lowers latency, and improves overall performance. It also enables each request to be handled atomically within a single database transaction.

The Raw JDBC Connector Builder is the only builder that lets you manage transactions yourself. All other Connector Builders treat each service call as its own transaction: on success the transaction is committed; on failure it is rolled back and an exception is thrown.