Win a copy of Java 9 Modularity: Patterns and Practices for Developing Maintainable Applications this week in the Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Configure Tomcat & Mysql  RSS feed

Hussein Baghdadi
clojure forum advocate
Posts: 3479
Clojure Mac Objective C
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 18774
Android Eclipse IDE Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!