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_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 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, 2 months ago
JBO-27122: SQL error during statement preparation. Statement: select dummy from my_table
via Oracle Community by arubelj, 3 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 793149, 1 week ago
JBO-29114 ADFContext is not setup to process messages for this exception. Use the exception stack trace and error code to investigate the root cause of this exception. Root cause error code is JBO-27122. Error message parameters are {0=SELECT * FROM
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)
at private.sag.modelo.core.SAGSeguridadServiceImpl.prepareSession(SAGSeguridadServiceImpl.java:43)
at oracle.jbo.server.ApplicationModuleImpl.prepareSession(ApplicationModuleImpl.java:6061)
at oracle.jbo.server.ApplicationPoolMessageHandler.doPoolMessage(ApplicationPoolMessageHandler.java:135)
at oracle.jbo.server.ApplicationModuleImpl.doPoolMessage(ApplicationModuleImpl.java:7777)
at oracle.jbo.common.ampool.ApplicationPoolImpl.sendPoolMessage(ApplicationPoolImpl.java:4074)
at oracle.jbo.common.ampool.ApplicationPoolImpl.prepareApplicationModule(ApplicationPoolImpl.java:2161)
at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:1961)
at oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:2793)
at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:453)
at oracle.jbo.http.HttpSessionCookieImpl.useApplicationModule(HttpSessionCookieImpl.java:233)
at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:424)
at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:419)
at oracle.adf.model.bc4j.DCJboDataControl.rebuildApplicationModule(DCJboDataControl.java:1517)
at oracle.adf.model.bc4j.DCJboDataControl.beginRequest(DCJboDataControl.java:1381)
at private.sag.gui.jsf.common.binding.SAGJboDataControl.beginRequest(SAGJboDataControl.java:86)

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.