[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