Hi Implementations of connection pooling typically use a "test query" to first check whether a connection is still valid before sending the actual query across. A test query looks like SELECT SYSDATE FROM DUAL (eg. PostgreSQL or Oracle) or SELECT 1 (eg. Ingres)
What is a suitable test query for Derby? I couldn't find one off-hand. Thanks Martin
