Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 36080 invoked from network); 13 Aug 2009 04:48:29 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 13 Aug 2009 04:48:29 -0000 Received: (qmail 5922 invoked by uid 500); 13 Aug 2009 04:48:35 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 5854 invoked by uid 500); 13 Aug 2009 04:48:35 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 5846 invoked by uid 99); 13 Aug 2009 04:48:35 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 13 Aug 2009 04:48:35 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates 216.139.236.158 as permitted sender) Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 13 Aug 2009 04:48:25 +0000 Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1MbSEO-0001JD-Rl for user-java@ibatis.apache.org; Wed, 12 Aug 2009 21:48:04 -0700 Message-ID: <24948782.post@talk.nabble.com> Date: Wed, 12 Aug 2009 21:48:04 -0700 (PDT) From: pczurak To: user-java@ibatis.apache.org Subject: Re: How Do I Change Schema In-Reply-To: <16178eb10908122137r2835b3fepadc72f47bdd202ce@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: CZUPET@wsinc.com References: <24948645.post@talk.nabble.com> <16178eb10908122137r2835b3fepadc72f47bdd202ce@mail.gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org I've seen this post http://www.mail-archive.com/user-java@ibatis.apache.org/msg09212.html http://www.mail-archive.com/user-java@ibatis.apache.org/msg09212.html But it does not explain what file or where, so I though maybe someone in this forum would know. Clinton Begin wrote: > > I suggest you remove the specific schema and log in as the appropriate > user > and use the appropriate schema. This can be specified in your JDBC URL. > > But if they're hard coded as you have below... then you're in for some > Search and Replace. > > clinton > > On Wed, Aug 12, 2009 at 10:26 PM, pczurak wrote: > >> >> I am using iBATIS 2.1 >> >> My question is how do I change Schema name for DB2 database? >> >> Schema.tablename >> >> ex: Select * from TEST.Payroll Payroll where amount > 100 >> change to >> Select * from PRODUCTION.Payroll Payroll where amount > 100 >> >> What file and what parameters/properties do I have to change / add so I >> can >> change the schema without changing all of the XML files ? >> >> >> Thank You >> >> >> Peter >> -- >> View this message in context: >> http://www.nabble.com/How-Do-I-Change-Schema-tp24948645p24948645.html >> Sent from the iBATIS - User - Java mailing list archive at Nabble.com. >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org >> For additional commands, e-mail: user-java-help@ibatis.apache.org >> >> > > -- View this message in context: http://www.nabble.com/How-Do-I-Change-Schema-tp24948645p24948782.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org For additional commands, e-mail: user-java-help@ibatis.apache.org