Thanks Brett and Knut.
Interesting you guys mention Bitronix TM.
I was dealing with Atomikos when this question of a test query came up.
Unlike Bitronix it doesn't support the JDBC4 isValid().
-------- Original Message --------
Subject: Re: Suitable test query for Derby?
From: Knut Anders Hatlen <[email protected]>
To: Derby Discussion <[email protected]>
Date: 4/13/2012 9:29 PM
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.)
