aspose file tools*
The moose likes JDBC and the fly likes create mysql db for web application Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "create mysql db for web application" Watch "create mysql db for web application" New topic

create mysql db for web application

Yahya Elyasse
Ranch Hand

Joined: Jul 07, 2005
Posts: 510

Sorry if my question seems should be very basic to experts like you

I want to create a mysql database that I will later connect to from a servlet under apache tomcat server.
my question : where should i put the mysql database ? should it go into WEB-INF directory of my application ?
what is the mysql SQL command i should type to put db int the right directory ?

Maximilian Xavier Stocker
Ranch Hand

Joined: Sep 20, 2005
Posts: 381
When you connect to a MySQL database you connect to a server not the files directly. So the location of the actual files is not relevent. It only matters to your application that you can reach the mysql server through a socket from wherever you are running.

Are you confused about where to have the driver jar?
It is sorta covered in the JavaRanch Style Guide.
subject: create mysql db for web application