db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Martin Lichtin <lich...@yahoo.com>
Subject Suitable test query for Derby?
Date Fri, 13 Apr 2012 14:48:43 GMT
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

Mime
View raw message