Ok, I suspect the problem is to do with my query. It's returning results like
this:
username | authority | description | authority
Maarten | ROLE_CUSTOMER | SPECIAL | ROLE_MANAGEMENT
Maarten | ROLE_CUSTOMER | SPECIAL | ROLE_XYZ
Maarten | ROLE_VISITOR | SPECIAL | ROLE_MANAGEMENT
Maarten | ROLE_VIS
Hi to all,
select * from Someone where name like 'a%'
this is in oracel
if i run this query i am getting only 3 records
for this query in ibatis
Select * from someone where UPPER(NAME) LIKE '%' ||
UPPER(#name#)||'%'
if i run this query i am getting all the result
Can you modify "name" to include %, instead of using it in the query?
#name# --> "%" + name + "%"
2009/9/23 HelpMePlz :
>
> Hi to all,
>
> select * from Someone where name like 'a%'
> this is in oracel
>
> if i run this query i am getting only 3 records
>
> for this query in ibatis
>
> Select
Or '%$name$%', but that opens up the vulnerability for sql injection
-Original Message-
From: Mikel sanchez [mailto:mikel.sanchez...@gmail.com]
Sent: 23 September 2009 02:08 PM
To: user-java@ibatis.apache.org
Subject: Re: like issue plz help me
Can you modify "name" to include %, inst
Not sure if I understand right but can't you just do...
select * from Someone where UPPER(name) like UPPER(#name# )
Then put the '%' in the actual name proerty value. As in String s =
"%nameParamValue%";
That's how I do my LIKE statements.
HelpMePlz wrote:
>
> Hi to all,
>
> select * from
I might be missing your question, but... Your ibatis query is
wildcarded on both sides versus your straight SQL one. Try removing
the first %.
On Wednesday, September 23, 2009, quinya wrote:
>
> Not sure if I understand right but can't you just do...
>
> select * from Someone where UPPER(name) l
I'm having a problem with cached stored procedures call, using null
parameters.
When I call a stored procedure like: "call user.some_sp(?,?)" I get the same
cacheKey for parameters: [1, null] and [null, 1]
I think that the problem is in class
com.ibatis.sqlmap.engine.exchange.BaseDataExchange on me
