ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clinton Begin <clinton.be...@gmail.com>
Subject Re: How Do I Change Schema
Date Thu, 13 Aug 2009 12:49:41 GMT
Sorry... iBATIS 2...


$schema$

On Wed, Aug 12, 2009 at 10:57 PM, pczurak <CZUPET@wsinc.com> wrote:

>
> 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 <CZUPET@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 <CZUPET@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-unsubscribe@ibatis.apache.org
> >> >> For additional commands, e-mail: user-java-help@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-unsubscribe@ibatis.apache.org
> >> For additional commands, e-mail: user-java-help@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-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>

Mime
View raw message