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.