I'm calling a procedure from a page, every time I call it I get this error in console
09:34:08,942 INFO [stdout] (http-localhost/127.0.0.1:8080-3) 20/04/2017
09:34:08.941 INFO projectX:ReportRankingPointsMB:searchReport:86 - [UserId: 210] searchReport() SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1449];
09:34:08,942 INFO [stdout] (http-localhost/127.0.0.1:8080-3) --- The error occurred in com/ivision/dao/sqlMapPointsCashlessDB.xml.
09:34:08,942 INFO [stdout] (http-localhost/127.0.0.1:8080-3) --- The error occurred while applying a parameter map.
09:34:08,942 INFO [stdout] (http-localhost/127.0.0.1:8080-3) --- Check the points.getPointsRankingByParameter-InlineParameterMap.
09:34:08,942 INFO [stdout] (http-localhost/127.0.0.1:8080-3) --- Check the statement (update procedure failed).
09:34:08,943 INFO [stdout] (http-localhost/127.0.0.1:8080-3) --- Cause: java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
09:34:08,943 INFO [stdout] (http-localhost/127.0.0.1:8080-3) --- The error occurred in com/ivision/dao/sqlMapPointsCashlessDB.xml.
09:34:08,943 INFO [stdout] (http-localhost/127.0.0.1:8080-3) --- The error occurred while applying a parameter map.
09:34:08,943 INFO [stdout] (http-localhost/127.0.0.1:8080-3) --- Check the points.getPointsRankingByParameter-InlineParameterMap.
09:34:08,943 INFO [stdout] (http-localhost/127.0.0.1:8080-3) --- Check the statement (update procedure failed).
09:34:08,943 INFO [stdout] (http-localhost/127.0.0.1:8080-3) --- Cause: java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist
I am using jboss eap 6.x as a server and configure the standalone, I have no problems when making other queries, is there any way I can solve this error?
I can not modify user permissions since that the only access that I have to db, besides I am not using any root user neither in my project nor in the standalone which seems very strange to me