File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes JDBC installation problems Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC installation problems" Watch "JDBC installation problems" New topic

JDBC installation problems

ian rogers

Joined: Feb 03, 2005
Posts: 2

I have a problem, which is proberbly very simple but i am still having trouble with it.

I have downloaded the jdbc driver 'mysql-connector-java-3.1.6-bin.jar and placed it in my packages directory. I have changed my classpath to include that directory and the directory containing my java program as below

set classpath=\c:\Program Files\java\jdk1.5.0\mypackages\mysql-connector-java-3.1.6-bin.jar;c:\Program Files\java\jdk1.5.0

when i run my program it comes up with the error "Exception: No Suitable Driver"

I have tried placing the .jar file in the jdk1.5.0\jre\lib\ext but that still comes up with an error.

I was just wondering if anybody can see what i am doing wrong?

I would be very grateful for any advice

below is the code for the java program i am using to test my connection:

[edited to add code tags]
[ February 03, 2005: Message edited by: Jeanne Boyarsky ]
ian rogers

Joined: Feb 03, 2005
Posts: 2
Hello again

I have looked into this problem and can see that i the java program was incorrect, and my program now works with JDBC

sorry for this post

Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33113

Welcome to JavaRanch! I'm glad to see that you found the solution so quickly.

I added UBB code tags to your posts. It makes code easier to read. For future reference, the UBB tags are right below the editor on the edit screen.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: JDBC installation problems
It's not a secret anymore!