Sorry for the false alarm. I tracked this back to a bug in one of my DB triggers.
I am now investigating why the correct stacktrace being printed. I know QueryDSL wraps the JdbcBatchUpdateException in a QueryException. Invoking JdbcBatchUpdateException.printStackTrace() prints the correct stack-trace but QueryException.printStackTrace() does not (you get the truncated stack-trace seen above). It's not (yet) clear whether QueryException or JdbcBatchUpdateException's implementation is at fault. Gili On Tuesday, October 14, 2014 12:42:43 AM UTC-4, Gili wrote: > > 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 > > On 14/10/2014 12:36 AM, Noel Grandin wrote: > > Can you post the rest of the stacktrace? The actual source of the > > exception is not shown. > > > > On Tue, Oct 14, 2014 at 6:21 AM, Gili <cowwoc@...> wrote: > >> Hi, > >> > >> I am using H2 version 1.4.181. I am executing a PreparedStatement that > takes > >> 3 arguments (int, short, short) and when I do so I get the following > >> exception: > >> > >> 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) > >> > >> Does this indicate a bug in H2 or in my own code? > >> > >> Thank you, > >> Gili > >> > >> -- > >> You received this message because you are subscribed to the Google > Groups > >> "H2 Database" group. > >> To unsubscribe from this group and stop receiving emails from it, send > an > >> email to [email protected]. > >> To post to this group, send email to [email protected]. > >> Visit this group at http://groups.google.com/group/h2-database. > >> For more options, visit https://groups.google.com/d/optout. > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
