Configure isolation level on a resource reference during assembly

Specify the appropriate isolation level for each of your resource references. The isolation level is used only by JDBC users. For information about setting isolation levels on a resource reference, see Isolation level and resource reference.

One can define multiple resource references for the same BMP bean or servlet. Each resource reference has its own Java Naming and Directory Interface logical name. One can also bind multiple resource references to the same data source. Each JNDI resource reference naming lookup returns the connections from the data source that has the same isolation level.

For example, an account bean has two resource references defined:

jdbc/RRResRef:
resource_ref has RepeatableRead isolation level
jdbc/RCResRef:
resource_ref has ReadCommitted isolation level

If your application uses RRResRef to get the data source instance, all connections that are acquired from this data source instance have the RepeatableRead isolation level.

If your application uses RCResRef to get the data source instance, all connections that are acquired from this data source instance have the ReadCommitted isolation level.

---

Data sources