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

    turning off transactions - how?

    Andy Hallam Newbie

      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:


      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.