File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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?
I agree. Here's the link:
subject: create mysql db for web application
It's not a secret anymore!