ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ashish Kulkarni <kulkarni_ash1...@yahoo.com>
Subject Caused by: com.ibatis.sqlmap.client.SqlMapException: Unrecognized parameter mapping field
Date Tue, 05 Jul 2005 18:48:13 GMT
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