Hi All,
I have a situation here where cfquery doesn't seem to be performing well on
jdbc driver, when I read in forums it was clearly mentioned that cfquery
timeout doesn't support some drivers, Is there any another alternate to this.
My requirement is no matter what happens, if query
themselves,
often the only way to ensure such a timeout is with a second monitor
thread.
~Brad
Original Message
Subject: cfquery timeout doesn't work out on jdbc driver
From: Vamsi Pappu vissu.va...@gmail.com
Date: Thu, October 08, 2009 7:47 am
To: cf-talk cf-talk@houseoffusion.com
that cfquery
timeout doesn't support some drivers, Is there any another alternate to
this.
My requirement is no matter what happens, if query is not responding in
given amount of time then it should timeout.Can anyone suggest a good
advice.
Thanks,
Vamsi
:
Hi All,
I have a situation here where cfquery doesn't seem to be performing well on
jdbc driver, when I read in forums it was clearly mentioned that cfquery
timeout doesn't support some drivers, Is there any another alternate to
this.
My requirement is no matter what happens, if query
Anyone? Bueller? I really need an answer to this -- even though I'm running
Fusion Reactor and can keep a survival strategy, this is no way to keep a
server running. Is there anyone out there who's successfully used the TIMEOUT
parameter in CFQUERY with CFMX 7.0.2 and SQL 2005 Standard?
On Tue, Apr 14, 2009 at 5:25 PM, Sung Woo s...@cornell.edu wrote:
Hi Casey,
What happened today is that the SQL server basically locked up. CF kept
waiting for the request to come back, but it never did because it just hung
infinitely. It seems as if CF waits forever in a case like this,
[mailto:s...@cornell.edu]
Sent: Wednesday, April 15, 2009 7:58 AM
To: cf-talk
Subject: Re: CFQUERY Timeout for SQL2005 Fails
Anyone? Bueller? I really need an answer to this -- even though I'm
running Fusion Reactor and can keep a survival strategy, this is no way to
keep a server running
, concurrent threads
and cfquery timeout settings but seem to still have the same problem on
occasion, I'm wondering if they're caused by the same issue, I too running
SQL2k5 however I'm on CF8.
Mark, I'd concur that its waiting to establish a connection, is there anything
which can be done
Mark and Casey,
Thanks for clarifying this for me. I don't own the SQL Server that I need to
hit, so it looks like I'm between a rock and a hard place.
I still don't think the TIMEOUT parameter is working, though. In my example,
I'm hitting a database that is fully operational, and I have a
Also -- this may just be me being dense, but I don't get why the TIMEOUT
feature in CFQUERY has to work this way. It's CF that's making the initial
request to the datasource, so it should start counting down from the moment it
creates that request. And then after waiting for a predetermined
Hi Mark,
To answer your question -- there's a DDL transaction that's running on the
server, and from what the folks have told me, an ALTER TABLE command was
causing the lock to occur. And the downside is that giving hints (i.e., WITH
(NOLOCK)) is not going to have an effect in this
-talk
Subject: Re: CFQUERY Timeout for SQL2005 Fails
Hi Mark,
To answer your question -- there's a DDL transaction that's running on the
server, and from what the folks have told me, an ALTER TABLE command was
causing the lock to occur. And the downside is that giving hints (i.e.,
WITH (NOLOCK
The docs say, no, it may not timeout at 1 second. Check out the
livedocs... Because the timeout attribute only affects the maximum
time for each suboperation of a query, the cumulative time may exceed
its value.
And, even then, the query stuff is considered to be 3rd party (or at
least, so
Check this out. This one, as I've said before, outputs a number around 3000.
cfquery name=test datasource=dsn timeout=1
select top 2 *
from table/cfquery
cfoutput#cfquery.ExecutionTime#/cfoutput
However, this one results in an error: Error Executing Database Query.
Here's my test:
cfquery name=test datasource=dsn timeout=1
select top 2 *
from table
/cfquery
cfoutput#cfquery.ExecutionTime#/cfoutput
I'm getting 3000+ for this value. This shouldn't be, right? Because I have
the timeout parameter set for a second? The driver I'm using
Actually, I was wrong -- even cfsetting requesttimeout=1
enablecfoutputonly=No doesn't work, because it still waits for the cfquery
to finish before it outputs the timeout error. Is there any solution for this?
The database we're relying on is unstable and we need to be able to kill the
how about adding WITH (NOLOCK)
If your queries are just selecting data, i'd use WITH (NOLOCK)
that way you don't need to wait for transactions to finish if that table
gets heavy inserts
cfquery name=test datasource=dsn timeout=1
select top 2 * WITH (NOLOCK)
from table
Hi Casey,
What happened today is that the SQL server basically locked up. CF kept
waiting for the request to come back, but it never did because it just hung
infinititely. It seems as if CF waits forever in a case like this, so it's
vital that I can kill the connection from the CFQUERY.
Can somebody tell me exactly how this works? Reading the documentation I get
this message.
Timeout:
Maximum number of seconds that each action of a query is permitted to execute
before returning an error. The cumulative time may exceed this value.
What exactly is an action in a query and if
?
www.bennadel.com/ask-ben/
-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 22, 2007 12:38 PM
To: CF-Talk
Subject: Cfquery timeout parameter.
Can somebody tell me exactly how this works? Reading the documentation
I get this message.
Timeout:
Maximum
I guess it means the execution of a single:
UPDATE
SELECT
DELETE
Would this also apply to sub-selects and other more comlex SQL syntax?
Say:
SELECT aField
FROM (SELECT bField FROM bTable) aTable
Would that be two actions? Each one allowed to run for the timeout period, or
if the inner select
]
Sent: Thursday, February 22, 2007 12:52 PM
To: CF-Talk
Subject: RE: Cfquery timeout parameter.
I guess it means the execution of a single:
UPDATE
SELECT
DELETE
Would this also apply to sub-selects and other more comlex SQL syntax?
Say:
SELECT aField
FROM (SELECT bField FROM bTable) aTable
Hello All,
My host has issues from time to time I get a CFQUERY timeout.But when I rerun the query it works (most times).What type of CFCATCH type would this be?
Here is my error
Error Occurred While Processing Request
The request has exceeded the allowable time limit Tag: CFQUERY
Thanks in
you can't catch this type of issue.Look at tuning the queries and code on the page to run faster.Also look at cfsetting requesttimeout= if needed.
Doug
-Original Message-
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 10, 2004 5:03 PM
To: CF-Talk
Subject: CFQUERY Timeout
cftry
cfquery
x
x
/cfquery
cfcatch type=database
Your error routine here
/cfcatch
/cftry
-Original Message-
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 10, 2004 5:03 PM
To: CF-Talk
Subject: CFQUERY Timeout
Hello All,
My host has issues from time to time I get
Does Oracle's ODBC driver support the cfquery timeout attribute? The
Microsoft ODBC for Oracle doesn't seem to...
Thanks :)
EC
.
~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community
We had an Oracle listener hang. This caused big problems in
ColdFusion. The timeout attribute just didn't seem to work. I posted
this here before and it was suggested that the timeout clock doesn't start
until the SQL is sent. Since the listener was hung, I'm not sure how far CF
went
Use CFTRY/CFCATCH around your queries and do a little custom error handling.
It goes a LONG way!
Dave
- Original Message -
From: Carlisle, Eric [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, November 29, 2001 8:04 AM
Subject: REPOST - cfquery timeout attribute
We had
Every query I do is nested in a try/catch. To bad I can't timeout a
try/catch block. :/
Thanks :)
EC
-Original Message-
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 8:17 AM
To: CF-Talk
Subject: Re: REPOST - cfquery timeout attribute
Use CFTRY
Whenever I have an Oracle listner problem, try/catch always catches it. Are
you sure it was a listner crash?
Dave
- Original Message -
From: Carlisle, Eric [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, November 29, 2001 8:18 AM
Subject: RE: REPOST - cfquery timeout
Subject: Re: REPOST - cfquery timeout attribute
Whenever I have an Oracle listner problem, try/catch always catches it. Are
you sure it was a listner crash?
Dave
- Original Message -
From: Carlisle, Eric [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, November 29, 2001 8:18
I'm not sure if designating your CFCATCH TYPE=Database would catch a
timeout or not.
Dave
- Original Message -
From: Carlisle, Eric [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, November 29, 2001 8:54 AM
Subject: RE: REPOST - cfquery timeout attribute
The listener
. :/
Thanks :)
EC
-Original Message-
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 8:17 AM
To: CF-Talk
Subject: Re: REPOST - cfquery timeout attribute
Use CFTRY/CFCATCH around your queries and do a little custom error handling.
It goes a LONG way!
Dave
From the CFML documentation on the cfquery timeout attribute:
This attribute is not supported by most ODBC drivers. TIMEOUT is supported
by the SQL Server 6.x or above driver. The minimum and maximum allowable
values vary, depending on the driver.
Is there an account of what ODBC drivers
34 matches
Mail list logo
