GlassFish bundle with MySQL Community Server
By sathyan on Mar 26, 2008
"Sun Java System Application Server 9.1 Update 1 with MySQL Community Server" bundle is available now for download.
GlassFish is the name for the open source development project for building a Java EE 5 application server. Visit https://glassfish.dev.java.net/ for more info.
MySQL is the world's most popular open source database software, with over 100 million copies of its software downloaded or distributed throughout its history. Visit http://www.mysql.com/ for more info.
I was the Engineering Lead for this exciting project that provides a distribution of GlassFish V2 U1 with MySQL Community Server 5.0.
- MySQL Connector/J version 5.1-6 is included in this bundle. This JDBC Driver is installed under <Installation Directory>
/lib to conveniently create a JDBC connection pool pointing to MySQL database through Glassfish's powerful Administration console. The installation program automatically creates an option file to be used by MySQL based on the size of target deployment environment. This option file can be used after installation without the need for modifications in most cases.
To provide a better out-of-the box experience on windows platforms, Program Group items for Starting and Stopping MySQL Server are provided by the installer.
They are installed under "Programs > Sun Microsystems > Sun Java System Application Server 9.1 Update 1 with MySQL Community Server > ....".
Look for items titled "Start MySQL 5.0 Database" and "Stop MySQL 5.0 Database".
A windows service by name "ASMySQL" will also be created if the user chooses to do so during installation. This service is configured with start-up mode set to "manual". The MySQL binaries included in this distribution are self-contained and do not interfere with other MySQL instances running on installing environment. This is accomplished by the installer generating an option file to be used for all of mysql command line programs. On Windows environment, the interfaces to start and stop MySQL(Windows Program Group/Items and Windows Service), are automatically configured to use the generated option file. Where to get it?
- Download the bundle from http://java.sun.com/javaee/downloads/index.jsp. Currently the binaries are not available for Debian and AIX platforms.
How to Install this bundle?
- Refer installation guide from http://docs.sun.com/doc/820-3797 to install this bundle. NOTE: This guide has instruction set covering other bundles of GlassFish V2U1 also, so be sure to follow the instructions specific to installing "Sun Java System Application Server 9.1 Update 1 with MySQL Community Server".
Sample Setup/Usage:Refer http://weblogs.java.net/blog/msreddy/archive/2008/03/java_ee_5_sampl.html for details on how to setup/deploy/run a sample Java EE application with MySQL bundled in this distribution.
Many people to Thank for their support and help at various stages of this project with aggressive schedule.
Anil Gaur, Abhijit Kumar and Eduardo Pelegri-Llopart for their support throughout this project, Carla Carlson for Program Management, Alex Pineda and his group for testing, Steve Carusso and his team for ensuring Compatibility, Carolyn Wong for all her help in hosting the bundle, Terena Chinn-Fuji for Release Engineering, Chinmay Srivatsava for providing documentation, Sreenivas Munnangi for verifying samples integration with this bundle and many others.