Get the tools you need to learn Java skills fast!
Video tutorials, eBooks, hands-on lab exercises, sample code.
Get started
The moose likes Tomcat and the fly likes Configure Tomcat & Mysql Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Badass: Making Users Awesome this week in the Game Development forum!
JavaRanch » Java Forums » Products » Tomcat
Bookmark "Configure Tomcat & Mysql" Watch "Configure Tomcat & Mysql" New topic

Configure Tomcat & Mysql

Hussein Baghdadi
clojure forum advocate

Joined: Nov 08, 2003
Posts: 3479

Hey ranchers.
I am using Tomcat and I want to add a datasource.
what is the best place to add a datasource to server.xml file ?
before the closing </host> element close to the end of the file ?
I have been reading that mysql user account should has a password in
order to be tomcat able to connect...
but when installing mysql, I didn't create any account (I mean, when
I connect to mysql, I don't provide any passwords or usernames).
so I think to do the following to server.xml :
and the some thing to the password....
please correct me if I am wrong.
also, I have been reading that I need to grant the appropriate priviliges
for tomcat to be able to connect to mysql using the username and the
the command is :
grant all privileges on *.* to admin@localhost indentified by 'admin'
with grant option;
so what to do in my case (there is no user account and password in mysql) ?
admin in admin@localhost is the name that I have provided when installing
tomcat, right ?
thanks alot.
Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 16537

You can set your datasource resource ID at the global (server.xml) level or at the individual webapp level. Where I work, we have different webapps running against different databases, so to configure them, I create a "webapp.xml" file and put it in the Tomcat webapps directory. It has the database resource definitions, the security resource definitions, and the application context.

Caution: In Tomcat 4.1, having a WAR file with the same name as a webapp xml file will hide the config info in the webapp xml. So I put my wars in their own special directory (/opt/webapps). The rules are different for Tomcat 5, however.

Customer surveys are for companies who didn't pay proper attention to begin with.
Consider Paul's rocket mass heater.
subject: Configure Tomcat & Mysql