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 16:32:52 GMT

I am sorry, I am very new to iBates, I do not know what this means

"You'll have to make
$schema$ a property of your parameter object. "

how do I do this, can you point me to an example?




Jeff Butler-2 wrote:
> 
> 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
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/How-Do-I-Change-Schema-tp24948645p24955435.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