Hi,
in some situations I've this exception. I'm sure the query is correct,
infact most of the time all works fine. After this exception I restarted
all and all worked fine but maybe it is a bug in h2?
27/10/2014 12:39:00 ERROR TaskUtils$LoggingErrorHandler:95 - Unexpected
error occurred in scheduled task.
org.springframework.orm.jpa.JpaSystemException: commit failed; nested
exception is org.hibernate.TransactionException: commit failed
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.
convertHibernateAccessException(HibernateJpaDialect.java:303)
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.
translateExceptionIfPossible(HibernateJpaDialect.java:214)
at org.springframework.orm.jpa.JpaTransactionManager.doCommit(
JpaTransactionManager.java:519)
at org.springframework.transaction.support.
AbstractPlatformTransactionManager.processCommit(
AbstractPlatformTransactionManager.java:757)
at org.springframework.transaction.support.
AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager
.java:726)
at org.springframework.transaction.support.TransactionTemplate.execute(
TransactionTemplate.java:150)
at org.granite.tide.spring.TideDataPublishingTransactionTemplate.execute
(TideDataPublishingTransactionTemplate.java:90)
at it.task.MarketingTask.esegui(MarketingTask.java:161)
at it.task.MarketingTask$$FastClassBySpringCGLIB$$46e85431.invoke(<
generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:
204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation
.invokeJoinpoint(CglibAopProxy.java:717)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:157)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.
proceed(MethodInvocationProceedingJoinPoint.java:85)
at org.granite.tide.spring.TideDataPublishingAspect$1.call(
TideDataPublishingAspect.java:86)
at org.granite.tide.spring.TideDataPublishingWrapper.execute(
TideDataPublishingWrapper.java:127)
at org.granite.tide.spring.TideDataPublishingAspect.invoke(
TideDataPublishingAspect.java:83)
at sun.reflect.GeneratedMethodAccessor94.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.
invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.
invokeAdviceMethod(AbstractAspectJAdvice.java:610)
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(
AspectJAroundAdvice.java:68)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:168)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.
invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.
CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653)
at it.task.MarketingTask$$EnhancerBySpringCGLIB$$43a3b10e.esegui(<
generated>)
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.springframework.scheduling.support.ScheduledMethodRunnable.run(
ScheduledMethodRunnable.java:65)
at org.springframework.scheduling.support.
DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(
ReschedulingRunnable.java:81)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:
511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$201(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(ScheduledThreadPoolExecutor.java:293)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.hibernate.TransactionException: commit failed
at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(
AbstractTransactionImpl.java:187)
at org.hibernate.jpa.internal.TransactionImpl.commit(TransactionImpl.
java:77)
at org.springframework.orm.jpa.JpaTransactionManager.doCommit(
JpaTransactionManager.java:515)
... 38 more
Caused by: org.hibernate.TransactionException: unable to commit against
JDBC connection
at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.
doCommit(JdbcTransaction.java:116)
at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(
AbstractTransactionImpl.java:180)
... 40 more
Caused by: org.h2.jdbc.JdbcSQLException: General error:
"java.lang.NullPointerException"; SQL statement:
COMMIT [50000-182]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:168)
at org.h2.message.DbException.convert(DbException.java:295)
at org.h2.command.Command.executeUpdate(Command.java:262)
at org.h2.jdbc.JdbcConnection.commit(JdbcConnection.java:468)
at sun.reflect.GeneratedMethodAccessor75.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.
java:126)
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.
java:109)
at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(
DisposableConnectionFacade.java:80)
at com.sun.proxy.$Proxy39.commit(Unknown Source)
at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.
doCommit(JdbcTransaction.java:112)
... 41 more
Caused by: java.lang.NullPointerException
at org.h2.store.LobStorageMap.setTable(LobStorageMap.java:251)
at org.h2.value.ValueLobDb.unlink(ValueLobDb.java:235)
at org.h2.engine.Session.endTransaction(Session.java:551)
at org.h2.engine.Session.commit(Session.java:536)
at org.h2.command.dml.TransactionCommand.update(TransactionCommand.java:
46)
at org.h2.command.CommandContainer.update(CommandContainer.java:78)
at org.h2.command.Command.executeUpdate(Command.java:254)
... 50 more
This is the connection string:
jdbc:h2:~/db;IFEXISTS=FALSE;IGNORECASE=TRUE;AUTO_RECONNECT=TRUE;MVCC=TRUE;DEFRAG_ALWAYS=TRUE;LOCK_TIMEOUT=10000;AUTO_SERVER=TRUE
Thanks!
--
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.
