Connecting to HeidiSql Using the JDBC DriverManager Interface

I am trying to connect to Heidisql Using the JDBC DriverManager Interface. But , am getting error java.lang.ClassNotFoundException


package db.connector;

//STEP 1. Import required packages
import java.sql.*;

public class DbConnection {
// JDBC driver name and database URL
static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
static final String DB_URL = "jdbc:mysql://[192.168.1.254]:3306/gm_db_algo";

// Database credentials
static final String USER = "devUser";
static final String PASS = "devUser159";

public static void main(String[] args) {
Connection conn = null;
Statement stmt = null;
try{
//STEP 2: Register JDBC driver
Class.forName("com.mysql.jdbc.Driver");

//STEP 3: Open a connection
System.out.println("Connecting to database...");
conn = DriverManager.getConnection(DB_URL,USER,PASS);

//STEP 4: Execute a query
System.out.println("Creating statement...");
stmt = conn.createStatement();
String sql;
sql = "SELECT CRED_DEBT_PORTF_ID, CRED_DEBT_PORTF_DEBT_CUST_ID FROM cred_debt_portf ";
ResultSet rs = stmt.executeQuery(sql);

//STEP 5: Extract data from result set
while(rs.next()){
//Retrieve by column name
int id = rs.getInt("id");
int age = rs.getInt("age");
// String first = rs.getString("first");
// String last = rs.getString("last");

//Display values
System.out.print("ID: " + id);
System.out.print(", Age: " + age);
//System.out.print(", First: " + first);
//System.out.println(", Last: " + last);
}
//STEP 6: Clean-up environment
rs.close();
stmt.close();
conn.close();
}catch(SQLException se){
//Handle errors for JDBC
se.printStackTrace();
}catch(Exception e){
//Handle errors for Class.forName
e.printStackTrace();
}finally{
//finally block used to close resources
try{
if(stmt!=null)
stmt.close();
}catch(SQLException se2){
}// nothing we can do
try{
if(conn!=null)
conn.close();
}catch(SQLException se){
se.printStackTrace();
}//end finally try
}//end try
System.out.println("Goodbye!");
}//end main
}//end FirstExample

You are not connecting to HeidiSQL. You can't connect to HeidiSQL at all; at least, not more than you can connect to Microsoft PowerPoint or Mozilla Firefox.

Apparently, you're trying to connect to MySQL Server, which is an entirely difference piece of software.

if the error is from the Class.forName() line, you do not have the mysql jdbc driver.
it is not a part of the standard java install, but has to be downloaded from here,
and installed into your jre/lib/ext directory.