You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@geronimo.apache.org by Jeremy Boynes <jb...@gluecode.com> on 2004/10/01 10:15:39 UTC
Derby embedded in Geronimo
For those interested, I have begun a simple embedding of Derby into
Geronimo allowing it to act as the SystemDatabase for functions such as
persistent timers etc. It is also generally bound as a local-transaction
resource for use by applications.
If things work out well and there are no objections I plan to switch
away from Axion as our default embedded database.
Before then, there are a couple of things that need to be done if anyone
is interested in participating:
* GBean wrapper for NetworkServiceControl
* verification of XA support and recovery
* switch connector to use DataSource internally rather than
the DriverManager
* expose database properties to JMX via GBean wrapper
* operations to create/delete databases & other adminy things
I'll add these to the Geronimo Jira as enhancements.
Thanks to the Derby team for giving us the chance to use it.
--
Jeremy
Re: Derby embedded in Geronimo
Posted by Kathey Marsden <km...@Sourcery.Org>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
> Before then, there are a couple of things that need to be done if anyone
> is interested in participating:
> * GBean wrapper for NetworkServiceControl
> * verification of XA support and recovery
> * switch connector to use DataSource internally rather than
> the DriverManager
> * expose database properties to JMX via GBean wrapper
> * operations to create/delete databases & other adminy things
>
Just thought I would mention that while we do have XA support for
Cloudscape embedded, we don't have it yet for Network Server. I am
currently working on XA support for Network Server.
Thanks
Kathey
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFBXYd6G0h36bFmkocRAkjUAJ43/qQ8u1XUGMFbp/q0VYZunu7b5QCbBgQS
F+ntwtXJkoElq9Vp1Flo4zs=
=+tT0
-----END PGP SIGNATURE-----
RE: Derby embedded in Geronimo
Posted by Rodney Waldhoff <rw...@apache.org>.
On Fri, 1 Oct 2004, Noel J. Bergman wrote:
> Jeremy Boynes wrote:
>
>> If things work out well and there are no objections I plan
>> to switch away from Axion as our default embedded database.
>
> Obvious question would be why. Seems as if there are some technical
> reasons. As I understand them, totally hearsay, they are:
>
> Axion: faster startup time,
> great for unit testing
> each transaction has its own copy of data
> Oracle compatible SQL dialect (sequences, etc.)
> ~400K
>
> Derby: XA support
> multiple concurrent users
> transactions use locking
> DB2 compatible SQL dialect
> ~3MB
>
> Is that correct? Anything else? Both are good, but with some differences,
> so it might be helpful to have a comparison matrix if there are knowledgable
> people who would contribute to it.
>
I know this is an old thread, but just to clear up any misconceptions:
(1) Axion supports multiple concurrent users
(2) Axion supports "snapshot isolation" transactions, which sorta acts
like "each tranaction has its own copy of data", but that's not really
what's going on. Oracle and PostgreSQL also support snapshot isolation,
among others.
> --- Noel
RE: Derby embedded in Geronimo
Posted by "Noel J. Bergman" <no...@devtech.com>.
Jeremy Boynes wrote:
> If things work out well and there are no objections I plan
> to switch away from Axion as our default embedded database.
Obvious question would be why. Seems as if there are some technical
reasons. As I understand them, totally hearsay, they are:
Axion: faster startup time,
great for unit testing
each transaction has its own copy of data
Oracle compatible SQL dialect (sequences, etc.)
~400K
Derby: XA support
multiple concurrent users
transactions use locking
DB2 compatible SQL dialect
~3MB
Is that correct? Anything else? Both are good, but with some differences,
so it might be helpful to have a comparison matrix if there are knowledgable
people who would contribute to it.
--- Noel