Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Help with JDBC

 
Michael Melamu
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello

I downloaded a project from this site :http://www.cs.wcupa.edu/~rkline/Java/java-web-store.html
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

Michael.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34178
340
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Michael,
Welcome to JavaRanch!

That's a long page. Which step specifically are you stuck on?
 
Michael Melamu
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello

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 .
Thanks
Michael
 
Fatih Keles
Ranch Hand
Posts: 182
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

Regards,

Fatih.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic