Check Data Base is Up or Down

[karthikeyanj]

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

[Guest]

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.

[TLC-IT]

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