You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by Mag Gam <ma...@gmail.com> on 2005/08/28 22:51:20 UTC
GUI for Derby
Is there a GUI for Derby, similar to what Cloudscape(Cloudview) had?
http://www-1.ibm.com/support/docview.wss?rs=636&context=SSCRVP&dc=D400&uid=swg24001379&loc=en_US&cs=UTF-8&lang=en
TIA!
Re: GUI for Derby
Posted by Daniel Noll <da...@nuix.com.au>.
Mag Gam wrote:
>Is there a GUI for Derby, similar to what Cloudscape(Cloudview) had?
>
>
>
I've used iSQL as a GUI for Derby in the past... it's more of a generic
JDBC GUI than a Derby-specific one, but it does work.
Daniel
--
Daniel Noll
NUIX Pty Ltd
Level 8, 143 York Street, Sydney 2000
Phone: (02) 9283 9010
Fax: (02) 9283 9020
This message is intended only for the named recipient. If you are not
the intended recipient you are notified that disclosing, copying,
distributing or taking any action in reliance on the contents of this
message or attachment is strictly prohibited.
Re: GUI for Derby
Posted by "Jean T. Anderson" <jt...@bristowhill.com>.
Jean T. Anderson wrote:
>... Also the Web Tools Project
> http://www.eclipse.org/webtools/ bundles derby (albeit 10.0) and even
> provides a tutorial that includes derby at
> http://www.eclipse.org/webtools/wst/components/rdb/RDBTutorial.html .
I misspoke on the "bundling" -- wtp does not include the derby jars. It
just includes the support for creating a 10.0 connection (which is
easily pointed at the 10.1 jars).
sorry for any confusion,
-jean
Re: GUI for Derby
Posted by "Jean T. Anderson" <jt...@bristowhill.com>.
Charlie Kelly wrote:
> ...
> Here is a "conservative" outline for configuring Eclipse + Hibernate +
> Derby;
> ...
> I intend to write an article that explains this process in the "near"
> future.
>
awesome! that'll be appreciated.
In the meantime, thanks for the details.
-jean
Re: GUI for Derby
Posted by Charlie Kelly <Ch...@CharlieKelly.com>.
I'd like to add something about Eclipse + Hibernate, since Charlie raves
about that (see
http://mail-archives.apache.org/mod_mbox/db-derby-user/200509.mbox/%3c4321CE26.2010700@CharlieKelly.com%3e
), but only if somebody has an URL handy that shows how to configure
that combination.
Here is a "conservative" outline for configuring Eclipse + Hibernate +
Derby;
(It is conservative in that there are alternative methods that use less
space).
1) Create a new Eclipse plugin (eg com.yourname.persistence)
2) Copy all jars for Hibernate and Derby to this plugin
3) Export these jars via plugin.xml (for this plugin)
4) If you want to use automatically generated build.xml, modify
build.properties to include jars from step 2
5) Beneath the "src" folder, create the persistent classes for your
application
You can include Hibernate annontations (using Hibernate v3.1) or
Xdoclet meta-information in these classes
6) Make this plugin available to other plugins in you application (via
dependencies their plugin.xml files)
Additionally you might choose to configure your plugin as a feature,
and possibly build an update site for the feature.
I intend to write an article that explains this process in the "near"
future.
Hope this helps.
Charlie
Re: GUI for Derby
Posted by "Jean T. Anderson" <jt...@bristowhill.com>.
Mamta Satoor wrote:
> It will be nice to put these GUI interfaces options in Derby FAQ.
Initially, I'm just trying to clean up the GUI tools links at
http://db.apache.org/derby/integrate/misc.html#Products+by+Type . Then
I'll add a link to that from the Derby FAQ.
Right now the summary page lists 3 products for GUI tools:
1) Eclipse
The Eclipse link is way old (Oct 2004). Since then, the Derby Plug-ins
have been added. Also the Web Tools Project
http://www.eclipse.org/webtools/ bundles derby (albeit 10.0) and even
provides a tutorial that includes derby at
http://www.eclipse.org/webtools/wst/components/rdb/RDBTutorial.html .
Anything more to say here?
I'd like to add something about Eclipse + Hibernate, since Charlie raves
about that (see
http://mail-archives.apache.org/mod_mbox/db-derby-user/200509.mbox/%3c4321CE26.2010700@CharlieKelly.com%3e
), but only if somebody has an URL handy that shows how to configure
that combination.
2) iSQL-Viewer
I haven't seen lots of posts about this on derby-user.
3) SQuirreL SQL
Lots of posts to derby-user indicate this works well.
anything else?
thanks,
-jean
Re: GUI for Derby
Posted by Charlie Kelly <Ch...@CharlieKelly.com>.
Hi Rajesh,
No, I didn't know about these.
Thanks
Charlie
Rajesh Kartha wrote:
> Charlie Kelly wrote:
>
>>
>> Derby inside Eclipse is easy. I made the transition by exchanging
>> the HSQL jar that I previously used, with the Derby jar.
>>
> Hi Charlie,
>
> Maybe you know about this, Derby comes as a plug-in for Eclipse and
> is available at the:
> http://db.apache.org/derby/releases/release-10.1.1.0.cgi#Distributions
>
> The Core provides all the Derby jars and the Ui provides the
> integration into Eclipse. In addition one can
> write their own plug-ins that uses only the Core as one its dependency
> plug-ins to use Derby for itself.
>
> Regards,
> Rajesh
>
>
>
Re: GUI for Derby
Posted by Rajesh Kartha <ka...@Source-Zone.Org>.
Charlie Kelly wrote:
>
> Derby inside Eclipse is easy. I made the transition by exchanging the
> HSQL jar that I previously used, with the Derby jar.
>
Hi Charlie,
Maybe you know about this, Derby comes as a plug-in for Eclipse and is
available at the:
http://db.apache.org/derby/releases/release-10.1.1.0.cgi#Distributions
The Core provides all the Derby jars and the Ui provides the integration
into Eclipse. In addition one can
write their own plug-ins that uses only the Core as one its dependency
plug-ins to use Derby for itself.
Regards,
Rajesh
Re: GUI for Derby
Posted by Charlie Kelly <Ch...@CharlieKelly.com>.
Jean,
Derby inside Eclipse is easy. I made the transition by exchanging the
HSQL jar that I previously used, with the Derby jar.
Hibernate presents some ClassLoader problems within Eclipse for a first
time user. However, separating classes that will be persisted into a
separate Eclipse plugin (that will be loaded) solves this problem.
I don't know of a handy list of setup instructions.
Charlie
>
>
> Charlie, I'm interested in what you say about Eclipse+Hibernate. How
> easy is this to do and have you encountered any problems? Do you know
> of a handy list of setup instructions anywhere?
>
> -jean
>
> Mamta Satoor wrote:
>
>> It will be nice to put these GUI interfaces options in Derby FAQ.
>>
>> Mamta
>>
>>
>> On 8/28/05, *Charlie Kelly* <Charlie@charliekelly.com
>> <ma...@charliekelly.com>> wrote:
>>
>> An excellent combination for Derby is Eclipse plus Hibernate.
>>
>> Eclipse provides a great GUI (SWT and JFace) while Hibernate
>> provides
>> object relational mapping to a Derby database.
>>
>> Eclipse can also serve as a Rich Client launch platform for your
>> application (open source, no royalties).
>> This is how I use Derby databases.
>>
>> There are several excellent GUI interfaces that use this combination
>> (see www.Hibernate.org <http://www.Hibernate.org>).
>>
>> Hope this helps.
>>
>> Charlie Kelly
>>
>>
>> Mag Gam wrote:
>>
>> >Is there a GUI for Derby, similar to what Cloudscape(Cloudview)
>> had?
>> >
>>
>> >http://www-1.ibm.com/support/docview.wss?rs=636&context=SSCRVP&dc=D400&uid=swg24001379&loc=en_US&cs=UTF-8&lang=en
>>
>>
>> <http://www-1.ibm.com/support/docview.wss?rs=636&context=SSCRVP&dc=D400&uid=swg24001379&loc=en_US&cs=UTF-8&lang=en>
>>
>> >
>> >TIA!
>> >
>> >
>> >
>> >
>> >
>>
>>
>
>
>
Re: GUI for Derby
Posted by "Jean T. Anderson" <jt...@bristowhill.com>.
Actually, there's a GUI category here and I could add a link to it from
the FAQ:
http://db.apache.org/derby/integrate/misc.html#Products+by+Type
Charlie, I'm interested in what you say about Eclipse+Hibernate. How
easy is this to do and have you encountered any problems? Do you know of
a handy list of setup instructions anywhere?
-jean
Mamta Satoor wrote:
> It will be nice to put these GUI interfaces options in Derby FAQ.
>
> Mamta
>
>
> On 8/28/05, *Charlie Kelly* <Charlie@charliekelly.com
> <ma...@charliekelly.com>> wrote:
>
> An excellent combination for Derby is Eclipse plus Hibernate.
>
> Eclipse provides a great GUI (SWT and JFace) while Hibernate provides
> object relational mapping to a Derby database.
>
> Eclipse can also serve as a Rich Client launch platform for your
> application (open source, no royalties).
> This is how I use Derby databases.
>
> There are several excellent GUI interfaces that use this combination
> (see www.Hibernate.org <http://www.Hibernate.org>).
>
> Hope this helps.
>
> Charlie Kelly
>
>
> Mag Gam wrote:
>
> >Is there a GUI for Derby, similar to what Cloudscape(Cloudview) had?
> >
> >http://www-1.ibm.com/support/docview.wss?rs=636&context=SSCRVP&dc=D400&uid=swg24001379&loc=en_US&cs=UTF-8&lang=en
> <http://www-1.ibm.com/support/docview.wss?rs=636&context=SSCRVP&dc=D400&uid=swg24001379&loc=en_US&cs=UTF-8&lang=en>
> >
> >TIA!
> >
> >
> >
> >
> >
>
>
Re: GUI for Derby
Posted by Mamta Satoor <ms...@gmail.com>.
It will be nice to put these GUI interfaces options in Derby FAQ.
Mamta
On 8/28/05, Charlie Kelly <Ch...@charliekelly.com> wrote:
>
> An excellent combination for Derby is Eclipse plus Hibernate.
>
> Eclipse provides a great GUI (SWT and JFace) while Hibernate provides
> object relational mapping to a Derby database.
>
> Eclipse can also serve as a Rich Client launch platform for your
> application (open source, no royalties).
> This is how I use Derby databases.
>
> There are several excellent GUI interfaces that use this combination
> (see www.Hibernate.org <http://www.Hibernate.org>).
>
> Hope this helps.
>
> Charlie Kelly
>
>
> Mag Gam wrote:
>
> >Is there a GUI for Derby, similar to what Cloudscape(Cloudview) had?
> >
> >
> http://www-1.ibm.com/support/docview.wss?rs=636&context=SSCRVP&dc=D400&uid=swg24001379&loc=en_US&cs=UTF-8&lang=en
> >
> >TIA!
> >
> >
> >
> >
> >
>
>
Re: GUI for Derby
Posted by Charlie Kelly <Ch...@CharlieKelly.com>.
An excellent combination for Derby is Eclipse plus Hibernate.
Eclipse provides a great GUI (SWT and JFace) while Hibernate provides
object relational mapping to a Derby database.
Eclipse can also serve as a Rich Client launch platform for your
application (open source, no royalties).
This is how I use Derby databases.
There are several excellent GUI interfaces that use this combination
(see www.Hibernate.org).
Hope this helps.
Charlie Kelly
Mag Gam wrote:
>Is there a GUI for Derby, similar to what Cloudscape(Cloudview) had?
>
>http://www-1.ibm.com/support/docview.wss?rs=636&context=SSCRVP&dc=D400&uid=swg24001379&loc=en_US&cs=UTF-8&lang=en
>
>TIA!
>
>
>
>
>
RE: GUI for Derby
Posted by Brett Dobbs <br...@5kraces.com>.
I have just started using SQuirreL SQL Client
http://squirrel-sql.sourceforge.net/. I like this over iSQL hands down,
especially when using the client driver.
Brett
-----Original Message-----
From: Mag Gam [mailto:magawake@gmail.com]
Sent: Sunday, August 28, 2005 3:51 PM
To: Derby Discussion
Subject: GUI for Derby
Is there a GUI for Derby, similar to what Cloudscape(Cloudview) had?
http://www-1.ibm.com/support/docview.wss?rs=636&context=SSCRVP&dc=D400&uid=s
wg24001379&loc=en_US&cs=UTF-8&lang=en
TIA!