• Post Reply Bookmark Topic Watch Topic
  • New Topic

How to solve the exception is - StatementCallback; bad SQL grammar  RSS feed

 
Sumit RawalArora
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
the exception is - StatementCallback; bad SQL grammar
 
Sumit RawalArora
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
the exception is - StatementCallback; bad SQL grammar [SELECT A.NUM_PORD,B.ID_MSS_PGM_CLAIM ,B.NUM_MSS_CLAIM_SEQ,B.CDE_MSS_CLMACT_STS,B.DTS_MSS_CLMACT_STS ,A.ID_USA_VIN,V.CDE_MODL_CLS,V.DES_MODL,D.NAM_MSS_PGM_TYP,C.ID_MSS_PGM,C.NAM_MSS_PGM,C.AMT_TOT_BDGT,B.DTS_CREA,B.IND_CLM_CHGBK,I.DES_MSS_CLMACT_STS,A.DES_MSS_CLM_RVRSL,B.DTE_MSS_PMT_SCHD,B.AMT_PAYMENT,F.DES_MSS_PMT_RECP,B.ID_DLR,B.ID_MSS_VEND,B.ID_FNCE_CO,B.ID_SLS_PERS,B.ID_SLS_MGR,A.NUM_MSS_PGM_CERT,A.NUM_CAN,H.NAM_CUS_PFX,H.NAM_CUST_FIR,H.NAM_CUST_MI,H.NAM_CUST_LST,H.NAM_CUST_SFX,H.ADR_CUST_LIN_1,H.ADR_CUST_LIN_2,H.ADR_CUST_CITY,H.ADR_CUST_STA_CDE,H.ADR_CUST_ZIP_CDE,A.ID_MSS_INITR_CLM,A.QTY_MTH_LES_TERM,C.CDE_CO FROM SCHEMA.MSS_CLAIM A,SCHEMA.MSS_CLM_ACTIV B LEFT OUTER JOIN SCHEMA.FNCE_CO G ON B.ID_FNCE_CO = G.ID_FNCE_CO LEFT OUTER JOIN SCHEMA.MSS_VENDOR J ON B.ID_MSS_VEND = J.ID_MSS_VEND LEFT OUTER JOIN SCHEMA.MSS_CLM_ACT_CUST H ON B.ID_MSS_PGM_CLAIM = H.ID_MSS_PGM_CLAIM AND B.NUM_MSS_CLAIM_SEQ = H.NUM_MSS_CLAIM_SEQ ,SCHEMA.MSS_PROGRAM C,SCHEMA.MSS_PGM_TYP D,SCHEMA.MSS_PMT_RECP F,SCHEMA.MSS_CLM_ACTIV_STAT I ,SCHEMA.VEH_VEHI V WHERE A.ID_MSS_PGM_CLAIM = B.ID_MSS_PGM_CLAIM AND A.ID_MSS_PGM = C.ID_MSS_PGM AND C.ID_MSS_PGM_TYP = D.ID_MSS_PGM_TYP AND B.CDE_MSS_PMT_RECP = F.CDE_MSS_PMT_RECP AND A.NUM_PORD = V.NUM_PORD AND B.CDE_MSS_CLMACT_STS = I.CDE_MSS_CLMACT_STS AND ((A.CDE_MSS_CLM_STAT = "A" AND B.CDE_MSS_CLMACT_STS = "A") OR   (A.CDE_MSS_CLM_STAT = "C" AND B.CDE_MSS_CLMACT_STS = "C") OR   (A.CDE_MSS_CLM_STAT = "D" AND B.CDE_MSS_CLMACT_STS = "R")) AND   B.DTS_MSS_CLM_FNCE IS NULL  with ur;]; nested exception is com.ibm.websphere.ce.cm.StaleConnectionException: SCHEMA.MSS_CLAIM IS AN UNDEFINED NAME
 
Sumit RawalArora
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
ll
 
Campbell Ritchie
Marshal
Posts: 56599
172
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Doesn't the message explain it all? I hope the original statement didn't have all that bad indentation. Do you really use all those illegible abbreviations? Do you really have a table called SCHEMA? It would appear not to contain MSS_CLAIM.
 
Dave Tolls
Ranch Foreman
Posts: 3068
37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
SCHEMA.MSS_CLAIM IS AN UNDEFINED NAME.

So, does MSS_CLAIM exist?

Have you tried running that query directly against your database with the login used for your connections?
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!