Re: Error while connecting to MySQL database

2006-06-30 Thread David Smith
Ok.. 1. Don't mess with the CLASSPATH. In all modern version of tomcat, the class loading heirarchy should take care of all your needs. 2. File ownership - make sure all of tomcat's files are owned by the tomcat user. Sounds to me the db.properties file is not readable by the tomcat user a

Re: Error while connecting to MySQL database

2006-06-29 Thread navaneethan loganathan
Hi I am sorry, as I did not mention that I have root password for mysql. I have entered the root password(for mysql) in my db.properties file. I have specified in CLASSPATH as well for mysql connector in both $CATALINA_HOME/bin/setclasspath.sh and also the user's .bash_profile. Today morning I

RE: Error while connecting to MySQL database

2006-06-29 Thread Gordon Smith
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. A

RE: Error while connecting to MySQL database

2006-06-29 Thread Jitendra Kharche
Hi, I don't' know whether specifying db.properties works or not, but I configured a datasource for mysql as follows: 1. Shutdown tomcat. 2. Enter followin in TOMCAT_HOME/conf/server.xml (If you have an entry in server.xml for this update it as below) 3. Enter following in your-web-app/META