RE: The solution: (was: Re: Is there a way to force lock release on Access database? (CF9) )
Nobody throws a dwarf... ;o) -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Tuesday, September 21, 2010 1:26 AM To: cf-talk Subject: Re: The solution: (was: Re: Is there a way to force lock release on Access database? (CF9) ) throwing a dwarf may also help On Tue, Sep 21, 2010 at 6:23 AM, James Holmes james.hol...@gmail.comwrote: Have you tried intentionally throwing an error? **runs away** :-P -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 21 September 2010 05:28, Russ Michaels r...@michaels.me.uk wrote: don't blame you, its a very long and repetitive thread. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337255 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: The solution: (was: Re: Is there a way to force lock release on Access database? (CF9) )
At the risk of taking this off topic (it's too late I know) But technically, one tosses a dwarf: http://en.wikipedia.org/wiki/Dwarf_tossing -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: 21 September 2010 11:44 To: cf-talk Subject: RE: The solution: (was: Re: Is there a way to force lock release on Access database? (CF9) ) Nobody throws a dwarf... ;o) -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Tuesday, September 21, 2010 1:26 AM To: cf-talk Subject: Re: The solution: (was: Re: Is there a way to force lock release on Access database? (CF9) ) throwing a dwarf may also help On Tue, Sep 21, 2010 at 6:23 AM, James Holmes james.hol...@gmail.comwrote: Have you tried intentionally throwing an error? **runs away** :-P -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 21 September 2010 05:28, Russ Michaels r...@michaels.me.uk wrote: don't blame you, its a very long and repetitive thread. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337259 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: The solution: (was: Re: Is there a way to force lock release on Access database? (CF9) )
Not in Middle Earth (unless it's necessary in battle :o) -Original Message- From: Will Swain [mailto:w...@hothorse.com] Sent: Tuesday, September 21, 2010 8:39 AM To: cf-talk Subject: RE: The solution: (was: Re: Is there a way to force lock release on Access database? (CF9) ) At the risk of taking this off topic (it's too late I know) But technically, one tosses a dwarf: http://en.wikipedia.org/wiki/Dwarf_tossing -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: 21 September 2010 11:44 To: cf-talk Subject: RE: The solution: (was: Re: Is there a way to force lock release on Access database? (CF9) ) Nobody throws a dwarf... ;o) -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Tuesday, September 21, 2010 1:26 AM To: cf-talk Subject: Re: The solution: (was: Re: Is there a way to force lock release on Access database? (CF9) ) throwing a dwarf may also help On Tue, Sep 21, 2010 at 6:23 AM, James Holmes james.hol...@gmail.comwrote: Have you tried intentionally throwing an error? **runs away** :-P -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 21 September 2010 05:28, Russ Michaels r...@michaels.me.uk wrote: don't blame you, its a very long and repetitive thread. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337260 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: The solution: (was: Re: Is there a way to force lock release on Access database? (CF9) )
In the old days intentionally throwing a driver error would do it :) Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Andrew Scott [mailto:andr...@andyscott.id.au] Sent: Sunday, September 19, 2010 11:49 PM To: cf-talk Subject: RE: The solution: (was: Re: Is there a way to force lock release on Access database? (CF9) ) One could always use the Administrator API, and remove that setting from the admin settings. Whether this lock is changed on the request as easily is another story. Just a thought. Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: Mike Kear [mailto:afpwebwo...@gmail.com] Sent: Monday, 20 September 2010 2:41 PM To: cf-talk Subject: The solution: (was: Re: Is there a way to force lock release on Access database? (CF9) ) That would work too, Dave. I think!The second page would contain the delete functionality? Seems to make sense. The problem is to force ColdFusion to let go of the datasource completely before attempting to delete the MDB file. I have found that using CFThread wont work, because ColdFusion still hangs on to the datasource even after the .cfthread accessing it has completed. Later: ... I tried Dave Watts' suggestion of a CFLOCATION to a second page, and it works on my development environment.PROGRESS! Thank you Dave. So the lesson to learn: [A] ColdFusion 9 retains a lock on an Access database for the entire time a page that requires it is active. Once the page finishes processing, the lock is automatically released on the access database. PROVISO: you have to have set up the datasouce in the CFAdministrator as -- Maintain connections across client requests. set to Off (unchecked). I have not been doing any work on this with that option On, so I can only assume it wont work with that option set. [B] causing an error, by running a query on a non-existent table wont release the lock on the database post-CF5. That was the advice way back in the old days, but now it wont work. In fact it'll be counter-productive because it will cause the connection to the dsn to persist even longer and therefore retain the lock longer. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337236 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: The solution: (was: Re: Is there a way to force lock release on Access database? (CF9) )
Your about the nth person to give that answer Mark. as I said at the start, that hasn't worked since CF5. On Mon, Sep 20, 2010 at 4:48 PM, Mark A. Kruger mkru...@cfwebtools.comwrote: In the old days intentionally throwing a driver error would do it :) Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Andrew Scott [mailto:andr...@andyscott.id.au] Sent: Sunday, September 19, 2010 11:49 PM To: cf-talk Subject: RE: The solution: (was: Re: Is there a way to force lock release on Access database? (CF9) ) One could always use the Administrator API, and remove that setting from the admin settings. Whether this lock is changed on the request as easily is another story. Just a thought. Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: Mike Kear [mailto:afpwebwo...@gmail.com] Sent: Monday, 20 September 2010 2:41 PM To: cf-talk Subject: The solution: (was: Re: Is there a way to force lock release on Access database? (CF9) ) That would work too, Dave. I think!The second page would contain the delete functionality? Seems to make sense. The problem is to force ColdFusion to let go of the datasource completely before attempting to delete the MDB file. I have found that using CFThread wont work, because ColdFusion still hangs on to the datasource even after the .cfthread accessing it has completed. Later: ... I tried Dave Watts' suggestion of a CFLOCATION to a second page, and it works on my development environment.PROGRESS! Thank you Dave. So the lesson to learn: [A] ColdFusion 9 retains a lock on an Access database for the entire time a page that requires it is active. Once the page finishes processing, the lock is automatically released on the access database. PROVISO: you have to have set up the datasouce in the CFAdministrator as -- Maintain connections across client requests. set to Off (unchecked). I have not been doing any work on this with that option On, so I can only assume it wont work with that option set. [B] causing an error, by running a query on a non-existent table wont release the lock on the database post-CF5. That was the advice way back in the old days, but now it wont work. In fact it'll be counter-productive because it will cause the connection to the dsn to persist even longer and therefore retain the lock longer. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337239 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: The solution: (was: Re: Is there a way to force lock release on Access database? (CF9) )
Russ uh... sorry - should have read the whole thread... and I wasn't giving an answer really.. just being nostalgic :) Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Monday, September 20, 2010 4:14 PM To: cf-talk Subject: Re: The solution: (was: Re: Is there a way to force lock release on Access database? (CF9) ) Your about the nth person to give that answer Mark. as I said at the start, that hasn't worked since CF5. On Mon, Sep 20, 2010 at 4:48 PM, Mark A. Kruger mkru...@cfwebtools.comwrote: In the old days intentionally throwing a driver error would do it :) Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Andrew Scott [mailto:andr...@andyscott.id.au] Sent: Sunday, September 19, 2010 11:49 PM To: cf-talk Subject: RE: The solution: (was: Re: Is there a way to force lock release on Access database? (CF9) ) One could always use the Administrator API, and remove that setting from the admin settings. Whether this lock is changed on the request as easily is another story. Just a thought. Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: Mike Kear [mailto:afpwebwo...@gmail.com] Sent: Monday, 20 September 2010 2:41 PM To: cf-talk Subject: The solution: (was: Re: Is there a way to force lock release on Access database? (CF9) ) That would work too, Dave. I think!The second page would contain the delete functionality? Seems to make sense. The problem is to force ColdFusion to let go of the datasource completely before attempting to delete the MDB file. I have found that using CFThread wont work, because ColdFusion still hangs on to the datasource even after the .cfthread accessing it has completed. Later: ... I tried Dave Watts' suggestion of a CFLOCATION to a second page, and it works on my development environment.PROGRESS! Thank you Dave. So the lesson to learn: [A] ColdFusion 9 retains a lock on an Access database for the entire time a page that requires it is active. Once the page finishes processing, the lock is automatically released on the access database. PROVISO: you have to have set up the datasouce in the CFAdministrator as -- Maintain connections across client requests. set to Off (unchecked). I have not been doing any work on this with that option On, so I can only assume it wont work with that option set. [B] causing an error, by running a query on a non-existent table wont release the lock on the database post-CF5. That was the advice way back in the old days, but now it wont work. In fact it'll be counter-productive because it will cause the connection to the dsn to persist even longer and therefore retain the lock longer. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337241 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: The solution: (was: Re: Is there a way to force lock release on Access database? (CF9) )
don't blame you, its a very long and repetitive thread. On Mon, Sep 20, 2010 at 10:21 PM, Mark A. Kruger mkru...@cfwebtools.comwrote: Russ uh... sorry - should have read the whole thread... and I wasn't giving an answer really.. just being nostalgic :) Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Monday, September 20, 2010 4:14 PM To: cf-talk Subject: Re: The solution: (was: Re: Is there a way to force lock release on Access database? (CF9) ) Your about the nth person to give that answer Mark. as I said at the start, that hasn't worked since CF5. On Mon, Sep 20, 2010 at 4:48 PM, Mark A. Kruger mkru...@cfwebtools.comwrote: In the old days intentionally throwing a driver error would do it :) Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Andrew Scott [mailto:andr...@andyscott.id.au] Sent: Sunday, September 19, 2010 11:49 PM To: cf-talk Subject: RE: The solution: (was: Re: Is there a way to force lock release on Access database? (CF9) ) One could always use the Administrator API, and remove that setting from the admin settings. Whether this lock is changed on the request as easily is another story. Just a thought. Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: Mike Kear [mailto:afpwebwo...@gmail.com] Sent: Monday, 20 September 2010 2:41 PM To: cf-talk Subject: The solution: (was: Re: Is there a way to force lock release on Access database? (CF9) ) That would work too, Dave. I think!The second page would contain the delete functionality? Seems to make sense. The problem is to force ColdFusion to let go of the datasource completely before attempting to delete the MDB file. I have found that using CFThread wont work, because ColdFusion still hangs on to the datasource even after the .cfthread accessing it has completed. Later: ... I tried Dave Watts' suggestion of a CFLOCATION to a second page, and it works on my development environment.PROGRESS! Thank you Dave. So the lesson to learn: [A] ColdFusion 9 retains a lock on an Access database for the entire time a page that requires it is active. Once the page finishes processing, the lock is automatically released on the access database. PROVISO: you have to have set up the datasouce in the CFAdministrator as -- Maintain connections across client requests. set to Off (unchecked). I have not been doing any work on this with that option On, so I can only assume it wont work with that option set. [B] causing an error, by running a query on a non-existent table wont release the lock on the database post-CF5. That was the advice way back in the old days, but now it wont work. In fact it'll be counter-productive because it will cause the connection to the dsn to persist even longer and therefore retain the lock longer. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337242 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: The solution: (was: Re: Is there a way to force lock release on Access database? (CF9) )
Have you tried intentionally throwing an error? **runs away** :-P -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 21 September 2010 05:28, Russ Michaels r...@michaels.me.uk wrote: don't blame you, its a very long and repetitive thread. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337246 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: The solution: (was: Re: Is there a way to force lock release on Access database? (CF9) )
throwing a dwarf may also help On Tue, Sep 21, 2010 at 6:23 AM, James Holmes james.hol...@gmail.comwrote: Have you tried intentionally throwing an error? **runs away** :-P -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 21 September 2010 05:28, Russ Michaels r...@michaels.me.uk wrote: don't blame you, its a very long and repetitive thread. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337247 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
The solution: (was: Re: Is there a way to force lock release on Access database? (CF9) )
That would work too, Dave. I think!The second page would contain the delete functionality? Seems to make sense. The problem is to force ColdFusion to let go of the datasource completely before attempting to delete the MDB file. I have found that using CFThread wont work, because ColdFusion still hangs on to the datasource even after the .cfthread accessing it has completed. Later: ... I tried Dave Watts' suggestion of a CFLOCATION to a second page, and it works on my development environment.PROGRESS! Thank you Dave. So the lesson to learn: [A] ColdFusion 9 retains a lock on an Access database for the entire time a page that requires it is active. Once the page finishes processing, the lock is automatically released on the access database. PROVISO: you have to have set up the datasouce in the CFAdministrator as -- Maintain connections across client requests. set to Off (unchecked). I have not been doing any work on this with that option On, so I can only assume it wont work with that option set. [B] causing an error, by running a query on a non-existent table wont release the lock on the database post-CF5. That was the advice way back in the old days, but now it wont work. In fact it'll be counter-productive because it will cause the connection to the dsn to persist even longer and therefore retain the lock longer. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Mon, Sep 20, 2010 at 1:40 PM, Dave Watts dwa...@figleaf.com wrote: Why not have one page that redirects to another using CFLOCATION? Dave Watts, CTO, Fig Leaf Software ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337222 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: The solution: (was: Re: Is there a way to force lock release on Access database? (CF9) )
One could always use the Administrator API, and remove that setting from the admin settings. Whether this lock is changed on the request as easily is another story. Just a thought. Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: Mike Kear [mailto:afpwebwo...@gmail.com] Sent: Monday, 20 September 2010 2:41 PM To: cf-talk Subject: The solution: (was: Re: Is there a way to force lock release on Access database? (CF9) ) That would work too, Dave. I think!The second page would contain the delete functionality? Seems to make sense. The problem is to force ColdFusion to let go of the datasource completely before attempting to delete the MDB file. I have found that using CFThread wont work, because ColdFusion still hangs on to the datasource even after the .cfthread accessing it has completed. Later: ... I tried Dave Watts' suggestion of a CFLOCATION to a second page, and it works on my development environment.PROGRESS! Thank you Dave. So the lesson to learn: [A] ColdFusion 9 retains a lock on an Access database for the entire time a page that requires it is active. Once the page finishes processing, the lock is automatically released on the access database. PROVISO: you have to have set up the datasouce in the CFAdministrator as -- Maintain connections across client requests. set to Off (unchecked). I have not been doing any work on this with that option On, so I can only assume it wont work with that option set. [B] causing an error, by running a query on a non-existent table wont release the lock on the database post-CF5. That was the advice way back in the old days, but now it wont work. In fact it'll be counter-productive because it will cause the connection to the dsn to persist even longer and therefore retain the lock longer. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337223 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
