Re: Simultaneous threads and maintain database connections
Hi back, Dave! > > Or do the request thread and the database connection operate > independently of each other? > > Yes, they're completely independent. Thanks. This is what I always thought but I read something that made me think things might be otherwise. George ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359170 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Simultaneous threads and maintain database connections
Hi, George! > Is there a relationship between CF simultaneous requests and maintained > database connections? No, not really. > Does a maintained database connection use one of the threads allocated for > simultaneous requests? No. Database connections use their own separate thread pool. The basic pooling mechanism is pretty similar, though. > For example, suppose in Request Tuning I have simultaneous (Template) > requests set to 10 and in > CF data source settings I have Maintain Connections checked with Timeout set > to 20 (minutes). > > A request completes. The database connection now is inactive and remains so > for at least 20 minutes. > CF maintains the connection to the database for 20 minutes. > > Does the maintained database connection also continue to hold on to the > thread that was being used > by the request that completed for the same 20 minutes? No. > Or do the request thread and the database connection operate independently of > each other? Yes, they're completely independent. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359169 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Simultaneous threads and maintain database connections
Is there a relationship between CF simultaneous requests and maintained database connections? Does a maintained database connection use one of the threads allocated for simultaneous requests? For example, suppose in Request Tuning I have simultaneous (Template) requests set to 10 and in CF data source settings I have Maintain Connections checked with Timeout set to 20 (minutes). A request completes. The database connection now is inactive and remains so for at least 20 minutes. CF maintains the connection to the database for 20 minutes. Does the maintained database connection also continue to hold on to the thread that was being used by the request that completed for the same 20 minutes? Or do the request thread and the database connection operate independently of each other? Thanks! George ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359168 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Maintaining database connections :: not working
On Wednesday 03 Oct 2007, [EMAIL PROTECTED] wrote: > 1. Should one put .cfm files under the WEB-INF directory? Nope. We have a separate web root, set that as DocumentRoot in Apache and all is well. -- Tom Chiverton Helping to enthusiastically orchestrate error-free features on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290052 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Maintaining database connections :: not working
Hi again, Thanks for taking the time to point me in the right direction with this one. I've done a little more investigation and I've discovered that this the change in behaviour is not simply due to the move from CF7 to CF8. I am happy to confirm that I have now seen DB connections pooled correctly in CF8 using Firebird's Jaybird driver. This does leave me with a couple of interesting questions, although not ones that really needs answers as I can work around the problem. Here's the scenario: I have a number of Linux boxes each with a CF8 enterprise instance, the CF instances are clustered. Each box also has an Apache installation, each Apache can see the whole cluster. The Apache instances are load balanced. The web source code is on an NFS share which each Linux box has mounted. I decided it would be convenient to have a bit of code on each server which would not come from the NFS share and would be unique to each server. It simply provides information to the load balancers about how the servers are getting on. I discovered this could be achieved by dropping this code into CF's WEB-INF directory. It's the code which runs here which builds a new connection to the DB each time it's run, seemingly ignoring the pooling settings, although it simply refers to the same datasource as the main app. As it turns out, this code wasn't unique after all and it can return to the NFS share but it raises a couple of interesting questions: 1. Should one put .cfm files under the WEB-INF directory? 2. Is it significant / interesting that it seems to behave differently with respect to DB pooling? Cheers, Simon ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290051 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Maintaining database connections :: not working
Thanks Tom - will do. -- [EMAIL PROTECTED] Applications Development Manager Warwick Business School >>> Tom Chiverton <[EMAIL PROTECTED]> 02/10/2007 14:13 >>> On Tuesday 02 Oct 2007, [EMAIL PROTECTED] wrote: > You're right to suspect that I don't have any direct evidence for this ;-) Well, I'd certainly fire up the server monitor or DB layer debugging then. Maybe your CF8 site is just busier :-) -- Tom Chiverton Helping to continuously enable B2B experiences on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289914 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Maintaining database connections :: not working
On Tuesday 02 Oct 2007, [EMAIL PROTECTED] wrote: > You're right to suspect that I don't have any direct evidence for this ;-) Well, I'd certainly fire up the server monitor or DB layer debugging then. Maybe your CF8 site is just busier :-) -- Tom Chiverton Helping to continuously enable B2B experiences on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289905 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Maintaining database connections :: not working
>How do you know it's not working ? Poor performance could be a vast number of >things. Hi Tom, You're right to suspect that I don't have any direct evidence for this ;-) I'm basing my suspicion on the fact that I see the following in the database logs: Oct 2 08:55:56 db_server xinetd[2232]: START: gds_db pid=12168 from=web_server Oct 2 08:55:56 db_server xinetd[2232]: START: gds_db pid=12169 from=web_server Oct 2 08:55:56 db_server xinetd[2232]: START: gds_db pid=12170 from=web_server Oct 2 08:55:56 db_server xinetd[2232]: START: gds_db pid=12171 from=web_server Oct 2 08:55:56 db_server xinetd[2232]: START: gds_db pid=12172 from=web_server Oct 2 08:55:56 db_server xinetd[2232]: START: gds_db pid=12173 from=web_server Oct 2 08:55:56 db_server xinetd[2232]: START: gds_db pid=12174 from=web_server ... etc. about six entries per second. As I said before we have a CF7 server as well which only appears in this log every few minutes. These entries only appear when I start the CF instance on the web server machine and disappear when it is stopped. Also, the CF8 server has approximately 90 connections to the DB at any one point where as the CF7 server has 15. It is possible to enable logging on the DB driver so I'll turn that on and take a look. >Some databases (maybe FireBird) do actively drop idling connections, in >certain circumstances. Or if the network drops out, that will do it too. Thanks again Tom. I'm quite happy to accept that the DB driver will need to be looked at again, but I was particularly interested to hear if this had been noticed elsewhere. I suspect not. Regards, Simon -- [EMAIL PROTECTED] Applications Development Manager Warwick Business School ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289894 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Maintaining database connections :: not working
>> Having just moved one of our sites from CF7 to CF8 I've >> noticed that the connection pooling (Maintain Connections) >> setting is not working >> This is having a horrible effect on performance of the site Dave Watts wrote: >If you check the neo-datasource.xml file for your datasource, do you see any >information pertaining to connection pooling? Thanks for looking, Dave. Yes, I've checked the XML file and each of the datasources contains the following: Simon -- [EMAIL PROTECTED] Applications Development Manager Warwick Business School ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289892 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Maintaining database connections :: not working
> Having just moved one of our sites from CF7 to CF8 I've > noticed that the connection pooling (Maintain Connections) > setting is not working (I've unticked and ticked again to > check!). The sites left on the CF7 installation are still > working with the same driver as I would expect. > > This is having a horrible effect on performance of the site > and I'm wondering if anyone else has experienced this. We're > using Firebird DB (which I don't suppose many people are!) > but I would have thought the job of maintaining the > connections would fall to CF/JRun. If you check the neo-datasource.xml file for your datasource, do you see any information pertaining to connection pooling? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289876 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Maintaining database connections :: not working
On Monday 01 Oct 2007, [EMAIL PROTECTED] wrote: > Having just moved one of our sites from CF7 to CF8 I've noticed that the > connection pooling (Maintain Connections) setting is not working (I've > unticked and ticked again to check!). How do you know it's not working ? Poor performance could be a vast number of things. > (which I don't suppose many people are!) but I would have thought the job > of maintaining the connections would fall to CF/JRun. Some databases (maybe FireBird) do actively drop idling connections, in certain circumstances. Or if the network drops out, that will do it too. -- Tom Chiverton Helping to paradigmatically bully proactive e-tailers on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289858 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Maintaining database connections :: not working
Hi, Having just moved one of our sites from CF7 to CF8 I've noticed that the connection pooling (Maintain Connections) setting is not working (I've unticked and ticked again to check!). The sites left on the CF7 installation are still working with the same driver as I would expect. This is having a horrible effect on performance of the site and I'm wondering if anyone else has experienced this. We're using Firebird DB (which I don't suppose many people are!) but I would have thought the job of maintaining the connections would fall to CF/JRun. Does anyone have any ideas how to crack this one? Thanks, Simon ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289852 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Check database connections
Yes, sp_who or select * from sysprocesses would work, but he stated that he didn't have access to the database server. That is a good question. I bet there is something in service factory which will tell you. ~Brad -Original Message- From: Tom G [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 02, 2007 3:41 PM To: CF-Talk Subject: Re: Check database connections >Well.. for SQL server... > >Do you have access to the database server? You can use a perfmon to see >current connections. > >Also, for SQL 2000 you can use Enterprise Manager (Management - Current >Activity) and for SQL 2005 you can use SQL studio. > >Jacob > >-Original Message- >From: Tom G [mailto:[EMAIL PROTECTED] >Sent: Wednesday, May 02, 2007 7:56 AM >To: CF-Talk >Subject: Check database connections > >Anyone know how to see how many database connections are currently open to a >particular database? Without having to ask a DBA to check? The app runs on >MX7. It connects to both an Oracle database and a SQL Server database. No, we don't have access to the database server (for SQL Server). I was trying to find a way to check the number of connections through CF somehow. Haven't had much luck with that search. How about checking connections to an Oracle database? This SQL Server database is going to migrate to Oracle sometime in the near future. Plus, we have our own Oracle database (the SQL Server database is owned by an outside vendor and we just read from it). So if I can figure out how to check connections to an Oracle database I'll feel like I've made some progress. Thanks. ~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276824 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Check database connections
>Well.. for SQL server... > >Do you have access to the database server? You can use a perfmon to see >current connections. > >Also, for SQL 2000 you can use Enterprise Manager (Management - Current >Activity) and for SQL 2005 you can use SQL studio. > >Jacob > >-Original Message- >From: Tom G [mailto:[EMAIL PROTECTED] >Sent: Wednesday, May 02, 2007 7:56 AM >To: CF-Talk >Subject: Check database connections > >Anyone know how to see how many database connections are currently open to a >particular database? Without having to ask a DBA to check? The app runs on >MX7. It connects to both an Oracle database and a SQL Server database. No, we don't have access to the database server (for SQL Server). I was trying to find a way to check the number of connections through CF somehow. Haven't had much luck with that search. How about checking connections to an Oracle database? This SQL Server database is going to migrate to Oracle sometime in the near future. Plus, we have our own Oracle database (the SQL Server database is owned by an outside vendor and we just read from it). So if I can figure out how to check connections to an Oracle database I'll feel like I've made some progress. Thanks. ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276822 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Check database connections
Well.. for SQL server... Do you have access to the database server? You can use a perfmon to see current connections. Also, for SQL 2000 you can use Enterprise Manager (Management - Current Activity) and for SQL 2005 you can use SQL studio. Jacob -Original Message- From: Tom G [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 02, 2007 7:56 AM To: CF-Talk Subject: Check database connections Anyone know how to see how many database connections are currently open to a particular database? Without having to ask a DBA to check? The app runs on MX7. It connects to both an Oracle database and a SQL Server database. ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276770 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Check database connections
Anyone know how to see how many database connections are currently open to a particular database? Without having to ask a DBA to check? The app runs on MX7. It connects to both an Oracle database and a SQL Server database. ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276765 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Timeouts and Database Connections
Tom Kitta wrote: > Delete operations use exclusive locks on SQL server by default Hence you should make sure you have set the transaction to use a snapshot isolation level. Jochem ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254877 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Timeouts and Database Connections
Looks like someone is locking a table during user interaction - this is a bug. You never lock a table with even CF code in it that could run few ms, not to mention user interaction. Remove user from the transaction and all will be fine. Delete operations use exclusive locks on SQL server by default thus delete operation will block read operation (which is not a dirty read). Your problem is the user interaction inside a transaction. TK -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Saturday, September 30, 2006 7:11 AM To: CF-Talk Subject: Re: Timeouts and Database Connections Smith, Daron [PA] wrote: > I recently had CF lock up a bunch of times because a main table used > on > the website was locked for a delete operation and waiting for a user > confirmation response. I have the overall timeout setting in the > cfadmin set to 30 seconds however queries against this table were > eventually causing CF to lockup as the table was locked. Is there > another way to ensure that queries against a locked table will fail > rather than waiting? The query was against SQL Server if that makes > a difference. What is the default isolation level of your database? I don't think you would want to run an isolation level where deletes block reads for a website. Jochem ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254875 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Timeouts and Database Connections
Smith, Daron [PA] wrote: > I recently had CF lock up a bunch of times because a main table used > on > the website was locked for a delete operation and waiting for a user > confirmation response. I have the overall timeout setting in the > cfadmin set to 30 seconds however queries against this table were > eventually causing CF to lockup as the table was locked. Is there > another way to ensure that queries against a locked table will fail > rather than waiting? The query was against SQL Server if that makes > a difference. What is the default isolation level of your database? I don't think you would want to run an isolation level where deletes block reads for a website. Jochem ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254865 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Timeouts and Database Connections
I think you can use either Select * from table with (nolock) which will get you old data before the other transaction took place or Select * from table with (updlock, nowait) which will put an update lock on the table (records maybe?) and will not wait if it can't get a lock. You can also try just "with (nowait)" to see if that works for you as well. Russ > -Original Message- > From: Smith, Daron [PA] [mailto:[EMAIL PROTECTED] > Sent: Friday, September 29, 2006 2:52 PM > To: CF-Talk > Subject: Timeouts and Database Connections > > I recently had CF lock up a bunch of times because a main table used on > the website was locked for a delete operation and waiting for a user > confirmation response. I have the overall timeout setting in the > cfadmin set to 30 seconds however queries against this table were > eventually causing CF to lockup as the table was locked. Is there > another way to ensure that queries against a locked table will fail > rather than waiting? The query was against SQL Server if that makes a > difference. > > Thanks, > Daron Smith > PSEA IT > > "PSEA E-mail Firewall" annotation on Fri Sep 29 2006 14:53:23 > - > NOTICE: Only the individual sender is responsible for the content of the > message, and the message does not necessarily reflect the position or > policy of the Pennsylvania State Education Association. > - > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254826 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Timeouts and Database Connections
I recently had CF lock up a bunch of times because a main table used on the website was locked for a delete operation and waiting for a user confirmation response. I have the overall timeout setting in the cfadmin set to 30 seconds however queries against this table were eventually causing CF to lockup as the table was locked. Is there another way to ensure that queries against a locked table will fail rather than waiting? The query was against SQL Server if that makes a difference. Thanks, Daron Smith PSEA IT "PSEA E-mail Firewall" annotation on Fri Sep 29 2006 14:53:23 - NOTICE: Only the individual sender is responsible for the content of the message, and the message does not necessarily reflect the position or policy of the Pennsylvania State Education Association. - ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254822 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: database connections
there is a timeout setting in the CFADMIN tool for this. I'd guess turning off teh 'maintain connections' should kill each connection after the timeout, maybe before I can't recall. ah...the docs have Timeout (min) The maximum number of minutes after the data source connection is made that you want ColdFusion MX to cache a connection after it is used. Interval (min) The time (in minutes) that the server waits between cycles to check for expired data source connections to close. Doug - Original Message - From: Phill B <[EMAIL PROTECTED]> Date: Tue, 31 Aug 2004 10:44:28 -0500 Subject: database connections To: CF-Talk <[EMAIL PROTECTED]> Here is the deal. I have CFMX on my laptop with dev apps that connect to the mssql server. I use an app that hits 3 different data sources which would create 3 processes on the sql server. Lets say I shut down and restart my laptop and run the app again. I now have 6 processes running on the sql server. In CF Admin I have maintain connections checked. If I uncheck it, will that help or fix the problem? Also, is there a way to time out connections on the sql server? -- Phillip B. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
database connections
Here is the deal. I have CFMX on my laptop with dev apps that connect to the mssql server. I use an app that hits 3 different data sources which would create 3 processes on the sql server. Lets say I shut down and restart my laptop and run the app again. I now have 6 processes running on the sql server. In CF Admin I have maintain connections checked. If I uncheck it, will that help or fix the problem? Also, is there a way to time out connections on the sql server? -- Phillip B. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
JRUN drops database connections
It seems JRUN keeps dropping connections from the database(using connection pooling). Are there any know issues with db connections being dropped for no apparent reason. We are running JRUN4 w/updater 3 and MS SQL Server 2000 sp4. We've tried using both Macromedia and Microsoft JDBC drivers and the problem occurs with both of them. The issue also occurred when using updater 2 and we thought(hoped) updater 3 would resolve the issue but no luck. I know this is the ColdFusion forum but. Thanks, Dave HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Maintain database connections
> I'm helping to setup a new live CF5 Pro server and I've heard > that "Maintain database connections" should be unchecked in a > shared environment. Does anyone know what best practice is on > this? In general, you want to maintain database connections, because they're expensive to create and destroy at runtime. However, there are some cases where you might not want to do this: - if your specific database environment (including drivers) doesn't work well with it enabled, - if you're using a file-based database like MS Access and you want to be able to overwrite the file while CF is running - if your application can't take advantage of them because it's using user-specific database logins for each application user, and has very few database interactions per user On a slightly unrelated note, I'd like to point out that best practices are not often monolithic. They tend to be fluid, and dependent on your situation. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Maintain database connections
Im helping to setup a new live CF5 Pro server and Ive heard that Maintain database connections should be unchecked in a shared environment. Does anyone know what best practice is on this? Thank you, Aftershock Web Design, Inc. by: Stan Winchester President/Developer [EMAIL PROTECTED] http://www.aftershockweb.com/ Tel. 503-244-3440 Fax 503-244-3454 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Downside to disabling "Maintain Database Connections
Thx! I figured it was somewhere in there. Cheers, --- Matt Robertson, MSB Designs, Inc. http://mysecretbase.com - Retail --- -- Original Message -- from: Sean A Corfield <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Wed, 6 Nov 2002 12:41:32 -0800 >On Wednesday, Nov 6, 2002, at 08:29 US/Pacific, Matt Robertson wrote: >> As I understand it, disabling that setting is the recommended best >> practice for Access. Keeps things from crashing outright, so in this >> narrow circumstance there is no downside. An article on this was in >> the >> KB somewhere. It was entitled along the lines of ''using access in >> production environments''. I couldn't find it by searching for >> "access". > >http://www.macromedia.com/v1/Handlers/index.cfm?ID=1540&Method=Full > >> Whatever happened to the plain ol' KB? Did it get absorbed into >> something? I couldn't even find the thing on the MM site. > >On the home page, in the Flash movie, mouse over Support and click >SHORTCUTS. Enter your query, select the ColdFusion support center and >click SEARCH. > >Admittedly, that search didn't turn up the article. But from the >results page I clicked this link: > >http://www.macromedia.com/v1/support/knowledgebase/searchform.cfm > >And that gave me a 'power search' on the old KB. > >In fact, http://www.allaire.com/support/knowledgebase/searchform.cfm >still works, just like it did a year ago (it was my team that had to >build the web server magic to make sure all the old URLs continued to >work when we merged the sites! :) > >Hope that helps! > >"If you're not annoying somebody, you're not really alive." >-- Margaret Atwood > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Downside to disabling "Maintain Database Connections
On Wednesday, Nov 6, 2002, at 08:29 US/Pacific, Matt Robertson wrote: > As I understand it, disabling that setting is the recommended best > practice for Access. Keeps things from crashing outright, so in this > narrow circumstance there is no downside. An article on this was in > the > KB somewhere. It was entitled along the lines of ''using access in > production environments''. I couldn't find it by searching for > "access". http://www.macromedia.com/v1/Handlers/index.cfm?ID=1540&Method=Full > Whatever happened to the plain ol' KB? Did it get absorbed into > something? I couldn't even find the thing on the MM site. On the home page, in the Flash movie, mouse over Support and click SHORTCUTS. Enter your query, select the ColdFusion support center and click SEARCH. Admittedly, that search didn't turn up the article. But from the results page I clicked this link: http://www.macromedia.com/v1/support/knowledgebase/searchform.cfm And that gave me a 'power search' on the old KB. In fact, http://www.allaire.com/support/knowledgebase/searchform.cfm still works, just like it did a year ago (it was my team that had to build the web server magic to make sure all the old URLs continued to work when we merged the sites! :) Hope that helps! "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Downside to disabling "Maintain Database Connections
Another thing to be aware of is that Maintained DB connections are actually cached by CF (I'm pretty sure); so if a network outage causes an error when attempting to connect to a DB, CF can cache that error, and prohibit the DB connection even when the network is back up. This may not really be an issue on a local connection to access; but then again, why would you be concerned about performance on such a configuration. IGOR ILYINSKY CREDIT|FIRST SUISSE|BOSTON GLOBAL WEB SERVICES -Original Message- From: Matt Robertson [mailto:matt@;mysecretbase.com] Sent: Wednesday, November 06, 2002 11:29 AM To: CF-Talk Subject: RE: Downside to disabling "Maintain Database Connections As I understand it, disabling that setting is the recommended best practice for Access. Keeps things from crashing outright, so in this narrow circumstance there is no downside. An article on this was in the KB somewhere. It was entitled along the lines of ''using access in production environments''. I couldn't find it by searching for "access". Whatever happened to the plain ol' KB? Did it get absorbed into something? I couldn't even find the thing on the MM site. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Paul Sinclair [mailto:lists@;mail1.kingcrest.com] Sent: Wednesday, November 06, 2002 7:43 AM To: CF-Talk Subject: Downside to disabling "Maintain Database Connections I posted a note yesterday re several sites running veeey slow on a server. I have a couple sites that are MS Access databases. I am in the process of moving these to SQL but in the interim I need to keep the sites up. I found that by disabling the "Maintain Database Connections" setting in the ODBC configuration for these Access databases that it seems to take care of the problem for the most part. I am just wondering what the downside is to disabling that setting? Thanks for advice. Paul Sinclair ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Downside to disabling "Maintain Database Connections
Matt, I have the same problem with MM's resources. I'm always having to wade through stuff to find the plain old technical articles - while tutorials abound. -mk -Original Message- From: Matt Robertson [mailto:matt@;mysecretbase.com] Sent: Wednesday, November 06, 2002 10:29 AM To: CF-Talk Subject: RE: Downside to disabling "Maintain Database Connections As I understand it, disabling that setting is the recommended best practice for Access. Keeps things from crashing outright, so in this narrow circumstance there is no downside. An article on this was in the KB somewhere. It was entitled along the lines of ''using access in production environments''. I couldn't find it by searching for "access". Whatever happened to the plain ol' KB? Did it get absorbed into something? I couldn't even find the thing on the MM site. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Paul Sinclair [mailto:lists@;mail1.kingcrest.com] Sent: Wednesday, November 06, 2002 7:43 AM To: CF-Talk Subject: Downside to disabling "Maintain Database Connections I posted a note yesterday re several sites running veeey slow on a server. I have a couple sites that are MS Access databases. I am in the process of moving these to SQL but in the interim I need to keep the sites up. I found that by disabling the "Maintain Database Connections" setting in the ODBC configuration for these Access databases that it seems to take care of the problem for the most part. I am just wondering what the downside is to disabling that setting? Thanks for advice. Paul Sinclair ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Downside to disabling "Maintain Database Connections
As I understand it, disabling that setting is the recommended best practice for Access. Keeps things from crashing outright, so in this narrow circumstance there is no downside. An article on this was in the KB somewhere. It was entitled along the lines of ''using access in production environments''. I couldn't find it by searching for "access". Whatever happened to the plain ol' KB? Did it get absorbed into something? I couldn't even find the thing on the MM site. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Paul Sinclair [mailto:lists@;mail1.kingcrest.com] Sent: Wednesday, November 06, 2002 7:43 AM To: CF-Talk Subject: Downside to disabling "Maintain Database Connections I posted a note yesterday re several sites running veeey slow on a server. I have a couple sites that are MS Access databases. I am in the process of moving these to SQL but in the interim I need to keep the sites up. I found that by disabling the "Maintain Database Connections" setting in the ODBC configuration for these Access databases that it seems to take care of the problem for the most part. I am just wondering what the downside is to disabling that setting? Thanks for advice. Paul Sinclair ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Downside to disabling "Maintain Database Connections
Paul, The downside is that you are adding overhead to each request by making them negotiate a connection rather than selecting from existing connections. This is worth it in your case however, as it seems to solve your performance problem on another level. Access has a connection "threshold" for stability that I've heard is as low as "25 connections (i.e. more than 25 connections and performance begins to degrade) and as high as 75. Different folks say different things - but everybody says this ... "don't run your production sites on access" . It sounds like you are well on your way to solving this problem by migrating to SQL. The only other tip that "some" have made regarding access is that the OLE DB drivers tend to perform better. -mk -Original Message- From: Paul Sinclair [mailto:lists@;mail1.kingcrest.com] Sent: Wednesday, November 06, 2002 9:43 AM To: CF-Talk Subject: Downside to disabling "Maintain Database Connections I posted a note yesterday re several sites running veeey slow on a server. I have a couple sites that are MS Access databases. I am in the process of moving these to SQL but in the interim I need to keep the sites up. I found that by disabling the "Maintain Database Connections" setting in the ODBC configuration for these Access databases that it seems to take care of the problem for the most part. I am just wondering what the downside is to disabling that setting? Thanks for advice. Paul Sinclair ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Downside to disabling "Maintain Database Connections
Ironically, disabling persistent database connections should slow down database access since every call would require the creation of a new database connection. Go figure. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ > -Original Message- > From: Paul Sinclair [mailto:lists@;mail1.kingcrest.com] > Sent: Wednesday, November 06, 2002 10:43 AM > To: CF-Talk > Subject: Downside to disabling "Maintain Database Connections > > > I posted a note yesterday re several sites running veeey slow on a > server. I have a couple sites that are MS Access databases. I am in the > process of moving these to SQL but in the interim I need to keep the sites > up. I found that by disabling the "Maintain Database Connections" > setting in > the ODBC configuration for these Access databases that it seems > to take care > of the problem for the most part. I am just wondering what the downside is > to disabling that setting? > > Thanks for advice. > > Paul Sinclair > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Downside to disabling "Maintain Database Connections
I posted a note yesterday re several sites running veeey slow on a server. I have a couple sites that are MS Access databases. I am in the process of moving these to SQL but in the interim I need to keep the sites up. I found that by disabling the "Maintain Database Connections" setting in the ODBC configuration for these Access databases that it seems to take care of the problem for the most part. I am just wondering what the downside is to disabling that setting? Thanks for advice. Paul Sinclair ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
CF Admin- Database Connections
When using WK2, MS-SQL 7, and CF5 what's the performance difference in having Maintain Database Connections -(Check this box to maintain connections to data sources across client requests.) Checked in cf datasources? Thanks, Dave __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: database connections
it does. i can connect to all the databases alone just fine. it is when i try to join them is where i get the error. -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 5:03 PM To: CF-Talk Subject: RE: database connections Check to make sure the Cold Fusion service account has access to the SQL database. Or maybe use the User and Password attributes of the CFQuery tag. Good luck. Shawn Grover -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 1:58 PM To: CF-Talk Subject: database connections > -Original Message- > From: Jones, Becky > Sent: Monday, September 17, 2001 11:19 AM > To: '[EMAIL PROTECTED]' > Subject: database connections > > i have a complex problem. i basically have 3 databases. one access, one > sql 6.5 and one sql 7.0. > i do most of my connecting and querying in the access database. my > problem is that i wrote a query in access that is using linked tables to > the sql6.5 database and also to the 7.0. > my query runs perfectly inside my access database...no errors. > but in cf when i try to run this query using: > ''''this ITDATA is my access > datasource''' > SELECT * FROM qryWO > > i get an error that says: > ODBC Error Code = S1000 (General error) > [Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'SQL > ServerBALTMGMT01' failed. > The error occurred while processing an element with a general identifier > of (CFQUERY), occupying document position (10:2) to (10:45) in the > template file C:\INETPUB\WWWROOT\HELPDESK\FRMOPENWO.CFM. > the error seems to be in connecting to the sql7.0 dbase. > has anyone run into this problem before? is there an easier way to do a > connection to tables from 2 seperate databases??? > thanks for your help. > bec. > > > * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: database connections
Check to make sure the Cold Fusion service account has access to the SQL database. Or maybe use the User and Password attributes of the CFQuery tag. Good luck. Shawn Grover -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 1:58 PM To: CF-Talk Subject: database connections > -Original Message- > From: Jones, Becky > Sent: Monday, September 17, 2001 11:19 AM > To: '[EMAIL PROTECTED]' > Subject: database connections > > i have a complex problem. i basically have 3 databases. one access, one > sql 6.5 and one sql 7.0. > i do most of my connecting and querying in the access database. my > problem is that i wrote a query in access that is using linked tables to > the sql6.5 database and also to the 7.0. > my query runs perfectly inside my access database...no errors. > but in cf when i try to run this query using: > ''''this ITDATA is my access > datasource''' > SELECT * FROM qryWO > > i get an error that says: > ODBC Error Code = S1000 (General error) > [Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'SQL > ServerBALTMGMT01' failed. > The error occurred while processing an element with a general identifier > of (CFQUERY), occupying document position (10:2) to (10:45) in the > template file C:\INETPUB\WWWROOT\HELPDESK\FRMOPENWO.CFM. > the error seems to be in connecting to the sql7.0 dbase. > has anyone run into this problem before? is there an easier way to do a > connection to tables from 2 seperate databases??? > thanks for your help. > bec. > > > * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
database connections
> -Original Message- > From: Jones, Becky > Sent: Monday, September 17, 2001 11:19 AM > To: '[EMAIL PROTECTED]' > Subject: database connections > > i have a complex problem. i basically have 3 databases. one access, one > sql 6.5 and one sql 7.0. > i do most of my connecting and querying in the access database. my > problem is that i wrote a query in access that is using linked tables to > the sql6.5 database and also to the 7.0. > my query runs perfectly inside my access database...no errors. > but in cf when i try to run this query using: > ''''this ITDATA is my access > datasource''' > SELECT * FROM qryWO > > i get an error that says: > ODBC Error Code = S1000 (General error) > [Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'SQL > ServerBALTMGMT01' failed. > The error occurred while processing an element with a general identifier > of (CFQUERY), occupying document position (10:2) to (10:45) in the > template file C:\INETPUB\WWWROOT\HELPDESK\FRMOPENWO.CFM. > the error seems to be in connecting to the sql7.0 dbase. > has anyone run into this problem before? is there an easier way to do a > connection to tables from 2 seperate databases??? > thanks for your help. > bec. > > > * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
database connections
i have a complex problem. i basically have 3 databases. one access, one sql 6.5 and one sql 7.0. i do most of my connecting and querying in the access database. my problem is that i wrote a query in access that is using linked tables to the sql6.5 database and also to the 7.0. my query runs perfectly inside my access database...no errors. but in cf when i try to run this query using: this ITDATA is my access datasource''' SELECT * FROM qryWO i get an error that says: ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'SQL ServerBALTMGMT01' failed. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (10:2) to (10:45) in the template file C:\INETPUB\WWWROOT\HELPDESK\FRMOPENWO.CFM. the error seems to be in connecting to the sql7.0 dbase. has anyone run into this problem before? is there an easier way to do a connection to tables from 2 seperate databases??? thanks for your help. bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: database connections in Studio
> I can't find any reference to CF Studio 5 at the > Macromedia web site. Did you confuse this with > UltraDev Studio? Same thing. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: database connections in Studio
> Get the Studio 5 beta 2. Much, *much* better than 4.5... I can't find any reference to CF Studio 5 at the Macromedia web site. Did you confuse this with UltraDev Studio? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: database connections in Studio
At 02:07 AM 08/23/2001 -0700, you wrote: > > reads "access violation at address 00617D40 in module > > 'cfstudio45.exe'. read of address ." It then > >Get the Studio 5 beta 2. Much, *much* better than 4.5... It is more stable, I'll give it that. -- Jeffry Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- I'm looking for a room-mate in the Hartford CT area, starting in August -- Instant ColdFusion 5.0 | ISBN: 0-07-213238-8 http://www.instantcoldfusion.com -- DotComIt, LLC database driven web data using ColdFusion, Lotus Notes/Domino -- Far Cry Fly, Alternative Folk Rock http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- Change is good ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: database connections in Studio
> reads "access violation at address 00617D40 in module > 'cfstudio45.exe'. read of address ." It then Get the Studio 5 beta 2. Much, *much* better than 4.5... ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
database connections in Studio
I used to not have these problems, and it seems like they just started occuring since I added the upgrade to version 4.5.2 from CF Server 5.0. When I select the database tab in the Resources section of Studio's window and try to expand the tables of an access database, I get an error that reads "access violation at address 00617D40 in module 'cfstudio45.exe'. read of address ." It then just sits there and say "retrieving tables", but never does anything. Also, I have a remote SQL server, and when I try to connect to that, nothing happens at all. Once in a while I get an error that reads "unknown internal error in RDS proxy. Enable logging if possible". All these daabases are entered in as ODBC datasources and DO verify via CF Administrator. My CF pages that query these databases also do work. Any help would be greatly appreciated. Tim ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Another Question About Database Connections Using Oracle
Here I go again... Where can I find specific information on how CF connects to an Oracle DB using Native Drivers? In the CF Administrator, under data sources, Native Drivers, what happens when I select the option "Maintain Database Connections". Does this mean that only one connection per client is made when accessing an application? If I deselect this box, will multiple sessions be opened each time a query is executed on a page during a user's session? Obviously, I'm lost. But I know among this group there has got to be an Oracle guru. Thanks Again, Debbie Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Lost ODBC Database Connections
Are you using the same userid and passwords from the ODBC32 control panel and the cold fusion administrator? It's probably and id and password failure. Mary |+> || Mike Deane| || | ||| || 08/29/2000 09:56 | || AM| || Please respond to | || cf-talk | ||| |+> >| || | To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>| | cc: (bcc: Mary Baotic/na/Hyperion) | | Subject: Lost ODBC Database Connections | >| 1. My NT/IIS DSNs all check out fine in the ODBC32 Control Panel. TEST COMPLETED SUCCESSFULLY! 2. The same DSNs in the ColdFusion Administrator (where every one of these was built from) have stopped working. Failed. Any clues? Thanks. /mdeane -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Lost ODBC Database Connections
> 1. My NT/IIS DSNs all check out fine in the ODBC32 Control > Panel. TEST COMPLETED SUCCESSFULLY! > 2. The same DSNs in the ColdFusion Administrator (where every one of > these was built from) have stopped working. Failed. This can happen if you use different authentication info in the ODBC Control Panel than you do in the CF Administrator. Check whether or not you're using trusted connections in both, and that you're using the same username and password in both. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Lost ODBC Database Connections
1. My NT/IIS DSNs all check out fine in the ODBC32 Control Panel. TEST COMPLETED SUCCESSFULLY! 2. The same DSNs in the ColdFusion Administrator (where every one of these was built from) have stopped working. Failed. Any clues? Thanks. /mdeane -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Force database connections to close....
Or, as pointed out to me on this list, you can also try: CFUSION_DBCONNECTIONS_FLUSH(); Gregory M. Saunders, Ph.D. Senior Design Architect Cognitive Arts Corporation (http://www.cognitivearts.com) 1840 Oak Avenue, 4th Floor Evanston, IL 60201-5914 At 11:58 AM 7/11/00 +1000, [EMAIL PROTECTED] wrote: > >> Is there a way to force the database connection to close or to >> release memory as data is dumped to the client..??? >> >> some like connection.close() >> >> This would really be a powerful feature to have... >> > >If you do a CFQUERY to a table that doesn't exist, the database connection >closes. Don't know if that helps. > > >Rob Keniger > > >--- --- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Force database connections to close....
The default behavior of ODBC connections created through CF Admin is to keep connections open. This is done to avoid the overhead of repeatedly opening and closing the connection on a per call basis. When this option is turned off, via the checkbox in the connection configuration, a new connection is opened and then closed for every call to a DSN. This is less efficient but, can be useful when a particular DSN is used infrequently or to avoid locking problems with file based dbs, like Access. This can be helpful in development environments. In situations where you have a template or app that is called infrequently but uses a large number of connections you may want the best of both worlds, i.e. a persistent connection for the life of the template/app/session that drops when finished. A possibility is to see if the call that CF Admin makes to clear all connections can be tailored to only drop an individual connection. You could then leave your connections in persistent mode and drop them on demand :) Steve > From: [EMAIL PROTECTED] > Reply-To: [EMAIL PROTECTED] > Date: Mon, 10 Jul 2000 11:25:38 -0700 > To: [EMAIL PROTECTED] > Subject: Force database connections to close > > > Hello all, > It looks like CF doesnt like to release the > data brought down, which hogs up on the memory. > > Is there a way to force the database connection to close or to > release memory as data is dumped to the client..??? > > some like connection.close() > > This would really be a powerful feature to have... > > Any ideas > > Thanks > Joe > > - > Sent using MailStart.com ( http://MailStart.Com/welcome.html ) > The FREE way to access your mailbox via any web browser, anywhere! > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in the > body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Force database connections to close....
> Is there a way to force the database connection to close or to > release memory as data is dumped to the client..??? > > some like connection.close() > > This would really be a powerful feature to have... > If you do a CFQUERY to a table that doesn't exist, the database connection closes. Don't know if that helps. Rob Keniger -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Force database connections to close....
- Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 10, 2000 2:25 PM Subject: Force database connections to close > > Hello all, > It looks like CF doesnt like to release the > data brought down, which hogs up on the memory. > > Is there a way to force the database connection to close or to > release memory as data is dumped to the client..??? > > some like connection.close() > > This would really be a powerful feature to have... > > Any ideas > > Thanks > Joe > > - > Sent using MailStart.com ( http://MailStart.Com/welcome.html ) > The FREE way to access your mailbox via any web browser, anywhere! > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Force database connections to close....
Hi Joe, Can't this be controlled from the CF Administrator on a per ODBC connection level? If you look at the ODBC connections, there is an option to keep the connections open for that data source. I normally leave this as on, but I assume that unchecking that option would not keep the connections open and effectively do what you are asking? Hope this helps Nick > From: [EMAIL PROTECTED] > Reply-To: [EMAIL PROTECTED] > Date: Mon, 10 Jul 2000 11:25:38 -0700 > To: [EMAIL PROTECTED] > Subject: Force database connections to close > > > Hello all, > It looks like CF doesnt like to release the > data brought down, which hogs up on the memory. > > Is there a way to force the database connection to close or to > release memory as data is dumped to the client..??? > > some like connection.close() > > This would really be a powerful feature to have... > > Any ideas > > Thanks > Joe > > - > Sent using MailStart.com ( http://MailStart.Com/welcome.html ) > The FREE way to access your mailbox via any web browser, anywhere! > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in the > body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Force database connections to close....
Hello all, It looks like CF doesnt like to release the data brought down, which hogs up on the memory. Is there a way to force the database connection to close or to release memory as data is dumped to the client..??? some like connection.close() This would really be a powerful feature to have... Any ideas Thanks Joe - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Simultaneous database connections to MS Access
> Also, if a query is cached, does it make a connection to the DB at > all, or is it totally in RAM? Queries cached by CF are stored in memory on the CF server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Simultaneous database connections to MS Access
FWIW - Access 2000 CLAIMS to be able to handle 255 concurrent users. (yea, right!). But if queries is all you're doing, not a bunch of input and update stuff, then you should be fine. Dave - Original Message - From: Bud <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, April 01, 2000 10:09 PM Subject: Simultaneous database connections to MS Access > Hi. I know Access is supposed to break down if hit with too many > requests at once. Using Access 2000, what would be a good number to > limit the simultaneous connections to the database? I've been setting > them at 5. I don't expect there's going to major traffic at any of > the sites. A couple GB a month or so. If there are 10-20 people on > the site at once, since most queries are going to run in way under a > second, there shouldn't be but a second or 2 delay at the most, eh? > > Also, if a query is cached, does it make a connection to the DB at > all, or is it totally in RAM? > > Thanks. > > Bud Schneehagen - Tropical Web Creations > > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ > ColdFusion Solutions / eCommerce Development > [EMAIL PROTECTED] > http://www.twcreations.com/ > 954.721.3452 > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Simultaneous database connections to MS Access
Hi. I know Access is supposed to break down if hit with too many requests at once. Using Access 2000, what would be a good number to limit the simultaneous connections to the database? I've been setting them at 5. I don't expect there's going to major traffic at any of the sites. A couple GB a month or so. If there are 10-20 people on the site at once, since most queries are going to run in way under a second, there shouldn't be but a second or 2 delay at the most, eh? Also, if a query is cached, does it make a connection to the DB at all, or is it totally in RAM? Thanks. Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
