Eclipse Community Forums: Newcomers » Eclipse IDE - Unable to connect to mysql database

Home » Newcomers » Newcomers » Eclipse IDE - Unable to connect to mysql database(MYSQL database connector to Eclipse IDE)

Show: Today's Messages :: Show Polls :: Message Navigator

Eclipse IDE - Unable to connect to mysql database [message #1821618]

Mon, 17 February 2020 13:58

Tania Das

Messages: 2
Registered: February 2020

Junior Member

I followed the instructions of downloading the connector driver (version 8.0.19) of MYSQL database (5.1) and getting connected to eclipse IDE(13 version), but shows the error message is

java.sql.SQLException: No suitable driver found for jdbc:mysql//localhost:3306/employee
at java.sql.DriverManager.getConnection(DriverManager.java:700)
at java.sql.DriverManager.getConnection(DriverManager.java:258)
at jdbcdemo.Driver.main(Driver.java:14)

I tried to map the driver connector file from the reference library to the project file, but still gives the error.

Please could you help me connected to mysql database?
If there is any way of explaining it in a better way, then please let me know.

I have attached the java file that shows the connection steps taken.

package jdbcdemo;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class Driver {

public static void main(String[] args) {

try{
//get connection to database
Class.forName("com.mysql.cj.jdbc.Driver");
Connection myConn=DriverManager.getConnection("jdbc:mysql//localhost:3306/employee","root", "Akshitabogam#24");
//create statement
Statement myStmt =myConn.createStatement();
//execute a sql query
ResultSet myRs = myStmt.executeQuery("select * from employeesample");
//process the result
while (myRs.next()){
System.out.println(myRs.getString("age"));
}
}
catch(Exception exc){
exc.printStackTrace();
}

System.out.println("Connected?");
}

}

Attachment: Driver.java
(Size: 0.80KB, Downloaded 372 times)

Report message to a moderator

Re: Eclipse IDE - Unable to connect to mysql database [message #1821619 is a reply to message #1821618]

Mon, 17 February 2020 14:03

Nitin Dahyabhai

Messages: 4435
Registered: July 2009

Senior Member

While this sounds more like a general Java programming question than one specifically to do with Eclipse, could you clarify what "I tried to map the driver connector file from the reference library to the project file" means within the context of Eclipse, and its UI?

_
Nitin Dahyabhai
Eclipse Web Tools Platform

Report message to a moderator

Re: Eclipse IDE - Unable to connect to mysql database [message #1821622 is a reply to message #1821619]

Mon, 17 February 2020 14:44

Tania Das

Messages: 2
Registered: February 2020

Junior Member

I first downloaded the driver connector jar file and saved it in the folder.
After creating a database project in Eclipse IDE, I used the build path option to get the driver connector file. And the driver file gets downloaded in the reference library folder under the project file name database.

So I am trying to ensure that I have the driver connector file under the source project name database, before I run the program. I watched a few videos of getting their mysql database connected to their eclipse SE IDE and doing the exact same setps but for some reason, I am unable to get the driver connected to the eclipse IDE

Report message to a moderator

Re: Eclipse IDE - Unable to connect to mysql database [message #1830505 is a reply to message #1821622]

Tue, 28 July 2020 01:19

Roger Medlen

Messages: 1
Registered: July 2020

Junior Member

Was this ever resolved?
I'm having the exact same issue. It's as though the inclusion of the .jar file isn't being recognized. Thanks in advance.

Report message to a moderator

Re: Eclipse IDE - Unable to connect to mysql database [message #1830506 is a reply to message #1830505]

Tue, 28 July 2020 02:37

Nitin Dahyabhai

Messages: 4435
Registered: July 2009

Senior Member

Shouldn't the mysql part of that URL be followed by a :, before any /s, i.e. jdbc:mysql:/localhost:3306/employee , rather than was shown? It's not part of the hostname, so it's part of the "protocol."

_
Nitin Dahyabhai
Eclipse Web Tools Platform

Report message to a moderator

Previous Topic:	Programmatically call 3rd party plugin editors
Next Topic:	I need help in the Tutorial i am doing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 15:33:14 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter