aspose file tools
The moose likes JDBC and the fly likes Apache Derby: Creating tables Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Apache Derby: Creating tables" Watch "Apache Derby: Creating tables" New topic
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Apache Derby: Creating tables
 
Similar Threads
JDBC-ODBC Bridge VS JNDI
where data is stored in apache derby?
help with the derby-ij tool
Netbeans can't connect to database server
Netbeans Glassfish and apache derby