Logo 
Search:

Java Forum

Ask Question   UnAnswered
Home » Forum » Java       RSS Feeds

Installing Connector/J MySQL JDBC Driver

  Asked By: Hamish    Date: Feb 24    Category: Java    Views: 993
  

I need your precious help in my problem I am facing.

I am Installing Connector/J MySQL JDBC Driver in the following environment properties:

[1] OS: Windows Advanced Server
[2] DBase: database MySQL 4.0.20d
[3] App Server: Tomcat 4.0.6
[4] Http Server: Apache 1.3.27
I need to know the exact steps to follow as to use the Connector/J as I am using the MyODBC 3.51 of MySQL, yet it is required to use the Connector/J only.

Also, I need to know what driver to use:

Class.forName("com.mysql.jdbc.Driver").newInstance();

and what URL to include:

con = java.sql.DriverManager.getConnection("jdbc:mysql:mydbase","username","password");

Please, send me all required steps that were already deployed and working.

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Mercedes Andrews     Answered On: Feb 24

Put a copy of the mysql-connector-java-3.0.??.zip into the following directory of your jsdk, Example:

C:\j2sdk1.4.2_04\jre\lib\ext

extract the zip file and copy the jar file: mysql-connector-java-3.0.??-bin.jar into the following directory of your tomcat:

C:\jakarta-tomcat_version\common\lib

Driver and URL:
Class.forName("com.mysql.jdbc.Driver");

Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase?user=;password=");

 
Answer #2    Answered By: Fuzairah Neeman     Answered On: Feb 24

Just an addition:

MySQL Connector/J has two Driver classes. the one with
"org.gjt.mm.mysql.Driver.class" is preferred/mandatory for some java/j2ee
application such as JMS and ORMapping.

 
Didn't find what you were looking for? Find more on Installing Connector/J MySQL JDBC Driver Or get search suggestion and latest updates.




Tagged: