Return-Path: Delivered-To: apmail-cayenne-user-archive@www.apache.org Received: (qmail 25426 invoked from network); 23 Mar 2010 18:41:27 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 23 Mar 2010 18:41:27 -0000 Received: (qmail 33914 invoked by uid 500); 23 Mar 2010 18:41:27 -0000 Delivered-To: apmail-cayenne-user-archive@cayenne.apache.org Received: (qmail 33901 invoked by uid 500); 23 Mar 2010 18:41:27 -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 33886 invoked by uid 99); 23 Mar 2010 18:41:26 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 23 Mar 2010 18:41:26 +0000 X-ASF-Spam-Status: No, hits=2.9 required=10.0 tests=HTML_MESSAGE,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [208.123.79.45] (HELO outbound-b1.mx-route.com) (208.123.79.45) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 23 Mar 2010 18:41:16 +0000 X-MXTB-ROUTE2: outbound-B2 Received: from static-72-248-97-150.ny.onecommunications.net (HELO es-mail2.escholar.com) ([72.248.97.150]) by outbound-b1.mx-route.com with ESMTP; 23 Mar 2010 13:40:53 -0500 To: user@cayenne.apache.org MIME-Version: 1.0 Subject: Switching databases X-Mailer: Lotus Notes Release 8.0.1 February 07, 2008 Message-ID: From: MGargano@escholar.com Date: Tue, 23 Mar 2010 14:40:48 -0400 X-MIMETrack: Serialize by Router on es-mail2/escholar(Release 7.0|August 18, 2005) at 03/23/2010 02:40:50 PM, Serialize complete at 03/23/2010 02:40:50 PM Content-Type: multipart/alternative; boundary="=_alternative 00669C3C852576EF_=" --=_alternative 00669C3C852576EF_= Content-Type: text/plain; charset="US-ASCII" Hi, I'm looking into using Cayenne as a backend ORM technology replacing hibernate. Currently our product supports multiple DBMSes (SQL Server, Oracle, DB2) depending on what the client already has installed. In hibernate when switching between oracle and sql server, for example, is just a matter of changing the dialect. Is there a recommended way in Cayenne to generate models in a generic way so that the backend DBMS can be swapped out in code? (How is auto id generation effected? How are stored procs. handled? etc.) I only see articles related to running across multiple DBMSes. Thanks. -Mike --=_alternative 00669C3C852576EF_=--