0 Replies Latest reply on Feb 21, 2005 3:40 PM by Paul Lindorff

    Effect of calling setTransactionIsolation with connection po

    Paul Lindorff Newbie

      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!