org.apache.openjpa.persistence.PersistenceException: Protocol violation {prepstmnt 15921893 SELECT * FROM (SELECT t0.id, t0.app_name, t0.status, t0.user_name, t0.group_name, t0.start_time, t0.end_time, t0.app_path, t0.concurrency, t0.frequency, t0.last_action, t0.next_matd_time, t0.created_time, t0.time_unit, t0.time_zone, t0.time_out FROM COORD_JOBS t0 WHERE t0.bean_type = ? ORDER BY t0.created_time DESC) WHERE ROWNUM <= ? [params=(String) CoordinatorJobBean, (long) 50]} [code=17401, state=99999]

openjpa-users | Angelo K. Huang | 6 years ago
  1. 0

    Re: ReportingSQLException: Protocol violation

    openjpa-users | 6 years ago | Angelo K. Huang
    org.apache.openjpa.persistence.PersistenceException: Protocol violation {prepstmnt 15921893 SELECT * FROM (SELECT t0.id, t0.app_name, t0.status, t0.user_name, t0.group_name, t0.start_time, t0.end_time, t0.app_path, t0.concurrency, t0.frequency, t0.last_action, t0.next_matd_time, t0.created_time, t0.time_unit, t0.time_zone, t0.time_out FROM COORD_JOBS t0 WHERE t0.bean_type = ? ORDER BY t0.created_time DESC) WHERE ROWNUM <= ? [params=(String) CoordinatorJobBean, (long) 50]} [code=17401, state=99999]
  2. 0

    OpenJPA Users - ReportingSQLException: Protocol violation

    nabble.com | 5 months ago
    org.apache.openjpa.persistence.PersistenceException: Protocol violation {prepstmnt 15921893 SELECT * FROM (SELECT t0.id, t0.app_name, t0.status, t0.user_name, t0.group_name, t0.start_time, t0.end_time, t0.app_path, t0.concurrency, t0.frequency, t0.last_action, t0.next_matd_time, t0.created_time, t0.time_unit, t0.time_zone, t0.time_out FROM COORD_JOBS t0 WHERE t0.bean_type = ? ORDER BY t0.created_time DESC) WHERE ROWNUM <= ? [params=(String) CoordinatorJobBean, (long) 50]} [code=17401, state=99999]        at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4232)
  3. 0

    [GERONIMO-3907] Persistence Exception is not visible/lost for client. - ASF JIRA

    apache.org | 1 year ago
    org.apache.openjpa.persistence.PersistenceException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    TestDistributionType#testBigint fail

    GitHub | 4 years ago | ilgrosso
    org.apache.openjpa.persistence.PersistenceException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred. FailedObject: org.apache.openjpa.azure.beans.PersonBINT@7591777e
  6. 0

    Re: How to find cause for PersistenceException?

    apache.org | 1 year ago
    org.apache.openjpa.persistence.PersistenceException: Invalid value for getInt() - '-'

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.apache.openjpa.lib.jdbc.ReportingSQLException

      Protocol violation {prepstmnt 15921893 SELECT * FROM (SELECT t0.id, t0.app_name, t0.status, t0.user_name, t0.group_name, t0.start_time, t0.end_time, t0.app_path, t0.concurrency, t0.frequency, t0.last_action, t0.next_matd_time, t0.created_time, t0.time_unit, t0.time_zone, t0.time_out FROM COORD_JOBS t0 WHERE t0.bean_type = ? ORDER BY t0.created_time DESC) WHERE ROWNUM <= ? [params=(String) CoordinatorJobBean, (long) 50]} [code=17401, state=99999]

      at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap()
    2. OpenJPA Aggregate Jar
      QueryImpl.getResultList
      1. org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192)
      2. org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:57)
      3. org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:852)
      4. org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:262)
      5. org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1595)
      6. org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:252)
      7. org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:496)
      8. org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:384)
      9. org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:325)
      10. org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:331)
      11. org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:94)
      12. org.apache.openjpa.lib.rop.WindowResultList.<init>(WindowResultList.java:57)
      13. org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4232)
      14. org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4197)
      15. org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
      16. org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:88)
      17. org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:64)
      18. org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:155)
      19. org.apache.openjpa.lib.rop.WindowResultList.<init>(WindowResultList.java:64)
      20. org.apache.openjpa.jdbc.kernel.JDBCFetchConfigurationImpl.newResultList(JDBCFetchConfigurationImpl.java:234)
      21. org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1228)
      22. org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:990)
      23. org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:805)
      24. org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:775)
      25. org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:771)
      26. org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:517)
      27. org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:255)
      28. org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:294)
      28 frames
    3. org.apache.oozie
      CoordinatorStore.doOperation
      1. org.apache.oozie.store.CoordinatorStore$15.call(CoordinatorStore.java:609)
      2. org.apache.oozie.store.CoordinatorStore$15.call(CoordinatorStore.java:567)
      3. org.apache.oozie.store.CoordinatorStore.doOperation(CoordinatorStore.java:425)
      3 frames