oracle.jbo.SQLStmtException: JBO-27122: Error SQL durante la preparación de la sentencia. Sentencia: SELECT EOUsuario.U_ID, EOUsuario.U_NOMBRE_USUARIO, EOUsuario.U_EMAIL, EOUsuario.U_ADMIN_SEGURIDAD, EOUsuario.U_ADMIN_SISTEMA, EOUsuario.U_PASSWORD, EOUsuario.U_TOKEN, EOUsuario.U_REPORTE FROM USUARIOS EOUsuario WHERE (U_ID LIKE :Id OR :Id IS NULL) AND (UPPER(U_NOMBRE_USUARIO) LIKE CONCAT(CONCAT('%',UPPER(:Nombre)),'%') OR :Nombre IS NULL) AND (U_EMAIL LIKE CONCAT(CONCAT('%',UPPER(:Email)),'%') OR :Email IS NULL ) AND (U_ADMIN_SISTEMA LIKE :AdmSis OR :AdmSis IS NULL ) AND (U_ADMIN_SEGURIDAD LIKE CONCAT(CONCAT('%',UPPER(:AdmSeg)),'%') OR :AdmSeg IS NULL ) AND (U_REPORTE LIKE CONCAT(CONCAT('%',UPPER(:URep)),'%') OR :URep IS NULL ) ORDER BY EOUsuario.U_ID

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 771205, 1 year ago
, EOUsuario.U_PASSWORD, EOUsuario.U_TOKEN, EOUsuario.U_REPORTE FROM USUARIOS EOUsuario WHERE (U_ID LIKE :Id OR :Id IS NULL) AND (UPPER(U_NOMBRE_USUARIO) LIKE CONCAT(CONCAT('%',UPPER(:Nombre)),'%') OR :Nombre IS NULL) AND (U_EMAIL LIKE CONCAT
via Oracle Community by 405435, 4 months ago
JBO-27122: SQL error during statement preparation. Statement: select dummy from my_table
via Oracle Community by 771205, 1 year ago
, EOUsuario.U_REPORTE FROM USUARIOS EOUsuario WHERE (U_ID LIKE :Id OR :Id IS NULL) AND (UPPER(U_NOMBRE_USUARIO) LIKE CONCAT(CONCAT('%',UPPER(:Nombre)),'%') OR :Nombre IS NULL) AND (U_EMAIL LIKE CONCAT(CONCAT('%',UPPER(:Email)),'%') OR :Email IS NULL ) AND
via Oracle Community by arubelj, 4 months ago
JBO-27122: SQL error during statement preparation. Statement: select user_id user_id from apps.fnd_user where user_name =:SSOUse rName
via Oracle Community by 788094, 1 year ago
JBO-27122: SQL error during statement preparation. Statement: SELECT DISTINCT FND_USER.USER_NAME ,FND_RESPONSIBILITY.RESPONSIBILITY_ID ,FND_RESPONSIBILITY.APPLICATION_ID ,FND_USER.USER_ID FROM apps.FND_USER_RESP_GROUPS ,apps.FND_USER
via Oracle Community by soso_xuc, 1 year ago
JBO-27122: SQL error during statement preparation. Statement: SELECT T.FUNCTION_ID FUNCTION_ID, T.FUNCTION_NAME FUNCTION_NAME, T.FUNCTION_URL FUNCTION_URL, T.FUNCTION_PARAMS FUNCTION_PARAMS FROM TASKS.FUNCTIONS T
oracle.jbo.SQLStmtException: JBO-27122: Error SQL durante la preparación de la sentencia. Sentencia: SELECT EOUsuario.U_ID, EOUsuario.U_NOMBRE_USUARIO, EOUsuario.U_EMAIL, EOUsuario.U_ADMIN_SEGURIDAD, EOUsuario.U_ADMIN_SISTEMA, EOUsuario.U_PASSWORD, EOUsuario.U_TOKEN, EOUsuario.U_REPORTE FROM USUARIOS EOUsuario WHERE (U_ID LIKE :Id OR :Id IS NULL) AND (UPPER(U_NOMBRE_USUARIO) LIKE CONCAT(CONCAT('%',UPPER(:Nombre)),'%') OR :Nombre IS NULL) AND (U_EMAIL LIKE CONCAT(CONCAT('%',UPPER(:Email)),'%') OR :Email IS NULL ) AND (U_ADMIN_SISTEMA LIKE :AdmSis OR :AdmSis IS NULL ) AND (U_ADMIN_SEGURIDAD LIKE CONCAT(CONCAT('%',UPPER(:AdmSeg)),'%') OR :AdmSeg IS NULL ) AND (U_REPORTE LIKE CONCAT(CONCAT('%',UPPER(:URep)),'%') OR :URep IS NULL ) ORDER BY EOUsuario.U_ID
at oracle.jbo.server.BaseSQLBuilderImpl.processException(BaseSQLBuilderImpl.java:3383)
at oracle.jbo.server.OracleSQLBuilderImpl.processException(OracleSQLBuilderImpl.java:3977)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:961)
at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3751)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:743)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:892)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:806)
at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:800)
at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3671)
at private.sag.extensiones.modelo.view.CustomViewObjectImpl.executeQuery(CustomViewObjectImpl.java:89)
at private.sag.modelo.core.view.seguridad.VOUsuariosImpl.recuperarInfoUsuarioAutenticado(VOUsuariosImpl.java:49)

Users with the same issue

You are the first who have seen this exception.

Write tip

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