You haven't posted the calling code so it's tough to see what might be
wrong. But I have a hunch that this might have to do with "SYSTEM" being a
reserved keyword so you might have to escape it with back ticks. Thats just
a shot in the dark. Also, as far as I can see, just passing in a Map of
Integer and String objects should work fine and you don't really need to use
a parameter map.
----- Original Message -----
From: "Ashish Kulkarni" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Tuesday, July 12, 2005 1:59 PM
Subject: problem with delete statement definition , SQL0206 error
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
