This week's giveaway is in the Spring forum.
We're giving away four copies of REST with Spring (video course) and have Eugen Paraschiv on-line!
See this thread for details.
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

Win a copy of REST with Spring (video course) this week in the Spring forum!
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: 32819

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
subject: JDBC installation problems
It's not a secret anymore!