Just as an FYI, locking is an issue with databases, however, most database engines handle it internally so there's usually no significant need to go out of your way to handle it in a server-side scripting language like ColdFusion ... MS Access has been known to have a few issues, which is why it is occasionally handled "externally" with ColdFusion's cflock ( using a lock name ) or cftransaction tags. The cftransaction tag provides a means of accomplishing similar functionality as cflock using database specific odbc tools. Both have their strengths and weaknesses.
Isaac www.turnkey.to 954-776-0046 > No I don't have any session. application. Or server. > variables, just a > few url. variables so locking shouldn't be the issue. I > have never used > locking and I was under the impression that you used > cflock to lock the > database when you were writing to it but I have since > started auuiming > that that is not the case and locking is for session. > application. Or > server. Variables. > Thank you for the suggestion of cihost, I could always > afford to save a > few bucks. I will look into them > Thanks! > Jim Vosika > http://www.tinyclick.com > -----Original Message----- > From: Mike Brunt [mailto:[EMAIL PROTECTED]] > Sent: Sunday, June 30, 2002 4:39 PM > To: CF-Talk > Subject: RE: REPOST: CF Server Error > Jim, a couple of things, first a question do you have any > Application. - > Server. - Session. variables in your app, if so I would > still check the > locking issue prior to your moving to dedicated. Second a > suggestion, > when > cost is an issue we use the dedicated hosting packages at > www.cihost.com, > they are good on Win2k systems and keep up with patches > etc. It is most > cost-effective there to have your own copy of ColdFusion. > Their customer > service can be a bit patchy at times but we have > structured our internal > systems to deal with that and they are very > cost-competitive. > Again hth. > Kind Regards - Mike Brunt, CTO > Webapper > http://www.webapper.com > Downey CA Office > 562.243.6255 > AIM - webappermb > "Webapper - Making the NET work" > -----Original Message----- > From: Jim Vosika [mailto:[EMAIL PROTECTED]] > Sent: Sunday, June 30, 2002 2:23 PM > To: CF-Talk > Subject: RE: REPOST: CF Server Error > Thank you everyone for you help, I would have responded > earlier but I > was taking a nap. :) After reading all of the responses I > don't think it > is my code that is the issue on the server because on that > account it is > mostly cfif's cfquery's and cfoutput's so not that I > couldn't have made > a mistake but it is probably other accounts on my shard > server that are > causing the services to restart or what ever is happening. > I will > probably have to look into a dedicated server this week, > which probably > isn't economical but it will cost less in Advil... Thank > you all for you > suggestions and insights, I really appreciate it alot. > Take Care, > Jim Vosika > http://www.softwaresupermall.com > http://www.webbomber.com > -----Original Message----- > From: Mike Brunt [mailto:[EMAIL PROTECTED]] > Sent: Sunday, June 30, 2002 1:51 PM > To: CF-Talk > Subject: RE: REPOST: CF Server Error > Just adding to the thrust, I would say this is pretty > certainly a > locking > issue or a lack of. This error always accompanies memory > corruption > issues > as a result of unlocked shared scope variables. You can > only control > your > own code and in a shared environment other's code could be > an issue. > Here > is what I suggest. If you have Application. - Server. - > Session. > variables > in your application you should lock all reads and writes > using the > <cflock > tag. > Hth > Kind Regards - Mike Brunt, CTO > Webapper > http://www.webapper.com > Downey CA Office > 562.243.6255 > AIM - webappermb > "Webapper - Making the NET work" > -----Original Message----- > From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] > Sent: Sunday, June 30, 2002 11:30 AM > To: CF-Talk > Subject: Re: REPOST: CF Server Error > Hi Jim, > I've typically seen this error in my applications when > I've done > something > horribly wrong and ime it's usually accompanied by the > cfserver service > restarting. It's possible that it could be related to > locking, although > locking is typically not related to datasource issues ( > although I've > heard > of it being used as a workaround for certain problems with > MS Access ) > and > even when it is a database problem, you'll usually just > get odbc errors > rather than big-time cf server problems... > It might be related to unlocked data manipulation in the > application or > more > often session scopes... and unfortunately being on a > shared server, it'd > be > difficult to say whether going through all of your own > code and making > sure > all of your own stuff is locked would even solve the > problem. Personally > I > think it'd be nice to see the hosting companies turning > full-checking on > on > their shared servers, but for various reasons ( loss of > performance, > time on > the phone with customers explaining locking, etc... ) it > just doesn't > happen > that way. > In any event, if you're using session, application or > server ( I'd stay > away > from these on a shared server ) variables I would probably > _start_ by > making > sure they're all locked and then if it continues I'd > consider finding > another host if it's bothersome enough. > Wish I could provide more solid answers for you, > Isaac > www.turnkey.to > 954-776-0046 > __________________________________________________________ > ____________ > This list and all House of Fusion resources hosted by > CFHosting.com. The place for dependable ColdFusion > Hosting. > 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 ______________________________________________________________________ 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
