Hi there
I defined sql Map definition for select statement
as follows :
<select id="getBgList" resultClass="Result">
SELECT
SEQNO as seqNo,
NAME as name
FROM testtable
WHERE
NME like #paraName#
</select>
This Statement works, but following insert statement
fails when null(java) value is specified to any parameters
even if you use valid Bean Class which has correct
properties :
<statement>
INSERT INTO testtable
VALUES (
#seqNo#,
#name#
)
</statement>
But statement below works fine even if null parameters are
contained :
<statement parameterClass="Parameter">
INSERT INTO testtable
VALUES (
#seqNo#,
#name#
)
</statement>
So, I wonder I must specify parameterMap or parameterClass for
every SQL Map definition.
I thought it is just a performance issue for whether you should
specify parameterMap / parameter Class or not.
Should I always specify parameterMap / parameterClass attribute?
Please teach me !
thanks,