Re: Coldfusion Server Crashing
We are having some trouble with Coldfusion MX 7 on one of our servers. Every few days for some reason Coldfusion runs into a problem and can not connect to any of our data sources, bringing all of our sites down. Error: Executing Database Query.Timed out trying to establish connection The specific sequence of files included or processed is: When I go to restart Coldfusion, I am able to restart all Coldfusion Services besides the Coldfusion MX 7 ODBC Server. I have to then actually restart the server to get Coldfusion working again. Do you think this is a problem with code that we have written on one of our sites or a problem with Coldfusion on this machine? Thanks, Heath Stein ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279843 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion Server Crashing
Which DB? We have seen similiar errors when using SQL 2005. It looks more than likely a network issue. Is the DB an ODBC connection or JDBC? Which drivers? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Robert Mack To: CF-Talk Sent: Fri Jun 01 18:18:16 2007 Subject: Re: Coldfusion Server Crashing We are having some trouble with Coldfusion MX 7 on one of our servers. Every few days for some reason Coldfusion runs into a problem and can not connect to any of our data sources, bringing all of our sites down. Error: Executing Database Query.Timed out trying to establish connection The specific sequence of files included or processed is: When I go to restart Coldfusion, I am able to restart all Coldfusion Services besides the Coldfusion MX 7 ODBC Server. I have to then actually restart the server to get Coldfusion working again. Do you think this is a problem with code that we have written on one of our sites or a problem with Coldfusion on this machine? Thanks, Heath Stein ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279844 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion Server Crashing
The database you use will determine the driver you use...if you use Access then http://www.mysql.com/ Adam Haskell On 5/21/07, heath stein [EMAIL PROTECTED] wrote: The solution really is to run a JDBC driver preferably type 3 or type 4. What sort of data are you accessing with your ODBC driver? Chris Thanks Chris, My next question is how do we go about switching to JDBC driver for all of are sites? Also when I check the Logs it seems that one particular query always seems to be running right before Coldfusion crashes. We are actually using XML to build a query object and then loading the query into an application variable. Heath ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279880 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion Server Crashing
Greetings. I intended to just read the earlier post in this thread but I inadvertently reposted it. I have the same problem, with Access databases and ODBC drivers using a current version of MX7. I'm investigating the suggestions previously posted earlier in the thread: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:51767 Bob Mack Which DB? We have seen similiar errors when using SQL 2005. It looks more than likely a network issue. Is the DB an ODBC connection or JDBC? Which drivers? ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279882 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Coldfusion Server Crashing
We are having some trouble with Coldfusion MX 7 on one of our servers. Every few days for some reason Coldfusion runs into a problem and can not connect to any of our data sources, bringing all of our sites down. Error: Executing Database Query.Timed out trying to establish connection The specific sequence of files included or processed is: When I go to restart Coldfusion, I am able to restart all Coldfusion Services besides the Coldfusion MX 7 ODBC Server. I have to then actually restart the server to get Coldfusion working again. Do you think this is a problem with code that we have written on one of our sites or a problem with Coldfusion on this machine? Thanks, Heath Stein ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278751 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion Server Crashing
heath stein wrote: When I go to restart Coldfusion, I am able to restart all Coldfusion Services besides the Coldfusion MX 7 ODBC Server. Don't use ODBC, use a type 4 JDBC driver. Jochem ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278752 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion Server Crashing
and make sure you have the latest drivers http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=42dcb10a On 5/21/07, Jochem van Dieten [EMAIL PROTECTED] wrote: heath stein wrote: When I go to restart Coldfusion, I am able to restart all Coldfusion Services besides the Coldfusion MX 7 ODBC Server. Don't use ODBC, use a type 4 JDBC driver. Jochem ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278753 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion Server Crashing
heath stein wrote: When I go to restart Coldfusion, I am able to restart all Coldfusion Services besides the Coldfusion MX 7 ODBC Server. Don't use ODBC, use a type 4 JDBC driver. What is the issue with using ODBC? Also how do you go about changing to JDBC driver? Thanks Heath ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278755 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion Server Crashing
Heath, We had this very same problem on our CFMX6.1 sever a couple of years ago. It was like pulling teeth to get Macromedia to help, but once we had a test case that would produce the problem on demand, they finally looked at it. It turns out that our ODBC driver wasn't thread safe. Using the JDBC/ODBD bridge (read: Type 1 JDBC driver) exasperated this problem. The solution really is to run a JDBC driver preferably type 3 or type 4. What sort of data are you accessing with your ODBC driver? Chris heath stein wrote: We are having some trouble with Coldfusion MX 7 on one of our servers. Every few days for some reason Coldfusion runs into a problem and can not connect to any of our data sources, bringing all of our sites down. Error: Executing Database Query.Timed out trying to establish connection The specific sequence of files included or processed is: When I go to restart Coldfusion, I am able to restart all Coldfusion Services besides the Coldfusion MX 7 ODBC Server. I have to then actually restart the server to get Coldfusion working again. Do you think this is a problem with code that we have written on one of our sites or a problem with Coldfusion on this machine? Thanks, Heath Stein ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278756 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion Server Crashing
heath stein wrote: Don't use ODBC, use a type 4 JDBC driver. What is the issue with using ODBC? Also how do you go about changing to JDBC driver? http://livedocs.adobe.com/coldfusion/7/htmldocs/1736.htm#1261469 Jochem ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278759 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion Server Crashing
The solution really is to run a JDBC driver preferably type 3 or type 4. What sort of data are you accessing with your ODBC driver? Chris Thanks Chris, My next question is how do we go about switching to JDBC driver for all of are sites? Also when I check the Logs it seems that one particular query always seems to be running right before Coldfusion crashes. We are actually using XML to build a query object and then loading the query into an application variable. Heath ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278768 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion Server Crashing
In the ColdFusion administrator, go to data source, create an new Data Source and select 'Other' as the driver. The parameters will depend on what RDBMS you have. If you let us know what you have, I am sure someone can post you a string. You will give the Data Source the same name as the previous one, so nothing will can with in your application. Or a new name and then can you application to use the new one. On 5/22/07, heath stein [EMAIL PROTECTED] wrote: The solution really is to run a JDBC driver preferably type 3 or type 4. What sort of data are you accessing with your ODBC driver? Chris Thanks Chris, My next question is how do we go about switching to JDBC driver for all of are sites? Also when I check the Logs it seems that one particular query always seems to be running right before Coldfusion crashes. We are actually using XML to build a query object and then loading the query into an application variable. Heath ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278835 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4