oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT Employees.EMPLOYEE_ID, Employees.FIRST_NAME, Employees.LAST_NAME, Employees.EMAIL, Employees.PHONE_NUMBER, Employees.HIRE_DATE, Employees.JOB_ID, Employees.SALARY, Employees.COMMISSION_PCT, Employees.MANAGER_ID, Employees.DEPARTMENT_ID FROM EMPLOYEES Employees WHERE (Employees.EMPLOYEE_ID = :1)

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 blogspot.com by Unknown author, 2 years ago
JBO-27122: SQL error during statement preparation. Statement: SELECT Employees.EMPLOYEE_ID, Employees.FIRST_NAME, Employees.LAST_NAME, Employees.EMAIL, Employees.PHONE_NUMBER, Employees.HIRE_DATE
via blogspot.nl by Unknown author, 1 year ago
JBO-27122: SQL error during statement preparation. Statement: SELECT Employees.EMPLOYEE_ID, Employees.FIRST_NAME, Employees.LAST_NAME, Employees.EMAIL, Employees.PHONE_NUMBER, Employees.HIRE_DATE
via Oracle Community by Jigar Kothari, 1 year ago
JBO-27122: SQL error during statement preparation. Statement: SELECT effective_date FROM MEDICARE_FEE_SCHEDULE WHERE PROCEDURE_CODE =:ProcCode AND LOCALITY_PSRO = :Locality AND :ProcDate > EFFECTIVE_DATE AND EFFECTIVE_DATE = (SELECT MAX(EFFECTIVE_DATE) FROM MEDICARE_FEE_SCHEDULE WHERE PROCEDURE_CODE = :ProcCode AND LOCALITY_PSRO = :Locality AND :ProcDate > EFFECTIVE_DATE)
via Oracle Community by 336358, 4 months ago
JBO-27122: SQL error during statement preparation. Statement: SELECT blah, blah FROM MYTABLE MyTableEo WHERE ? = MyTableEo.LINKCOLUMN
via Oracle Community by BabakSaraie, 1 year ago
JBO-27122: SQL error during statement preparation. Statement: SELECT employeeSalary(:empID) as EmpSal FROM DUAL
via Oracle Community by 304584, 8 months ago
JBO-27122: SQL error during statement preparation. Statement: select * from emp
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT Employees.EMPLOYEE_ID, Employees.FIRST_NAME, Employees.LAST_NAME, Employees.EMAIL, Employees.PHONE_NUMBER, Employees.HIRE_DATE, Employees.JOB_ID, Employees.SALARY, Employees.COMMISSION_PCT, Employees.MANAGER_ID, Employees.DEPARTMENT_ID FROM EMPLOYEES Employees WHERE (Employees.EMPLOYEE_ID = :1)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1015)
at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:762)
at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:5681)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1005)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:1162)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago

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