Return-Path: Delivered-To: apmail-cayenne-user-archive@www.apache.org Received: (qmail 18254 invoked from network); 19 Jul 2007 07:41:33 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 19 Jul 2007 07:41:33 -0000 Received: (qmail 40629 invoked by uid 500); 19 Jul 2007 07:41:14 -0000 Delivered-To: apmail-cayenne-user-archive@cayenne.apache.org Received: (qmail 40380 invoked by uid 500); 19 Jul 2007 07:41:13 -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 40371 invoked by uid 99); 19 Jul 2007 07:41:13 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 19 Jul 2007 00:41:13 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of malcolm.edgar@gmail.com designates 64.233.162.236 as permitted sender) Received: from [64.233.162.236] (HELO nz-out-0506.google.com) (64.233.162.236) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 19 Jul 2007 00:41:09 -0700 Received: by nz-out-0506.google.com with SMTP id f1so1205607nzc for ; Thu, 19 Jul 2007 00:40:49 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=rdEoGY96NAP5HuRasSaUEP7Yi1c6PKS6p3hu6ANKBC0RQhMxIV36ECfgTvC8PIewR8rwJnVQQNxhftCdqq37+uvVMaSRczoXW/5aYux3K55ZVMgGvYeBiSMsDYAryA0N+X5QQT3pLTGFMzXAmTXE+47iScS5JZENUbmgfQxjj7s= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=I45bBPS3l4CFFRyHcBZceD1SKF2PQrbHQa0r/5usA6GgOHLgJGJrCjf1fqQrORCRQOZLqubWQns3kAXiolyb1vT2LIn74474xGd6ksOxV6acg1YLYovUT/kYCYcJkx1lfFWENQOWuQrJZ9XOj4vuMuM+kQzbHjwUqOzVUOZNaEo= Received: by 10.142.79.15 with SMTP id c15mr108016wfb.1184830848637; Thu, 19 Jul 2007 00:40:48 -0700 (PDT) Received: by 10.142.103.18 with HTTP; Thu, 19 Jul 2007 00:40:48 -0700 (PDT) Message-ID: <525d8e10707190040m451bf2fayd5a79541afdd2706@mail.gmail.com> Date: Thu, 19 Jul 2007 17:40:48 +1000 From: "Malcolm Edgar" To: user@cayenne.apache.org Subject: Re: Switching Between Databases In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_115803_12871076.1184830848617" References: <525d8e10707181923l5315cc9aw540ea489e7470b20@mail.gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_115803_12871076.1184830848617 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Thanks I will give it a try. regards Malcolm Edgar On 7/19/07, Andrus Adamchik wrote: > > > > My concern it that the > > schema name is defined in the cayenne mapping file. > > AFAIK MySQL schema is the same as "database name" part of the URL, so > use an empty schema and change connection URL. > > Andrus > > > > On Jul 19, 2007, at 5:23 AM, Malcolm Edgar wrote: > > > Hi All, > > > > what is an easy way to switch between databases in Cayenne, while > > maintaining the same mapping file. > > > > We are going on the road doing demos, with different MySQL > > databases (same > > schema design), and want to be able to switch between them with the > > same > > application. Is there an way to do this is Cayenne. My concern it > > that the > > schema name is defined in the cayenne mapping file. > > > > Any ideas? > > > > regards Malcolm Edgar > > ------=_Part_115803_12871076.1184830848617--