ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Larry Meadors <larry.mead...@gmail.com>
Subject Re: Caused by: com.ibatis.sqlmap.client.SqlMapException: Unrecognized parameter mapping field
Date Tue, 05 Jul 2005 19:24:17 GMT
Any fields with # in them need to be escaped with ##

A.PCVER# AS PCVER,

 - should be - 

A.PCVER## AS PCVER,


..and...

   WHERE A.Pcpord  = "VALUE#

 - should be - 

   WHERE A.Pcpord  = #VALUE#

What db is this? That is a freaky looking join with all the
(((((((((((((((( in there.

Larry


On 7/5/05, Ashish Kulkarni <kulkarni_ash1312@yahoo.com> wrote:
> Hi
> I am not sure why i am getting the above error, is
> there a way to debug it.
> I am going to paste my xml file definiation here,
> I am sure this SQL statement works
> the error i am getting is as below
> Caused by: com.ibatis.sqlmap.client.SqlMapException:
> Unrecognized parameter mapping field: ' F.P813NAME AS
> P813NAME' in  AS BP2FAX, F.P813NAME AS P813NAME,
> F.P813PHON AS P813PHON, G.P830DESC AS P830DESC,
> A.PCSHPV AS PCSHPV, A.PCFRGT AS PCFRGT, A.PCORIG AS
> PCORIG, A.PCCURR AS PCCURR, A.PCEXCG AS PCEXCG,
> A.PCBUYR AS PCBUYR, A.PCBLOR AS PCBLOR, A.PCSRCE AS
> PCSRCE, A.PCVALU AS PCVALU, A.PCAKDT AS PCAKDT,
> A.PCVNDT AS PCVNDT, A.PCFXDT AS PCFXDT, A.PCINDT AS
> PCINDT, A.PCSPN1 AS PCSPN1, A.PCSPN2 AS PCSPN2,
> A.PCSPN3 AS PCSPN3, A.PCENDU AS PCENDU, A.PCUSF1 AS
> PCUSF1, A.PCUSF2 AS PCUSF2, A.PCUSF3 AS PCUSF3,
> A.PCSTAT AS PCSTAT, A.PCCANC AS PCCANC, A.PCVER
> 
> 
> my sql statement is as below
> 
> SELECT  A.PCPORD  AS PCPORD  ,
>         A.PCVALU  AS PCVALU ,
>         A.PCPTYP  AS PCPTYP ,
>         A.PCODAT  AS PCODAT  ,
>         A.PCVNDR  AS PCVNDR  ,
>         A.PCINVV AS PCINVV,
>         A.PCSHPT AS PCSHPT,
>         A.PCBILT AS PCBILT,
>         A.PCCONF AS PCCONF,
>         A.PCROUT AS PCROUT,
>         A.PCASTA AS PCASTA,
>         A.PCAPVU AS PCAPVU,
>         A.PCAPVD AS PCAPVD,
>         A.PCAPVT AS PCAPVT,
>         A.PCPAYT AS PCPAYT,
>         A.PCDISC AS PCDISC,
>         C.P2FAX# AS BP2FAX,
>         F.P813NAME AS P813NAME,
>         F.P813PHON AS P813PHON,
>         G.P830DESC AS P830DESC,
>         A.PCSHPV AS PCSHPV,
>         A.PCFRGT AS PCFRGT,
>         A.PCORIG AS PCORIG,
>         A.PCCURR AS PCCURR,
> A.PCEXCG AS PCEXCG,
> A.PCBUYR AS PCBUYR,
> A.PCBLOR AS PCBLOR,
> A.PCSRCE AS PCSRCE,
> A.PCVALU AS PCVALU,
> A.PCAKDT AS PCAKDT,
> A.PCVNDT AS PCVNDT,
> A.PCFXDT AS PCFXDT,
> A.PCINDT AS PCINDT,
> A.PCSPN1 AS PCSPN1,
> A.PCSPN2 AS PCSPN2,
> A.PCSPN3 AS PCSPN3,
> A.PCENDU AS PCENDU,
> A.PCUSF1 AS PCUSF1,
> A.PCUSF2 AS PCUSF2,
> A.PCUSF3 AS PCUSF3,
> A.PCSTAT AS PCSTAT,
> A.PCCANC AS PCCANC,
> A.PCVER# AS PCVER,
> A.PCINCO AS PCINCO,
>  A.PCDATE AS PCDATE,
>  A.PCTIME AS PCTIME,
>  A.PCUSER AS PCUSER,
>  H.P1NAME  AS VP1NAME  ,
>  H.P1ADR1  AS VP1ADR1 ,
>  H.P1ADR2  AS VP1ADR2 ,
>  H.P1ADR3  AS VP1ADR3 ,
>  H.P1COUN  AS VP1COUN ,
>  H.P1PROV  AS VP1PROV ,
>  H.P1CITY  AS VP1CITY ,
>  H.P1STE   AS VP1STE  ,
>  H.P1CTRY  AS VP1CTRY ,
>  H.P1ZIP   AS VP1ZIP  ,
>  H.P1TEL#  AS VP1TEL  ,
>  H.P1FAX#  AS VP1FAX  ,
>  H.P1MAIL  AS VP1MAIL ,
>  H.P1CONT  AS VP1CONT ,
>  A.PCSHPT  AS PCSHPT,
>  B.P2NAME  AS SNAME,
>  B.P2ADR1 AS SP2ADR1,
> B.P2ADR2 AS SP2ADR2,
> B.P2CITY AS SP2CITY,
> B.P2STE  AS SP2STE ,
> B.P2ZIP  AS SP2ZIP ,
> B.P2ATTN AS SP2ATTN,
> B.P2PHON AS SP2PHON,
> B.P2FAX# AS SP2FAX,
> C.P2NAME  AS BNAME,
> C.P2ADR1 AS BP2ADR1,
> C.P2ADR2 AS BP2ADR2,
> C.P2CITY AS BP2CITY,
> C.P2STE  AS BP2STE ,
> C.P2ZIP  AS BP2ZIP ,
> C.P2ATTN AS BP2ATTN,
> C.P2PHON AS BP2PHON,
> D.P832DESC AS P832DESC,
> E.P834DESC AS P834DESC,
> J.PDLINE  AS PDLINE ,
> J.PDITEM  AS PDITEM ,
> K.M0DESC   AS M0DESC ,
> J.PDPUME  AS PDPUME ,
> J.PDREQ   AS PDREQ  ,
> J.PDRQRD  AS PDRQRD ,
> J.PDRQST  AS PDRQST,
> J.PDSETP  AS PDSETP ,
> J.PDQTYP  AS PDQTYP ,
> J.PDPRCE  AS PDPRCE,
> I.SENAME   AS SENAME,
> L.C803CNAM AS C803NAM,
> L.C803GSDS  AS C803GSDS,
> M.P804DESC  AS P804DESC,
> N.P039PORD  AS P039PORD,
> N.P039POLN  AS P039POLN,
> N.P039DSLN  AS P039DSLN,
> N.P039QTY   AS P039QTY ,
> N.P039SHIP  AS P039SHIP,
> N.P039DELV  AS P039DELV,
> N.P039REQ   AS P039REQ ,
> N.P039COMM  AS P039COMM,
> P.P2NAME  AS PBNAME,
> P.P2ADR1 AS PBP2ADR1,
> P.P2ADR2 AS PBP2ADR2,
> P.P2CITY AS PBP2CITY,
> P.P2STE  AS PBP2STE ,
> P.P2ZIP  AS PBP2ZIP ,
> P.P2ATTN AS PBP2ATTN,
> P.P2PHON AS PBP2PHON,
> P.P2FAX# AS PBP2FAX,
> Q.P2NAME  AS QBNAME,
> Q.P2ADR1 AS QBP2ADR1,
> Q.P2ADR2 AS QBP2ADR2,
>  Q.P2CITY AS QBP2CITY,
>  Q.P2STE  AS QBP2STE ,
>  Q.P2ZIP  AS QBP2ZIP ,
>  Q.P2ATTN AS QBP2ATTN,
>  Q.P2PHON AS QBP2PHON,
>  Q.P2FAX# AS QBP2FAX,
>  R.SENAME AS RSENAME,
> S.SENAME AS SSENAME
>    FROM
> 
> 
> 
>  (((((((((((((((( Pu1012 A left join pu1002 B on
> 
>            A.PcShpt = B.P2code )   Left join Pu1002 C
> on
>            A.PcBilt = C.P2code )   Left Join Pu1832 D
> on
>            A.PcShpv = D.P832Code ) Left join Pu1834 E
> on
>            A.PcFRGT = E.P834Code ) Left join PU1813 F
> on
>            A.PCBUYR = F.P813Code)  Left join PU1830 G
> on
>            A.PCPAYT = G.P830Code)  Left join PU1001 H
> on
>            A.PCVNDR = H.P1VNDR)    Left join SE1001 I
> on
>            A.PCAPVU = I.SEUSID)    Left join CF1803C L
> on
>            A.PCCOMP = L.C803COMP)  Left join PU1804 M
> on
>            A.PCptyp = M.p804code)  Left join pu1013 J
> on
>            A.pcpord = J.pdpord)    Left join pu1039 N
> on
>            J.pdpord = N.p039pord   and
> 
>            J.pdline = N.p039poln)  LEFT JOIN  PU1002 P
> ON
>            J.PDSHIP = P.P2CODE)    LEFT JOIN  PU1002 Q
> ON
>            N.P039SHIP = Q.P2CODE)  LEFT JOIN  SE1001 R
> ON
>            N.P039REQ  = R.SEUSID)  LEFT JOIN  SE1001 S
> ON
>            J.PDRQST   = S.SEUSID),
> 
> 
> 
>           RS1002 K
> 
> 
> 
>    WHERE A.Pcpord  = "VALUE#
> 
>      And A.Pcpord  = J.pdpord
> 
>      AND J.PDITEM  = K.M0CODE
> 
>      Order by   PDLINE
> 
> 
> 
> 
> 
> 
> 
> 
> 
> __________________________________
> Discover Yahoo!
> Use Yahoo! to plan a weekend, have fun online and more. Check it out!
> http://discover.yahoo.com/
>

Mime
View raw message