Amrinder Singh wrote:
>
> hi i've downloaded the mysql and loaded the driver(mm.nysql) driver for it.If i try
>to use it in a regular program without involving the server(tomcat3.2.1) it works
>fine . i can get the resultset etc which is fine. But when i created another
>applicatoin which involved the use of Tomcat it gives me error saying
>
> Started: 21:13:29.210 PM
> Error: java.sql.SQLException: Invalid authorization specification: Access denied for
>user: 'username@localhost' (Using password: YES)
>
> i've looked at hundreds of webpages but nothing so far has revealed a suitable
>reaason and solution for it. one webpage said to put the jar file in WEB-INF/lib dir
>but in my version of tomcat3.2.1 theres no subdirectory as that .
Well, you wrote the web application right? So technically no directories
exist until you put them there :)
Applications running in tomcat get can load their classes from three
main locations, /jre/lib/ext (Standard installed extensions, don't use
this as it's a nightmare to maintain, believe me!), /$TOMCAT_HOME/lib
(for general drivers that everything should be able to see) and
/$TOMCAT_HOME/webapps/YOUR_APP/lib.
So, the short answer (and I'm not even sure your problem is anything to
do with this, but it's a faq anyway) is to create the 'lib' subdirectory
and put the driver jar in it.
Cheers,
Tom
--
To unsubscribe: <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>
