Zarar Do you have an example for trying to do what i am doing without using a parameter MAP
<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> Ashish --- Zarar Siddiqi <[EMAIL PROTECTED]> wrote: > 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 > > > > > > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
