MySQL and Java - connectivity past, present, and future thoughts

wizard:java graham$ /usr/local/mysql/bin/mysql -uwellho -p

Enter password: 

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 3

Server version: 5.1.48 MySQL Community Server (GPL)

 

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

This software comes with ABSOLUTELY NO WARRANTY. This is free software,

and you are welcome to modify and redistribute it under the GPL v2 license

 

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

 

mysql>

Java - originated by Sun and release in 1995, is now owned by Oracle too as part of its acquisition of Sun. When I visited the web service page at http://java.sun.com/webservices/ yesterday, I noted the following text at the base of the page:

Oracle is reviewing the Sun product roadmap and will provide guidance to customers in accordance with Oracle's standard product communication policies. Any resulting features and timing of release of such features as determined by Oracle's review of roadmaps, are at the sole discretion of Oracle. All product roadmap information, whether communicated by Sun Microsystems or by Oracle, does not represent a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. It is intended for information purposes only, and may not be incorporated into any contract.

 

© 2010, Oracle Corporation and/or its affiliates

What does this all mean?

On one hand, the brining together of MySQL and Java under a single ownership has enhanced the strength of the line between them. JDBC (the way that Java connects to all flavours of databases) ships as a set of manager classes only, and you need to download / install the actual drivers youself. In much earlier days, those were from a third party site and the class was loaded as follows into a Java application:
  Class.forName("org.gjt.mm.mysql.Driver").newInstance();
but the the support was taken up by the MySQL folks, and now that's a part of Oracle - I downloaded the drivers from dev.mysql.com yesterday, and now load them as follows into my Java appliaction:
  Class.forName("com.mysql.jdbc.Driver").newInstance();

But on the other hand, I have no crystal ball and I cannot tell you where the Java and MySQL products will be taken; all I can do is to reproduce (for your own review) the text above and suggest that you follow through Oracle's communications if you wish, and that you factor in - as you feel appropriate - all of this information in any decision making with regard to future projects.

You may see my updated "Hello MySQL and Java World" example - which selects data from a database and displays it to the screen - [here]. I've added a whole load of annotation to that example, including test runs and an analysis of standard error messages (and possible solutions) such as:
  java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
and
  com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The original example (but I have modernised the class load call) is [here] and for comparison we have a similar example that connects to an Oracle database [here].

[If you're looking to use MySQL from within Java from within a JSP (Java Server Page), there's a source code example of the class that we use on our Deploying Apache httpd and Tomcat training course [here] (we also cover programming Java Server Pages on some of our Java Courses).]
(written 2010-07-09) 245b

Associated topics are indexed under

J811 - Java - JDBC - Relational Database Access
  [3046] Java Beans, tag libraries and JSPs - what and why. - (2010-11-13)
  [2154] Bean Classes in Java and Java Database Connections - (2009-05-02)
  [515] MySQL - an FAQ - (2005-12-03)

S050 - MySQL - General
  [3361] Blowing our own trumpet - MySQL resources - (2011-07-18)
  [2567] Extra MySQL course dates (2 day course, UK) - (2010-01-08)
  [2561] The future of MySQL - (2010-01-03)
  [2559] Moving the product forward - ours, and MySQL, Perl, PHP and Python too - (2010-01-01)
  [2426] Which version of MySQL am I running? - (2009-09-26)
  [2240] How do I query a database (MySQL)? - (2009-06-15)
  [2134] Oracle take over Sun who had taken over MySQL - (2009-04-21)
  [2085] MySQL - licensing issues, even with using the name - (2009-03-16)
  [2053] What a difference a MySQL Index made - (2009-02-25)

J050 - Java - General
  [3573] New in Java 7 - and why we are not running public Java 7 courses - (2012-01-08)
  [2504] Learning to program in ... - (2009-11-15)
  [2420] Exceptions in Java - why and how - (2009-09-24)
  [2417] Java Programming Fundamentals - (2009-09-24)
  [2114] Which Version of Java am I running? - (2009-04-02)
  [2091] C, C++ and C# ... Java and JavaScript - (2009-03-20)
  [2087] Comparing Java Courses - what can we do? - (2009-03-17)

Back to
What methods are available on this Java object?

Previous and next
or
Horse's mouth home

Forward to
Fail Safe Error Handling in Java via Exceptions

Some other Articles

Relationships between Java classes - inheritance, packaging and others
Changing with weather and seasons
Writing a server in Java
Fail Safe Error Handling in Java via Exceptions
MySQL and Java - connectivity past, present, and future thoughts
What methods are available on this Java object?
Using java, javac, jar, and CLASSPATH - a simple example
The healthy option - away from the private car
Park and Ride at Batheaston - will it solve Wiltshires Ills?
Two sides of the coin

4086 posts, page by page

Link to page ... 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82 at 50 posts per page

This is a page archived from The Horse's Mouth at http://www.wellho.net/horse/ - the diary and writings of Graham Ellis. Every attempt was made to provide current information at the time the page was written, but things do move forward in our business - new software releases, price changes, new techniques. Please check back via our main site for current courses, prices, versions, etc - any mention of a price in "The Horse's Mouth" cannot be taken as an offer to supply at that price.

Link to Ezine home page (for reading).
Link to Blogging home page (to add comments).