If Class.forName throws a null pointer exception, chances are it can't find the driver because you have a Tomcat configuration problem or other classpath-related problem relating to driver setup. Please check out the documentation on tomcat.apache.org for the details for your version of Tomcat.
As an aside, please consult the MySQL documentation about setting a root password and disabling unneeded accounts in the database. You are leaving a gaping security hole in your app by not establishing a root db pwd. Once you put a root pwd in place, there's no reason to share it in this forum as long as you can connect by using that pwd from the MySQL client. Hope this helps. Cheers, Gordon Smith -----Original Message----- From: navaneethan loganathan [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 28, 2006 7:57 PM To: users@tomcat.apache.org Subject: Error while connecting to MySQL database Hi, I am facing a problem with my Apache-Tomcat-MySQL installation.MyEnvironment is as follows: Redhat ES4(2.6.9-5.EL), Apache-Tomcat-5.5.15, MySQL 4.1.12, Java version 1.5.0_06, Apache-Tomcat connector ajp13, mysql-connector-java-3.2.0-alpha-bin.jar. After installation and configuration I am unable to connect to the database through the application and getting the following exception in catalina.outlog file. java.lang.NullPointerException at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:164) However, I am able to browse my site perfectly with http://localhost/index.jsp (the connector also configured perfectly, so that I do not need to specify the port number in URL). I put the mysql-connector-java-3.2.0-alpha-bin.jar file in $CATALINA_HOME/common/lib and also specified in CLASSPATH. I am able to login to MySQL through command and access the database without any problem. My db.properties is as under: # MySQL database access properties db.driver = org.gjt.mm.mysql.Driver db.url = jdbc:mysql://localhost:3306/testdb db.user = root db.pwd = Any clue will be very much helpfull.Thanks in advance. --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
