Re: GUI for Derby

["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

["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

["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

[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