Hello there,

I'm having a terrible time trying to use the JDBC in os x.

What I want to do is use a program written in java and executed on my
mac to connect to a database on my website and INSERT a huge amount of
data. I have to do this as the upload limit on the web hosting is 2MB
and I've got a GB of data...

So, I've downloaded and extracted the jdbc mysql driver:
mysql-connector-java-3.1.14

Then I've opened my etc/profile file and added the location to the
classpath like this:

PATH="/bin:/sbin:/usr/bin:/usr/sbin:/usr/mysql-connector-java-3.1.14/mysql-connector-java-3.1.14-bin.jar"
export PATH  - This might be the problem but I couldn't find an
explicit example of how to do this...

Then I connect to the DB like this:

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

   String conStr = "jdbc:mysql://http://mywebsite.net/myDatabase";

try {
Connection conn = DriverManager.getConnection(conStr, "user", "pass");
System.out.println("connected");
}
...

The result is always this:

SQLException: No suitable driver
SQLState: 08001
VendorError: 0

I'm a long way from being an expert so this is totally baffling me. Any
help would be great.

All the best
B