in

WOWWOW

How To Setup JDBC in Windows 10

JDBC setup java
Reading time: 2 min

JDBC stands for Java DataBase Connectivity. JDBC is a standard Java API for database-independent connectivity between the Java programming language and a wide range of databases. By using JDBC, a Java application can access any kind of tabular data, especially data stored in a Relational Database. JDBC works with Java on a variety of platforms, such as Windows, Mac OS, and the various versions of UNIX.

Read: Install Mysql on Windows 10 Step by Step.

By following the steps users can run SQL commands with java. The most common error that arises when using JDBC in cmd is Java.lang.ClassNotFoundException: com.mysql.jdbc.driver or no suitable driver found for jdbc:mysql://localhost/. By following the below steps you can tackle these errors.

Follow the steps below to set up JDBC in the latest JDK.

  1. Download the JDBC connector by going here.
  2. Select Operating System as Platform Independent.
  3. Download the zip file.
  4. Extract the zip file and copy the mysql-connector-java.jar
     unzip JDBC
  5. Go to the installation directory of Java.
    C:\Program Files\Java\jdk-14.0.2\
    Create a folder named ext and paste mysql-connector-java.jar in that folder.
    ext folder java
  6. Open Advanced System Settings. If you don’t know how to open the Advanced System Settings follow this guide. Open Advanced System Setting in Windows 10 (three solutions)!
  7. Click Environment Variables.
  8. In System Variable click New Button.
    Variable Name: classpath
    Variable Value: C:\Program Files\Java\jdk-14.0.2\ext\mysql-connector-java-8.0.21.jar;.

    Make sure to include semicolon and a dot at last ;.

    JDBC Environment Variable Click OK.

  9. Done, now you can compile the JDBC program and run.

Written by Sumit Paul

Self-motivated Blogger. Very much fascinated by tech stuffs especially softwares.

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

Loading…

Loading…

0
Error_Code: LICENSE_PROCESS_RESPONSE_FAILURE on Prime Videos

Solved Error_Code: LICENSE_PROCESS_RESPONSE_FAILURE on Prime Videos

get old google meet ui

Switch back to old version of Google Meet in Android