You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Thanh PHAM <de...@pham.me> on 2009/08/18 11:56:10 UTC
ibatis 3 - standard string concatenation - double pipe
Hello,
We have to support many various DB like Oracle, MSSQL, Postgre in our
application and we want to use sql standard. However, MSSQL doesn't support
the *double **pipe** *character sequence || (standard) and use +
Does anyone know a solution to support sql concatenation (|| or +) in a
standard way with iBatis ?
Thanks in advance.
Re: ibatis 3 - standard string concatenation - double pipe
Posted by Clinton Begin <cl...@gmail.com>.
You could write a JDBC driver wrapper, that intercepts the call to execute.
Clinton
On Fri, Sep 25, 2009 at 8:41 AM, Thanh PHAM <de...@pham.me> wrote:
> Hi,
>
> I know your suggestion will work for almost situation. But my boss want to
> modify the sql before sending to DB in case where he can't pass it in
> parameter. Ex : a complex function.
>
> Do you a way to modify sql of iBatis ?
>
> I know it's sick but it's the boss.
>
> Thanks in advance.
>
>
> 2009/8/18 Clinton Begin <cl...@gmail.com>
>
>> Make it part of the parameter you pass in, and configure it in your app.
>>
>>
>> Clinton
>>
>> On 2009-08-18, Thanh PHAM <de...@pham.me> wrote:
>> > Hello,
>> >
>> > We have to support many various DB like Oracle, MSSQL, Postgre in our
>> > application and we want to use sql standard. However, MSSQL doesn't
>> support
>> > the *double **pipe** *character sequence || (standard) and use +
>> >
>> > Does anyone know a solution to support sql concatenation (|| or +) in a
>> > standard way with iBatis ?
>> >
>> > Thanks in advance.
>> >
>>
>> --
>> Sent from my mobile device
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
>> For additional commands, e-mail: user-java-help@ibatis.apache.org
>>
>>
>
>
Re: ibatis 3 - standard string concatenation - double pipe
Posted by Thanh PHAM <de...@pham.me>.
Hi,
I know your suggestion will work for almost situation. But my boss want to
modify the sql before sending to DB in case where he can't pass it in
parameter. Ex : a complex function.
Do you a way to modify sql of iBatis ?
I know it's sick but it's the boss.
Thanks in advance.
2009/8/18 Clinton Begin <cl...@gmail.com>
> Make it part of the parameter you pass in, and configure it in your app.
>
> Clinton
>
> On 2009-08-18, Thanh PHAM <de...@pham.me> wrote:
> > Hello,
> >
> > We have to support many various DB like Oracle, MSSQL, Postgre in our
> > application and we want to use sql standard. However, MSSQL doesn't
> support
> > the *double **pipe** *character sequence || (standard) and use +
> >
> > Does anyone know a solution to support sql concatenation (|| or +) in a
> > standard way with iBatis ?
> >
> > Thanks in advance.
> >
>
> --
> Sent from my mobile device
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>
Re: ibatis 3 - standard string concatenation - double pipe
Posted by Thanh PHAM <de...@pham.me>.
thanks Clinton,
2009/8/18 Clinton Begin <cl...@gmail.com>
> Make it part of the parameter you pass in, and configure it in your app.
>
> Clinton
>
> On 2009-08-18, Thanh PHAM <de...@pham.me> wrote:
> > Hello,
> >
> > We have to support many various DB like Oracle, MSSQL, Postgre in our
> > application and we want to use sql standard. However, MSSQL doesn't
> support
> > the *double **pipe** *character sequence || (standard) and use +
> >
> > Does anyone know a solution to support sql concatenation (|| or +) in a
> > standard way with iBatis ?
> >
> > Thanks in advance.
> >
>
> --
> Sent from my mobile device
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>
Re: ibatis 3 - standard string concatenation - double pipe
Posted by Clinton Begin <cl...@gmail.com>.
Make it part of the parameter you pass in, and configure it in your app.
Clinton
On 2009-08-18, Thanh PHAM <de...@pham.me> wrote:
> Hello,
>
> We have to support many various DB like Oracle, MSSQL, Postgre in our
> application and we want to use sql standard. However, MSSQL doesn't support
> the *double **pipe** *character sequence || (standard) and use +
>
> Does anyone know a solution to support sql concatenation (|| or +) in a
> standard way with iBatis ?
>
> Thanks in advance.
>
--
Sent from my mobile device
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org