how to install mysqlconnecter java correctly?

java mysql netbeans connector
Nickool picture Nickool · Sep 26, 2012 · Viewed 11.8k times · Source

after surfing the web I realized that I should set the class path the path File of the connecter jar file in system environment variables I did so and in commandline by entering this command I have this:

C:\Users\User>echo %classpath%
D:\classpath\mysql-connector-java-5.1.22-bin.jar

but when I wrote a java program to show me the class path:

System.out.println(System.getProperty("java.class.path"));

it shows me this one:

C:\Users\User\Documents\NetBeansProjects\JavaApplication3\build\classes;C:\Users\User\Documents\NetBeansProjects\JavaApplication3\src

I want to connect to a database how should I install my connector?

Answer

a_horse_with_no_name picture a_horse_with_no_name · Sep 26, 2012

The JDBC driver does not need any "installation".

You should not set the system wide CLASSPATH environment variable, that only leads to confusion.

When starting your program, simply provide the location of the file to the Java command:

java -cp myapp.jar;D:\classpath\mysql-connector-java-5.1.22-bin.jar MyMain

To use it inside your NetBeans project, add the jar file in the "Libraries" section of your project.

Related questions

Connect to MariaDB from Java application in NetBeans on Linux (Mageia)

I am trying to connect to a database in Mariadb through a simple java application but the connection is told to be unsuccessful and an Exception is thrown. I have done the similar connection using mysql and it was working …

Read More
Solving a "communications link failure" with JDBC and MySQL

I'm trying to connect to the local MySQL server but I keep getting an error. Here is the code. public class Connect { public static void main(String[] args) { Connection conn = null; try { String userName = "myUsername"; String password = "myPassword"; String url = "…

Read More
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

I'm working on getting my database to talk to my Java programs. Can someone give me a quick and dirty sample program using the JDBC? I'm getting a rather stupendous error: Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.…

Read More