ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From pczurak <CZU...@wsinc.com>
Subject Re: How Do I Change Schema
Date Thu, 13 Aug 2009 04:57:14 GMT

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