Connect to the EJB Timers Database

Payara 4

To connect to the default Derby EJB Timer Database via SQL, you can use the small and scriptable ij, which is included within Payara.

Go to /path/to/payara/payara41/javadb/bin/

Run either ij (or ij.bat if you are on Windows) to start the SQL Console and then run the following command to connect to the EJB Timer database:

connect ‘jdbc:derby:/opt/payara/payara41/glassfish/domains/domain1/lib/databases/ejbtimer’;

Finally, to select all the data within the EJB__TIMER__TBL run the final command:

select * from ejb__timer__tbl;

Payara 5 and Payara 6

You can use the Web front end to connect to the H2 database within Payara 5. By default, this will start both a TCP and PostgreSQL server and open a browser window to connect locally.

Navigate to /path/to/payara/payara5/h2db/bin, to find the h2db binaries.

To start just the TCP and PostGreSQL servers, run the following command:

java -jar h2.jar -tcp -pg

To start both servers and open a browser window (-tcp -pg -browser), just run the jar with no arguments

java -jar h2.jar

You will find the default credentials auto-filled, aside from the JDBC URL, but if they are not use the following:

• Driver Class: org.h2.driver
• JDBC URL: jdbc:h2:/path/to/payara/payara5/glassfish/domains/domain1/lib/databases/ejbtimer
• User: sa
• Password: <blank>