Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 210
  • Last Modified:

JDBC - MySQL ??

I have downloaded mm.mysql 2.0.14 drivers.
I tried serveral ways to make it work; however
I can't.

Actually, my problem is i don't know where
i have to set for CLASSPATH.

I also tried for the second way, putting jar file
into jre/lib/ext, but i think it might have
some change in 'String driverName = "org.gjt.mm.mysql.Driver"' but i don't know what it
have to be !!!!

Are there any document about this ?? thank you
0
mrvithan
Asked:
mrvithan
  • 4
  • 3
1 Solution
 
cheekycjCommented:
code to access the driver:
Class.forName("org.gjt.mm.mysql.Driver");
       
Connection conn = DriverManager.getConnection("jdbc:mysql://SERVER1:3306/DB", "UN", "PW");

to set the classpath in windows:
C:\> set CLASSPATH=\path\to\mm.mysql.jdbc-[version];%CLASSPATH%
to set the classpath in unix:
$ setenv CLASSPATH /path/to/mm.mysql.jdbc-[version]:$CLASSPATH

HTH,
CJ
0
 
mrvithanAuthor Commented:
Well...i think i found the problem...
I went to DOS mode to set the CLASSPATH.
then i exit which means - I thought - the CLASSPATH
is also deleted...

So what i have to do ???
0
 
cheekycjCommented:
yes.. you would have to set the classpath for each dos window.

Or you can set it as an environment variable:
In WinNT/Win2k:
  Under Computer/System Properties-> Environment Variables.. add your classpath.
In Win9x:
   Add it to autoexec.bat.

CJ
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
mrvithanAuthor Commented:
Well, let's me try tomorrow.. today i so tried
0
 
cheekycjCommented:
ok.. post an update when you try it out.

CJ
0
 
mrvithanAuthor Commented:
I put the unjar all files at c:\mm.mysql,
then i set the CLASSPATH=c:\mm.mysql.

And
   String driverName = "org.gjt.mm.mysql.Driver";
   Class.forName(driverName);

it still doesn't work... what i did wrong ????


0
 
tomboshellCommented:
Here is a silly question, but have to make sure, did you un-jar the jar file that you downloaded?  Make sure that you have extracted the proper jar from within the original jar, then you could place it into the lib/ext directory.  I've done that on a W98 and W2000 machine without any problems, never needed to set the path.  Ok, I see that you did un-jar the files, then copy the bin jar named: mm.mysql-2.0.14-bin.jar and place it into the lib/ext directory.  
0
 
mrvithanAuthor Commented:
Well, it works right now....

I will give the point to cheekycj; sorry to tombshell...

Thank you
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now