This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
I am trying to get conncetion to MySQL database using this simple java class.
I have added the mysql driver to NetBeans IDE, but when I try to compile the file I get a ClassNotFound error (the file can't locate the mysqljdbc.jar). Can anybody please suggest me how to fix this? If I need to register the database specificaly for this program how to do it then?
If that doesn't work, try connecting to your database using a third-party client like SQuirreL, and open source SQL client available on sourceforge (http://sourceforge.net/projects/squirrel-sql/). I recommend it specifically because it is implemented in Java, and you can use the same driver to test with.