Begin detailed description.
This figure shows the basic steps an application might take to make concurrent transactions on multiple connections.
The following table lists these steps in the
order they occur, indicates the transaction to which each step belongs,
and provides comments that describe what occurs.
| Application step | Transaction | Comments |
|---|---|---|
| Allocate connection "A" | None | These steps initialize two connections with two statement handles per connection. |
| Connect to "A" | ||
| Allocate statement "A1" | ||
| Allocate statement "A2" | ||
| Allocate connection "B" | ||
| Connect to "B" | ||
| Allocate statement "B1" | ||
| Allocate statement "B2" | ||
| Execute statement "A1" | Transaction 1 | These steps perform transactions on connection "A" only. |
| Execute statement "A2" | ||
| Commit at "A" | ||
| Execute statement "B1" | Transaction 2 | These steps perform transactions on connection "B" only. |
| Execute statement "B2" | ||
| Commit at "B" | ||
| Execute statement "B2" | Transaction 3 | These steps perform transactions on connections "A" and "B", but are part of separate transactions. Commit "A" ends the transaction on connection "A". Commit "B" ends the transaction on connection "B". |
| Execute statement "A1" | Transaction 4 | |
| Execute statement "B2" | Transaction 3 | |
| Execute statement "A2" | Transaction 4 | |
| Commit at "A" | ||
| Execute statement "B1" | Transaction 3 | |
| Commit at "B" |
End detailed description.