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...
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).
Your use of this web site or any of its content or software indicates your agreement to be bound by these Terms of Participation.
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.