Question on J8055 : Setting transaction isolation for JBoss

[trusha]

"trusha" wrote:
Hi!
I have no idea, how can I set a transaction isolation for my Entity Beans with CMP2.0 using JBoss 3.0 and MySQL-DB. Probably, it should be done in Deployment Descriptor, but I didn't find any information, how to do this in ejb-jar.xml. Would u be so kind to tell me, how did u set it for your application?

Thanx in advance,
Trusha

[juha]

I'm not sure if it is possible for 3.0, in 3.2 you can configure the isolation level in your datasource configuration file (see generic-ds.xml for an example).

-- Juha

[n2]

"n2" wrote:
you can set the transaction isolation level in the datasource configuration file name-ds.xml in the deploy directory for jboss 3.x.x.
this is an example for ms sqlserver:

<datasources>
<local-tx-datasource>
<jndi-name>matrix</jndi-name>
<connection-url>jdbc:microsoft:sqlserver://<ip>:1433;databaseName=<db-name>;SelectMethod=cursor</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
<user-name>xxx</user-name>
< password>xxx< /password>
<transaction-isolation>TRANSACTION_READ_UNCOMMITTED</transaction-isolation>
</local-tx-datasource>
</datasources>

possible values are: TRANSACTION_SERIALIZABLE, TRANSACTION_REPEATABLE_READ, TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED