0 Replies Latest reply on Jul 7, 2005 7:56 AM by Andy Hallam

    turning off transactions - how?

    Andy Hallam Newbie

      Spec:
      JBOSS 4.0.2
      JTDS JDBC Driver
      WINDOWS 2000
      SQLSERVER 2000

      Through using JXInsight I can see that a SELECT statement is using a transaction.

      I do not want select statements to use transactions so I first altered the datasource from:

      <local-tx-datasource>
      to:
      <no-tx-datasource>

      this made no difference.

      I then altered the SQL to use " WITH (NOLOCK) ", again JXInsight still shows a transaction line above the statement execution block.

      Does anyone know of a way of creating a data source which doesn?t start a transaction.

      thanks for any help on this.

      Andy.