Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

problem setting up mm.mysql driver

 
Lucy Smaile
Ranch Hand
Posts: 45
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I've been trying to follow the Cattle Drive jdbc tutorial, but i'm stuck on installing mm.mysql.
I downloaded mm.mysql-2.0.6.1.jar.
The tutorial says "Do not unjar the file - you're going to just mash that into your class path. "
Then it tells you to cut and paste the program that uses it.
I just put the .jar file in the same directory, but it throws an exception:
"could not load JDBC driver: java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver"
Can anyone help?
 
Lucy Smaile
Ranch Hand
Posts: 45
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I guess it's a class path problem. I tried to do one of the thing the Release Notes suggests - putting
mysql-2.0.11-bin.jar
into
C:\jdk1.3\jre\lib\ext,
but that didn't work.
Strangly, the error message changes, but only when I run the prog from Textpad, not from the command line. But it's still an error:
could not get JDBC connection: java.sql.SQLException: Cannot connect to MySQL se
rver on localhost:3306. Is there a MySQL server running on the machine/port you
are trying to connect to? (java.net.ConnectException)

Please could anyone help with the right way to do it?
 
Elahe Shafie
Ranch Hand
Posts: 291
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
For my experience I used this version(mm.mysql-2.0.11-you-must-unjar-me.jar) and I unjar it and get mm.mysql-2.0.11-bin.jar and just put it in
C:\Tomcat323\webapps\bugtrack\WEB-INF\lib (that is my path eventually should go to lib) where the jar files should go and it is working I hope it works for you too...
Elahe
 
Lucy Smaile
Ranch Hand
Posts: 45
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks, but hmm, I haven't got Tomcat yet (doing things one thing at a time...) Can you install Tomcat without Apache, or do you have to have all the works?
What exactly do you actually need to do servlets? How complicated is Tomcat installation?
Thanks in advance!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic