Skip to main content

a few basic questions....

2 replies [Last post]
aski
Offline
Joined: 2007-06-27
Points: 0

Reply viewing options

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

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 (http://www.albeesonline.com/blog/2008/08/06/creating-and-configuring-a-m...)
- 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 https://glassfish.dev.java.net/issues/show_bug.cgi?id=3983

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...

aski
Offline
Joined: 2007-06-27
Points: 0

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).

aski