Solved

In NetBeans connect to mySQL table

Posted on 2010-11-16
10
900 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 

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
 

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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

Suggested Solutions

An old method to applying the Singleton pattern in your Java code is to check if a static instance, defined in the same class that needs to be instantiated once and only once, is null and then create a new instance; otherwise, the pre-existing insta…
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…
Viewers learn about the “while” loop and how to utilize it correctly in Java. Additionally, viewers begin exploring how to include conditional statements within a while loop and avoid an endless loop. Define While Loop: Basic Example: Explanatio…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
Suggested Courses

739 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