Novell Home

Missing Java class

Novell Cool Solutions: Question & Answer

Posted: 22 Nov 2004

Q:
I am setting up a MySQL database for reporting in Novell Audit. What is the Java class for the MySQL database that is asked for during reporting setup? I have looked at the Java JDK 1.2.1 for the answer but still have come up empty.

A:
1. Go to the MySQL site and download their latest MySQL Java connector:
http://dev.mysql.com/downloads/connector/j/3.0.html

2. From the zipped file, extract the following file:
mysql-connector-java-3.0.14-production-bin.jar

and put it under /var/opt/novell/tomcat4/common/lib

3. Restart Tomcat and define a new database as follows:

Name:      MySQL
JDBC Class:       com.mysql.jdbc.Driver
Host:      jdbc:mysql://127.0.0.1
Port:      3306
Database:      naudit
Tabella:      log
Username:      <your_mysql_user_here>
Password:      <your_password>

4. Perform your queries.

Novell Cool Solutions (corporate web communities) are produced by WebWise Solutions. www.webwiseone.com

Novell® Making IT Work As One

© 2008 Novell, Inc. All Rights Reserved.