Related idea: https://github.com/querydsl/querydsl/issues/1007

If you mirror getNextException() into addSuppressed(), I think 
printStackTrace() would pick it up properly.

Gili

On Tuesday, October 14, 2014 3:15:54 AM UTC-4, Gili wrote:
>
> Got it: http://stackoverflow.com/a/17378186/14731
>
> So in the case of batched queries, it looks like I need to add explicit 
> usage of getNextException(). I've noticed you made an attempt in 
> JdbcBatchUpdateException to improve the situation (you print out 
> getNextException() in printStackTrace()).
>
> Is it possible to further improve the implementation so it prints 
> getNextException() if printStackTrace() is invoked on a wrapper exception 
> (where getCause() returns the JdbcBatchUpdateException)?
>
> Thanks,
> Gili
>
> On Tuesday, October 14, 2014 2:55:47 AM UTC-4, Gili wrote:
>>
>> 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.

Reply via email to