3 Replies Latest reply on Aug 17, 2012 5:58 PM by Cdelahun-Oracle

    Intermittent ORA-01722 error while trying to query thru Eclipselink

    newToplinkUser
      We are seeing this error from time to time, the same query works fine when run from SQLPLUS connecting to Oracle, any help would be appreciated.

      org.eclipse.persistence.exceptions.DatabaseException:
      Internal Exception: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

      Error Code: 1722
      Call: SELECT id, type, CSDKExtSys, CoveredTradeEXTSYS, CptyReqIdEXTSYS,
      CptyTradeIdEXTSYS, DirectFXTraderEXTSYS, FIX43EXTSYS, ISEXTSYS,
      JMSPROXYWAITTIME, OAORDERMATCHEDBYADAPTOR , OAORDERPUBLISHEDBYADAPTOR ,
      OAORDERRECEIVEDB
      YADAPTOR , ProviderEXTSYS, RFSQUOTESTATECHANGESNAPSHOT , RequestIdEXTSYS,
      TraderESPEXTSYS, UPI, AcptRecvdByAdpt, AcptRecvdByApp, AcptSentByAdpt,
      AcptSentByApp, AcptSentByUser, actualSettlementDate, bkOfficeId, businessExecu
      tionDate , channel, CLIENTCPUUSAGE , CLIENTMEMORYUSAGE , CLIENTPOLLLATENCY ,
      CLIENTTAG, CnfrmByUser, confirmDate, CPTYALEI, CPTYBLEI, coverTradeTxIds,
      coveredTradeTxId, createdDate, description, displayKey, entryDateTime, ET
      LTIMESTAMP, execDate, execFlags, ftOfficeId, guid, ISEVENTSMATCHPARAMETRIC,
      ISEVENTSMODIFIED, ISTEMPLATE, lastEventDate, MAKERMKTSNAPSHOT,
      MAKERORDERDLTCCY, MAKERORDERIDREF, MAKERORDERCHNL, makerRefId, MANUALLYUPDATED,
      MASKE
      DLP, maturityDate, modificationDateTime, modifiedDate, NOOFATTEMPTSBYCLIENT,
      note, NxtRateRecvdByApp, OrdMtchdByApp, OrdRecvdByApp, ORDERID,
      ORIGINATINGAMOUNT, origCptyId, ORIGINATINGORDERID, origUsrId, ownerCptyRef,
      PRICERE
      GENERATIONKEY, PRICEREGENERATIONSTATE, QuoteCreatedByApp, RateAcptByUser,
      RateAggrtByApp, RateDsplyByUser, RateEffective, RateQueriedByUser,
      RateRecvdByAdpt, RateRecvdByApp, RateRecvdByPrxy, RateRecvdByUser,
      RateSentByAdpt,
      RateSentByApp, RateSentByPrxy, RESPSENTBYADPT, RISKPOSITION, RjctRecvdByApp,
      RjctRecvdFrmPrvdr, RjctSentByApp, settlementDate, status, statusLastModified,
      STREAM, symbol, takerRefId, tradeDate, tid, TRIGGERREACHEDAT, unadjus
      tedMaturityDate, unadjustedSettlementDate, USERLATENCY, version, VIRTUALSERVER,
      VrfyRecvdByApp, VrfyRecvdFrmPrvdr, VrfySentByApp, settlementbclag,
      settlementbclagtype, settlementbchol1, settlementbchol2, settlementbchol3, se
      ttlementbcrollcnv, settlementDateTermLength, settlementDateTermUnit,
      termLength, termUnit, allocTrdId, bookAId, bookBId, brokerId, bsnsCtrId,
      calcAgentId, cntnTrdId, cptyAId, cptyBId, cptyCId, cptyDId,
      coveredTradeCounterpar
      ty, coveredTradeUser, cptyAllocTblId, entryUserId, exchngId, ovrFinEvtBldId,
      lastModifiedById, mkrCptyId, makerRequestId, MKRSDCPTYID, MKRSDUSRID, mkrUsrId,
      namespaceId, netTradeId, orgId, pfId, quoteId, requestId, SALESDLRC
      PTYID, SALESDLRCPTYUSERID, busSettDateRl, stateid, tkrCptyId, clsfId,
      tradeStatId, ownerId, TRIGGEREDBY, workflowStateMapId FROM IDCTRD WHERE ((id =
      ?) AND (type = ?))
      bind => [37243044, IdcFXSLegC]
      Query: ReadObjectQuery(referenceClass=FXSingleLegC )
      at
      org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333)
      at
      org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:644)