Hi Anton,
Just wondering, does this happen the first time the route gets hit or
subsequent times?
Have you tried providing an explicit EntityManagerFactory bean to the
endpoint?
John
On Wed, Apr 13, 2016 at 6:24 AM Anton <kurren...@gmail.com> wrote:
> Hi
>
> I tried changing this from sqlite to h2, and now I get a similar error:
> Caused by: java.lang.IllegalStateException: The file is locked:
> nio:/home/anton/twdb.mv.db [1.4.191/7]
> at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:773)
> at org.h2.mvstore.FileStore.open(FileStore.java:172)
> at org.h2.mvstore.MVStore.<init>(MVStore.java:342)
> at org.h2.mvstore.MVStore$Builder.open(MVStore.java:2888)
> at org.h2.mvstore.db.MVTableEngine$Store.open(MVTableEngine.java:154)
> ... 125 more
>
> at
>
> org.jboss.weld.bootstrap.events.AbstractDeploymentContainerEvent.fire(AbstractDeploymentContainerEvent.java:37)
> at
>
> org.jboss.weld.bootstrap.events.AfterDeploymentValidationImpl.fire(AfterDeploymentValidationImpl.java:28)
> at org.jboss.weld.bootstrap.WeldStartup.validateBeans(WeldStartup.java:449)
> at
> org.jboss.weld.bootstrap.WeldBootstrap.validateBeans(WeldBootstrap.java:90)
> at org.jboss.weld.environment.se.Weld.initialize(Weld.java:558)
> at
>
> org.apache.deltaspike.cdise.weld.WeldContainerControl.boot(WeldContainerControl.java:68)
> at org.apache.camel.cdi.Main.doStart(Main.java:95)
> at org.apache.camel.support.ServiceSupport.start(ServiceSupport.java:61)
> at org.apache.camel.main.MainSupport.run(MainSupport.java:138)
> at org.apache.camel.main.MainSupport.run(MainSupport.java:390)
> at org.apache.camel.cdi.Main.main(Main.java:57)
>
>
> Anyone know why camel is doing this?
>
> On Tue, Apr 12, 2016 at 7:18 PM, Anton <kurren...@gmail.com> wrote:
>
> > Hello
> >
> > I am trying to use Camel JPA to store entities into a sqlite database.
> >
> >
> > My route looks like this:
> >
> >
> > public void configure() {
> >
> >
> from(zendeskEndpoint).to("jpa:org.zendesk.client.v2.model.Ticket&persistenceUnit=camel");
> > }
> >
> > However, I am getting the following error:
> >
> > [l-1) thread #0 - zendesk://foo] ZendeskConsumer WARN
> > Error processing exchange. Exchange[ID-Charles-38935-1460481217959-0-2].
> > Caused by: [javax.persistence.PersistenceException -
> > org.hibernate.exception.GenericJDBCException: error performing isolated
> > work]
> > javax.persistence.PersistenceException:
> > org.hibernate.exception.GenericJDBCException: error performing isolated
> work
> > at
> >
> org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1692)
> > at
> >
> org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1602)
> > at
> >
> org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1608)
> > at
> >
> org.hibernate.jpa.spi.AbstractEntityManagerImpl.merge(AbstractEntityManagerImpl.java:1171)
> > 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:498)
> > at
> >
> org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:344)
> > at com.sun.proxy.$Proxy71.merge(Unknown Source)
> > at
> org.apache.camel.component.jpa.JpaProducer$1.save(JpaProducer.java:116)
> > at
> >
> org.apache.camel.component.jpa.JpaProducer$1.doInTransaction(JpaProducer.java:89)
> > at
> >
> org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)
> > at
> org.apache.camel.component.jpa.JpaProducer.process(JpaProducer.java:62)
> > at
> >
> org.apache.camel.util.AsyncProcessorConverterHelper$ProcessorToAsyncProcessorBridge.process(AsyncProcessorConverterHelper.java:61)
> > at
> org.apache.camel.processor.SendProcessor.process(SendProcessor.java:145)
> > at
> >
> org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77)
> > at
> >
> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:468)
> > at
> >
> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:190)
> > at
> >
> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:190)
> > at
> >
> org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:109)
> > at
> >
> org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:87)
> > at
> > io.tradeworks.camel.zendesk.ZendeskConsumer.poll(ZendeskConsumer.java:44)
> > at
> >
> org.apache.camel.impl.ScheduledPollConsumer.doRun(ScheduledPollConsumer.java:175)
> > at
> >
> org.apache.camel.impl.ScheduledPollConsumer.run(ScheduledPollConsumer.java:102)
> > at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
> > at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
> > at
> >
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
> > at
> >
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
> > 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.exception.GenericJDBCException: error performing
> > isolated work
> > at
> >
> org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)
> > at
> >
> org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
> > at
> >
> org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
> > at
> >
> org.hibernate.resource.transaction.backend.jdbc.internal.JdbcIsolationDelegate.delegateWork(JdbcIsolationDelegate.java:79)
> > at
> >
> org.hibernate.id.enhanced.TableGenerator$1.getNextValue(TableGenerator.java:530)
> > at
> org.hibernate.id.enhanced.NoopOptimizer.generate(NoopOptimizer.java:40)
> > at
> >
> org.hibernate.id.enhanced.TableGenerator.generate(TableGenerator.java:526)
> > at
> >
> org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:105)
> > at
> >
> org.hibernate.jpa.event.internal.core.JpaMergeEventListener.saveWithGeneratedId(JpaMergeEventListener.java:56)
> > at
> >
> org.hibernate.event.internal.DefaultMergeEventListener.saveTransientEntity(DefaultMergeEventListener.java:254)
> > at
> >
> org.hibernate.event.internal.DefaultMergeEventListener.entityIsTransient(DefaultMergeEventListener.java:234)
> > at
> >
> org.hibernate.event.internal.DefaultMergeEventListener.entityIsDetached(DefaultMergeEventListener.java:300)
> > at
> >
> org.hibernate.event.internal.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:169)
> > at
> >
> org.hibernate.event.internal.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:68)
> > at org.hibernate.internal.SessionImpl.fireMerge(SessionImpl.java:843)
> > at org.hibernate.internal.SessionImpl.merge(SessionImpl.java:825)
> > at org.hibernate.internal.SessionImpl.merge(SessionImpl.java:830)
> > at
> >
> org.hibernate.jpa.spi.AbstractEntityManagerImpl.merge(AbstractEntityManagerImpl.java:1161)
> > ... 28 more
> > Caused by: java.sql.SQLException: database is locked
> > at org.sqlite.core.DB.throwex(DB.java:859)
> > at org.sqlite.core.DB.exec(DB.java:142)
> > at org.sqlite.jdbc3.JDBC3Connection.commit(JDBC3Connection.java:165)
> > at
> >
> org.hibernate.resource.transaction.backend.jdbc.internal.JdbcIsolationDelegate.delegateWork(JdbcIsolationDelegate.java:60)
> > ... 42 more
> >
> >
> > Does anyone know what the problem is?
> >
> > Thanks
> >
>
