Problems with MySQL Driver

I have never done remote logins in Java before, so I am very new to this.

I copied this test code from MySQL 5.0:

Code:

---

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

// Notice, do not import com.mysql.jdbc.*
// or you will have problems!

public class LoadDriver {
    public static void main(String[] args) {
        try {
            // The newInstance() call is a work around for some
            // broken Java implementations

            Class.forName("com.mysql.jdbc.Driver").newInstance();
        } catch (Exception ex) {
            // handle the error
        }
    }
}

---

I ran it and it worked fine, so I thought I could continue with my own code. When nothing worked however, I went back and added a System.out.prinlnt("Exception: " + ex.getMessage()); to the catch statement.

When I ran the code this time, I got this message:

Exception: com.mysql.jdbc.Driver

I have no idea what this means and Google for once is not helping me at all.

Thanks for your time.

have you add jdbc jar to your project or classpath?

I've read in three different places about adding the driver (Connector/J I think it's usually called online) to the classpath, but none of the instructions worked. If I recall, one was just typing out a long command in the terminal starting with Classpath, ending in the downloaded driver. The second one was adding the Classpath command to /etc/environment (which I later removed when it interfered with running normal java programs), the third was performing a jar command.

I don't know if I did it right, but I did it exactly as the instructions all read.

So can anyone give me any info on how to properly install this driver? None of the documentation thus far has been of any help.

have you include the MySQL Connector (jar file)?
i found this when trying to execute code without MySQL Connector:

Quote:

---

com.mysql.jdbc.Driver

---

I'm having the same exact issue. I couldn't find MySQL connector jar file anywhere (I have mysql 5.0.75 installed). Please let me know the exact name of MySQL connector jar file. Where exactly it has to be included?
Thank you

you may get the jar file dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.8.zip/from/pick, i think it must be more comfortable if we use Netbeans IDE in developing application. for adding the jar file by doing these:
1. right click on the project,
2. select Properties,
3. select Libraries,
4. click Add Jar/ Folder,
5. select the jar file,
6. ok
try to rebuild the project then run it.

Thanks, mariosimaremare! That worked perfectly

The new issue I now experience when I use getGeneratedKeys() method on Statement object. "java.sql.SQLFeatureNotSupportedException" exception is thrown. Is this an issue of mysql driver that does not have this method defined?

thanks