| Author |
Apache Derby: Creating tables
|
Yohan Weerasinghe
Ranch Hand
Joined: Oct 07, 2010
Posts: 485
|
|
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.
|
Are you better than me? Then please show me my mistakes..
|
 |
Wendy Gibbons
Bartender
Joined: Oct 21, 2008
Posts: 1098
|
|
have you ever used squirrel sql?
it is a client that can be used angaist any database you have.
squirrel
|
 |
Wendy Gibbons
Bartender
Joined: Oct 21, 2008
Posts: 1098
|
|
|
but you must watch out to disconnect from the db before running your app.
|
 |
Yohan Weerasinghe
Ranch Hand
Joined: Oct 07, 2010
Posts: 485
|
|
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
|
 |
 |
|
|
subject: Apache Derby: Creating tables
|
|
|