Hi All,
I am getting the following error when calling an Update. I can see UserDTO is passes properly with data. May be declaration is not right ?
Error
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/ml/camsweb/resources/User.xml.
--- The error occurred while applying a parameter map.
--- Check the update-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0SL: Unsupported SQL type 0.
Caused by: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0SL: Unsupported SQL type 0.
Update
public void update(UserDTO userDTO) throws SQLException {
try {
sqlMapCams.startTransaction();
sqlMapCams.update("update",userDTO);
sqlMapCams.commitTransaction();
} finally{
sqlMapCams.endTransaction();
}
}
User.XML
<typeAlias alias="UserObject" type="com.ml.camsweb.dto.UserDTO"/>
<update id="update" parameterClass="UserObject">
UPDATE users
SET
first_name = #firstName#,
last_name = #lastName#,
phone = #phone#,
fax = #fax#,
e_mail = #email#,
location = #location#,
address1 = #address1#,
address2 = #address2#,
city = #city#,
state = #state#,
zip = #zip#,
password = #password#,
password_last_updated = #password_last_updated#
WHERE user_id = #userId#
</update>
Thanks,
Ali
(201) 671-5499
