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?