Good call P! I tried connecting to the database from the command line and was not able to. Another difference between Windows and Linux it seems as the user was defined the same in both cases. Now I have copied the user to use host 'localhost' as well as '@' and it works.
I have to say that the exception thrown is just a little misleading (typical British understatement there!) ThanKs, Paul ________________________________________ From: Pid [...@pidster.com] Sent: 03 March 2009 16:26 To: Tomcat Users List Subject: Re: Cannot create JDBC driver of class '' for connect URL 'null'Causedby: java.lang.NullPointerException at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(JdbcOdbcDriver.java:507) Paul Maxted wrote: > Hello again, > > Thanks for your swift responses - apologies for the length of the original, > but I see so many posts where people immediately ask for more details! > > David, I have tried dropping the validation query and I also tried rolling > back the version of mysql-connector-java to 5.0.8 in case the mismatch > between that and the MySQL version was relevant. > Neither has changed the outcome. > > Any further thoughts? Can you connect to the DB using the command line mysql client program & the credentials you're trying to use? (I think that's a different error message, but worth checking anyway). I recently ran into the same unhelpful error message and found that the war redeployment process wasn't removing the tomcat/conf/Catalina/myhost/mycontext.xml file, which contained stale information from an earlier deployment. Delete the war, remove the copied context.xml from conf & trying putting a freshly built war back. p > Regards, Paul > ________________________________________ > From: Pid [...@pidster.com] > Sent: 03 March 2009 15:02 > To: Tomcat Users List > Subject: Re: Cannot create JDBC driver of class '' for connect URL > 'null'Caused by: java.lang.NullPointerException at > sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(JdbcOdbcDriver.java:507) > > David Smith wrote: >> Pid wrote: >>> Paul Maxted wrote: >>> >>>> Hello, I need some help with my database access application. >>>> >>>> I am running Tomcat 6.0.16-6.4 installed from the OpenSUSE repositories. I >>>> am trying to connect to MySQL 5.0.51a-27.2. >>>> I have mysql-connector-java-5.1.7-bin.jar in the tomcat6/lib directory. >>>> >>>> I have not modified server.xml or context.xml in tomcat6/conf - I include >>>> them for reference >>>> >> .... >>> where's the DB driver? >>> it's not in your war/lib... >>> >>> >>> p >>> >>> >>> >> See the top of the message. The OP included that info in the >> introductory part. It's in the correct place for tomcat 6. > > So he did, I must have lost that in all the scrolling... > > p > > > >> --David >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org >> For additional commands, e-mail: users-h...@tomcat.apache.org >> >> > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > > > "DISCLAIMER: This message is proprietary to Aricent and is intended solely > for the use of the individual to whom it is addressed. It may contain > privileged or confidential information and should not be circulated or used > for any purpose other than for what it is intended. If you have received this > message in error,please notify the originator immediately. If you are not the > intended recipient, you are notified that you are strictly prohibited from > using, copying, altering, or disclosing the contents of this message. Aricent > accepts no responsibility for loss or damage arising from the use of the > information transmitted by this email including damage from virus." > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org "DISCLAIMER: This message is proprietary to Aricent and is intended solely for the use of the individual to whom it is addressed. It may contain privileged or confidential information and should not be circulated or used for any purpose other than for what it is intended. If you have received this message in error,please notify the originator immediately. If you are not the intended recipient, you are notified that you are strictly prohibited from using, copying, altering, or disclosing the contents of this message. Aricent accepts no responsibility for loss or damage arising from the use of the information transmitted by this email including damage from virus." --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
