Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Development" <derby-dev@db.apache.org>
Received-SPF: pass (hermes.apache.org: local policy includes SPF record at
 spf.trusted-forwarder.org)
Message-ID: <41926C25.6010804@debrunners.com>
Date: Wed, 10 Nov 2004 11:29:41 -0800
From: Daniel John Debrunner <djd@debrunners.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
 rv:1.4.1) Gecko/20031008
MIME-Version: 1.0
To: Derby Development <derby-dev@db.apache.org>
Subject: Re: User Defined Types
References: <4192277A.1010907@panix.com>
In-Reply-To: <4192277A.1010907@panix.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Rick Strong wrote:

> Greetings,
>
> Sorry to nag, but recently I posed a question fairly recently as to
> whether Cloudscapes user defined types would be re-implemented in Derby,
> as IBM seems to have pulled support for this feature out, presumably to
> bring it more in line with DB2. I haven't heard anything so far - can
> anyone advise as to whether there is any work being done on this?

There has been some earlier discussion on this, check the archive.

Note that Cloudscape's implementation of user defined types as Java
types is proprietary and (as you have found) will lock any application
into a Cloudscape database solution. After Cloudscape implemented their
Java user defined type system, Java types in SQL were standardized in
part 13 of the SQL standard.

It's also interesting to note that Java types in SQL has not been widely
adopted, the current trend seems to be for OR mappers, like Hibernate or
EJBs. In eight years of working with Cloudscape, we did not come up with
a compelling use of Java objects stored in the database.


Dan.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFBkmwlIv0S4qsbfuQRAoV3AJ4mFFMmCPPHF9XRJRoBiYd8eCfSdwCeKgNk
1YBzsmRMqs5wP4pfiv9aEOI=
=cIIY
-----END PGP SIGNATURE-----