Sorry correcting myself: in this case you might have to pass it in as a parameter.  I don't think the SQL statements themselves count in the application of properties.

Clinton

On Wed, Aug 12, 2009 at 10:52 PM, Clinton Begin <clinton.begin@gmail.com> 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