This week's giveaway is in the Programmer Certification (OCPJP) forum.
We're giving away four copies of Java Mock Exams (software) and have David Mayer on-line!
See this thread for details.
Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Suggestions for a tool

 
Dwayne Barsotta
Ranch Hand
Posts: 72
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am incorporating a Derby database into a personal Java project.  It will be an embedded database.  What I am wondering is can y'all offer suggestions for a free GUI application that will help me design, alter, visualize and ultimately help build the SQL statements I am going to need.  I have one had one course on basic database design.  So I have basic knowledge of the process but would like to use a GUI application to help make sure I am doing things correctly.
 
Tim Moores
Saloon Keeper
Posts: 3326
61
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
SquirrelSQL (on SourceForge) is a good GUI JDBC client, which I have been using for years.
 
Dwayne Barsotta
Ranch Hand
Posts: 72
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank You
 
Dwayne Barsotta
Ranch Hand
Posts: 72
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It took me a little playing around but I was finally able to connect to the embedded database and then to understand the extra data showing.
 
Dwayne Barsotta
Ranch Hand
Posts: 72
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is there a way I can build a completely new test database in squirrelSQL, Using the derby embedded driver.  Then I can build the database in the same way I want my application to handle it through code, copy the correct SQL statements into the java code and bing boom?  I was messing around with it a bit but can't see where I start a new database. 

Thanks 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!