Using derby

Hiexist one client pgm for to use derby db installed with jsc2 upd_1?thanks
[96 byte] By [mirianoe] at [2007-11-26 6:59:20]
# 1
HiWhat does java Studio creator 2 . Update 1 means ?what kind of client you mean ?do you need a cluent to create and manage your database ?
Legolasw at 2007-7-6 15:37:07 > top of Java-index,Development Tools,Java Tools...
# 2
yes,similarly poinbase manager for pointbase, release together in the old version of sun application server 8.1.I would want create schema or table with a simple gui...thanks
mirianoe at 2007-7-6 15:37:07 > top of Java-index,Development Tools,Java Tools...
# 3
Hi mirianoe,Unfortunately no GUI client exists for Derby. You can use the command-line tool, ij. Or you can execute SQL queries via Creator, by the way.Thanks, Misha(Creator team)
Mikhail_Matveev at 2007-7-6 15:37:07 > top of Java-index,Development Tools,Java Tools...
# 4
Ok, thanks
mirianoe at 2007-7-6 15:37:07 > top of Java-index,Development Tools,Java Tools...
# 5

This is a bit weak, don't you think? Studio Creator assumes that there is an existing database it can connect to, but it provides no tools whatsoever how this schema can be created.

Plain SQL/DDL is simply not satisfying. A GUI editor to create and manage tables and schemas is really desireable.

SkyScraper at 2007-7-6 15:37:07 > top of Java-index,Development Tools,Java Tools...
# 6
A few people are using this open source tool from sourceforge.net: http://sourceforge.net/projects/squirrel-sql/krysCreator Team
3431603 at 2007-7-6 15:37:07 > top of Java-index,Development Tools,Java Tools...
# 7
Also, a quick look on the Derby website turned up this list (see the GUI heading): http://wiki.apache.org/db-derby/UsesOfDerby
ChuckBing at 2007-7-6 15:37:07 > top of Java-index,Development Tools,Java Tools...
# 8
You need only create schema manually (one query: CREATE SCHEMA MY_SCHEMA), after that you can use Creator's query editor to manage tables and schemas.Thanks, Misha(Creator team)
Mikhail_Matveev at 2007-7-6 15:37:07 > top of Java-index,Development Tools,Java Tools...