0 Replies Latest reply on Feb 28, 2003 6:39 AM by Giovanni Santos

    Informix Transaction Isolation

    Giovanni Santos Newbie

      Hi, All.

      I'm using JBoss3.0.2 and Informix Database 9.1.

      I configured the ManagedConnectionFactoryProperties like this:

      InformixXaDbRealm2

      <depends optional-attribute-name="ManagedConnectionFactoryName">
      <!--embedded mbean-->

      <!--hack-->
      <depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=Minerva JDBC XATransaction ResourceAdapter

      <!--real attributes-->


      <config-property>
      <config-property-name>XADataSourceClass</config-property-name>
      <config-property-type>java.lang.String</config-property-type>
      <config-property-value>com.informix.jdbcx.IfxXADataSource</config-property-value>
      </config-property>
      <config-property>
      <config-property-name>XADataSourceProperties</config-property-name>
      <config-property-type>java.lang.String</config-property-type>
      <config-property-value>Description=My Description;IfxIFXHOST=giovanni.nct.com.br;PortNumber=1526;DatabaseName=multa;ServerName=ol_giovanni</config-property-value>
      </config-property>
      <config-property>
      <config-property-name>TransactionIsolation</config-property-name>
      <config-property-type>java.lang.String</config-property-type>
      <config-property-value>TRANSACTION_READ_UNCOMMITTED</config-property-value>
      </config-property>


      MultaDS






      I need set isolation level to DIRTY READ (DR). Thus, I set TransactionIsolation above to TRANSACTION_READ_UNCOMMITTED.

      When JBoss open a initial connection with the database, I execute the command "onstat -g sql" and can see that
      Isolation Level is DR.

      However, when I execute a finder method, for example, the Isolation Level is setted to COMMITED READ (CR).

      Is there a manner to avoid that isolation level change of DR to CR? Can anybody help me?