Martin Lichtin <[email protected]> writes: > 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.
VALUES 1 would be Derby's equivalent of the Ingres query. Or you could use isValid(), as Brett suggested. (If I remember correctly, the client driver actually implements isValid() by executing VALUES 1 on the server.) -- Knut Anders
