Skip to main content
K
karthikeyanj
Participant
July 28, 2009
Question

Check Data Base is Up or Down

  • July 28, 2009
  • 2 replies
  • 664 views

Hi All,

              How can i check whether the Data Base is Up or Down in cold fusion.Bacause in Cold fusion Data base connectional are made in Connection pool as  in Data source in Admin part, But some time my Data base goes  down.In that time the Data source is correct .And the my .cfm file try to  access the DB but DB is not responsing.  So bacause of this my Application goes slow .Please help me how can i check the DB is up or down in Cold fusion coding.

Thanks & My Best regrads
Karthikeyan.J

    This topic is closed to new replies. Start a new post to keep the conversation going.

    2 replies

    T
    TLC-IT
    Inspiring
    July 30, 2009

    You may also need to explicitly specify (short...) timeouts in your database connection strings, if your particular DBMS provides for them.

    A
    Anonymous
    July 28, 2009

    You could wrap a simple <cfquery>select*...</cfquery> in a cftry/cfcatch block - which would catch the DB down error and allow you to handle it gracefully.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices