[ic] Catch database down
Mike Heins
mike at perusion.com
Tue Sep 29 14:23:30 UTC 2009
Quoting Marco (m.mescoli at omnib.it):
> Stefan Hornburg (Racke) ha scritto:
> > Marco wrote:
> >> [try label=dbdown]
> >> [query
> >> type=list
> >> st=db
> >> table=my_ic_table
> >> sql=|SELECT COUNT(*) AS n FROM my_db_table;|]
> >> [list][sql-param n][/list]
> >> [/query]
> >> [/try]
> >>
> >> [catch label=dbdown]
> >> [/table my_ic_table connect failed/]
> >> my_db_table non connected, database down ?
> >> [/table my_ic_table connect failed/]
> >> [/catch]
> >>
> >> On database down i get: 'Internal Server Error' without catching.
> >
> > I tried to reproduce this and found that catching work, but probably some
> > other part of your code crashes due to missing database connection.
> >
> > Check your global error log for the exact error message.
> >
> > Regards
> > Racke
> >
> Thanks Racke, now is catching, as you write there were more db
> connection problems.
You have a query problem. You can't put a semi-colon (;) in those
queries.
--
Mike Heins
Perusion -- Expert Interchange Consulting http://www.perusion.com/
phone +1.765.328.4479 <mike at perusion.com>
Being against torture ought to be sort of a bipartisan thing.
-- Karl Lehenbauer
More information about the interchange-users
mailing list