Can't connect to a mysql DB with DriverManager

Question

Ok I am trying to connect to a mysql db with the following code. I tried looking at documentation but I am just having no luck what so ever.

Here is the code:

public class TESTSQL {

static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
static final String DB_URL = "jdbc:mysql://SLibraryDev.db.996****.hostedresource.com";
static final String USER = "SLD";
static final String PASS = "F11!";

public static void main(String[] args) {

    Connection conn = null;
    Statement stmt = null;

    try {
        // STEP 2: Register JDBC driver
        Class.forName(JDBC_DRIVER);

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

This is the error I am getting :

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)

When I comment out "Class.forName(JDBC_DRIVER)" and run it I get this error:

java.sql.SQLException: No suitable driver found for jdbc:mysql://SLibraryDev.db.996****.hostedresource.com
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)

What I thought I needed to do was to download and run this : http://dev.mysql.com/downloads/connector/j/ which I did but it seemed like something was wrong with this installer...It seemed like it never finished, like it cut out in the middle of the process. Anyone have any ideas on what I need to do.

You've got to add the ConnectorJ jar library to your project classpath. — FThompson
– FThompson, Commented Feb 6, 2013 at 5:40

Fathah Rehman P · Accepted Answer · 2013-02-06 05:57:09Z

1

Download mysql-connector from following url http://nearbuy.googlecode.com/files/mysql-connector-java-5.1.13-bin.jar

and add it to your class path.

If you are using netbeans, to add this file to your project do followoing

Right click on your project>click libraries>click add JAR/Folder> then select downloaded jar file

edited Feb 6, 2013 at 5:57

answered Feb 6, 2013 at 5:51

Fathah Rehman P

8,8014 gold badges43 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Renjith · Accepted Answer · 2013-02-06 05:40:22Z

0

You need to download the mysql jdbc driver jar and include it in your classpath

answered Feb 6, 2013 at 5:40

Renjith

3,28421 silver badges39 bronze badges

Comments

Hussain Akhtar Wahid 'Ghouri' · Accepted Answer · 2013-02-06 05:51:02Z

0

java.sql.SQLException: No suitable driver found for jdbc:mysql://SLibraryDev.db.996****.hostedresource.com
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)

clearly suggests that there is no driver in your class path

simply add the mysql driver jar file in to class path

answered Feb 6, 2013 at 5:51

Hussain Akhtar Wahid 'Ghouri'

6,6379 gold badges52 silver badges87 bronze badges

Collectives™ on Stack Overflow

Can't connect to a mysql DB with DriverManager

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related