Hello
I am getting the following error
Check the DELETE FROM POCOMMENT WHERE SYSTEM=#system#
and USER=#user# and ENVNAME=#envname# and P204PORD =
#ponum# and P204ROUT=#routing# .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: [SQL0206] Column
#SYSTEM# not in specified tables.
Why do i get it,
Here is what i have defined in my xml file
<parameterMap id="po-map-param" class="Map">
<parameter property="system" jdbcType="VARCHAR"
javaType="java.lang.String" />
<parameter property="user" jdbcType="VARCHAR"
javaType="java.lang.String" />
<parameter property="envname" jdbcType="VARCHAR"
javaType="java.lang.String" />
<parameter property="ponum" jdbcType="NUMERIC"
javaType="java.math.BigDecimal" />
<parameter property="routing" jdbcType="VARCHAR"
javaType="java.lang.String" />
</parameterMap>
<delete id="deletePOComment"
parameterMap="po-map-param">
DELETE FROM POCOMMENT WHERE SYSTEM=#system# and
USER=#user# and ENVNAME=#envname# and
P204PORD = #ponum# and P204ROUT=#routing#
</delete>
I am
__________________________________
Yahoo! Mail
Stay connected, organized, and protected. Take the tour:
http://tour.mail.yahoo.com/mailtour.html
