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