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 Help with JDBC 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 "Help with JDBC " Watch "Help with JDBC " New topic

Help with JDBC

Michael Melamu

Joined: May 14, 2010
Posts: 7

I downloaded a project from this site :
Called webstore.

I imported the project *.war file to eclipse,and added the necessary external jars,the problem is that i dont know how to configure the mysql database to start the project.

I mean that i dont understand the instructions on website about the server part.

if any one can help me and tell me the steps to configure the server and add the database.

I will mostly appreciate it.

Thank you very very much

Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33130

Welcome to JavaRanch!

That's a long page. Which step specifically are you stuck on?

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Michael Melamu

Joined: May 14, 2010
Posts: 7

I am stuck here :

Database Setup
This project uses the webstore database with multiple tables. We will assume the guest user with no password has been created. Go into the WebStore folder and run these:

$ mysql -u root < database.sql
$ mysql -u guest webstore < tables.sql
$ mysql -u guest webstore < tables-images.sql

I Have mysql installed,but i dont how to configure it,and even more i dont know where to run these 3 commands.

Any help will be mostly appreciated .
Fatih Keles
Ranch Hand

Joined: Sep 01, 2005
Posts: 182
Hi Micheal,

As you say you have installed mysql you should have the special "root" account.

Follow these steps
1. Start mysql service (this may be helpful)
2. Add a user account named guest (this may be helpful)
3. Go to mysql installation directory/bin (you will have already discovered this after previous steps) and execute the database installation sql files for project in command prompt.

For further help please provide your environment details.


I agree. Here's the link:
subject: Help with JDBC
It's not a secret anymore!