Joe Eugene wrote:
What do you mean by a start read-only SQL transaction?
Multiple select statements within a cfquery?
SQL transactions have an isolation level which indicates how to
handle concurrency. That isolation level can have the values raed
uncommitted, read committed, repeatable read
And I believe it is currently not guaranteed that multiple
queries from one request will use the same connection. Right?
That's an interesting question. It's my understanding that multiple queries
using the same datasource within a single request do use the same
connection, based on
This would make sense, since I was having trouble when I used a different
User ID and password within a single object/class.
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Monday, July 21, 2003 10:04 AM
To: CF-Talk
Subject: RE: read-only SQL transactions
And I
On Monday, Jul 21, 2003, at 08:03 US/Pacific, Dave Watts wrote:
And I believe it is currently not guaranteed that multiple
queries from one request will use the same connection. Right?
That's an interesting question. It's my understanding that multiple
queries
using the same datasource
Sean A Corfield wrote:
On Monday, Jul 21, 2003, at 08:03 US/Pacific, Dave Watts wrote:
That's an interesting question. It's my understanding that multiple
queries
using the same datasource within a single request do use the same
connection, based on conversations I've had with some MM people,
PROTECTED]
Sent: Monday, July 21, 2003 1:23 PM
To: CF-Talk
Subject: Re: read-only SQL transactions
On Monday, Jul 21, 2003, at 08:03 US/Pacific, Dave Watts wrote:
And I believe it is currently not guaranteed that multiple
queries from one request will use the same connection. Right
Next question: Will any other concurrently processing
requests use that connection, or is it reserved for the
exclusive use of the current thread? It seems to me that
when a request gets a connection, it is removed from the
pool of connections until the request is over, but like
Jochem,
-Original Message-
From: Sean A Corfield [mailto:[EMAIL PROTECTED]
Sent: Monday, July 21, 2003 1:23 PM
To: CF-Talk
Subject: Re: read-only SQL transactions
On Monday, Jul 21, 2003, at 08:03 US/Pacific, Dave Watts wrote:
And I believe it is currently not guaranteed that multiple
-
From: Matt Liotta [mailto:[EMAIL PROTECTED]
Sent: Monday, July 21, 2003 1:57 PM
To: CF-Talk
Subject: Re: read-only SQL transactions
It seems like one of the benefits to using cfquery as opposed to JDBC
directly is that you don't have to deal with connection issues and what
have you
-Original Message-
From: Sean A Corfield [mailto:[EMAIL PROTECTED]
Sent: Monday, July 21, 2003 1:23 PM
To: CF-Talk
Subject: Re: read-only SQL transactions
On Monday, Jul 21, 2003, at 08:03 US/Pacific, Dave Watts wrote:
And I believe it is currently not guaranteed that multiple
Matt Liotta wrote:
It just seems like it wouldn't be in anyone's interest to formally
specify the connection behavior of cfquery since that would mean it
couldn't change in the future. Basically what I am saying is that if
you are willing to give up control over the connections then you
, Senior Development Engineer
AudienceCentral
[EMAIL PROTECTED]
voice : 360.756.8080 x12
fax : 360.647.5351
www.audiencecentral.com
-Original Message-
From: Matt Liotta [mailto:[EMAIL PROTECTED]
Sent: Monday, July 21, 2003 2:23 PM
To: CF-Talk
Subject: Re: read-only SQL transactions
How do you start a read-only SQL transaction from CF MX?
Jochem
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
How do you start a read-only SQL transaction from CF MX?
I don't think the CFTRANSACTION tag supports this. I suspect that you could
just write your batch within CFQUERY tags and set it there. This is just a
suspicion, though; I haven't tried it.
Dave Watts, CTO, Fig Leaf Software
What do you mean by a start read-only SQL transaction?
Multiple select statements within a cfquery?
Joe Eugene
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Sunday, July 20, 2003 4:41 PM
To: CF-Talk
Subject: read-only SQL transactions
How do you
15 matches
Mail list logo