aspose file tools*
The moose likes JDBC 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
Bookmark "JDBC installation problems" Watch "JDBC installation problems" New topic
Author

JDBC installation problems

ian rogers
Greenhorn

Joined: Feb 03, 2005
Posts: 2
Hello

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
Thanks

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
Greenhorn

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

Ian
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 31069
    
232

Ian,
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.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC installation problems