ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clinton Begin <clinton.be...@gmail.com>
Subject Re: Caused by: com.ibatis.sqlmap.client.SqlMapException: Unrecognized parameter mapping field
Date Sun, 10 Jul 2005 15:20:15 GMT
Looks like a mainframe conversion, possibly from a hierarchical DB. Possibly 
an ERP system like SAP or JDE.

Those are always nasty.

Clinton

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
> >
> >
> 
>

Mime
View raw message