This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes import database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "import database" Watch "import database" New topic

import database

vijay joseph

Joined: Feb 26, 2007
Posts: 18
i have an project done using mysql database and i want to run in my machine how to configure that data base to run in my machine, my project done using tomcat. i copy the project to webapps folder and now have to configure the database how to do that please help thnks in advance
krishnamoorthy kitcha
Ranch Hand

Joined: Feb 04, 2006
Posts: 96

First check with jdbc connection jar files which is provided by mysql

and check with your database, table and all were using in the existing project , The same will reflect in your machine.

Like database name,loginname and password

If your not clear , can you tell me where do you face the problem ?
Please explain in detail.
vijay joseph

Joined: Feb 26, 2007
Posts: 18
actually iam new to mysql and have an project which is developed in seperate machine using tomcat and mysql database, now i want to run in my machine,
so idone the following steps
1.copy the project folder into the webapps in tomcat directory
2.create the database database name;
3: Now Type the command
use database name;
4: Now type the command
\. healthman.sql(it is already in the project sql file)

when i enter the username password
it is showing the error
error was:

HTTP Status 404 - /healthman/ValidateUser
type Status report

message /healthman/ValidateUser

description The requested resource (/healthman/ValidateUser) is not available.
Apache Tomcat/5.5.23

please let me know
how to connect my data base with existing project database
[ September 27, 2007: Message edited by: vijay joseph ]
krishnamoorthy kitcha
Ranch Hand

Joined: Feb 04, 2006
Posts: 96

what is your Tomcat port number default is 8080

just ping from your browser


if it is run properly, everything should be fine

or else there is some problem

404 showed only when particular projects not avilable.

Try to put your projects webapps/root/yourproject

Then try and tell me your feedback.
subject: import database
Similar Threads
EJB simple client is not running
JDBC......Driver ....
Tomcat and Mysql Configuration
JBuilder 2005 and Tomcat 5.0.27
problem with Websphere Portal 5.1 Server