How to install mysql for java

[Monica Kapoor]

Hi Ranchers,
I am trying to install mysql and wanna use it with java.I have installed the server.My problem is what else should I and how I have to install to work with Servlets and JSPs and the Mysql.I have setup of mysql-connector-odbc and mysql-connector-java.Thank you alot guys,regards,
Monica

[Andy Grove]

Hi Monica,

mysql-connector-j is a jdbc driver. You need to read up on JDBC as the next step. I'd recommend taking a look at javadocs for DriverManager and Connection in the standard JDK.

Also, there's the JDBC tutorial here:

http://java.sun.com/docs/books/tutorial/jdbc/index.html

Cheers,

[Maximilian Xavier Stocker]

Find yourself a MySQL tutorial and admin tool as well.

[rob armstrong]

Monica did you get yours to work yet?
roba

[wise owen]

Connecting to MySQL using JSP and JDBC

[Nilesh Molankar]

Hi Monica,
You will need to install "mysql-connector-java-3.1.12-bin.jar". and add its location to your classpath.
Like if the u have istalled the driver at "C:\mysql-connector-java-3.1.12\mysql-connector-java-3.1.12-bin.jar;" add this path to your classpath.

How this helps.

-Nilesh