ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ashish Kulkarni <kulkarni_ash1...@yahoo.com>
Subject problem with delete statement definition , SQL0206 error
Date Tue, 12 Jul 2005 17:59:02 GMT
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 


Mime
View raw message