ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hugh Ross <hh4r...@gmail.com>
Subject Re: How Do I Change Schema
Date Tue, 01 Sep 2009 18:59:53 GMT
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


Mime
View raw message