7 Replies Latest reply on Mar 13, 2003 6:43 PM by Micah Gideon Modell

    JBOSS 2.4.4 / Informix 7.31 cannot change Isolation Level or

    jim schimmoeller Newbie

      HELP!!!!!

      We are using Jboss 2.4.4 with tomcat 4.0.1. We want to be able to change the isolation level from committed read to dirty read and also change the lock mode from no wait to wait for 30 seconds. We are using a connection pool and configuration of the pool is below. As you see, we have set the TransactionIsolation to read uncommitted and set blocking to true however when I review the connections via informix using a "onstat -g sql" they are still committed read and no wait.

      I see that there is other using informix and jboss do you have any answers.

      Jim


      com.informix.jdbc.IfxDriver



      NetADS
      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
      jdbc:informix-sqli://netaserv:22386/netanalytics:INFORMIXSERVER=netaservshm</at
      tribute>
      netauser
      netauser
      50
      10
      true
      true
      true
      true
      30000
      120000
      1800000
      true
      true
      0
      TRANSACTION_READ_UNCOMMITTED