users@glassfish.java.net

Re: Problem with EJB Timer Service

From: <glassfish_at_javadesktop.org>
Date: Mon, 18 Jun 2007 01:37:22 PDT

1) Does the directory "/usr/local/glassfish/domains/domain1/lib/databases/ejbtimer" exist ?
2) You can connect to this database using "ij" tool and check whether database is fine.
a) cd $GLASSFISH_HOME/javadb/frameworks/NetworkServer/bin
b) set DERBY_HOME to $GLASSFISH_HOME/javadb or export DERBY_HOME=$GLASSFISH_HOME/javadb
c) ij.ksh - will start 'ij' command line
d)ij > connect 'jdbc:derby:/usr/local/glassfish/domains/domain1/lib/databases/ejbtimer';
e) ij > show tables;
(must list a no. of tables along with "APP |EJB__TIMER__TBL |"
f) ij > select * from EJB__TIMER__TBL;
(select must show the contents (if any) in the table )

(2) might also throw the same exception (along with the underlying exceptions) for you, if there is any problem with the database contents.
[Message sent by forum member 'jr158900' (jr158900)]

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