ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeff Butler <jeffgbut...@gmail.com>
Subject Re: How Do I Change Schema
Date Thu, 13 Aug 2009 13:53:47 GMT
You can't do this with a properties file.  You'll have to make
$schema$ a property of your parameter object.

At one point we talked about adding syntax for accessing properties in
SQL statements for iBATIS3, but it did not get implemented.  Then we
would have had something like this:

#{...} use bean properties as parameters
${...} use bean properties for string substitution
?{...} use system properties for string substitution

I don't remember if we thought this was too complex to implement, or
too confusing to use, or if we just forgot to do it.

Jeff Butler


On Thu, Aug 13, 2009 at 9:31 AM, pczurak<CZUPET@wsinc.com> wrote:
>
> 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 <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
>>>
>>>
>>
>>
>
> --
> 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-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>

---------------------------------------------------------------------
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