db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@debrunners.com>
Subject Re: User Defined Types
Date Wed, 10 Nov 2004 19:29:41 GMT
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.

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


View raw message