0 Replies Latest reply on Jan 21, 2004 3:54 PM by Susil Rayamajhi

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

    Susil Rayamajhi Newbie

       

      "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>