Hi All,
I ran the update sql outside with the same
values and no issues.
I have "null" data values in
updates as column allows NULLS for VARCHAR. I think it is giving error on
"null" data.
Is there an issue in IBATIS with
null data updating in Varchar field?
Thanks,
Ali
(201) 671-5499
-----Original
Message-----
From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Larry Meadors
Sent: Wednesday, April 26, 2006
11:08 AM
To: [email protected];
Balaji
Subject: Re:
Update Statement Error ?
Another quick-n-dirty way to find
these (if you have a unit test) is
to remove columns from the update until it works. The last
one you
removed is
the problem.
Larry
On 4/26/06, Balaji
<[EMAIL PROTECTED]> wrote:
>
> Ali,
>
> It
could be because of null value(s) in password date etc. Check
the
> datatype
& acceptable value for fields in db table vs the dto. Execute
the
> SQL
outside ibatis (winsql, plsql etc) with the values you are passing
when
> this
error is occuring. That should give you a better error
message.
>
>
>
Balaji
>
>
>
>
----- Original Message -----
> From: Ali, Mohammed (Liquidity & Risk
Technology)
>
To: [email protected]
> Sent: Wednesday, April 26, 2006 9:25 AM
> Subject: Update Statement
Error ?
>
>
>
>
> 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
>
________________________________
>
> If you are not an intended recipient of this e-mail, please notify
the
> sender,
delete it and do not read, act upon, print, disclose, copy,
retain
> or
redistribute it. Click here for important additional terms relating
to
> this
e-mail. http://www.ml.com/email_terms/
>
________________________________
>
If you are not an intended recipient of this e-mail, please notify the
sender, delete it and do not read, act upon, print, disclose, copy, retain or
redistribute it.
Click here for
important additional terms relating to this e-mail.
http://www.ml.com/email_terms/