I tried $schema$, but getting the following error.
Cause: com.ibatis.common.beans.ProbeException: There is no READABLE property
named 'schema' in class 'com.wsinc.control.model.proddta.Control'; nested
exception is com.ibatis.common.jdbc.exception.NestedSQLException:
So it seems $schema$ should work, but I don't know where to define it, what
file or what section.
Would it go in the applicationContext.xml file, but what section?
Clinton Begin wrote:
>
> Sorry... iBATIS 2...
>
>
> $schema$
>
> On Wed, Aug 12, 2009 at 10:57 PM, pczurak <czu...@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 <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
>>
>>
>
>
--
View this message in context:
http://www.nabble.com/How-Do-I-Change-Schema-tp24948645p24954424.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
