From: <glassfish_at_javadesktop.org>
Date: Thu, 22 May 2008 14:53:02 PDT

Found the answer after a search of the entire source code. In jdbcra/src/com/sun/gjc/spi/ManagedConnectionFactory.java the SQL called is:

SELECT COUNT(*) FROM " + tableName

So, with Oracle, dual will work just fine because "select count(*) from dual" returns 1.

-Dave
[Message sent by forum member 'davideagen' (davideagen)]

http://forums.java.net/jive/thread.jspa?messageID=276147