Search:

Hi,
Thnx for the suggestion will give that a shot too. I tried the following

<select id="searchLike" parameterClass="java.lang.String" resultClass="Test.model.TEMP_EMP_DO" >
select * from...

thnx dude... was trying the following

like '%'+#EMPID#+'%'

so just added the '%' on either side of the string to search and passed as a parameter.

thnx once again....

hey buddy thnx... had to correct the appcontext xml.

any ideas how to use the like clause in the sqlMap. have tried all sorts ofsolutiond but in vain...

Priya

Hi,
1)Has anybody used Ibatis on WSAD 5.1 (WebSphere Studio Application Developer)? I have downloaded and used Ibatis on Eclipse and it works fine. Though WSAD works on Eclipse technology am not...

thnx buddy but it didnt help :( i get the following error:
The data type of an operand of an arithmetic function or operation "+" is not numeric. SQLSTATE=42819

hi,

I have a question: I am trying to use the LIKE clause in the query and I do not get any result. I tried the following ways but in vain.

1)
<select id="searchSelect"...

Hi,
Ibexx is rt the header of the config file needs to be changed.

I have a question: I am trying to use the LIKE clause in the query and I do not get any result. I tried the following ways but...

hey thnx rasool,
the prob was I was using Abator's file. Abator generates a config file which is used to generate the Java objects, map.xml & DAO's. The SQL config file has to be written seperately....

Hi,
I'm new to ibatis and am using Abator. Am facing the same problem, I have written a very simple client to read the SQL map generated by abator. I keep getting the following error. Please help. ...