Return-Path: X-Original-To: apmail-cayenne-user-archive@www.apache.org Delivered-To: apmail-cayenne-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id E6D338028 for ; Fri, 12 Aug 2011 15:11:03 +0000 (UTC) Received: (qmail 46223 invoked by uid 500); 12 Aug 2011 15:11:03 -0000 Delivered-To: apmail-cayenne-user-archive@cayenne.apache.org Received: (qmail 46138 invoked by uid 500); 12 Aug 2011 15:11:03 -0000 Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cayenne.apache.org Delivered-To: mailing list user@cayenne.apache.org Received: (qmail 46125 invoked by uid 99); 12 Aug 2011 15:11:02 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 12 Aug 2011 15:11:02 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [208.78.103.231] (HELO vorsha.objectstyle.org) (208.78.103.231) by apache.org (qpsmtpd/0.29) with SMTP; Fri, 12 Aug 2011 15:10:55 +0000 Received: (qmail 19441 invoked from network); 12 Aug 2011 15:10:33 -0000 Received: from unknown (HELO ?192.168.1.94?) (194.158.197.10) by vorsha.objectstyle.org with SMTP; 12 Aug 2011 15:10:33 -0000 Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Apple Message framework v1084) Subject: Re: Coexisting with WebObjects From: Andrus Adamchik In-Reply-To: <8D02F4BA-1DEC-4BE8-B1E5-3AE53620E7CA@gmail.com> Date: Fri, 12 Aug 2011 18:10:31 +0300 Content-Transfer-Encoding: quoted-printable Message-Id: <694CD00D-A089-490D-9855-1201306AA7F8@objectstyle.org> References: <52825D07-D45C-46B7-8A5F-F6C680D4E889@gmail.com> <1E845F7C-04DF-471C-9840-6F6D3DF94637@gmail.com> <06A92B64-1A83-402D-91AB-5EA618A3E747@objectstyle.org> <8D02F4BA-1DEC-4BE8-B1E5-3AE53620E7CA@gmail.com> To: user@cayenne.apache.org X-Mailer: Apple Mail (2.1084) X-Virus-Checked: Checked by ClamAV on apache.org Of course. With AutoAdapter which is the default, this in theory is = configuration-free. In a real life you will need some extra effort to ensure that the = schemas are identical across DB's, your code doesn't rely on = functionality absent from some DBs (e.g. the data size exceeds column = size limits on some of them, or numeric data types support the same = precision). Things like that.... Andrus On Aug 12, 2011, at 6:02 PM, John Huss wrote: > Is it possible to run against two different databases without having = to manually change the model? So either switching at startup like with = properties or at runtime? >=20 > On Aug 12, 2011, at 12:26 AM, Andrus Adamchik = wrote: >=20 >>=20 >> On Aug 11, 2011, at 9:37 PM, Mike Kienenberger wrote: >>=20 >>>>=20 >>>> 3) are there DB specific plugins like EOF? >>>=20 >>> Yes, they are called Adaptors in Cayenne. But it seems to me that >>> they are not needed as much -- the generic adaptor works most of the >>> time. Maybe that's just because the jdbc interface and sql is more >>> standard now. But if you need it, it's there. >>=20 >> Modern versions of Cayenne by default use something called = AutoAdapter that detects the DB type on startup and internally installs = the right DB adapter. Actually there are more than a few runtime cases = where the adapter still matters. But yeah, the biggest area where the = adapter differences lie is DDL operations that is of no concern in = runtime. >>=20 >> Andrus >>=20 >=20