A penny er two...
You may have already come up with this solution, but I'd recommend doing a
basic database call before anything else in the site, maybe even stick it in
application.cfm (ooh, that's a no-no in FB! Don't tell on me, please!). If
the cftry around the db call catches anything, then send a few emails to
your boss (the stingy who think that this is a viable solution) notifying
him that the site is not working.
Sounds like you're doing the right thing already.
BTW - many people DO use client vars from a DB. They're fast and simple and
cool and scalable and neato and ...
NAT
-----Original Message-----
From: Scott Knaub [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 28, 2000 12:32 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Has anyone CFTRY'd this?
Thanks for the reply...I was starting to feel like the kid who is picked
last for the kickball team. :-)
You are absolutely right! I have already told the management that the money
and time should be spent on database server, but this is a high profile site
so "for now" they want me to figure out a work around.
Scott
-----Original Message-----
From: McCollough, Alan [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 28, 2000 1:54 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Has anyone CFTRY'd this?
Well, I haven't tried it, but then I haven't had problems with my db-stored
client vars (in MS SQL 7), so [btw, I'm not trying to be a smart aleck
here], I dont' have any insights to offer.
There aren't a lotta folks doing db-stored client vars, and amongst those
who do, I can't recall hearing about any problems related to intermittent db
connectivity. Clearly, in a clustered environment, your db connectivity has
gotta be rock solid. What you have here is a problem, and I personally
believe you are treating the symptom by looking at CFAPPLICATION.
I'd pour all of my focus on the db conn; is it some sort of native driver
from Sybase to CF? Can you try ODBC? OLEDB? Is the db server maxed out? Can
you set up a private set of NICs between the CF boxes and the SQL box? I'd
say yeah, that's where I'd devote my energy...
Alan McCollough
Web Programmer
Allaire Certified ColdFusion Developer
Alaska Native Medical Center
> -----Original Message-----
> From: Scott Knaub [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, August 28, 2000 10:49 AM
> To: '[EMAIL PROTECTED]'
> Subject: RE: Has anyone CFTRY'd this?
>
> Is the silence on this question because I am pushing the CF envelope
> beyond
> known boundaries?
>
> Or is everyone laughing so hard at such a silly question that they can't
> type?
>
> Just wondering... :-)
>
> I did find a way to accomplish this goal, but was seeking opinions from
> more
> experienced developers.
>
>
>
> -----Original Message-----
> From: Scott Knaub [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 28, 2000 10:33 AM
> To: '[EMAIL PROTECTED]'
> Subject: Has anyone CFTRY'd this?
>
>
> I have a Fusebox site on two load-balanced Web servers that are using
> Client
> variables stored in a central database to manage session information. The
> database server is Sybase Adaptive Server Anywhere 6.0 and at this time
> there is no redundancy on this database server. (I know...this is bad...we
> are working on it.)
>
> Currently when the database server goes down, the CFAPPLICATION tag with
> the
> setting clientmanagement="yes" fails and that stops the entire site.
>
> My idea is to CFTRY the CFAPPLICATION tag in app_globals.cfm and CFCATCH
> any
> ODBC error. If an ODBC error is caught, I'd like to re-issue the
> CFAPPLICATION tag with the setting clientmanagement="yes" changed to
> clientmanagement="no". I'd also like to set an application variable called
> ODBC_Available to False so I can let the user know that the database
> functions are not available on the pages where the database is required.
>
> This way, if the database server goes down, the Web site allows the user
> to
> view pages that do not require the database.
>
> Has anyone else built a work around for the CFAPPLICATION tag when dealing
> with a temperamental database? For next year we are budgeting a redundant
> database server configuration, so that should help in the long run.
>
> Thanks,
> Scott
> --------------------------------------------------------------------------
> --
> --
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --------------------------------------------------------------------------
> ----
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
----------------------------------------------------------------------------
--
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
