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 04:37:14 GMT
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
>
>

Mime
View raw message