Skip to main content

a few basic questions....

2 replies [Last post]
Joined: 2007-06-27

Hello Everybody,

I have following questions and need your help:

1.Why Java DB is a part of GlassFish binary distribution? Is it used by GlassFish as data store for internal matters and can be replaced by MySQL? If yes, How? (Providing a link to a document will be enough.)

2.Where can I find a Sun Technical Article for:

Reply viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Joined: 2007-10-21

This is only a partial answers to your questions. I hope others will respond as well.
- Derby is used as an internal data store notably for EJB3 Timers.
- There are 3 data sources that uses Derby: __TimerPool, __CallFlowPool, __default.
- You can connect to these databases using for instance DBVisualizer. You will find the JDBC driver in glassfish\javadb\lib\derby.jar
- You can create MySQL datasource (
- The SQL scripts to create the timer database can be found in glassfish\lib\install\databases
- BLOB is a reserved keyword in MySQL so have a look at

However, if you don't plan to use Glassfish in cluster, you can keep the Derby databases that come out-of-the box.

Note: I'm not personally using MySQL + Glassfish...

Joined: 2007-06-27

Hello and thank you for your helping answers and useful tips.
MySQL is now integrated with GlassFish V3 running on Open Solaris 2009.06 box for use by enduser-applications (following your recommendation regarding GF and Java DB).