This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30138
    
150

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
 
Similar Threads
Help - - - ClassNotFoundException: com.mysql.jdbc.Driver
MySQL Connector/J
MySQL DataBase
not able to connect to the database
i couldn't run jdbc progam in netbeans