Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I do not have any personal experience with this but after some searching it seems that the <code>&lt;cfsetting requesttimeout=""&gt;</code> code is not honored by the <code>&lt;cfthread&gt;</code> tag. See the following references that I found.</p> <p><strong>Note that I am not suggesting you make the changes that they detail like disabling the request timeout setting in the ColdFusion administrator. I don't think that is a good idea.</strong> I am just passing along this information that I found. The gist being that the <code>&lt;cfthread&gt;</code> tag does not support the <code>&lt;cfsetting requesttimeout=""&gt;</code> option. So you probably need to find another way to do what you need or optimize your code to finish before the set timeout.</p> <p><a href="http://blogs.alagukannan.com/2010/04/28/cfthread-and-request-timeout-in-coldfusion/" rel="nofollow noreferrer">cfthread and request timeout in coldfusion</a></p> <blockquote> <p>In the process I found the following after some testing and playing around:</p> <ol> <li>The CFthread basically respects the CF admin panel timeout if it’s set and kills the thread after the timeout period.</li> <li>It doesn’t respect the request timeout set using the CFsetting tag in onRequestStart or any where in the code.</li> <li>There are still certain tags that don’t obey the CFthread request timeout,they are CFFTP,CFEXECUTE, CFX tags and CFStoredProc.</li> </ol> </blockquote> <p><a href="https://stackoverflow.com/questions/390148/increase-request-timeout-for-a-thread-in-cfml">Increase request timeout for a thread in CFML</a></p> <blockquote> <p>As you can see, I've tried adding a <code>&lt;cfsetting requestTimeout=240 /&gt;</code> to the top of the thread to try and make it live longer... no dice.</p> </blockquote> <p><a href="https://stackoverflow.com/questions/4148315/am-i-utilizing-cfthread-correctly-for-this-solution">Am I utilizing &lt;cfthread&gt; correctly for this solution?</a></p> <blockquote> <p>As for thread timeouts - you can specify a max time to wait for threads you created to rejoin page execution, but AFAIK there is no way to put a timeout (like a page request timeout) on the thread you created.</p> </blockquote> <p>And Charlie Arehart has a pretty good article on ColdFusion request timeouts in general - <a href="http://www.carehart.org/blog/client/index.cfm/2010/10/15/lies_damned_lies_and_cf_timeouts" rel="nofollow noreferrer">CF911: Lies, Damned Lies, and CF Request Timeouts...What You May Not Realize</a></p>
    singulars
    1. This table or related slice is empty.
    1. POCFTHREAD CFHTTP timeout
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USMiguel-F
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POCFTHREAD CFHTTP timeout
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUndeletion
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. CO@Miquel-F, totally hear ya, but I already did that. If you look at the line right after my starting cfthread tag, you will see I have set the requesttimeout to 400. It doesn't matter if i put that <cfsettting requesttimeout=400/> before or after the cfthread tag, I get the same results, which is cfhttp times out. Other ideas?
      singulars
      1. PO
      1. USuser2592724
    2. CO@user2592724 - But that is the point that I am trying to make... and again this is only based on searching, I do not have any personal experience with this. The `<cfthread>` tag ignores the `<cfsetting requesttimeout="">` tag. It will always timeout based on the setting in the ColdFusion administrator.
      singulars
      1. PO
      1. USMiguel-F
    3. COMy response was to the first post you made of 'Your <cfsetting requesttimeout="400"/> code needs to go in the calling template, the one making the cfhttp calls; MyThreadedCFHTTP.cfm in your example. Not in the page that is being called.'. Your updated one makes a lot of sense. Its interesting because the cfthread will run as long as it needs to. Its the cfhttp tag that times out based on the admin setting. I think I might need to follow the recommendation in the first link. Thanks for looking into this.
      singulars
      1. PO
      1. USuser2592724
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload