Using Hypersonic SQL for unit testing

["Alan D. Cabrera" <ad...@toolazydogs.com>]

I need a simple Java-based SQL database for my unit testing.  I was
thinking of using Hypersonic SQL but, not being a license wonk, don't
know if it's kosher.  I'm open to suggestions for alternatives
 
 
Regards,
Alan
 
 

Re: Using Hypersonic SQL for unit testing

[James Strachan <ja...@yahoo.co.uk>]

On 8 Nov 2003, at 04:01, Jeremy Boynes wrote:
> I was planning on using Hypersonic as well - the downside is that is 
> only
> supports read-uncommitted, but that may not be an issue for unit 
> testing.
>
> I am also considering Axion, which I had originally bypassed because 
> it's
> features page says it does not support subqueries, but James Strachan 
> now
> says are supported in head.

Alot of work has been done on Axion since its last release - expect an 
M3 release real soon (there's an M3-dev2.jar build on ibiblio available 
for now).

FWIW Axion is shortly moving to Apache at http://db.apache.org/. I can 
highly recommend Axion - its got a really clean & tidy codebase, nice 
functionality and a great set of unit tests. It will shortly be ASF 
licenced too.

James
-------
http://radio.weblogs.com/0112098/

RE: Using Hypersonic SQL for unit testing

[Jeremy Boynes <je...@coredevelopers.net>]

I was planning on using Hypersonic as well - the downside is that is only
supports read-uncommitted, but that may not be an issue for unit testing.

I am also considering Axion, which I had originally bypassed because it's
features page says it does not support subqueries, but James Strachan now
says are supported in head.

I do not think licensing is an issue if you are downloading via maven, and
there is no requirement to distribute a database with a certifed
implementation. If we do need one e.g. for configuration, then IIRC both
have ASF-friendly licenses.

--
Jeremy

> -----Original Message-----
> From: Alan D. Cabrera [mailto:adc@toolazydogs.com]
> Sent: Friday, November 07, 2003 6:44 PM
> To: geronimo-dev@incubator.apache.org
> Subject: Using Hypersonic SQL for unit testing
>
>
> I need a simple Java-based SQL database for my unit testing.  I was
> thinking of using Hypersonic SQL but, not being a license wonk, don't
> know if it's kosher.  I'm open to suggestions for alternatives
>
>
> Regards,
> Alan
>
>
>