Solved

In NetBeans connect to mySQL table

Posted on 2010-11-16
10
893 Views
Last Modified: 2013-11-23
I get this error when I try to connect to my mySQL db in Netbeans on a mac OSX 10.6.5

It worked fine on my ibm laptop
0
Comment
Question by:jdiebold
  • 7
  • 3
10 Comments
 

Author Comment

by:jdiebold
ID: 34150798
I get this error:

run:
Class Not Found Exception: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
BUILD SUCCESSFUL (total time: 1 second)


0
 

Author Comment

by:jdiebold
ID: 34150809
This is my code:

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package coffeebreak;

import java.sql.*;

/**
 *
 * @author PuckHead
 */
public class CoffeeBreak {

/**
 * @param args the command line arguments
 */
    public static void main(String[] args)
    {

        try
        {
            Class.forName("com.mysql.jdbc.Driver");
            String connectionUrl = "jdbc:mysql://localhost:8889/coffeebreak?" +
                                   "user=admin&password=admin";

            Connection con = DriverManager.getConnection(connectionUrl);

            Statement stmt = null;
            ResultSet rs = null;

            //SQL query command
            String SQL = "SELECT * FROM coffees WHERE PRICE between 7.00 and 8.00";

            stmt = con.createStatement();
            rs = stmt.executeQuery(SQL);
0
 
LVL 92

Expert Comment

by:objects
ID: 34150879
you need to add the mysql jar to your classpath
0
 

Author Comment

by:jdiebold
ID: 34150976
Awesome!  How do I do that on a mac?
0
 
LVL 92

Expert Comment

by:objects
ID: 34150998
add it to your netbeans build path
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:jdiebold
ID: 34151010
I have the mysql-connector-java-5.1.12.zip

included in my Libraries folder of my project in Netbeans

I guess i though that was adding it to the class path?
0
 

Author Comment

by:jdiebold
ID: 34151058
Is the classpath listed under properties > Misc > Ant?
0
 
LVL 92

Assisted Solution

by:objects
objects earned 100 total points
ID: 34151091
you need to unzip it and add the include *jar* to your libraries (not the whole zip)
0
 

Accepted Solution

by:
jdiebold earned 0 total points
ID: 34324655
I found the answer that I was looking for here:

http://forums.mysql.com/read.php?39,195400,195559#REPLY

Re: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver on Mac OS X Leopard
Posted by: Mitch Graves ()
Date: February 09, 2008 01:29AM





I have the answer. After a long dig through Google, I finally found a bit of information that solves my problem on Leopard and Tiger. I found that the CLASSPATH doesn't work at all (at least for me) and all that needs to be done is to copy the mysql JDBC connector to /Library/Java/Extensions. As soon as I did that, my java program could connect to my MySQL database and I was off and running.
0
 

Author Closing Comment

by:jdiebold
ID: 34367406
The CLASSPATH is the common answer here but it did not work. Only when I added the mysql JDBC connector to /Library/Java/Extensions did it work.

His last post may have hinted at that but not at enough detail to show me how to fix it as a novice.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
groupSum5 challenge 5 68
firstChar challenge 13 106
simple java question 3 44
why cannot we forward request once the response is committed 2 33
By the end of 1980s, object oriented programming using languages like C++, Simula69 and ObjectPascal gained momentum. It looked like programmers finally found the perfect language. C++ successfully combined the object oriented principles of Simula w…
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
Viewers learn about the “for” loop and how it works in Java. By comparing it to the while loop learned before, viewers can make the transition easily. You will learn about the formatting of the for loop as we write a program that prints even numbers…
This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now