derby schema

[karan malhi <ka...@gmail.com>]

How can i view the derby schema? is there a gui front-end which i can 
use? How do i start it the gui

-- 
Karan Singh

Re: derby schema

[karan malhi <ka...@gmail.com>]

Thanks Jean,

I know that Cloudscape had Cloudview as the gui tool. It was pretty 
convenient to use. Will try and look into dblook

Jean T. Anderson wrote:

> Craig Russell wrote:
>
>> Hi Karan,
>>
>> On Sep 4, 2005, at 3:04 PM, karan malhi wrote:
>>
>>> How can i view the derby schema?
>>
>>
>>
>> I use vi. The schema files (there are ten of them) are in directory 
>> test/sql/derby/{application}|{datastore}identity/schema*.sql
>
>
> If you don't have schema files readily available, the derby dblook 
> tool dumps the schema for a given database. More info is at 
> http://db.apache.org/derby/docs/10.1/tools/ctoolsdblook.html .
>
> Derby doesn't have any GUI tools, but a few that (seem to) work are 
> documented at http://db.apache.org/derby/integrate/misc.html . In 
> particular, I keep hearing really good things about SQuirreL SQL from 
> http://squirrel-sql.sourceforge.net/ . If you decide to look at this, 
> grab the new jar they made available that fixes a derby problem; see 
> http://sourceforge.net/mailarchive/forum.php?thread_id=7611732&forum_id=3116 
> .
>
>  -jean
>

-- 
Karan Singh

Re: derby schema

["Jean T. Anderson" <jt...@bristowhill.com>]

Craig Russell wrote:
> Hi Karan,
> 
> On Sep 4, 2005, at 3:04 PM, karan malhi wrote:
> 
>> How can i view the derby schema?
> 
> 
> I use vi. The schema files (there are ten of them) are in directory 
> test/sql/derby/{application}|{datastore}identity/schema*.sql

If you don't have schema files readily available, the derby dblook tool 
dumps the schema for a given database. More info is at 
http://db.apache.org/derby/docs/10.1/tools/ctoolsdblook.html .

Derby doesn't have any GUI tools, but a few that (seem to) work are 
documented at http://db.apache.org/derby/integrate/misc.html . In 
particular, I keep hearing really good things about SQuirreL SQL from 
http://squirrel-sql.sourceforge.net/ . If you decide to look at this, 
grab the new jar they made available that fixes a derby problem; see 
http://sourceforge.net/mailarchive/forum.php?thread_id=7611732&forum_id=3116 
.

  -jean

Re: derby schema

[Craig Russell <Cr...@Sun.COM>]

Hi Karan,

On Sep 4, 2005, at 3:04 PM, karan malhi wrote:

> How can i view the derby schema?

I use vi. The schema files (there are ten of them) are in directory  
test/sql/derby/{application}|{datastore}identity/schema*.sql

> is there a gui front-end which i can use?

Not that I'm aware of.

> How do i start it the gui


>
> -- 
> Karan Singh
>
>

Craig Russell
Architect, Sun Java Enterprise System http://java.sun.com/products/jdo
408 276-5638 mailto:Craig.Russell@sun.com
P.S. A good JDO? O, Gasp!