MySQL

 
 
MySQL is a fast, multi-threaded, multi-user open source SQL database server.

The MySQL database is released under the GNU General Public License (GPL). MySQL can be used for free when you are not distributing any part of the MySQL system. For example: If you run a commercial web site using the MySQL Database Software as long as MySQL is not distributed.

Please read the MySQL manual for situations where a commercial license is needed.

More information about MySQL can be found at: https://www.mysql.com

MySQL online manual can be found at: https://dev.mysql.com/doc/index.html

The latest MySQL version can be downloaded from: https://dev.mysql.com/downloads/index.html







Installing MySQL Connector/J 3.0.11.



Information
The official JDBC driver for MySQL is called Connector/J. This JDBC driver is a native Java driver that converts JDBC (Java Database Connectivity) calls into the network protocol used by the MySQL database. It lets developers working with the Java programming language easily build programs and applets that interact with MySQL and connect all corporate data, even in a heterogeneous environment. MySQL Connector/J is a Type IV JDBC driver and has a complete JDBC feature set that supports the capabilities of MySQL.

Operating system used
Windows XP Home Edition Version 5.1 SP 2

Software prerequisites
MySQL 3.23 or higher

Procedure
  1. Download and unzip mysql-connector-java-3.0.11-stable.zip from:
    http://www.mysql.com/products/connector-j/index.html

  2. The JDBC driver can be found at:
    ..\mysql-connector-java-3.0.11-stable\mysql-connector-java-3.0.11-stable-bin.jar

  3. Information about its usage can be found in:
    ..\mysql-connector-java-3.0.11-stable\README

    Here below a quick overview how to use the driver:

    Where to use What to do
    JBoss 3.x Set the "JBOSS_CLASSPATH" system environment variable. This should be set to
    mysql-connector-java-3.0.11-stable-bin.jar
    e.g.: JBOSS_CLASSPATH=C:\Tools\
    mysql-connector-java-3.0.11-stable\
    mysql-connector-java-3.0.11-stable-bin.jar

    If you do NOT want to set the system environment variable, there is another option:
    Copy the driver ..\mysql-connector-java-3.0.11-stable\
    mysql-connector-java-3.0.11-stable-bin.jar to the lib directory in the default server configuration
    (..\jboss-3.2.3\server\default\lib) assuming you are using the default server.

  4. A more detailed tutorial how to use a MySQL Connector/J 3.0.x driver can be found in quick guide How to use JDBC