• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Apache Derby: Creating tables

 
Yohan Weerasinghe
Ranch Hand
Posts: 507
Java Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hey all,

I am creating an application which is going to use the embedded apache derby dbms system (I have never used it, this is the first time). I embedded it to my application using netbeans IDE. Using the properties of my Netbeans IDE project, I added derby.jar file into project libraries. Then OK, it added. That's how I embedded it.

Now my question is, how to create tables and databases in this database? I am glad to use SQL for this purpose. But I don't know how to do it, because it has no query analyzer. Please help me.
 
Wendy Gibbons
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
have you ever used squirrel sql?
it is a client that can be used angaist any database you have.
squirrel
 
Wendy Gibbons
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
but you must watch out to disconnect from the db before running your app.
 
Yohan Weerasinghe
Ranch Hand
Posts: 507
Java Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Wendy Gibbons wrote:have you ever used squirrel sql?
it is a client that can be used angaist any database you have.
squirrel


Thanks Wendy. I just downloaded it. Will let you know the result
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic