SELECT statement does SX lock on table on JBoss3.2.2, why

[susil]

"susil" wrote:

"susil" wrote:
Since it is locking on SELECT (SX lock) I can not so anything. Has Isolation level changed on 3.2.2. What is the default ISOLATION Level And How to set it up in data source. How to get ride of this problem.

Any Help would be highly appreciated!

Thanks
Susil

Below is my datasource

<datasources>
<xa-datasource>
<jndi-name>ClusterOne</jndi-name>
<track-connection-by-tx>true</track-connection-by-tx>
<isSameRM-override-value>false</isSameRM-override-value>
<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
<xa-datasource-property name="URL">jdbc:oracle:thin:@localhost:1521:devtd</xa-datasource-property>
<xa-datasource-property name="User">dev</xa-datasource-property>
<xa-datasource-property name="Password">password</xa-datasource-property>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<min-pool-size>5</min-pool-size>
<max-pool-size>50</max-pool-size>
<blocking-timeoutd-millis>5000</blocking-timeoutd-millis>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
</xa-datasource>
<datasources>