Pattern selector

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

  1. DatabaseAccessor.executeCall() has thrown a SQLSyntaxErrorException
    EclipseLink Core
    5
    0
    0
  2. DatabaseAccessor.basicExecuteCall() has thrown a SQLSyntaxErrorException
    EclipseLink Core
    5
    0
    1

Your stack trace compared to the selected pattern

Jump to solutionsExpand frames
java.sql.SQLSyntaxErrorException: 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 = ?")
1 matching frame hidden
    at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:644)
    at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:535)

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. 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
  3. 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
  4. 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
  5. Unknown authorvia howtobuildsoftware.com5 months ago
    ORA-00972: Bezeichner ist zu lang Error Code: 972
    Show stack trace
  6. Donivia Stack Overflow5 months ago
    ORA-00972: Bezeichner ist zu lang Error Code: 972
    Show stack trace
  7. 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
  8. 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
  9. sdocavia Oracle Community2 years ago
    Table/View 'EJB__TIMER__TBL' does not exist. Error Code: 30000 Call: SELECT COUNT("TIMERID") FROM "EJB__TIMER__TBL" WHERE ("APPLICATIONID" = ?) bind => [1 parameter bound] Query: ReportQuery(name="countTimersByApplication" referenceClass=TimerState sql="SELECT COUNT("TIMERID") FROM "EJB__TIMER__TBL" WHERE ("APPLICATIONID" = ?)")
    Show stack trace
  10. Amivia Oracle Community2 years ago
    ORA-00904: "PARENT_GUID": invalid identifier Error Code: 904 Call: SELECT * FROM (SELECT /*+ FIRST_ROWS */ a.*, ROWNUM rnum FROM (SELECT APPLICATION_ID AS a1, SPACE_GUID AS a2, ANCESTOR_PATH AS a3, SPACES_USER AS a4, GS_MEMBER_COUNT AS a5, UPDATED_BY AS a6, SPACE_OFFLINE AS a7, VERSION AS a8, PARENT_GUID AS a9, SUB_GS_COUNT AS a10, DESCRIPTION AS a11, SPACES_TYPE AS a12, CLOSED AS a13, CREATE_DATE AS a14, LOGO AS a15, ICON AS a16, KEYWORDS AS a17, SECURITY_PARENT_GUID AS a18, SPACE_ID AS a19, SELF_SUB_ENABLED AS a20, RSS_ENABLED AS a21, LAST_UPDATE_DATE AS a22, DISCOVERABLE AS a23, SPACE_PUBLIC AS a24, IS_SEEDED AS a25, CREATED_BY AS a26, DISPLAY_NAME AS a27 FROM WC_SPACE_HEADER WHERE (((SPACES_TYPE = ?) AND (APPLICATION_ID = ?)) AND (PARENT_GUID IS NULL))) a WHERE ROWNUM <= ?) WHERE rnum > ? bind => [Y, webcenter, 101, 0] Query: ReadAllQuery(referenceClass=WcSpaceHeader sql="SELECT * FROM (SELECT /*+ FIRST_ROWS */ a.*, ROWNUM rnum FROM (SELECT APPLICATION_ID AS a1, SPACE_GUID AS a2, ANCESTOR_PATH AS a3, SPACES_USER AS a4, GS_MEMBER_COUNT AS a5, UPDATED_BY AS a6, SPACE_OFFLINE AS a7, VERSION AS a8, PARENT_GUID AS a9, SUB_GS_COUNT AS a10, DESCRIPTION AS a11, SPACES_TYPE AS a12, CLOSED AS a13, CREATE_DATE AS a14, LOGO AS a15, ICON AS a16, KEYWORDS AS a17, SECURITY_PARENT_GUID AS a18, SPACE_ID AS a19, SELF_SUB_ENABLED AS a20, RSS_ENABLED AS a21, LAST_UPDATE_DATE AS a22, DISCOVERABLE AS a23, SPACE_PUBLIC AS a24, IS_SEEDED AS a25, CREATED_BY AS a26, DISPLAY_NAME AS a27 FROM WC_SPACE_HEADER WHERE (((SPACES_TYPE = ?) AND (APPLICATION_ID = ?)) AND (PARENT_GUID IS NULL))) a WHERE ROWNUM <= ?) WHERE rnum > ?")
    Show stack trace