CF / .NET DLL - CF locking DLL's?
I'm trying to use some .NET DLL's through ColdFusion. It seems that CF is locking my DLL on the first run, which means that every time I do a change in the DLL's code, I have to create a version with a different name (since I can't overwrite the old one). Anyone know how to combat this? ~| 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:337224 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF / .NET DLL - CF locking DLL's?
You need to stop ColdFusion and restart it. Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: Michael Christensen [mailto:mich...@strib.dk] Sent: Monday, 20 September 2010 4:56 PM To: cf-talk Subject: CF / .NET DLL - CF locking DLL's? I'm trying to use some .NET DLL's through ColdFusion. It seems that CF is locking my DLL on the first run, which means that every time I do a change in the DLL's code, I have to create a version with a different name (since I can't overwrite the old one). Anyone know how to combat this? ~| 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:337225 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
.NET DLL driving me nuts....
Could anyone provide a working example of; 1) a working C# DLL file (the source obviously) that returns a string (just make it really, really simple) 2) a cfml that uses said DLL file and outputs the returned string I'm about at the end of my wits on this one... ~| 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:337226 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: .NET DLL driving me nuts....
Are you using a 32 bit or 64bit ColdFusion version, and how are you compiling this in the VS IDE? Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: Michael Christensen [mailto:mich...@strib.dk] Sent: Monday, 20 September 2010 5:48 PM To: cf-talk Subject: .NET DLL driving me nuts Could anyone provide a working example of; 1) a working C# DLL file (the source obviously) that returns a string (just make it really, really simple) 2) a cfml that uses said DLL file and outputs the returned string I'm about at the end of my wits on this one... ~| 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:337227 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: .NET DLL driving me nuts....
The thing is, that I can initiate the object, but as soon as I call any methods on it, everything goes awry. Are you using a 32 bit or 64bit ColdFusion version, and how are you compiling this in the VS IDE? Regards, Andrew Scott http://www.andyscott.id.au/ Could anyone provide a working example of; 1) a working C# DLL file (the source obviously) that returns a string (just make it really, really simple) 2) a cfml that uses said DLL file and outputs the returned string I'm about at the end of my wits on this one... ~| 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:337228 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfform issue within cflayout - cflayoutarea
Well, this is interesting. I set up a very simple set of pages. Test.cfm cflayout type=tab cflayoutarea name=test title=Test cfform action=testResponse.cfm method=post cfinput type=text name=test size=10 input type=submit / /cfform /cflayoutarea /cflayout testResponse.cfm cfparam name=FORM.test default= cfoutput#FORM.test#/cfoutput cflocation url=testTarget.cfm?show=#FORM.test# testTarget.cfm cfparam name=URL.show default= cfoutput#URL.show#/cfoutput pI came here/p When I enter some value in the input the program does indeed return to test.cfm and my tab but prints everything from testTarget.cfm The issue seems to be in how the form tag is processed by CF. I set up another file, test2, using form tags instead of cfform When you use cfform it's translated to: form name=CFForm_1 id=CFForm_1 action=testResponse.cfm method=post onsubmit=return ColdFusion.Ajax.checkForm(this, _CF_checkCFForm_1,'test') Using form there is no translation/processing. It looks like the culprit is the onsubmit statement. It works differently than ColdFusion.Ajax.submitForm(). The callback function for ColdFusion.Ajax.submitForm() returns everything on the target page including tags, header info, etc. where this is showing only what I actually output - but back into the cflayout area. And this is where it **really** gets weird: Run the code (test.cfm not test2.cfm) and what I see on the screen is my test tab and what I output in testTarget.cfm - I see no input box or submit button. BUT, if you view the code it's identical to the code before you do the submit. So where are the form elements? Some Ajax guru needs to help with this and tell us how you handle this. (I suppose one possibiity is to never actually use a submit button but handle it all with ColdFusion.Ajax.submitForm(). ) Larry Stephens -Original Message- From: Joe None [mailto:drue...@comcast.net] Sent: Friday, September 17, 2010 2:20 PM To: cf-talk Subject: Re: cfform issue within cflayout - cflayoutarea Yes I do. Just curious - do you end your processing page with cflocation ? Larry Stephens ~| 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:337229 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: .NET DLL driving me nuts....
Can you elaborate on goes awry ie What is the actual error message? Example: cfset obj = createObject(.net, MyLibrary.TestClass, ExpandPath('./MyLibrary.dll')) / cfset result = obj.getValue(Foo) / cfoutput#result#/cfoutput TestClass.cs = using System; using System.Collections.Generic; using System.Text; namespace MyLibrary { public class TestClass { public string getValue(string Value) { return You entered: + Value; } } } ~| 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:337230 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Creating a custom workflow process
I need to give the admin users of a website I'm developing the ability to create a custom workflow. They would need to be able to name the first step in the process and then specify if this is true/yes, go here and if no, go here. Then, when someone is working on something in the workflow, they want to be able to graphically display a you are here sort of diagram. Has anyone done something similar? I can sort of picture the database structure, but I can't wrap my head around the image short of creating a separate image for each step in the process. Which defeats the purpose of having this all be customizable/dynamic. Thanks, Scott ~| 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:337231 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Using a CSV as a datasource (CF8)
I have a badge reader that hangs on the network. It collects magnetic stripe scans to a CSV file located on the server. I need to get this into a SQL Server db ideally. I created the ODBC text data source on the server. When I attempt to add the data source in the ColdFusion administrator, it tells me: Connection verification failed for data source: BadgeScanner java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Text Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Text Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. I suspect my connection string for the data source in the administrator needs to be populated. Right now it is blank. Can anyone tell me what the connection string should look like... or any ideas on how to get these scans (occurring all day every day) into my database? ~| 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:337232 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Creating a custom workflow process
So, the workflow would be represented graphically on a single page? A workflow diagram that people could refer to in order to get their bearings in the workflow? -Original Message- From: Scott Spurlock [mailto:spurlock.sc...@yahoo.com] Sent: Monday, September 20, 2010 10:18 AM To: cf-talk Subject: Creating a custom workflow process I need to give the admin users of a website I'm developing the ability to create a custom workflow. They would need to be able to name the first step in the process and then specify if this is true/yes, go here and if no, go here. Then, when someone is working on something in the workflow, they want to be able to graphically display a you are here sort of diagram. Has anyone done something similar? I can sort of picture the database structure, but I can't wrap my head around the image short of creating a separate image for each step in the process. Which defeats the purpose of having this all be customizable/dynamic. Thanks, Scott ~| 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:337233 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Creating a custom workflow process
Yes. Let's say this is a proposal bidding process. One company might need the ability to enter three steps in their proposal process. Another company might have 20 steps. I want them to have as many or as few steps as they need. An example process could be: Does the proposal fit our strategic decision? Yes - Do we have a strong client relationship? Yes - Do we have a competitive edge? No - Can we improve it? No - Should we proceed? Yes - Do we have a strong client relationship? No - end of process And so on. I'm trying to build a dynamic decision tree. I'm also then wanting to show people where they are in this tree. Is there a way to graphi ~| 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:337234 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Vmware and CF 8+
Dave, Oh my!! You need to say that again several times till folks get it. I vis at least one server a week set to automatically install patches ... which about 1/3 of the time results in a reboot and about 1/2 the time installs extra software or upgrades that are not needed. Unless you are using your server as a desktop do you really need the latest version of windows media player? Or the upgraded browser helper active X? If it's not a print spooler does it need spooler flaw patches (and why is the spooler service enabled in the first place)? In my view it should always be set to download and let me choose and then you should schedule a time to check them out and install the appropriate ones and even then sometimes they trip you up (security based ones in particular have a way of resulting in unintended consequences). Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Sunday, September 19, 2010 10:37 PM To: cf-talk Subject: Re: Vmware and CF 8+ This is true if you blindly install every patch released by MS, but that is a poor patch management strategy to say the least. Dave Watts, CTO, Fig Leaf Software Sent from my Droid On Sep 19, 2010 4:59 PM, Chris Kelly juggler...@gmail.com wrote: true...I knew that, I think I meant more that nearly every month MS has at least one patch that requiresa reboot, rarely do I go through a patch tuesday without some critical fix... I saw a timeline somewhere where there are far more patches that require rebooting on the MS side - which is only to be expected as it's a full blown OS running there...as opposed to a stripped down kernel, just running what needs to be run for the one function. biggest problem with hyper-v is that service packs and critical fixes that require a reboot of the underlying OS means you have to reboot however many VM's are running on your box too). I use ESXi myself, and to be fair to Microsoft, when a critical patch for ESXi is release it requires the same process (shut down the VMs and reboot the hypervisor). Since I deployed ESXi there has been one patch I needed to install and that was four months ago. Most of the patches that come out are related to the CLI which ESXi doesn't ship with, so they're not relevant. -Justin ~| 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:337235 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
WebService question
Hello, I have a cfc which is used as a SOAP web service. This all works very well. But my question has to do with the arguments. I would like to have a argument called theXMLData for example ... cffunction name=CheckIn access=remote returntype=boolean output=no cfargument name=theXMLData But I get an error when I try to send straight XML through a web service. I know I can use Base64 encoding, but it adds 30 - 40% overhead to the message. Is there any way to send the XML data as XML instead of encapsulating it? The client software which is sending the data is a Objective-C app, which I wrote as well. So any suggestions are welcome. Thanks, tom ~| 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:337237 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Sessions persist after server restart.
So, I was working locally on an application today and I needed to restart my CF services. Much to my surprise, after I bounced CF I came back to my application and I was not forced back to the login screen as I would have expected. Rather, all of my session info was still there. I then shut down CF, clicked around in my application to make sure everything was down, then brought CF back up and my session info was still alive in my application. So, I did a little research and came across this (http://livedocs.adobe.com/coldfusion/8/htmldocs/sharedVars_02.html) where it states: /If you use J2EE session management and configure the J2EE server to retain session data between server restarts, ColdFusion retains session variables between server restarts./ Ok, I'm using J2EE sessions, so now I know what's going on. Now, my question is, how do I turn it off? Adobe hints that you can configure the J2EE server to retain session data, but gives no clue as to where or how. All I've found is the checkbox to enable/disable J2EE sessions. Also, is this something that is turned ON or OFF by default? I'm just wondering if I accidentally turned it on, or if it's always been on and I never noticed it. -- Thanks, Eric Cobb ECAR Technologies, LLC http://www.ecartech.com http://www.cfgears.com ~| 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:337238 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
question about this error - The request has exceeded the allowable time limit Tag: cfmail
We are getting this error to happend and I am trying to figure out how to do the following. what we are doing is running muliple external processed - ie ending job posting information out to sites. we are doing this in a trycatch and if the process errors out or we recieve an notice of a failure we send an email to an support group who looks at what is going on and jumps on it. The cfmail is in the cfcatch and that is what is erroring out and then the user is seeing the custom error message. we would like to make sure that they never see the error message just move along - not sure how we can do that. the second question I have is if on of the web services we are going to take 40 seconds to process - we have seen this - is the time out to the mail server part of the entire time out on the page request? or is this done inidividual and on request to the mail server is taking over 60 seconds. We are trying to figure how how to solve this. Any thougths would be great. Matt Friedman Life is too short to drink cheep beer ~| 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:337240 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: question about this error - The request has exceeded the allowable time limit Tag: cfmail
It sounds like the code you have that errors is inside your cfcatch tag. Can you post what the actual error is? On Mon, Sep 20, 2010 at 4:40 PM, Matthew Friedman m...@hozgroup.com wrote: We are getting this error to happend and I am trying to figure out how to do the following. what we are doing is running muliple external processed - ie ending job posting information out to sites. we are doing this in a trycatch and if the process errors out or we recieve an notice of a failure we send an email to an support group who looks at what is going on and jumps on it. The cfmail is in the cfcatch and that is what is erroring out and then the user is seeing the custom error message. we would like to make sure that they never see the error message just move along - not sure how we can do that. the second question I have is if on of the web services we are going to take 40 seconds to process - we have seen this - is the time out to the mail server part of the entire time out on the page request? or is this done inidividual and on request to the mail server is taking over 60 seconds. We are trying to figure how how to solve this. Any thougths would be great. Matt Friedman Life is too short to drink cheep beer ~| 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:337243 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: question about this error - The request has exceeded the allowable time limit Tag: cfmail
Unless you have a CFABORT in your CFCATCH i'm sure the default behaviour is for CF to continue executing any code after the CFTRY block. On Mon, Sep 20, 2010 at 9:40 PM, Matthew Friedman m...@hozgroup.com wrote: We are getting this error to happend and I am trying to figure out how to do the following. what we are doing is running muliple external processed - ie ending job posting information out to sites. we are doing this in a trycatch and if the process errors out or we recieve an notice of a failure we send an email to an support group who looks at what is going on and jumps on it. The cfmail is in the cfcatch and that is what is erroring out and then the user is seeing the custom error message. we would like to make sure that they never see the error message just move along - not sure how we can do that. the second question I have is if on of the web services we are going to take 40 seconds to process - we have seen this - is the time out to the mail server part of the entire time out on the page request? or is this done inidividual and on request to the mail server is taking over 60 seconds. We are trying to figure how how to solve this. Any thougths would be great. Matt Friedman Life is too short to drink cheep beer ~| 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:337244 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: question about this error - The request has exceeded the allowable time limit Tag: cfmail
btw a backup is to also have a CFERROR or default error template so u can catch cfcatch errors On Tue, Sep 21, 2010 at 12:21 AM, Russ Michaels r...@michaels.me.uk wrote: Unless you have a CFABORT in your CFCATCH i'm sure the default behaviour is for CF to continue executing any code after the CFTRY block. On Mon, Sep 20, 2010 at 9:40 PM, Matthew Friedman m...@hozgroup.comwrote: We are getting this error to happend and I am trying to figure out how to do the following. what we are doing is running muliple external processed - ie ending job posting information out to sites. we are doing this in a trycatch and if the process errors out or we recieve an notice of a failure we send an email to an support group who looks at what is going on and jumps on it. The cfmail is in the cfcatch and that is what is erroring out and then the user is seeing the custom error message. we would like to make sure that they never see the error message just move along - not sure how we can do that. the second question I have is if on of the web services we are going to take 40 seconds to process - we have seen this - is the time out to the mail server part of the entire time out on the page request? or is this done inidividual and on request to the mail server is taking over 60 seconds. We are trying to figure how how to solve this. Any thougths would be great. Matt Friedman Life is too short to drink cheep beer ~| 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:337245 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