Hi.
When calling methods in my CMP bean the transaction will not use transaction
level TRANSACTION_SERIALIZABLE. I've done a trace in sqlserver and there are no
statements to set the isolation level.
I'm using JBoss 2.4-beta and the Opta2000 drivers with sqlserver 7.0. All
methods in the bean have transaction set to Required. Below is the part where
the driver is loaded in jboss.jcml
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=PersonDB">
<attribute name="PoolName">PersonDB</attribute>
<attribute
name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attribute>
<attribute name="Properties">host=145.56.7.9; database=littledb</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">sa</attribute>
<attribute name="MaxSize">10</attribute>
<attribute name="Password">mypass</attribute>
<attribute name="GCEnabled">false</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="TimestampUsed">false</attribute>
<attribute name="Blocking">true</attribute>
<attribute name="GCInterval">120000</attribute>
<attribute name="IdleTimeout">1800000</attribute>
<attribute name="IdleTimeoutEnabled">false</attribute>
<attribute name="LoggingEnabled">false</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
<attribute name="MinSize">0</attribute>
<attribute name="URL">jdbc:inetdae7:145.56.7.9?database=littledb</attribute>
<attribute name="TransactionIsolation">TRANSACTION_SERIALIZABLE</attribute>
</mbean>
--
___________________________________
Nicolas Serrador Ivering
Greenmill Consulting AB
By�ngsgr�nd 20
SE-120 40 �rsta
Sweden
Office: +46 (0)8 664 7 664
Fax: +46 (0)8 664 7 864
Mobile: +46 (0)709 734237
Email: [EMAIL PROTECTED]
___________________________________
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
