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 <czu...@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-unsubscr...@ibatis.apache.org > For additional commands, e-mail: user-java-h...@ibatis.apache.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
