javax.faces.el.EvaluationException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT part.PARTICIPANT_CATEGORY_ID, part.PARTICIPANT_EMAIL, part.PARTICIPANT_NAME, part.REVIEW_ID, part.REVIEW_PARTICIPANT_ID, part.REVIEW_ROLE_NAME, cate.PARTICIPANT_CATEGORY, cate.IS_CURRENT_FLAG, part.IS_DRAFT_REP_RECIPIENT, part.IS_FINAL_RECIPIENT,part.IS_REVIEW_PARTICIPANT FROM PMACCR.CCR_REVIEW_PARTICIPANTS part, PMACCR.CCR_REVIEW_PARTI_CATEGORY cate WHERE part.PARTICIPANT_CATEGORY_ID = cate.PARTICIPANT_CATEGORY_ID AND part.REVIEW_ID = :reviewId

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by 2985623, 1 year ago
, cate.PARTICIPANT_CATEGORY, cate.IS_CURRENT_FLAG, part.IS_DRAFT_REP_RECIPIENT, part.IS_FINAL_RECIPIENT,part.IS_REVIEW_PARTICIPANT FROM PMACCR.CCR_REVIEW_PARTICIPANTS part, PMACCR.CCR_REVIEW_PARTI_CATEGORY cate WHERE part.PARTICIPANT_CATEGORY_ID = cate.PARTICIPANT_CATEGORY_ID AND part.REVIEW_ID = :reviewId
via Oracle Community by 669735, 1 year ago
javax.el.ELException: oracle.adfinternal.controller.savepoint.SavePointException: ADFC-08018: The ADF Controller is unable to create or execute a SQL statement: 'CREATE TABLE "ORADFCSAVPT" (SAVE_POINT_ID VARCHAR2(64 CHAR) NOT NULL,CREATED DATE
via hivmr.com by Unknown author, 1 year ago
oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement "INSERT INTO DRG_DONOR_PHOTOGRAPHS(PHOTOGRAPH_ID,DONOR_ID,PHOTOGRAPH,ACTIVE_FLAG,VERSION_NUMBER) VALUES (:1,:2,:3,:4,:5)".
via Stack Overflow by Vineet Verma
, 4 months ago
oracle.jbo.JboException: JBO-28202: Entities invalidated in beforeCommit(). Need to revalidate and post.
via Oracle Community by 969604, 1 year ago
javax.el.ELException: Error Parsing: #{null.null}
javax.faces.el.EvaluationException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT part.PARTICIPANT_CATEGORY_ID, part.PARTICIPANT_EMAIL, part.PARTICIPANT_NAME, part.REVIEW_ID, part.REVIEW_PARTICIPANT_ID, part.REVIEW_ROLE_NAME, cate.PARTICIPANT_CATEGORY, cate.IS_CURRENT_FLAG, part.IS_DRAFT_REP_RECIPIENT, part.IS_FINAL_RECIPIENT,part.IS_REVIEW_PARTICIPANT FROM PMACCR.CCR_REVIEW_PARTICIPANTS part, PMACCR.CCR_REVIEW_PARTI_CATEGORY cate WHERE part.PARTICIPANT_CATEGORY_ID = cate.PARTICIPANT_CATEGORY_ID AND part.REVIEW_ID = :reviewId
at oracle.jbo.server.BaseSQLBuilderImpl.processException(BaseSQLBuilderImpl.java:3735)
at oracle.jbo.server.OracleSQLBuilderImpl.processException(OracleSQLBuilderImpl.java:4725)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1491)
at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:1005)
at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:7515)
at com.oracle.ptsdemo.uiaccelerator.RSWPuview.EmailDraftVOImpl.executeQueryForCollection(EmailDraftVOImpl.java:27)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1260)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:1458)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:1364)
at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:1349)
at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:7410)
at oal.oracle.apps.RSWPbean.PublicationFeedbackSetupBean.populatePublicationSetup(PublicationFeedbackSetupBean.java:69)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Know the solutions? Share your knowledge to help other developers to debug faster.