File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Other Open Source Projects and the fly likes Testing MySQL Connector/J Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Testing MySQL Connector/J" Watch "Testing MySQL Connector/J" New topic
Author

Testing MySQL Connector/J

Swapna Gouri Kalanidhi
Ranch Hand

Joined: Mar 14, 2008
Posts: 107
Hi All
I have installed MySQL and MySQL Connector J on my system. How to test whether MySQL connector J has been installed properly or not...

I'm trying this command on the command prompt:

mysqld-nt --console

but getting following error:
081119 16:24:07 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.

Please kindly help...!


Thanks & Regards
Swapna Gouri
I "try", I "catch" and "finally" WIN !!!
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18564
    
    8

The only "installation" required for the JDBC driver is that the jar file be put in your application's classpath. If the application connects to the database then the driver is "installed" correctly. If you get a ClassNotFoundException then it isn't.
Swapna Gouri Kalanidhi
Ranch Hand

Joined: Mar 14, 2008
Posts: 107
Hi Paul
As you have said, I'm getting an exception...What should I do now? I have updated the class path but still I'm facing this problem. Can you suggest what should be done to get this to work...
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18564
    
    8

There are two steps.

1. Find the jar file which contains the JDBC driver. Make sure it actually contains the JDBC driver.

2. Put that jar file somewhere and make sure it is part of the classpath for your application. Bear in mind that different kinds of application configure their classpaths differently.

There's plenty of tutorials for setting Java classpaths, if you are just writing a command line application.
Swapna Gouri Kalanidhi
Ranch Hand

Joined: Mar 14, 2008
Posts: 107
Hi Paul
Thanks a bunch....I got it

Its working fine now!!!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Testing MySQL Connector/J