Return-Path: 
 <user-java-return-17651-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 88730 invoked from network); 1 Sep 2009 19:00:24 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 1 Sep 2009 19:00:24 -0000
Received: (qmail 33427 invoked by uid 500); 1 Sep 2009 19:00:23 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 33411 invoked by uid 500); 1 Sep 2009 19:00:23 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 33403 invoked by uid 99); 1 Sep 2009 19:00:23 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 01 Sep 2009 19:00:23 +0000
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of hh4ross@gmail.com designates
 209.85.211.182 as permitted sender)
Received: from [209.85.211.182] (HELO mail-yw0-f182.google.com)
 (209.85.211.182)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 01 Sep 2009 19:00:14 +0000
Received: by ywh12 with SMTP id 12so343047ywh.12
        for <user-java@ibatis.apache.org>;
 Tue, 01 Sep 2009 11:59:54 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:mime-version:received:in-reply-to:references
         :date:message-id:subject:from:to:content-type;
        bh=EzKtmgoJtY83srpw+DOmhUpIc6gM4oMh1g0/pomKvX8=;
        b=l9PXw4cN5YzcqJkttBthvteJvgXCIPZJ2G8NSd/E1gRXStbpEET531goVSmtKmXetX
         QllMcA+nIRXTxRHQN5/+z2zNpfgXHmaD3PPzdXQRAR32umo0BtCdLdlCil2tpSwk6LZu
         nBpya93GV0d6ltefbrsFEymKrjALB2XOlz7Hg=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=NHvCSZI9/BPcXlwP4EWJJcmj6IKZQ3jDpFHVbFzcY5vwRuSl5OhdNeE/TM/Q2y0cS8
         wxRT1vmIsxVNRP6SKbuWTibVcAvPxKatrhtzgpy44bkd0RVrHp3y6gB0mbxbqSDmVHiQ
         6xLRGniVC/y9V7GgsFOH61VKuie5InbB6GOCI=
MIME-Version: 1.0
Received: by 10.150.107.2 with SMTP id f2mr12162941ybc.188.1251831593319;
 Tue,
	01 Sep 2009 11:59:53 -0700 (PDT)
In-Reply-To: <25025072.post@talk.nabble.com>
References: <24948645.post@talk.nabble.com> <24954424.post@talk.nabble.com>
	 <c593b8750908130653r47a9bf8t61069fb33979bfa3@mail.gmail.com>
	 <24955435.post@talk.nabble.com> <25008285.post@talk.nabble.com>
	 <25018289.post@talk.nabble.com>
	 <OFD1E88356.98AF6410-ON65257616.001E483B-65257616.001E8792@in.ibm.com>
	 <25018874.post@talk.nabble.com>
	 <OF48B5F9EC.8243F70D-ON65257616.0020EBA8-65257616.002114B9@in.ibm.com>
	 <25025072.post@talk.nabble.com>
Date: Tue, 1 Sep 2009 14:59:53 -0400
Message-ID: <b929c7420909011159j67cdb85eifedbdbfbb1f13e42@mail.gmail.com>
Subject: Re: How Do I Change Schema
From: Hugh Ross <hh4ross@gmail.com>
To: user-java@ibatis.apache.org
Content-Type: text/plain; charset=ISO-8859-1
X-Virus-Checked: Checked by ClamAV on apache.org

Which type of Data Source do you use (e.g., JNDI or SIMPLE)?  For
SIMPLE, you can specify the schema on the connection URL, e.g.,

<property name="JDBC.ConnectionURL"
value="jdbc:db2://HOST:port/InstanceName:currentSchema=YourSchema;"/>

(Note: connection URL syntax varies some by database.)

For other Data Source types (e.g., when running under a J2EE
container), the admin tool usually provides a means to specify "custom
properties" for configuring Data Source properties.

Hope that helps...

On 8/18/09, pczurak <CZUPET@wsinc.com> wrote:
>
> Thanks that works!
>
>
> Not really!!!  The 'Current schema' register controls this, you can even
> change it by executing a 'SET CURRENT SCHEMA = XXX'
>
> http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.sql.ref.doc/doc/r0005877.html
>
> Mario
>
>
> --
> View this message in context: http://www.nabble.com/How-Do-I-Change-Schema-tp24948645p25025072.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
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org