Sorry for the cryptic summary; couldn't think of a good one.
I have created a JDBC connection pool and associated resource like this:
I created a connection pool and associated JDBC resource like this:
--restype=javax.sql.DataSource --description "Test connection pool" --property
asadmin create-jdbc-resource --connectionpoolid "TestConnectionPool"
--description "Test JDBC resource" jdbc/DB
Then I navigate to the GUI panel showing the connection pool attributes.
At the bottom, I see that the Isolation Level is set to Guaranteed (the check
box is selected). There is a bit of documentation there that says, "All
connections use same isolation level; requires Transaction Isolation".
However, the transaction isolation drop down is empty, as I never specified it
on the command line and do indeed wish to leave it up to the JDBC driver.
Additionally, you'll note in the command line that I never said anything about
guarantees of isolation.
I'm not sure what of all this is intended behavior and what is a bug, but
thought I'd raise it up.