If I call setTransactionIsolation on a pooled connection, will that new transaction isolation setting remain when the connection is returned to the pool? Or will the connection revert to its default isolation level?
I have a stateless session bean which needs to do some read-only queries quickly and doesn't care about dirty reads or the like.
(I am using JBoss 3.0.6a with SQL Server 8 & the JSQLConnect driver)
Thank you in advance!