Hi Noel,
Does this help?
00:39:50.039 [qtp381325774-3642] ERROR
com.vtlr.backend.QueryExceptionMapper.toResponse() - SQLState: HY000
com.mysema.query.QueryException: Caught JdbcBatchUpdateException for
update PERMISSION_CHILD
set REFERENCES = REFERENCES - ?
where PERMISSION_CHILD.PARENT_ID = ? and PERMISSION_CHILD.CHILD_ID = ?
at
com.mysema.query.sql.DefaultSQLExceptionTranslator.translate(DefaultSQLExceptionTranslator.java:38)
at com.mysema.query.sql.Configuration.translate(Configuration.java:514)
at
com.mysema.query.sql.dml.SQLUpdateClause.execute(SQLUpdateClause.java:196)
at com.vtlr.backend.row.Permission.removePath(Permission.java:216)
at com.vtlr.backend.row.Permission.removeById(Permission.java:290)
at com.vtlr.backend.row.Operator.remove(Operator.java:530)
at
com.vtlr.backend.resource.OperatorResource.removeOperator(OperatorResource.java:149)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at
org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
at
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:151)
at
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:171)
at
org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:152)
at
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:104)
at
org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:387)
at
org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:331)
at
org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:103)
at
org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:271)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
at
org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:297)
at
org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:254)
at
org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1030)
at
org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:373)
at
org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:381)
at
org.glassfish.jersey.servlet.ServletContainer.doFilter(ServletContainer.java:534)
at
org.glassfish.jersey.servlet.ServletContainer.doFilter(ServletContainer.java:482)
at
org.glassfish.jersey.servlet.ServletContainer.doFilter(ServletContainer.java:419)
at
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1650)
at
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:583)
at
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
at
org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
at
org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
at
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1125)
at
org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
at
org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
at
org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1059)
at
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
at org.eclipse.jetty.server.Server.handle(Server.java:497)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311)
at
org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:248)
at
org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
at
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:610)
at
org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:539)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.h2.jdbc.JdbcBatchUpdateException: General error:
"java.lang.ClassCastException: java.lang.Short cannot be cast to
java.lang.Integer"; SQL statement:
update PERMISSION_CHILD
set REFERENCES = REFERENCES - ?
where PERMISSION_CHILD.PARENT_ID = ? and PERMISSION_CHILD.CHILD_ID = ?
[50000-181]
at
org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1198)
at
com.mysema.query.sql.dml.AbstractSQLClause.executeBatch(AbstractSQLClause.java:161)
at
com.mysema.query.sql.dml.AbstractSQLClause.executeBatch(AbstractSQLClause.java:171)
at
com.mysema.query.sql.dml.SQLUpdateClause.execute(SQLUpdateClause.java:190)
... 48 common frames omitted
00:39:51.137 [qtp222651412-3714] ERROR
com.vtlr.backend.QueryExceptionMapper.toResponse() - SQLState: HY000
Gili