Could you post your complete resultMap?
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: maandag 31 oktober 2005 20:41
To: [email protected]
Subject: error while using a CTH
Here is the error.
com.ibatis.dao.client.DaoException: Error executing query for list.
Cause: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in reporting/request/dao/ibatis/mapping/
Requests.xml.
--- The error occurred while applying a result map.
--- Check the requestResult.
--- Check the result mapping for the 'submitter' property.
--- Cause: java.sql.SQLException: statement handle not executed
Caused by: java.sql.SQLException: statement handle not executed
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in reporting/request/dao/ibatis/mapping/
Requests.xml.
--- The error occurred while applying a result map.
--- Check the requestResult.
--- Check the result mapping for the 'submitter' property.
--- Cause: java.sql.SQLException: statement handle not executed
Caused by: java.sql.SQLException: statement handle not executed
reporting.request.dao.ibatis.BaseSqlMapDao.executeQueryForList
(BaseSqlMapDao.java:34)
just another error
com.ibatis.dao.client.DaoException: Error executing query for list.
Cause: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in reporting/request/dao/ibatis/mapping/
Requests.xml.
--- The error occurred while applying a result map.
--- Check the requestResult.
--- The error happened while setting a property on the result object.
--- Cause: java.sql.SQLException: Closed Resultset: next
Caused by: java.sql.SQLException: Closed Resultset: next
Here is the CTh code
public Object getResult(ResultGetter getter) throws SQLException {
String value = getter.getString();
if(value == null)
return null;
log.debug("User Value : " + value);
User user;
try {
user = UserService.getInstance().getUser(value);
} catch (EmployeeNotFoundException e) {
log.error("COuld not find employee : " + value, e);
user = null;
}
return user;
}
and the sqlmap
<result property="submitter" column="submitter"
typeHandler="reporting.request.dao.ibatis.UserCustomTypeHandler"/>
I am at a loss here.
