set the transaction isolation level to read_uncommitted. That will have the
desired effect.
In CFMX 6.0 datasource information used to be kept, partially, in
jrun-resources.xml. Datasources had a control element for isolation level
there, and you might have been able to modify the setting there.
CFMX 6.1 doesn't store datasource information there anymore, although some
other required information is in there.
Datasources created in a new jrun server instance do not have this xml
element for isolation level in the jrun-resources.xml, and I think you
wouldn't be able to add it back in.
_____
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, January 30, 2004 5:08 PM
To: CF-Talk
Subject: CFMX 6.1, JDBC, settings??
My DBA says that after each SQL run by CF the following is appended
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
The DBA is asking me if we can turn this off. Is there an XML config file
somewheres that can be tweaked to do this?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
