Dhananjay Patkar

Hi,
Just check you comparing null against an object type. and not for primitive data type.
I have used isNull several times and it works fine....

Cheers,
Dhananjay

Hi David,
You raised good concern, but Please have a look @ iBatis 3 Whiteboard iBatis 3 has support for interface binding, thus eliminating string type query ids ,typecasting ..

Cheers,
Dhananjay

In my opinion,iBatis is kind of OQM (Object Query Mapping) ,while hibernate is complete ORM thus both cant be compared
But 1 thing is for sure is iBatis is much more simpler,easy to learn and gives you more freedom in terms of writting complex SQL queries...
Thats what my experience says..

Cheers,
Dhananjay

Hi,
When Ibatis loads sql-map-config.xml it not only parses sql-map-config, but along with it ,It also parses all mapping files listed in sqlmapconfig.xml
So scan through all possible files ,If any of them is malformed xml you will get parsing error...

Cheers,
Dhananjay

Hi Vishnu,
You need to provide a type handler in case of custom types such as enums
You need to write a class which will implement
com.ibatis.sqlmap.client.extensions.TypeHandlerCallback
and provide implementation for
public Object getResult(ResultGetter getter)throws SQLException
public void setParameter(ParameterSetter setter, Object parameter)throws SQLException

Here's a simple example of a boolean handler that uses "Yes" and "No":
public class YesNoBoolTypeHandlerCallback implements TypeHandlerCallback { private static final String YES = "Y"; private static final String NO = "N"; public Object getResult(ResultGetter getter) throws SQLException { String s = getter.getString(); if (YES.equalsIgnoreCase(s)) { return new Boolean (true); } else if (NO.equalsIgnoreCase(s)) { return new Boolean (false); } else { throw new SQLException ( "Unexpected value " + s + " found where " + YES + " or " + NO + " was expected."); } } public void setParameter(ParameterSetter setter, Object parameter) throws SQLException { boolean b = ((Boolean)parameter).booleanValue(); if (b) { setter.setString(YES); } else { setter.setString(NO); } } public Object valueOf(String s) { if (YES.equalsIgnoreCase(s)) { return new Boolean (true); } else if (NO.equalsIgnoreCase(s)) { return new Boolean (false); } else { throw new SQLException ( "Unexpected value " + s + " found where " + YES + " or " + NO + " was expected."); } }

Hi aditee,
It seems you are facing N+1 problem in iBatis...Which is fully solvable
Below code snipet will solve your problem
This is from iBatis Developer guide

<sqlMap namespace="ProductCategory"> <resultMap id=�categoryResult� class=�com.ibatis.example.Category� groupBy=�id�> <result property=�id� column=�CAT_ID�/> <result property=�description� column=�CAT_DESCRIPTION�/> <result property=�productList� resultMap=�ProductCategory.productResult�/> </resultMap> <resultMap id=�productResult� class=�com.ibatis.example.Product�> <result property=�id� column=�PRD_ID�/> <result property=�description� column=�PRD_DESCRIPTION�/> </resultMap> <select id=�getCategory� parameterClass=�int� resultMap=�categoryResult�> select C.CAT_ID, C.CAT_DESCRIPTION, P.PRD_ID, P.PRD_DESCRIPTION from CATEGORY C left outer join PRODUCT P on C.CAT_ID = P.PRD_CAT_ID where CAT_ID = #value# </select> </sqlMap> //When you call... List myList = queryForList("ProductCategory.getCategory", new Integer(1002));

myList is a List of beans containing type
"com.ibatis.example.Category". Each object in that List will have a "productList" property that is also a List
populated from the same query, but using the "productResult" result map to populate the beans in the child
list. So, you end up with a list containing sub-lists, and only one database query is executed and both child and parent list are get popultaed as expected..

Cheers,
Dhananjay

Hey,
You can try out dynamic sql in iBatis.
I hope that will solve your problem as long as ,the query you are firing is differs in where clause...

Cheers,
Dhananjay

Hey,
Use <selectKey> ibatis tag ,Then you will achieve what you are expecting.
Its child tag of <insert>.

Cheers,
Dhananjay