I did, but I get Syntax errors in my SQL statements, so iBATES does not
understand ${schema}I don't know how or where to tell iBates to look in the properties file Clinton Begin wrote: > > Try the properties file you're using to configure the app... (specified in > the <properties...> element) > > On Wed, Aug 12, 2009 at 10:48 PM, pczurak <czu...@wsinc.com> wrote: > >> >> 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 <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 >> >> >> >> >> > >> > >> >> -- >> 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-unsubscr...@ibatis.apache.org >> For additional commands, e-mail: user-java-h...@ibatis.apache.org >> >> > > -- View this message in context: http://www.nabble.com/How-Do-I-Change-Schema-tp24948645p24948843.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
