Thread: Connection to MySql Database

Hi,

I'm just trying to get a simple connection going to my database. The database is fine but when I run my java program, all I see is, "Build Successful". I would like to display the information I put in my table. Thanks.

 
 
import java.sql.*;
 
public class TestSQL {
 
    public static void main(String args[]) {
        try {
 
            // Load the JDBC driver
            Class.forName("src.com.mysql.jdbc.Driver");
            System.out.println("---Driver loaded---");
 
            //Establish Connection
            Connection connection = DriverManager.getConnection(
                    "jdbc:mysql://localhost/test", "username", "password");
 
            //Create a Statement
            Statement statement = connection.createStatement();
 
            //Execute a Statement
            ResultSet rs = statement.executeQuery("SELECT * FROM people");
 
            //Iterate through the results and display data
            while(rs.next()){
 
                System.out.println(rs.getString(1) + rs.getString(2));
            }
 
 
            //Close connection
            connection.close();
 
 
 
        } catch (Exception e) {
 
            e.getMessage();
        }
 
    }
}

Im using Netbeans so Im compiling and then running.
I took your suggestion to printStackTrace and i get the following error.

java.lang.ClassNotFoundException: src.com.mysql.jdbc.Driver
	at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:169)
	at TestSQL.main(TestSQL.java:13)

Just to let you know as well, I've already downloaded the Connection Driver and placed the folder in "/Library/Java/JavaVirtualMachines/1.6.0.jdk/Contents/Home/lib"

ClassNotFoundException: src.com.mysql.jdbc.Driver

The JVM can not find the class shown in the error message.
Are you sure that is the correct name for the class?
Is the class file on the classpath where the JVM can find it?

Sorry I don't know anything about using Netbeans.

I think i have to change my class path, but Im not sure how to do this on mac. Ive been reading my text book and it suggests, "To use the MySQL and Oracle drivers, you have to add mysqljdbc.jar and ojdbc6.jar in the classpath using the following DOS command on Windows:
set classpath=%classpath%;c:\book\mysqljdbc.jar;c:\boo k\ojdbc6.jar" ...If anyone knows what the equivalent command for unix is, I think that should solve the problem

Hi All,

I finally figured out the problem, or at least one possible solution. In Netbeans you have to supply the path to the connection driver (JAR) from the projects properties.sql.jpg

Thanks, I realize this is a temporary fix. If I find a better suited solution I will post back.

My final solution was to keep the driver (JAR) in the project folder. many thanks again.