ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nathan Maves <Nathan.Ma...@Sun.COM>
Subject Re: Caused by: com.ibatis.sqlmap.client.SqlMapException: Unrecognized parameter mapping field
Date Sun, 10 Jul 2005 03:19:51 GMT
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