-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Massimiliano,
Massimiliano PASQUALONI wrote: > But, even though I specify the user and password in the connectionURL, > connectionURL = > "jdbc:mysql://localhost:3306/bi?user=myuser;password=mypassword", my Tomcat > return: "Error 500: javax.servlet.ServletException: Access denied for user > ''@'localhost' (using password: NO)" "Using password: NO" means that the password is not being sent correctly to the database server. You have an error in your URL: the ";" should be a "&", just like a regular URL. That's probably why the password is being ignored. In fact, I'll bet that the username being used is "myuser;password=mypassword". I agree with Pid's recommendation to use JNDI for your database connection. If you do that, you can use the same connection pool for Tomcat's realm authentication and your own application as well, instead of separate sets of connections. (If you setup a JDBCRealm, Tomcat manages either a single connection or a separate set of connections for authentication. I've seen misconfigurations where the application can connect to the database but the realm cannot. Oops!) - -chris > > :-( > > I the JNDI Datasource HOW-TO ( > http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html > ) I'ved see that I need to configure the server.xml and the web.xml files. > But, I belive, it's a particular specific use of Tomcat and MySql and I > don't need that, I just want a connection whit my application an mysql, not > from the Application Server and Mysql... > > > P.S. hearty congratulations, I think you are best comunity on the world, > swift, accurate and efficient! > > > > Thanks! > > > > > > > Massimiliano Pasqualoni > http://www.pasqualoni.it > > > > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > Scanned with Copfilter Version 0.83beta3a (ProxSMTP 1.4) > AntiVirus: ClamAV 0.88.4/3224 - Wed May 9 17:25:29 2007 > by Markus Madlener @ http://www.copfilter.org > > --------------------------------------------------------------------- > To start a new topic, e-mail: users@tomcat.apache.org > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGQw4i9CaO5/Lv0PARAgucAJ0cPOJt9BCbcRgLb67hafQ8N/7DwgCfQqj6 YNRwHUtyL5WAVcj1srNE+Js= =02Hj -----END PGP SIGNATURE----- --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
