Open source database

Thread view:

rajesh@solutionsoftware.com - 03 Jun 2005 07:01 GMT

Hi,
Is there any tool that is developed using Java that is free and is an
open source database which is relational in nature? I should be able to
write queries using joins, group by clause etc. I should be able to
access and query the data from the tables from an external application.

Apart from this, does SUN not provide with a database tool similar to
Microsoft Access 2000 (in windows) that gets installed by default when
MS Office is installed?

Kindly help.
Thanks in advance.
Regards,
Rajesh

Reply to this Message

Antti Karanta - 03 Jun 2005 07:14 GMT

> Is there any tool that is developed using Java that is free and is an
> open source database which is relational in nature?

http://hsqldb.sourceforge.net/

There are propably others as well, but I have been happy using hsqldb.
It is great especially for testing as it requires no installing - just
have the jar in your classpath.

-Antti-

Reply to this Message

Dyreatnews@sun.com - 03 Jun 2005 08:47 GMT

> Hi,
> Is there any tool that is developed using Java that is free and is an
> open source database which is relational in nature? I should be able to
> write queries using joins, group by clause etc. I should be able to
> access and query the data from the tables from an external application.

You could always try Derby:

http://incubator.apache.org/derby/

Signature

dt

However, experience shows that for many people and many applications a
dose of paranoia is reasonable - Bjarne Stroustrup

Reply to this Message

Roland Beuker - 03 Jun 2005 09:03 GMT

Derby is working very well!

>>Hi,
>>Is there any tool that is developed using Java that is free and is an
[quoted text clipped - 5 lines]
>
> http://incubator.apache.org/derby/

Reply to this Message

Lee Fesperman - 03 Jun 2005 18:13 GMT

> Is there any tool that is developed using Java that is free and is an
> open source database which is relational in nature? I should be able to
> write queries using joins, group by clause etc. I should be able to
> access and query the data from the tables from an external application.

It's not open source, but you might try FirstSQL/J ProLite --
http://www.firstsql.com/ProLiteoverview.shtml. It is freeware.

Signature

Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)

Reply to this Message

Volker - 20 Jun 2005 21:18 GMT

You can test SmallSQL http://www.smallsql.de. It implements some thinks to
make it easy to migrate from MS Access. This is helpful if you have
application is already write with MS Access.

Volker

Signature

http://www.smallsql.de - the 100% pure Java DBMS with JDBC interface for
desktop applications

> Hi,
> Is there any tool that is developed using Java that is free and is an
[quoted text clipped - 10 lines]
> Regards,
> Rajesh

Reply to this Message

Open source database

Free Magazines