From derby-dev-return-421-apmail-db-derby-dev-archive=db.apache.org@db.apache.org Mon Sep 20 16:26:57 2004 Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 74602 invoked from network); 20 Sep 2004 16:26:56 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 20 Sep 2004 16:26:56 -0000 Received: (qmail 30601 invoked by uid 500); 20 Sep 2004 16:26:22 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 30507 invoked by uid 500); 20 Sep 2004 16:26:21 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: List-Id: Reply-To: "Derby Development" Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 30484 invoked by uid 99); 20 Sep 2004 16:26:21 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=FORGED_RCVD_HELO X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy includes SPF record at spf.trusted-forwarder.org) Received: from [66.163.168.180] (HELO smtp801.mail.sc5.yahoo.com) (66.163.168.180) by apache.org (qpsmtpd/0.28) with SMTP; Mon, 20 Sep 2004 09:26:19 -0700 Received: from unknown (HELO debrunners.com) (ddebrunner@sbcglobal.net@64.173.20.47 with plain) by smtp801.mail.sc5.yahoo.com with SMTP; 20 Sep 2004 16:26:17 -0000 Message-ID: <414F04A3.80603@debrunners.com> Date: Mon, 20 Sep 2004 09:26:11 -0700 From: Daniel John Debrunner User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4.1) Gecko/20031008 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Development Subject: Re: Integrating Derby and Hibernate References: <200409181753.51766.Joel.Rosi-Schwartz@Etish.org> In-Reply-To: <200409181753.51766.Joel.Rosi-Schwartz@Etish.org> X-Enigmail-Version: 0.76.8.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enigC2DA76ACDFF31D227973F5CA" X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enigC2DA76ACDFF31D227973F5CA Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Joel Rosi-Schwartz wrote: > > First, though, I think that it might interest the Derby community to know that > there is now a DerbyDialect for Hibernate. It was contributed by Simon > Johnston and can be found at > http://opensource.atlassian.com/projects/hibernate/browse/HB-1224. While this > is not yet an official part of the Hibernate release, I have been pounding on > it pretty hard for the past two days and I am satisfied that it is good > enough for me to start writing code against. It will probably mature when the > Hibernate team gets to looking at Derby officially. I believe that they are > waiting for an official release from Apache. Personally I think it would be a > nice if someone from the team officially contacted Gavin to form a working > relationship. IMHO, having a sound integration would be a real win-win > proposition. > > My environment is Cloudscape 10 beta, Hibernate 2.1.6 and Java 1.4.2_04, > running on w2k. That's great to have the initial Hibernate/Derby integration. Pre-built jars are now available on the Derby site so I hope the integration will use the Derby driver and JDBC URL names, rather than the temporary names from tech preview (beta) IBM Cloudscape release. > The issue is the length limitation of 18 characters that Derby imposes on > foreign key constraint names. This is not an issues if one is writing a new > schema, but existing schemas and hibernate's auto generation of FK names do > cause a problem. Is there anyway to adjust this dynamically (I rather doubt > it) or is this essentially a enhancement request? The IBM Cloudscape > Reference Manual indicates that a similar 18 character limit applies to > index, function and trigger names. Are these also areas that might cause > portability issues? This would be a enhancement request, internally Derby can support up to 128 characters for identifiers. In the mean time can Hibernate address the issue as it does for DB2 (assuming it does :-), since DB2 has the same limits? Dan. --------------enigC2DA76ACDFF31D227973F5CA Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFBTwSkIv0S4qsbfuQRArTpAKDGKNyQeRnz1HBoz/CkFkNgKlwxNwCfaLxD sNzWCHYMz7IcGp9EWMO+wHw= =IUvg -----END PGP SIGNATURE----- --------------enigC2DA76ACDFF31D227973F5CA--