jdbc

I'm having problems setting up mysql to do some
jdbc. Here's what I've done so far:

a) downloaded mysql and set it up. I can do manual
sql entries, create table, insert into table, all
through a dos window.
path to mysql--> c:\program files\mysql

b) downloaded mysql-connector-j and set my classpath
variable through the control panal, system option.
path to mysql--> c:\program files\mysql connector
which is the directory containing the
mysql-connector-java-3.1.13-bin.jar file

c) typed a java file in which I just start with
Class.forName("EXACTLY WHAT GOES IN HERE?").newInstance();
I had what was in the connector-j documentation, which was
"com.mysql.jdbc.Driver", but all I've ever gotten was an
exception thrown

Can anybody help me? Am I missing something? I've followed ALL
the install instructions, but for some reason my program doesn't
recognize the driver.
Thanks,

John

"john gregory" <hockey9876@comcast.net> wrote in
news:MOudnWoiPoi7hFTZnZ2dnUVZ_vednZ2d@comcast.com:

> I'm having problems setting up mysql to do some
> jdbc. Here's what I've done so far:
>
> a) downloaded mysql and set it up. I can do manual
> sql entries, create table, insert into table, all
> through a dos window.
> path to mysql--> c:\program files\mysql
>
> b) downloaded mysql-connector-j and set my classpath
> variable through the control panal, system option.
> path to mysql--> c:\program files\mysql connector
> which is the directory containing the
> mysql-connector-java-3.1.13-bin.jar file
>

You have to add the jar file itself to the classpath, not the directory
containing it.

--
TeX is potentially the most significant invention in typesetting in this
century. It introduces a standard language for computer typography, and in
terms of importance could rank near the introduction of the Gutenberg
press.
-- Gordon Bell

Donkey Hot wrote:

> You have to add the jar file itself to the classpath, not the directory
>
>containing it.
>
>
>
I double checked the classpath and the
mysql-connector-java-3.1.13-bin.jar is in
there, not just the MySQL Connector directory. I had to do a similar
thing when
I set up Jakarta-Tomcat, include the servlet-api.jar and jsp-api.jar in
the classpath.

John