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 wrote: > > 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 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) )
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 wrote: > > 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 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) )
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 wrote: > > 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 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) )
throwing a dwarf may also help On Tue, Sep 21, 2010 at 6:23 AM, James Holmes wrote: > > 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 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
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 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) )
don't blame you, its a very long and repetitive thread. On Mon, Sep 20, 2010 at 10:21 PM, Mark A. Kruger wrote: > > 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 > wrote: > > > > > 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) )
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 wrote: > > 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) )
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 wrote: > > 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) )
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) )
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