ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From François Schiettecatte <fschietteca...@gmail.com>
Subject Re: Dynamic table replacement possible in iBatis3 ?
Date Thu, 08 Apr 2010 18:13:17 GMT
Nathan

Good point, I knew about it (and used it) but it slipped my mind.

Cheers

François

On Apr 8, 2010, at 11:39 AM, Nathan Maves wrote:

> You are only half correct.  The format that you just used as an
> example is only for parameters.  He is looking for the string
> substitution which also changed.
> 
> #{foo} == jdbc set parameter
> ${foo} == string substitution before the prepared statement
> 
> Nathan
> 
> 2010/4/7 François Schiettecatte <fschiettecatte@gmail.com>:
>> The format did change, here is the new format:
>> 
>>        <select id="selectCountBySourceKey" parameterType="String" resultType="Integer">
>> 
>>                /* contents.Content.selectCountBySourceKey */
>>                SELECT  COUNT(*)
>>                FROM    contents
>>                WHERE   source_key = #{value}
>> 
>>        </select>
>> 
>> 
>> François
>> 
>> On Apr 7, 2010, at 5:54 PM, Niels Beekman wrote:
>> 
>>> In iBATIS 2, you would use ${value}. Maybe this still holds for version 3?
>>> 
>>> Niels
>>> 
>>> On 7 April 2010 16:46, Joram Barrez <joram.barrez@gmail.com> wrote:
>>> Hi All,
>>> 
>>> I was wondering if this is possible with iBatis 3:
>>> 
>>> <select id="selectTableCount" parameterType="string" resultType="long" >
>>>    select count(*) from ${tableName}
>>> </select>
>>> 
>>> The problem is that the string ${tableName} is not replaced by the
>>> parameter, leadin to a 'select count(*) from null' at runtime.
>>> Am I doing something wrong here or is this feature not yet implemeted
>>> (as it worked on iBatis2 according to Google)?
>>> 
>>> 
>>> Regards,
>>> 
>>> Joram
>>> 
>>> ---------------------------------------------------------------------
>>> 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
>> 
>> 
> 
> ---------------------------------------------------------------------
> 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