Jboss/TEIID 中 SQL Server 连接的无锁定提示

Question

如何在JBOSS连接设置中没有锁定提示选项。传递TransAction_Read_Read_uncommitting标志正确吗？即使我在连接设置中有此标志，我仍然会看到lck_m_sch_s在进行更新/插入语句时，请等待JBOSS连接到SQL Server的等待类型。 以下是我在jboss的ostalone.xml文件中设置的内容：

<datasource jndi-name="java:/SourceModel" pool-name="SourceModel" enabled="true">
    <connection-url>jdbc:sqlserver://server:1433;integratedSecurity=true;authenticationScheme=NTLM;domain=domain.net;databaseName=dbname;sendStringParametersAsUnicode=false</connection-url>
    <driver>sqlserver</driver>
    <transaction-isolation>TRANSACTION_READ_UNCOMMITTED</transaction-isolation>
    <pool>
        <min-pool-size>0</min-pool-size>
        <max-pool-size>60</max-pool-size>
        <prefill>true</prefill>
        <use-strict-min>true</use-strict-min>
        <flush-strategy>IdleConnections</flush-strategy>
    </pool>
    <security>
        <security-domain>SourceModelSecurityDomain</security-domain>
    </security>
    <validation>
        <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mssql.MSSQLValidConnectionChecker"/>
        <check-valid-connection-sql>select 1</check-valid-connection-sql>
        <validate-on-match>true</validate-on-match>
        <use-fast-fail>false</use-fast-fail>
        <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.novendor.NullExceptionSorter"/>
    </validation>
    <timeout>
        <blocking-timeout-millis>30000</blocking-timeout-millis>
        <idle-timeout-minutes>30</idle-timeout-minutes>
    </timeout>
    <statement>
        <track-statements>false</track-statements>
        <prepared-statement-cache-size>400</prepared-statement-cache-size>
        <share-prepared-statements>true</share-prepared-statements>
    </statement>
</datasource>