MySQL provides connectivity for client applications developed in the Java programming language with MySQL Connector/J, a driver that implements the Java Database Connectivity (JDBC) API and also MySQL X DevAPI.
MySQL Connector/J 8.0 is a JDBC Type 4 driver that is compatible with the JDBC 4.2 specification. The Type 4 designation means that the driver is a pure Java implementation of the MySQL protocol and does not rely on the MySQL client libraries.
The driver also contains an implementation of MySQL X DevAPI, an application programming interface for working with MySQL as a Document Store through CRUD-based, NoSQL operations.
For more information, please visit the official MySQL Connector/J documentation.
Licensing
Please refer to the README and LICENSE files, available in this repository, and the Legal Notices in the MySQL Connector/J documentation for further details.
Getting the Latest Release
MySQL Connector/J is free for usage under the terms of the specified licensing and it runs on any operating system that is able to run a Java Virtual Machine.
Download and Install
MySQL Connector/J can be installed from pre-compiled packages that can be downloaded from the MySQL Connector/J download page. Installing MySQL Connector/J only requires obtaining the corresponding JAR file from the downloaded bundle or installer and including it in the application's CLASSPATH.
According to how you use MySQL Connector/J, you may also need to install the following third-party libraries on your system for it to work:
- Protocol Buffers (protobuf-java) is required for using X DevAPI
- Oracle Cloud Infrastructure SDK for Java (oci-java-sdk) is required to support OCI AIM authentication
- Simple Logging Facade API (slf4j-api) is required for using the logging capabilities provided by the default implementation of org.slf4j.Logger.Slf4JLogger by MySQL Connector/J
As a Maven Dependency
Alternatively, MySQL Connector/J can be obtained automatically via Maven's dependency management by adding the following configuration in the application's Project Object Model (POM) file:
<dependency> <groupId>com.mysql</groupId> <artifactId>mysql-connector-j</artifactId> <version>8.0.32</version> </dependency>
MySQL Connector/J's own Project Object Model (POM) file specifies a transitive dependency to Protocol Buffers (protobuf-java) since it is required for using X DevAPI. However, if you do not use the X DevAPI features, you may also want to add a dependency exclusion to avoid linking the unneeded sub-library. For example:
<dependency> <groupId>com.mysql</groupId> <artifactId>mysql-connector-j</artifactId> <version>8.0.32</version> <exclusions> <exclusion> <groupId>com.google.protobuf</groupId> <artifactId>protobuf-java</artifactId> </exclusion> </exclusions> </dependency>
Build From Source
This driver can also be complied and installed from the source available in this repository. Please refer to the MySQL Connector/J documentation for detailed instructions on how to do it.
GitHub Repository
This repository contains the MySQL Connector/J source code as per the latest release. No changes are made in this repository between releases.
Contributing
There are a few ways to contribute to the MySQL Connector/J code. Please refer to the contributing guidelines for additional information.
Akhirnya setelah saya kebingungan membaca manual instalasi MySQL-Connector/J saya menemukan satu buku yang menunjukkan bagaimana instalasi Connector/J dilakukan, buku tersebut berjudul “MySQL and Java Developer’s Guide“. Ternyata setelah saya mencobanya ternyata berhasil dan berakhirlah rasa penasaran saya. Pada tulisan ini saya akan tunjukkan bagaimana instalasi Connector/J (pada tulisan ini saya menggunakan MySQL-Connector/J 5.1) pada Windows platform.
Mendapatkan MySQL-Connector/J
Bila Anda belum mendapatkan MySQL-Connector/J, Anda dapat men-downlolad pada link-link dibawah ini:
- //repo1.maven.org/maven2/mysql/mysql-connector-java/5.1.6/
- //download.aquafold.com/download/jdbc-drivers/MySQL/
- //download.csdn.net/source/412363
- //www.spyfu.com/Term.aspx?t=470654
- //dev.mysql.com/downloads/connector/j/5.1.html
Instalasi Connector/J
Bila Anda sudah mendapatkan MySQL-Connector/J, ekstrak terlebih dahulu. Lalu Anda cari file JAR yang bernama mysql-connector-java-5.1.6-bin, file tersebut yang akan kita copy-kan.
Ternyata tidak terlalu sulit untuk melakukan instalasi Connector/J, kita hanya meng-copy file JAR yang bernama mysql-connector-java-5.1.6-bin. Anda buka terlebih dahulu Windows Explorer, lalu cari direktori Java Anda berada (pada komputer saya direktori tersebut berada pada C:\Program Files\Java\), setelah itu ikuti langkah-langkah berikut:
- Setelah Anda mendapatkan direktori Java, lalu Anda masuk ke direktori Java Runtime Envrionment Anda (pada komputer saya direktori tersebut berada pada C:\Program Files\Java\jre6)
- Lalu Anda masuk ke direktori lib
- Lalu setelah berada di direktori lib, masuk lagi ke direktori ext. Di direktori ini Anda copy kan file JAR tadi yang bernama mysql-connector-java-5.1.6-bin.
Bila sudah nanti library tersebut akan tersedia untuk aplikasi yang akan mengeksekusinya dalam Java Virtual Machine.
Menguji Instalasi MySQL-Connector/J
Lalu Anda buat file java dengan nama Test, lalu tulis kode berikut ini:
// NamaProgram: Test.java // Deskripsi: Menguji koneksi MySQL-Connector/J public class Test { public static void main(String args[]) { try { Class.forName("com.mysql.jdbc.Driver").newInstance(); System.out.println("Berhasil"); } catch(Exception E) { System.out.println("JDBC driver error"); } } // end of method main } // end of class TestLalu Anda compile file java tadi (saya anggap Anda sudah mengerti cara meng-compile-nya) dan jalankan. Bila berhasil maka program tadi yang sudah dibuat akan menampilkan pesan “Berhasil”, itu berati MySQL-Connector Anda sudah terpasang dengan benar.
Penutup
Begitulah instalasi MySQL-Connector dilakukan, bila Anda masih bingung dengan langkah-langkahnya, Anda dapat bertanya pada saya untuk penjelasan lebih lanjut.