MySQL and Java

For many years, Java has been the most popular application development language for MySQL's ISV / OEM customers and more recently for our Enterprise customers as well. In early 2009 we conducted our Annual MySQL User Survey and found that, among those surveyed, 57% of both ISVs /OEMs, and MySQL Enterprise users develop their MySQL applications in Java.

Why MySQL With Java Applications?

Some of the reasons for MySQL's popularity among Java application developers are its:

• Performance, Ease of use, Smaller footprint, Lower TCO, Full feature set with no functional limitations, Out-of-the-box support for scale-out implementations

In addition, MySQL is open source, freely available, and now ubiquitous. Because of its popularity, MySQL has been well integrated with the eco-systems supporting Java. It is often the default database for Java frameworks and tools, and there is a wide array of resources from formal tutorials to forums, all of which serve to make it even easier to develop and optimize Java and MySQL applications. Following is a compilation of those resources.

MySQL and Java Resources

Java + MySQL Application Development

General

JDBC - MySQL Connector/J

• "JDBC Driver for MySQL: MySQL Connector/J" -- MySQL Reference Manual (html)
• "MySQL's JDBC Driver, And Making It DWhat You Want" -- Java One session (web-cast, .pdf, mp3)
• "Bending MySQL Connector/J to Your Liking" -- MySQL User Conference presentation (.pdf)

How-Tos

• "Deep Dive: MySQL Tips for Java Developers -- expert interview (web-cast)
• "Automatic Multi-platform MySQL Deployment with your Java Application Using MySQL Connector/MXJ" -- MySQL webinar (web-cast, .pdf)
• "MySQL and Java Developer's Guide" -- book (paperback)

Dev Zone Resources and Forums

• Forum: MySQL JDBC and Java Forum -- MySQL.com forum
• Forum: Java forum & mailing list archive -- Nabble.com forum
• Resources: Using MySQL with Java -- MySQL DevZone page

MySQL Workbench Design Tool

• "MySQL Workbench: The Ultimate Database Design Tool for Developers" -- MySQL Conference session (file)

For High Performance, Scalability, and Availability

• MySQL SPECjAppServer Benchmark results -- Web page, articles, blog (html)
• "Scale-out Options with MySQL and Java" -- MySQL User Conference session (.pdf)
• "Scaling MySQL and Java in High Write Throughput Environments" -- MySQL User Conference session (.pdf)
• "JPA Performance, Don't Ignore the Database" -- technical article (html)
• "Optimizing MySQL for High Volume Data Logging Applications" -- MySQL User Conference Session (file)
• "Creating a Carrier Grade Service Execution Environment with MySQL Cluster and the Sun GlassFish Communications Server (SailFin)" -- white paper (.pdf)
"Using MySQL and Memcached on the GlassFish Application Server" -- technical article (html)

With Glassfish Application Server (Java EE)

• "GlassFish and MySQL, Part 1: A Perfect Combination for Web Applications" -- technical article (html)
• "GlassFish and MySQL, Part 2: Building a CRUD Web Application With Data Persistence" -- technical article (html)
• "GlassFish and MySQL, Part 3: Creating and Using a Web Service" -- technical article (html)
• "GlassFish and MySQL, Part 4: Creating a RESTful Web Service and JavaFX Client" -- technical article (html)
• "Java EE 6 Pet Catalog with GlassFish v3 preview and MySQL" -- technical article (html)
• "JSF 2.0, JPA, GlassFish and MySQL" -- technical article (html)
• "Combining Groovy, Grails, MySQL, and the Java Persistence API" -- technical article (html)
• "Leveraging Identity with GlassFish and MySQL" -- white paper (.pdf)

With Netbeans IDE

• "Developing MySQL-Backed Applications with Netbeans and Java RESTful Web Services" -- MySQL webinar, (web-cast, .pdf)
• "How to Develop MySQL-Backed Java Applications with Netbeans, JRuby-on-Rails & Glassfish" -- MySQL webinar (web-cast, .pdf)
• "Netbeans 6.0: Connecting ta MySQL Database" -- technical article (html)
• "Netbeans 6.5, 6.7: Exposing a MySQL Database with RESTful Web Services" -- technical article (html)
• "Writing Your First Ruby-on-Rails Web Application, (Netbeans, MySQL, Glassfish)" -- technical article (html)

Miscellaneous

• Database Migration: "Hibernate: A MySQL Enabler? Using Hibernate tMigrate from PostgreSQL to MySQL" -- TheServerSide article + thread (html)
• GIS: "Spatial SQL: Who Needs a Traditional GIS? -- MySQL User Conference -- (file)

Examples of MySQL + Java Customers

• SonicWALL
• FairWarning
• Clickability
• Evite
• Los Alamos National Labs
• MIT Lincoln Lab