Cloudscape-derby admin tool

Hi all,
is there anyone that knows an easy tool for managing a Cloudscape-Derby 10
DB?

i need something that helps me to build tables, views and procedures....

Is there some tools that can do this?

Thanks.

Mario

_Mario_ wrote:
> Hi all,
> is there anyone that knows an easy tool for managing a Cloudscape-Derby 10
> DB?
>
> i need something that helps me to build tables, views and procedures....
>
> Is there some tools that can do this?
>
> Thanks.
>
>  Mario
>
>
You could try *squirrel-sql*. I think if you have the jdbc driver for
the Cloudscape-Derby 10 DB, you could use this freebie. It is nice. Just
define the drive to the IDE.
>

http://squirrel-sql.sourceforge.net/

--


Thanks in Advance...
IchBin
 ________________________________________
__________________________________

'Laughter is inner jogging'
- Norman Cousins, editor and author (1915-1990)

"IchBin" <weconsul@ptd.net> wrote in message
news:89CdnSVeP62HoMbcUSdV9g@ptd.net...
> _Mario_ wrote: 
> You could try *squirrel-sql*. I think if you have the jdbc driver for the
> Cloudscape-Derby 10 DB, you could use this freebie. It is nice. Just
> define the drive to the IDE. 
>
>  http://squirrel-sql.sourceforge.net/
>
> --
Thanks,
I'm going to see it.

Mario

"IchBin" <weconsul@ptd.net> wrote in message
news:89CdnSVeP62HoMbcUSdV9g@ptd.net...
> _Mario_ wrote: 
> You could try *squirrel-sql*. I think if you have the jdbc driver for the
> Cloudscape-Derby 10 DB, you could use this freebie. It is nice. Just
> define the drive to the IDE. 
>
>  http://squirrel-sql.sourceforge.net/
>
> --
>
I've looked at squirrel... is there a way to make it create automaGically
the SQL for Creating and altering tables?

M

_Mario_ wrote:
> "IchBin" <weconsul@ptd.net> wrote in message
> news:89CdnSVeP62HoMbcUSdV9g@ptd.net...
> 
>
> I've looked at squirrel... is there a way to make it create automaGically
> the SQL for Creating and altering tables?
>
> M
>
>
Don't think it does. It makes the assumption that you know SQL.
Off-the-top don't now of that type of product. Except programming
interfaces for object/relational persistence and query products. Say
like Hibernate. But then do not think they do any DBA type admin
functions. Maybe someone else would know.

It's really not that bad if you work with databases.

--


Thanks in Advance...
IchBin
 ________________________________________
__________________________________

'Laughter is inner jogging'
- Norman Cousins, editor and author (1915-1990)

"IchBin" <weconsul@ptd.net> wrote in message
news:FFudnZtgF6NxksHcUSdV9g@ptd.net...
> _Mario_ wrote: 
> Don't think it does. It makes the assumption that you know SQL.

OK

> Off-the-top don't now of that type of product. Except programming
> interfaces for object/relational persistence and query products. Say like
> Hibernate. But then do not think they do any DBA type admin functions.
> Maybe someone else would know.

right...

> It's really not that bad if you work with databases.

You're right.

Thanks again.

Mario

_Mario_ wrote:
> "IchBin" <weconsul@ptd.net> wrote in message
> news:FFudnZtgF6NxksHcUSdV9g@ptd.net...
> 
>
>
> OK
>
> 
>
>
> right...
>
> 
>
>
> You're right.
>
> Thanks again.
>
>  Mario
>
>
Just realized that Netbeans has a database interface that lets you do
the things you want to do.. If you just need it for the database part,
the learning cure for the IDE will not be much at all.

Once you install.. open IDE then select menu windows > Runtime

In the runtime tab right click > Drivers > Add Driver

I have not created an initial database with this tool! You may need to
do that with the Cloudscape-derby product. I would be doing your
searches at IBM for Cloudscape for detailed information.

Once you have the database created you can do all of the things you want
to do.

Beta v2 was just released ..

http://www.netbeans.org/downloads/index.html

--


Hope this helps...
IchBin
 ________________________________________
__________________________________

'Laughter is inner jogging'
- Norman Cousins, editor and author (1915-1990)

IchBin wrote:
> _Mario_ wrote:
> 
> Just realized that Netbeans has a database interface that lets you do
> the things you want to do.. If you just need it for the database part,
> the learning cure for the IDE will not be much at all.
>
> Once you install.. open IDE then select menu windows > Runtime
>
> In the runtime tab right click > Drivers > Add Driver
>
> I have not created an initial database with this tool! You may need to
> do that with the Cloudscape-derby product. I would be doing your
> searches at IBM for Cloudscape for detailed information.
>
> Once you have the database created you can do all of the things you want
> to do.
>
> Beta v2 was just released ..
>
> http://www.netbeans.org/downloads/index.html
>
Sorry... Just saw this:

" In August, IBM contributed its Cloudscape Java database to the Apache
Software Foundation as an open source project. "

at http://www.devx.com/IBMCloudscape/A...rk=DXRSS_LATEST

So apache Software Foundation maybe your best resource.

--


Thanks in Advance...
IchBin
 ________________________________________
__________________________________

'Laughter is inner jogging'
- Norman Cousins, editor and author (1915-1990)