Cara menggunakan mysql connector jdbc maven

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.

Table of Contents Show

Getting the Latest Release
Download and Install
As a Maven Dependency
Build From Source
GitHub Repository
Contributing
Bagaimana langkah
Apa yang dibutuhkan agar Java dapat terkoneksi dengan database tersebut jelaskan?
Apa itu SQLException?

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:

http://repo1.maven.org/maven2/mysql/mysql-connector-java/5.1.6/
http://download.aquafold.com/download/jdbc-drivers/MySQL/
http://download.csdn.net/source/412363
http://www.spyfu.com/Term.aspx?t=470654
http://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 Test

Lalu 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.