aspose file tools*
The moose likes JDBC 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
Bookmark "Help with JDBC " Watch "Help with JDBC " New topic
Author

Help with JDBC

Michael Melamu
Greenhorn

Joined: May 14, 2010
Posts: 7
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30546
    
150

Michael,
Welcome to JavaRanch!

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


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Michael Melamu
Greenhorn

Joined: May 14, 2010
Posts: 7
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

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.

Regards,

Fatih.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Help with JDBC