25 Feb
2008
25 Feb
'08
7:23 p.m.
On Wednesday 20 February 2008, Łukasz Zwierko wrote: ( Just commenting on the connection testing, I agree in the general approachs. )
Still you feel that "select 1" is a better choice, but not all DB support it, you could just make an assumption, that in each DB there shall exist a table with just one column and row, and make a query to it (can call it KeepAliveTable).
You can always 'select 1 from $keepalivetable where 1=2', which generates a zero rows result. For keepalive, is easier, and works with any table. F.O.S.