Pattern selector

Most relevant patterns first. Most helpful ones displayed. Click here to show all.

  1. DatabaseAccessor.basicExecuteCall() has thrown a SQLSyntaxErrorException
    EclipseLink Core
    5
    0
    1
  2. DatabaseException.sqlException() has thrown a SQLSyntaxErrorException
    EclipseLink Core
    9
    0
    1

Your stack trace compared to the selected pattern

Jump to solutionsExpand frames
java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: SEQUENCE Error Code: -5501 Call: UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + ? WHERE SEQ_NAME = ? bind => [2 parameters bound] Query: DataModifyQuery(name="SEQUENCE" sql="UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + ? WHERE SEQ_NAME = ?")
    at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333)
    at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:646)

External results for this pattern (10)

  1. The Alchemistvia Spring JIRA5 months ago
    Syntax error: Encountered "_" at line 1, column 8. Error Code: 30000 Call: SELECT _id, ID, version FROM MACADDRESS Query: ReadAllQuery(referenceClass=MacAddress sql="SELECT _id, ID, version FROM MACADDRESS")
    Show stack trace
  2. Unknown authorvia com.br5 months ago
    user lacks privilege or object not found: SGI_PESSOA Error Code: -5501 Call: INSERT INTO sgi_pessoa (PESSOA_ID) VALUES (?) bind => [2] Query: InsertObjectQuery(entity.Pessoa@4993febc)
    Show stack trace
  3. newToplinkUservia Oracle Community5 months ago
    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 )
    Show stack trace
  4. david.minskyvia Eclipse Bugzilla5 months ago
    ORA-00904: "T1"."TEAM_MANAGER_ID": invalid identifier Error Code: 904 Call: SELECT CASE WHEN 10451 IN (SELECT DISTINCT t0.TEAM_MANAGER_ID FROM PROJECT t1 WHERE ((t1.PROJECT_STATUS = t0.projectStatus) AND (t1.TEAM_MANAGER_ID = t0.TEAM_MANAGER_ID))) THEN '1' ELSE '0' END FROM TEAM_MANAGER t0 WHERE (t0.TEAM_MANAGER_ID = 10451) Query: ReportQuery(name="AVAILABLE_PROJECTS" referenceClass=TeamManager sql="SELECT CASE WHEN ? IN (SELECT DISTINCT t0.TEAM_MANAGER_ID FROM PROJECT t1 WHERE ((t1.PROJECT_STATUS = t0.projectStatus) AND (t1.TEAM_MANAGER_ID = t0.TEAM_MANAGER_ID))) THEN ? ELSE ? END FROM TEAM_MANAGER t0 WHERE (t0.TEAM_MANAGER_ID = ?)")
    Show stack trace
  5. raja.perumalvia Eclipse Bugzilla5 months ago
    Column reference 'CODE' is invalid, or is part of an invalid expression. For a SELECT list with a GROUP BY, the columns and expressions being selected may only contain valid grouping expressions and valid aggregate expressions. Error Code: -1 Call: SELECT CODE, COUNTRY, COUNT(ID) FROM CUSTOMER_TABLE GROUP BY ID HAVING (COUNT(ID) > 3) Query: ReportQuery(referenceClass=Customer sql="SELECT CODE, COUNTRY, COUNT(ID) FROM CUSTOMER_TABLE GROUP BY ID HAVING (COUNT(ID) > 3)")
    Show stack trace
  6. yiping.zhaovia Eclipse Bugzilla5 months ago
    Syntax error: Encountered "t1" at line 1, column 439. Error Code: -1 Call: SELECT t1.EMP_ID, t2.EMP_ID, t1.PAY_SCALE, t1.L_NAME, t1.STATUS, t1.VERSION, t1.ROOM_NUM, t1.GENDER, t2.SALARY, t1.F_NAME, t1.START_OVERTIME, t1.END_OVERTIME, t1.START_TIME, t1.END_TIME, t1.ADDR_ID, t1.DEPT_ID, t1.MANAGER_EMP_ID, t1.FORMER_COMPANY, t1.FORMER_START_DATE, t1.FORMER_END_DATE, t1.START_DATE, t1.END_DATE, t0.ID, t0.NAME FROM CMP3_EMPLOYEE t1 LEFT OUTER JOIN CMP3_DEPT t0 ON (t0.ID = t1.DEPT_ID), CMP3_SALARY t2 WHERE ((CASE t1.F_NAME WHEN 'Bob' THEN 'Robert' WHEN 'Jill' THEN 'Gillian' ELSE '' END = 'Robert') AND (t2.EMP_ID = t1.EMP_ID)) Query: ReadAllQuery(referenceClass=Employee sql="SELECT t1.EMP_ID, t2.EMP_ID, t1.PAY_SCALE, t1.L_NAME, t1.STATUS, t1.VERSION, t1.ROOM_NUM, t1.GENDER, t2.SALARY, t1.F_NAME, t1.START_OVERTIME, t1.END_OVERTIME, t1.START_TIME, t1.END_TIME, t1.ADDR_ID, t1.DEPT_ID, t1.MANAGER_EMP_ID, t1.FORMER_COMPANY, t1.FORMER_START_DATE, t1.FORMER_END_DATE, t1.START_DATE, t1.END_DATE, t0.ID, t0.NAME FROM CMP3_EMPLOYEE t1 LEFT OUTER JOIN CMP3_DEPT t0 ON (t0.ID = t1.DEPT_ID), CMP3_SALARY t2 WHERE ((CASE t1.F_NAME WHEN 'Bob' THEN 'Robert' WHEN 'Jill' THEN 'Gillian' ELSE '' END = 'Robert') AND (t2.EMP_ID = t1.EMP_ID))")
    Show stack trace
  7. Unknown authorvia howtobuildsoftware.com5 months ago
    ORA-00972: Bezeichner ist zu lang Error Code: 972
    Show stack trace
  8. Donivia Stack Overflow5 months ago
    ORA-00972: Bezeichner ist zu lang Error Code: 972
    Show stack trace
  9. cybersoftvia Stack Overflow5 months ago
    Schema 'POSTGRES' does not exist Error Code: 20000 Call: UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + ? WHERE SEQ_NAME = ? bind => [2 parameters bound] Query: DataModifyQuery(name="SEQUENCE" sql="UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + ? WHERE SEQ_NAME = ?")
    Show stack trace
  10. 925395via Oracle Community1 year ago
    ORA-00904: "T1"."OS_TYPE": invalid identifier Error Code: 904 Call: SELECT DISTINCT t1.id, t1.name, t1.hostname, t1.os_type, t1.is_system, t1.version, t1.application_id FROM workstation_prop_set t0, workstation t1 WHERE (((t0.name = ?) AND (t1.application_id = ?)) AND (t0.workstation_id = t1.id)) bind => [eMEWorkstation, 1] Query: ReadAllQuery(name="WorkstationDb.queryWorkstationsByType" referenceClass=WorkstationDb sql="SELECT DISTINCT t1.id, t1.name, t1.hostname, t1.os_type, t1.is_system, t1.version, t1.application_id FROM workstation_prop_set t0, workstation t1 WHERE (((t0.name = ?) AND (t1.application_id = ?)) AND (t0.workstation_id = t1.id))")
    Show stack trace