Using an External Database With the Timer Service

By default, the timer service uses an embedded database to store timers. You can set up the timer service to another database.

Sample timer database creation files are provided for Java DB (Derby), PointBase, Oracle, Sybase, DB2, and MS SQL Server at install-dir/lib/install/databases/.

To use an external database with the Timer Service, first, set up a JDBC resource for the selected database as described in Creating a JDBC Resource. Then go to Configuration > EJB Container > EJB Timer Service and enter the JNDI name of the resource in the Timer DataSource field. Restart the Application Server.

See the following for related information:

• Creating a JDBC Resource

• Chapter 5, JNDI Resources

• The EJB Container