ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rahul Singh ( Anant )" <anantat...@gmail.com>
Subject Re: Caused by: com.ibatis.sqlmap.client.SqlMapException: Unrecognized parameter mapping field
Date Sun, 10 Jul 2005 04:59:26 GMT
Nice it looks like a very elegant solution. Why do you have to look at
it at such a level?


Rahul

On 7/9/05, Nathan Maves <Nathan.Maves@sun.com> wrote:
> just a thought but I would find and hurt the man who created these
> tables...
> 
> 
> On Jul 5, 2005, at 1:29 PM, Ashish Kulkarni wrote:
> 
> > Hi
> > Thanks, it worked, i am using DB2 on AS400 as database
> > for this query
> >
> > Ashish
> >
> > --- Larry Meadors <larry.meadors@gmail.com> wrote:
> >
> >
> >> 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/
> >>>
> >>>
> >>
> >>
> >
> >
> >
> >
> > __________________________________
> > Yahoo! Mail
> > Stay connected, organized, and protected. Take the tour:
> > http://tour.mail.yahoo.com/mailtour.html
> >
> >
> 
> 


-- 
Rahul Singh
CEO, Anant
rahul.singh@anant.us

Mime
View raw message