users@glassfish.java.net

Re: Oracle JDBC connection?

From: <glassfish_at_javadesktop.org>
Date: Thu, 26 Aug 2010 14:00:05 PDT

Here's my best guess:

I think the most commonly used sql "ping" used for Oracle is "select sysdate from dual;" (ask for the current date). This can possibly run into troubles compatible with the error message if the database server has incorrect / non-existing timezone specification: Without a timezone it is not possible to tell which date it is. Check the timezone setup for the database. You can probably find some docs for that over at Oracle.com.
[Message sent by forum member 'eirikma']

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