Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
Date: Wed, 10 Oct 2007 08:59:19 -0700
From: Rick Hillegas <Richard.Hillegas@Sun.COM>
Subject: Re: Derby Workbench or other GUI
In-reply-to: <9268d1770710100624u2c734c71oe41b5fb38e64792e@mail.gmail.com>
Sender: Richard.Hillegas@Sun.COM
To: derby-dev@db.apache.org
Message-id: <470CF6D7.6060700@sun.com>
MIME-version: 1.0
Content-type: text/plain; format=flowed; charset=ISO-8859-1
Content-transfer-encoding: 7BIT
References: <9268d1770710100624u2c734c71oe41b5fb38e64792e@mail.gmail.com>
User-Agent: Thunderbird 2.0.0.6 (Macintosh/20070728)

Hi Siamak,

Some work has already gone into creating management tools for Derby. 
Please take a look at DERBY-1387. That issue describes a JMX-based 
scheme for managing Derby servers and databases. It would be great if 
you could piggyback your work on top of those JMX extensions. I think 
you will discover that the people working on the JMX beans are wrestling 
with (and solving) the same issues which you will need to face as you 
build a management gui.

Thanks,
-Rick

Siamak Sarmady wrote:
> Hello,
>
> Recently I was able to test Netbeans' JavaDB (derby) GUI tools and I
> should say it was a very enjoyable experience. But I also had some
> problems.
>
> - I normally create the database directory inside my program's
> directory and then use embedded driver to connect it.
>
> - Netbeans creates its directory in a specific place and it is
> difficult to change it to your own directory and back to its initial
> one every time. (to be able to manage several databases)
>
> - I want it to be able to manage different derby directories easily
> (in addition be able to manage/connect a databases using socket and
> TCP).
>
> Now, is there a GUI available which does all these things?
>
> If not then I might be interested in a project to build such a thing
> (like Netbeans' JavaDB interface but as a separate application which
> also handles mentioned issues easily).
>
> I appreciate if you can give me feedback on this.
>
> Regards,
> Mac
>