java.sql.SQLSyntaxErrorException: 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" = ?)")

Oracle Community | sdoca | 5 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Cannot Deploy Ear - EJB Timer Service Not Available

    Oracle Community | 5 years ago | sdoca
    java.sql.SQLSyntaxErrorException: 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" = ?)")
  2. 0

    Test JPA with Arquillian: Derby driver is running instead of PostgreSQL

    Stack Overflow | 2 years ago | cybersoft
    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 = ?")

    Root Cause Analysis

    1. java.sql.SQLSyntaxErrorException

      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" = ?)")

      at org.eclipse.persistence.exceptions.DatabaseException.sqlException()
    2. EclipseLink (non-OSGi)
      DatabaseAccessor.executeCall
      1. org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333)
      2. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:644)
      3. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:535)
      3 frames