Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Connecting to HeidiSql Using the JDBC DriverManager Interface

swati's profile image swati posted 5 years ago in Creating a connection Permalink
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
kalvaro's profile image kalvaro posted 5 years ago Permalink
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.
jfalch's profile image jfalch posted 5 years ago Permalink
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.

Please login to leave a reply, or register at first.