Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
  b=tvgGY+oR/m6ge7xEfJjiAT9uojaycA6oQ7KHBnY3NIGG85YBLQnUHGugxu0F5Dz4u7vru3h8sgtq4c/51x/i2wP4BzAeP2Ux6rjDbvJoZIzn6FjW5QaBsvxt43YWTg9EL6WbOG1cf5i+YAnh1a2nu+hPFa0C3+NwHNhV3lSxHRs=
  ;
Message-ID: <20050705192952.22400.qmail@web32807.mail.mud.yahoo.com>
Date: Tue, 5 Jul 2005 12:29:52 -0700 (PDT)
From: Ashish Kulkarni <kulkarni_ash1312@yahoo.com>
Subject: Re: Caused by: com.ibatis.sqlmap.client.SqlMapException: Unrecognized
 parameter mapping field
To: user-java@ibatis.apache.org, lmeadors@apache.org
In-Reply-To: <a10a823c0507051224a101ebf@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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