trace file related to the H2 file is attached, after this the h2 file 
becomes corrupt and keeps throwing the error when tried to get connection 
"Internal Exception: org.h2.jdbc.JdbcSQLException: Unique index or primary 
key violation: "SYS_ID ON PUBLIC.SYS(ID)" [23505-169]"


On Wednesday, September 10, 2014 11:51:33 AM UTC+8, Sanchand wrote:
>
> In our project we execute sql files using Runscript.execute method of H2, 
> during one such execution, there was large number of delete statement for a 
> particular table in one of the sql file, the java utility handling the 
> execution exited in during execution of that file. The utility ran 
> successfully in few laptops but failed in failed in many exactly at the 
> execution of that file. Please advice. 
>

-- 
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 h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
07-23 20:19:18 jdbc[2]: exception
org.h2.jdbc.JdbcSQLException: Database is already closed (to disable automatic 
closing at VM shutdown, add ";DB_CLOSE_ON_EXIT=FALSE" to the db URL) [90121-160]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
        at org.h2.message.DbException.get(DbException.java:169)
        at org.h2.message.DbException.get(DbException.java:146)
        at org.h2.message.DbException.get(DbException.java:135)
        at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1394)
        at org.h2.jdbc.JdbcStatement.checkClosed(JdbcStatement.java:924)
        at org.h2.jdbc.JdbcStatement.checkClosedForWrite(JdbcStatement.java:909)
        at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:160)
        at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:152)
        at org.h2.tools.RunScript.execute(RunScript.java:163)
        at 
com.lifeisgreat.emas.installer.patchupdate.PatchExecution.decryptAndExecuteSQLfiles(PatchExecution.java:1160)
        at 
com.lifeisgreat.emas.installer.patchupdate.PatchExecution.applyProductSqlPatch(PatchExecution.java:1257)
        at 
com.lifeisgreat.emas.patchupdate.definition.PatchExecutionDefinition$11.execute(PatchExecutionDefinition.java:123)
        at 
com.lifeisgreat.emas.patchupdate.util.PatchUpdateUtility.applyPatchUpdate(PatchUpdateUtility.java:253)
        at 
com.lifeisgreat.emas.patchupdate.util.PatchUpdateUtility.initiatePatchUpdate(PatchUpdateUtility.java:129)
        at 
com.lifeisgreat.emas.patchupdate.util.PatchUpdateUtility.doPatchUpdate(PatchUpdateUtility.java:113)
        at 
com.lifeisgreat.emas.patchupdate.util.PatchUpdateUtility.doInBackground(PatchUpdateUtility.java:65)
        at 
com.lifeisgreat.emas.patchupdate.util.PatchUpdateUtility.doInBackground(PatchUpdateUtility.java:29)
        at javax.swing.SwingWorker$1.call(SwingWorker.java:277)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
        at java.util.concurrent.FutureTask.run(FutureTask.java:138)
        at javax.swing.SwingWorker.run(SwingWorker.java:316)
        at 
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:619)
07-23 20:24:26 jdbc[2]: exception
org.h2.jdbc.JdbcSQLException: Database is already closed (to disable automatic 
closing at VM shutdown, add ";DB_CLOSE_ON_EXIT=FALSE" to the db URL) [90121-160]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
        at org.h2.message.DbException.get(DbException.java:169)
        at org.h2.message.DbException.get(DbException.java:146)
        at org.h2.message.DbException.get(DbException.java:135)
        at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1394)
        at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1369)
        at org.h2.jdbc.JdbcConnection.createStatement(JdbcConnection.java:191)
        at 
com.lifeisgreat.emas.installer.patchupdate.PatchExecution.createConstants(PatchExecution.java:1366)
        at 
com.lifeisgreat.emas.installer.patchupdate.PatchExecution.decryptAndExecuteSQLfiles(PatchExecution.java:1157)
        at 
com.lifeisgreat.emas.installer.patchupdate.PatchExecution.applyProductSqlPatch(PatchExecution.java:1257)
        at 
com.lifeisgreat.emas.patchupdate.definition.PatchExecutionDefinition$11.execute(PatchExecutionDefinition.java:123)
        at 
com.lifeisgreat.emas.patchupdate.util.PatchUpdateUtility.applyPatchUpdate(PatchUpdateUtility.java:253)
        at 
com.lifeisgreat.emas.patchupdate.util.PatchUpdateUtility.initiatePatchUpdate(PatchUpdateUtility.java:129)
        at 
com.lifeisgreat.emas.patchupdate.util.PatchUpdateUtility.initiateTerminatedPatchUpdate(PatchUpdateUtility.java:157)
        at 
com.lifeisgreat.emas.patchupdate.util.PatchUpdateUtility.doPatchUpdate(PatchUpdateUtility.java:107)
        at 
com.lifeisgreat.emas.patchupdate.util.PatchUpdateUtility.doInBackground(PatchUpdateUtility.java:65)
        at 
com.lifeisgreat.emas.patchupdate.util.PatchUpdateUtility.doInBackground(PatchUpdateUtility.java:29)
        at javax.swing.SwingWorker$1.call(Unknown Source)
        at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at javax.swing.SwingWorker.run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown 
Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
07-23 20:24:35 database: close
java.lang.NullPointerException
        at org.h2.store.PageLog.removeUntil(PageLog.java:720)
        at org.h2.store.PageLog.removeUntil(PageLog.java:697)
        at org.h2.store.PageStore.checkpoint(PageStore.java:410)
        at org.h2.store.PageStore.compact(PageStore.java:576)
        at org.h2.engine.Database.closeOpenFilesAndUnlock(Database.java:1171)
        at org.h2.engine.Database.close(Database.java:1121)
        at org.h2.engine.DatabaseCloser.run(DatabaseCloser.java:80)
07-25 21:15:40 database: close
java.lang.ClassCastException: org.h2.index.PageBtreeLeaf cannot be cast to 
org.h2.index.PageBtreeNode
        at org.h2.index.PageBtreeLeaf.moveTo(PageBtreeLeaf.java:360)
        at org.h2.store.PageStore.compact(PageStore.java:714)
        at org.h2.store.PageStore.compact(PageStore.java:528)
        at org.h2.engine.Database.closeOpenFilesAndUnlock(Database.java:1199)
        at org.h2.engine.Database.close(Database.java:1149)
        at org.h2.engine.Database.removeSession(Database.java:1028)
        at org.h2.engine.Session.close(Session.java:563)
        at org.h2.jdbc.JdbcConnection.close(JdbcConnection.java:362)
        at 
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.closeDatasourceConnection(DatabaseAccessor.java:464)
        at 
org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.disconnect(DatasourceAccessor.java:481)
        at 
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.disconnect(DatabaseAccessor.java:476)
        at 
org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.disconnect(DatabaseSessionImpl.java:256)
        at 
org.eclipse.persistence.sessions.server.ServerSession.disconnect(ServerSession.java:500)
        at 
org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.logout(DatabaseSessionImpl.java:756)
        at 
org.eclipse.persistence.sessions.server.ServerSession.logout(ServerSession.java:741)
        at 
org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.removeSessionFromGlobalSessionManager(EntityManagerSetupImpl.java:284)
        at 
org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.undeploy(EntityManagerSetupImpl.java:1798)
        at 
org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.close(EntityManagerFactoryImpl.java:214)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at 
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.invokeProxyMethod(AbstractEntityManagerFactoryBean.java:423)
        at 
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean$ManagedEntityManagerFactoryInvocationHandler.invoke(AbstractEntityManagerFactoryBean.java:485)
        at $Proxy126.close(Unknown Source)
        at 
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.destroy(AbstractEntityManagerFactoryBean.java:408)
        at 
org.springframework.beans.factory.support.DisposableBeanAdapter.destroy(DisposableBeanAdapter.java:184)
        at 
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroyBean(DefaultSingletonBeanRegistry.java:487)
        at 
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroySingleton(DefaultSingletonBeanRegistry.java:463)
        at 
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroySingletons(DefaultSingletonBeanRegistry.java:431)
        at 
org.springframework.context.support.AbstractApplicationContext.destroyBeans(AbstractApplicationContext.java:1048)
        at 
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:433)
        at 
org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
        at 
org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:93)
        at 
com.lifeisgreat.emas.core.comp.product.ProductManager.getApplicationContext(Unknown
 Source)
        at com.lifeisgreat.emas.core.comp.product.ProductManager.init(Unknown 
Source)
        at 
com.lifeisgreat.emas.core.comp.servicelocator.ServiceManager.initComponents(Unknown
 Source)
        at 
com.lifeisgreat.emas.core.comp.servicelocator.ServiceManager.<clinit>(Unknown 
Source)
        at 
com.lifeisgreat.emas.UI.controller.BaseController.<init>(BaseController.java:72)
        at 
com.lifeisgreat.emas.offline.controller.OfflineCreateUserController.<init>(OfflineCreateUserController.java:30)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at 
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at 
org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:126)
        at 
org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:74)
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:958)
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:911)
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
        at 
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
        at 
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
        at 
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
        at 
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
        at 
org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1075)
        at 
org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler(AbstractUrlHandlerMapping.java:383)
        at 
org.springframework.web.servlet.handler.SimpleUrlHandlerMapping.registerHandlers(SimpleUrlHandlerMapping.java:129)
        at 
org.springframework.web.servlet.handler.SimpleUrlHandlerMapping.initApplicationContext(SimpleUrlHandlerMapping.java:104)
        at 
org.springframework.context.support.ApplicationObjectSupport.initApplicationContext(ApplicationObjectSupport.java:119)
        at 
org.springframework.web.context.support.WebApplicationObjectSupport.initApplicationContext(WebApplicationObjectSupport.java:72)
        at 
org.springframework.context.support.ApplicationObjectSupport.setApplicationContext(ApplicationObjectSupport.java:73)
        at 
org.springframework.context.support.ApplicationContextAwareProcessor.invokeAwareInterfaces(ApplicationContextAwareProcessor.java:106)
        at 
org.springframework.context.support.ApplicationContextAwareProcessor.postProcessBeforeInitialization(ApplicationContextAwareProcessor.java:85)
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:394)
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1413)
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
        at 
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
        at 
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
        at 
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
        at 
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
        at 
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580)
        at 
org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)
        at 
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
        at 
org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
        at 
org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
        at 
org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
        at 
org.jboss.resteasy.plugins.spring.SpringContextLoaderListener.contextInitialized(SpringContextLoaderListener.java:44)
        at 
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4723)
        at 
org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5226)
        at 
org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5221)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
        at java.util.concurrent.FutureTask.run(FutureTask.java:138)
        at 
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:619)
07-28 19:27:40 database: close
java.lang.ClassCastException: org.h2.index.PageBtreeLeaf cannot be cast to 
org.h2.index.PageBtreeNode
        at org.h2.index.PageBtreeLeaf.moveTo(PageBtreeLeaf.java:360)
        at org.h2.store.PageStore.compact(PageStore.java:714)
        at org.h2.store.PageStore.compact(PageStore.java:528)
        at org.h2.engine.Database.closeOpenFilesAndUnlock(Database.java:1199)
        at org.h2.engine.Database.close(Database.java:1149)
        at org.h2.engine.Database.removeSession(Database.java:1028)
        at org.h2.engine.Session.close(Session.java:563)
        at org.h2.jdbc.JdbcConnection.close(JdbcConnection.java:362)
        at 
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.closeDatasourceConnection(DatabaseAccessor.java:464)
        at 
org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.disconnect(DatasourceAccessor.java:481)
        at 
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.disconnect(DatabaseAccessor.java:476)
        at 
org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.disconnect(DatabaseSessionImpl.java:256)
        at 
org.eclipse.persistence.sessions.server.ServerSession.disconnect(ServerSession.java:500)
        at 
org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.logout(DatabaseSessionImpl.java:756)
        at 
org.eclipse.persistence.sessions.server.ServerSession.logout(ServerSession.java:741)
        at 
org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.removeSessionFromGlobalSessionManager(EntityManagerSetupImpl.java:284)
        at 
org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.undeploy(EntityManagerSetupImpl.java:1798)
        at 
org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.close(EntityManagerFactoryImpl.java:214)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at 
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.invokeProxyMethod(AbstractEntityManagerFactoryBean.java:423)
        at 
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean$ManagedEntityManagerFactoryInvocationHandler.invoke(AbstractEntityManagerFactoryBean.java:485)
        at $Proxy126.close(Unknown Source)
        at 
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.destroy(AbstractEntityManagerFactoryBean.java:408)
        at 
org.springframework.beans.factory.support.DisposableBeanAdapter.destroy(DisposableBeanAdapter.java:184)
        at 
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroyBean(DefaultSingletonBeanRegistry.java:487)
        at 
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroySingleton(DefaultSingletonBeanRegistry.java:463)
        at 
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroySingletons(DefaultSingletonBeanRegistry.java:431)
        at 
org.springframework.context.support.AbstractApplicationContext.destroyBeans(AbstractApplicationContext.java:1048)
        at 
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:433)
        at 
org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
        at 
org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:93)
        at 
com.lifeisgreat.emas.core.comp.product.ProductManager.getApplicationContext(Unknown
 Source)
        at com.lifeisgreat.emas.core.comp.product.ProductManager.init(Unknown 
Source)
        at 
com.lifeisgreat.emas.core.comp.servicelocator.ServiceManager.initComponents(Unknown
 Source)
        at 
com.lifeisgreat.emas.core.comp.servicelocator.ServiceManager.<clinit>(Unknown 
Source)
        at 
com.lifeisgreat.emas.UI.controller.BaseController.<init>(BaseController.java:72)
        at 
com.lifeisgreat.emas.offline.controller.OfflineCreateUserController.<init>(OfflineCreateUserController.java:30)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at 
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at 
org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:126)
        at 
org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:74)
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:958)
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:911)
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
        at 
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
        at 
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
        at 
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
        at 
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
        at 
org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1075)
        at 
org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler(AbstractUrlHandlerMapping.java:383)
        at 
org.springframework.web.servlet.handler.SimpleUrlHandlerMapping.registerHandlers(SimpleUrlHandlerMapping.java:129)
        at 
org.springframework.web.servlet.handler.SimpleUrlHandlerMapping.initApplicationContext(SimpleUrlHandlerMapping.java:104)
        at 
org.springframework.context.support.ApplicationObjectSupport.initApplicationContext(ApplicationObjectSupport.java:119)
        at 
org.springframework.web.context.support.WebApplicationObjectSupport.initApplicationContext(WebApplicationObjectSupport.java:72)
        at 
org.springframework.context.support.ApplicationObjectSupport.setApplicationContext(ApplicationObjectSupport.java:73)
        at 
org.springframework.context.support.ApplicationContextAwareProcessor.invokeAwareInterfaces(ApplicationContextAwareProcessor.java:106)
        at 
org.springframework.context.support.ApplicationContextAwareProcessor.postProcessBeforeInitialization(ApplicationContextAwareProcessor.java:85)
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:394)
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1413)
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
        at 
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
        at 
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
        at 
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
        at 
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
        at 
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580)
        at 
org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)
        at 
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
        at 
org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
        at 
org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
        at 
org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
        at 
org.jboss.resteasy.plugins.spring.SpringContextLoaderListener.contextInitialized(SpringContextLoaderListener.java:44)
        at 
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4723)
        at 
org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5226)
        at 
org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5221)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
        at java.util.concurrent.FutureTask.run(FutureTask.java:138)
        at 
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:619)
07-28 19:34:57 database: close
java.lang.ClassCastException: org.h2.index.PageBtreeLeaf cannot be cast to 
org.h2.index.PageBtreeNode
        at org.h2.index.PageBtreeLeaf.moveTo(PageBtreeLeaf.java:360)
        at org.h2.store.PageStore.compact(PageStore.java:714)
        at org.h2.store.PageStore.compact(PageStore.java:528)
        at org.h2.engine.Database.closeOpenFilesAndUnlock(Database.java:1199)
        at org.h2.engine.Database.close(Database.java:1149)
        at org.h2.engine.Database.removeSession(Database.java:1028)
        at org.h2.engine.Session.close(Session.java:563)
        at org.h2.jdbc.JdbcConnection.close(JdbcConnection.java:362)
        at 
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.closeDatasourceConnection(DatabaseAccessor.java:464)
        at 
org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.disconnect(DatasourceAccessor.java:481)
        at 
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.disconnect(DatabaseAccessor.java:476)
        at 
org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.disconnect(DatabaseSessionImpl.java:256)
        at 
org.eclipse.persistence.sessions.server.ServerSession.disconnect(ServerSession.java:500)
        at 
org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.logout(DatabaseSessionImpl.java:756)
        at 
org.eclipse.persistence.sessions.server.ServerSession.logout(ServerSession.java:741)
        at 
org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.removeSessionFromGlobalSessionManager(EntityManagerSetupImpl.java:284)
        at 
org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.undeploy(EntityManagerSetupImpl.java:1798)
        at 
org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.close(EntityManagerFactoryImpl.java:214)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at 
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.invokeProxyMethod(AbstractEntityManagerFactoryBean.java:423)
        at 
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean$ManagedEntityManagerFactoryInvocationHandler.invoke(AbstractEntityManagerFactoryBean.java:485)
        at $Proxy126.close(Unknown Source)
        at 
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.destroy(AbstractEntityManagerFactoryBean.java:408)
        at 
org.springframework.beans.factory.support.DisposableBeanAdapter.destroy(DisposableBeanAdapter.java:184)
        at 
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroyBean(DefaultSingletonBeanRegistry.java:487)
        at 
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroySingleton(DefaultSingletonBeanRegistry.java:463)
        at 
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroySingletons(DefaultSingletonBeanRegistry.java:431)
        at 
org.springframework.context.support.AbstractApplicationContext.destroyBeans(AbstractApplicationContext.java:1048)
        at 
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:433)
        at 
org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
        at 
org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:93)
        at 
com.lifeisgreat.emas.core.comp.product.ProductManager.getApplicationContext(Unknown
 Source)
        at com.lifeisgreat.emas.core.comp.product.ProductManager.init(Unknown 
Source)
        at 
com.lifeisgreat.emas.core.comp.servicelocator.ServiceManager.initComponents(Unknown
 Source)
        at 
com.lifeisgreat.emas.core.comp.servicelocator.ServiceManager.<clinit>(Unknown 
Source)
        at 
com.lifeisgreat.emas.UI.controller.BaseController.<init>(BaseController.java:72)
        at 
com.lifeisgreat.emas.offline.controller.OfflineCreateUserController.<init>(OfflineCreateUserController.java:30)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at 
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at 
org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:126)
        at 
org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:74)
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:958)
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:911)
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
        at 
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
        at 
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
        at 
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
        at 
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
        at 
org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1075)
        at 
org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler(AbstractUrlHandlerMapping.java:383)
        at 
org.springframework.web.servlet.handler.SimpleUrlHandlerMapping.registerHandlers(SimpleUrlHandlerMapping.java:129)
        at 
org.springframework.web.servlet.handler.SimpleUrlHandlerMapping.initApplicationContext(SimpleUrlHandlerMapping.java:104)
        at 
org.springframework.context.support.ApplicationObjectSupport.initApplicationContext(ApplicationObjectSupport.java:119)
        at 
org.springframework.web.context.support.WebApplicationObjectSupport.initApplicationContext(WebApplicationObjectSupport.java:72)
        at 
org.springframework.context.support.ApplicationObjectSupport.setApplicationContext(ApplicationObjectSupport.java:73)
        at 
org.springframework.context.support.ApplicationContextAwareProcessor.invokeAwareInterfaces(ApplicationContextAwareProcessor.java:106)
        at 
org.springframework.context.support.ApplicationContextAwareProcessor.postProcessBeforeInitialization(ApplicationContextAwareProcessor.java:85)
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:394)
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1413)
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
        at 
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
        at 
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
        at 
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
        at 
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
        at 
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580)
        at 
org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)
        at 
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
        at 
org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
        at 
org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
        at 
org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
        at 
org.jboss.resteasy.plugins.spring.SpringContextLoaderListener.contextInitialized(SpringContextLoaderListener.java:44)
        at 
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4723)
        at 
org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5226)
        at 
org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5221)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
        at java.util.concurrent.FutureTask.run(FutureTask.java:138)
        at 
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:619)

Reply via email to