to find folder

[tomi87]

Hello, I created some user and groups with the explorer. In which folder are this informations saved ?

[udoderk]

You must to start the h2 DBMS. Do you start that?

[tomi87]

I started H2 with the following settings:
Generic H2 (Embedded)
org.h2.Driver
jdbc:h2:tcp://localhost/activiti
sa
port 8082

but I get the following error message:
What could I change that its working ?
Fehler beim Öffnen der Datenbank: "Could not save properties C:/Program Files (x86)/H2/bin/activiti.lock.db"
Error opening database: "Could not save properties C:/Program Files (x86)/H2/bin/activiti.lock.db" [8000-171] 08000/8000 (Hilfe)
org.h2.jdbc.JdbcSQLException: Fehler beim Öffnen der Datenbank: "Could not save properties C:/Program Files (x86)/H2/bin/activiti.lock.db"
Error opening database: "Could not save properties C:/Program Files (x86)/H2/bin/activiti.lock.db" [8000-171]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
    at org.h2.message.DbException.get(DbException.java:158)
    at org.h2.store.FileLock.getExceptionFatal(FileLock.java:437)
    at org.h2.store.FileLock.save(FileLock.java:210)
    at org.h2.store.FileLock.lockFile(FileLock.java:334)
    at org.h2.store.FileLock.lock(FileLock.java:129)
    at org.h2.engine.Database.open(Database.java:541)
    at org.h2.engine.Database.openDatabase(Database.java:221)
    at org.h2.engine.Database.<init>(Database.java:216)
    at org.h2.engine.Engine.openSession(Engine.java:56)
    at org.h2.engine.Engine.openSession(Engine.java:159)
    at org.h2.engine.Engine.createSessionAndValidate(Engine.java:138)
    at org.h2.engine.Engine.createSession(Engine.java:121)
    at org.h2.server.TcpServerThread.run(TcpServerThread.java:137)
    at java.lang.Thread.run(Unknown Source)
Caused by: java.io.FileNotFoundException: C:\Program Files (x86)\H2\bin\activiti.lock.db (Zugriff verweigert)
    at java.io.FileOutputStream.open(Native Method)
    at java.io.FileOutputStream.<init>(Unknown Source)
    at java.io.FileOutputStream.<init>(Unknown Source)
    at org.h2.store.fs.FilePathDisk.newOutputStream(FilePathDisk.java:262)
    at org.h2.store.fs.FileUtils.newOutputStream(FileUtils.java:220)
    at org.h2.store.FileLock.save(FileLock.java:198)
    … 11 more

    at org.h2.engine.SessionRemote.done(SessionRemote.java:568)
    at org.h2.engine.SessionRemote.initTransfer(SessionRemote.java:111)
    at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:395)
    at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:287)
    at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:109)
    at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:93)
    at org.h2.Driver.connect(Driver.java:72)
    at org.h2.server.web.WebServer.getConnection(WebServer.java:645)
    at org.h2.server.web.WebApp.login(WebApp.java:900)
    at org.h2.server.web.WebApp.process(WebApp.java:205)
    at org.h2.server.web.WebApp.processRequest(WebApp.java:164)
    at org.h2.server.web.WebThread.process(WebThread.java:137)
    at org.h2.server.web.WebThread.run(WebThread.java:93)
    at java.lang.Thread.run(Unknown Source)
If I choose Generic H2 (Server) then the activiti explorer is working. But I still don't get my "old" users/groups.
Or would this the wrong setting with Generic H2 (Server) ?
With this settings I get this log:
(AbstractBeanFactory.java:197)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.
getBeansOfType(DefaultListableBeanFactory.java:424)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.
getBeansOfType(DefaultListableBeanFactory.java:414)
        at org.springframework.context.support.AbstractApplicationContext.getBea
nsOfType(AbstractApplicationContext.java:1163)
        at org.activiti.spring.SpringConfigurationHelper.buildProcessEngine(Spri
ngConfigurationHelper.java:39)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:601)
        at org.activiti.engine.ProcessEngines.initProcessEngineFromSpringResourc
e(ProcessEngines.java:122)
        at org.activiti.engine.ProcessEngines.init(ProcessEngines.java:109)
        at org.activiti.engine.ProcessEngines.getProcessEngine(ProcessEngines.ja
va:224)
        at org.activiti.engine.ProcessEngines.getDefaultProcessEngine(ProcessEng
ines.java:217)
        at org.activiti.rest.servlet.ActivitiServletContextListener.contextIniti
alized(ActivitiServletContextListener.java:32)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:4887)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContex
t.java:5381)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:901)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:87
7)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)

        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:977)

        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:
1655)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:47
1)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
        at java.util.concurrent.FutureTask.run(FutureTask.java:166)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:615)
        at java.lang.Thread.run(Thread.java:722)
Apr 13, 2013 11:14:06 PM org.apache.catalina.core.StandardContext listenerStart
SEVERE: Exception sending context initialized event to listener instance of clas
s org.activiti.rest.servlet.ActivitiServletContextListener
org.activiti.engine.ActivitiException: couldn't initialize process engine from s
pring configuration resource file:/C:/Program%20Files%20(x86)/activiti-5.12/apac
he-tomcat-7.0.39/webapps/activiti-rest/WEB-INF/classes/activiti-context.xml: nul
l
        at org.activiti.engine.ProcessEngines.initProcessEngineFromSpringResourc
e(ProcessEngines.java:130)
        at org.activiti.engine.ProcessEngines.init(ProcessEngines.java:109)
        at org.activiti.engine.ProcessEngines.getProcessEngine(ProcessEngines.ja
va:224)
        at org.activiti.engine.ProcessEngines.getDefaultProcessEngine(ProcessEng
ines.java:217)
        at org.activiti.rest.servlet.ActivitiServletContextListener.contextIniti
alized(ActivitiServletContextListener.java:32)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:4887)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContex
t.java:5381)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:901)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:87
7)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)

        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:977)

        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:
1655)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:47
1)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
        at java.util.concurrent.FutureTask.run(FutureTask.java:166)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:615)
        at java.lang.Thread.run(Thread.java:722)
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:601)
        at org.activiti.engine.ProcessEngines.initProcessEngineFromSpringResourc
e(ProcessEngines.java:122)
        … 18 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creati
ng bean with name 'processEngine': FactoryBean threw exception on object creatio
n; nested exception is org.springframework.transaction.CannotCreateTransactionEx
ception: Could not open JDBC Connection for transaction; nested exception is org
.h2.jdbc.JdbcSQLException: Fehler beim Íffnen der Datenbank: "Could not save pro
perties C:/Program Files (x86)/H2/bin/activiti.lock.db"
Error opening database: "Could not save properties C:/Program Files (x86)/H2/bin
/activiti.lock.db" [8000-171]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
        at org.h2.message.DbException.get(DbException.java:158)
        at org.h2.store.FileLock.getExceptionFatal(FileLock.java:437)
        at org.h2.store.FileLock.save(FileLock.java:210)
        at org.h2.store.FileLock.lockFile(FileLock.java:334)
        at org.h2.store.FileLock.lock(FileLock.java:129)
        at org.h2.engine.Database.open(Database.java:541)
        at org.h2.engine.Database.openDatabase(Database.java:221)
        at org.h2.engine.Database.<init>(Database.java:216)
        at org.h2.engine.Engine.openSession(Engine.java:56)
        at org.h2.engine.Engine.openSession(Engine.java:159)
        at org.h2.engine.Engine.createSessionAndValidate(Engine.java:138)
        at org.h2.engine.Engine.createSession(Engine.java:121)
        at org.h2.server.TcpServerThread.run(TcpServerThread.java:137)
        at java.lang.Thread.run(Unknown Source)
Caused by: java.io.FileNotFoundException: C:\Program Files (x86)\H2\bin\activiti
.lock.db (Zugriff verweigert)
        at java.io.FileOutputStream.open(Native Method)
        at java.io.FileOutputStream.<init>(Unknown Source)
        at java.io.FileOutputStream.<init>(Unknown Source)
        at org.h2.store.fs.FilePathDisk.newOutputStream(FilePathDisk.java:262)
        at org.h2.store.fs.FileUtils.newOutputStream(FileUtils.java:220)
        at org.h2.store.FileLock.save(FileLock.java:198)
        … 11 more

        at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.
doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:149)
        at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.
getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:102)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getObje
ctForBeanInstance(AbstractBeanFactory.java:1442)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:248)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:197)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.
getBeansOfType(DefaultListableBeanFactory.java:424)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.
getBeansOfType(DefaultListableBeanFactory.java:414)
        at org.springframework.context.support.AbstractApplicationContext.getBea
nsOfType(AbstractApplicationContext.java:1163)
        at org.activiti.spring.SpringConfigurationHelper.buildProcessEngine(Spri
ngConfigurationHelper.java:39)
        … 23 more
Caused by: org.springframework.transaction.CannotCreateTransactionException: Cou
ld not open JDBC Connection for transaction; nested exception is org.h2.jdbc.Jdb
cSQLException: Fehler beim Íffnen der Datenbank: "Could not save properties C:/P
rogram Files (x86)/H2/bin/activiti.lock.db"
Error opening database: "Could not save properties C:/Program Files (x86)/H2/bin
/activiti.lock.db" [8000-171]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
        at org.h2.message.DbException.get(DbException.java:158)
        at org.h2.store.FileLock.getExceptionFatal(FileLock.java:437)
        at org.h2.store.FileLock.save(FileLock.java:210)
        at org.h2.store.FileLock.lockFile(FileLock.java:334)
        at org.h2.store.FileLock.lock(FileLock.java:129)
        at org.h2.engine.Database.open(Database.java:541)
        at org.h2.engine.Database.openDatabase(Database.java:221)
        at org.h2.engine.Database.<init>(Database.java:216)
        at org.h2.engine.Engine.openSession(Engine.java:56)
        at org.h2.engine.Engine.openSession(Engine.java:159)
        at org.h2.engine.Engine.createSessionAndValidate(Engine.java:138)
        at org.h2.engine.Engine.createSession(Engine.java:121)
        at org.h2.server.TcpServerThread.run(TcpServerThread.java:137)
        at java.lang.Thread.run(Unknown Source)
Caused by: java.io.FileNotFoundException: C:\Program Files (x86)\H2\bin\activiti
.lock.db (Zugriff verweigert)
        at java.io.FileOutputStream.open(Native Method)
        at java.io.FileOutputStream.<init>(Unknown Source)
        at java.io.FileOutputStream.<init>(Unknown Source)
        at org.h2.store.fs.FilePathDisk.newOutputStream(FilePathDisk.java:262)
        at org.h2.store.fs.FileUtils.newOutputStream(FileUtils.java:220)
        at org.h2.store.FileLock.save(FileLock.java:198)
        … 11 more

        at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBe
gin(DataSourceTransactionManager.java:240)
        at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.getTransaction(AbstractPlatformTransactionManager.java:371)
        at org.springframework.transaction.support.TransactionTemplate.execute(T
ransactionTemplate.java:127)
        at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransa
ctionInterceptor.java:40)
        at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterc
eptor.java:31)
        at org.activiti.engine.impl.ProcessEngineImpl.<init>(ProcessEngineImpl.j
ava:76)
        at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProc
essEngine(ProcessEngineConfigurationImpl.java:372)
        at org.activiti.spring.SpringProcessEngineConfiguration.buildProcessEngi
ne(SpringProcessEngineConfiguration.java:64)
        at org.activiti.spring.ProcessEngineFactoryBean.getObject(ProcessEngineF
actoryBean.java:56)
        at org.activiti.spring.ProcessEngineFactoryBean.getObject(ProcessEngineF
actoryBean.java:32)
        at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.
doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142)
        … 31 more
Caused by: org.h2.jdbc.JdbcSQLException: Fehler beim Íffnen der Datenbank: "Coul
d not save properties C:/Program Files (x86)/H2/bin/activiti.lock.db"
Error opening database: "Could not save properties C:/Program Files (x86)/H2/bin
/activiti.lock.db" [8000-171]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
        at org.h2.message.DbException.get(DbException.java:158)
        at org.h2.store.FileLock.getExceptionFatal(FileLock.java:437)
        at org.h2.store.FileLock.save(FileLock.java:210)
        at org.h2.store.FileLock.lockFile(FileLock.java:334)
        at org.h2.store.FileLock.lock(FileLock.java:129)
        at org.h2.engine.Database.open(Database.java:541)
        at org.h2.engine.Database.openDatabase(Database.java:221)
        at org.h2.engine.Database.<init>(Database.java:216)
        at org.h2.engine.Engine.openSession(Engine.java:56)
        at org.h2.engine.Engine.openSession(Engine.java:159)
        at org.h2.engine.Engine.createSessionAndValidate(Engine.java:138)
        at org.h2.engine.Engine.createSession(Engine.java:121)
        at org.h2.server.TcpServerThread.run(TcpServerThread.java:137)
        at java.lang.Thread.run(Unknown Source)
Caused by: java.io.FileNotFoundException: C:\Program Files (x86)\H2\bin\activiti
.lock.db (Zugriff verweigert)
        at java.io.FileOutputStream.open(Native Method)
        at java.io.FileOutputStream.<init>(Unknown Source)
        at java.io.FileOutputStream.<init>(Unknown Source)
        at org.h2.store.fs.FilePathDisk.newOutputStream(FilePathDisk.java:262)
        at org.h2.store.fs.FileUtils.newOutputStream(FileUtils.java:220)
        at org.h2.store.FileLock.save(FileLock.java:198)
        … 11 more

        at org.h2.engine.SessionRemote.done(SessionRemote.java:568)
        at org.h2.engine.SessionRemote.initTransfer(SessionRemote.java:111)
        at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:395)
        at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.jav
a:287)
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:109)
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:93)
        at org.h2.Driver.connect(Driver.java:72)
        at org.springframework.jdbc.datasource.SimpleDriverDataSource.getConnect
ionFromDriver(SimpleDriverDataSource.java:140)
        at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.get
ConnectionFromDriver(AbstractDriverBasedDataSource.java:149)
        at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.get
Connection(AbstractDriverBasedDataSource.java:119)
        at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBe
gin(DataSourceTransactionManager.java:202)
        … 41 more

Apr 13, 2013 11:14:06 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Error listenerStart
Apr 13, 2013 11:14:06 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Context [/activiti-rest] startup failed due to previous errors
Apr 13, 2013 11:14:06 PM org.apache.catalina.loader.WebappClassLoader clearRefer
encesJdbc
SEVERE: The web application [/activiti-rest] registered the JDBC driver [org.h2.
Driver] but failed to unregister it when the web application was stopped. To pre
vent a memory leak, the JDBC Driver has been forcibly unregistered.
Apr 13, 2013 11:14:06 PM org.apache.catalina.loader.WebappClassLoader checkThrea
dLocalMapForLeaks
SEVERE: The web application [/activiti-rest] created a ThreadLocal with key of t
ype [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@199fe2c]) and a value
of type [org.apache.ibatis.executor.ErrorContext] (value [
### The error may exist in org/activiti/db/mapping/entity/EventSubscription.xml
### The error occurred while processing mapper_resultMap[compensateResultMap]])
but failed to remove it when the web application was stopped. Threads are going
to be renewed over time to try and avoid a probable memory leak.
Apr 13, 2013 11:14:06 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\Program Files (x86)\activiti-5.12\a
pache-tomcat-7.0.39\webapps\docs
Apr 13, 2013 11:14:06 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\Program Files (x86)\activiti-5.12\a
pache-tomcat-7.0.39\webapps\examples
Apr 13, 2013 11:14:06 PM org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
Apr 13, 2013 11:14:06 PM org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextInitialized()
Apr 13, 2013 11:14:06 PM org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: attributeAdded('org.apache.jasper.compiler.TldLocationsCa
che', 'org.apache.jasper.compiler.TldLocationsCache@194b94c')
Apr 13, 2013 11:14:06 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\Program Files (x86)\activiti-5.12\a
pache-tomcat-7.0.39\webapps\host-manager
Apr 13, 2013 11:14:07 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\Program Files (x86)\activiti-5.12\a
pache-tomcat-7.0.39\webapps\manager
Apr 13, 2013 11:14:07 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\Program Files (x86)\activiti-5.12\a
pache-tomcat-7.0.39\webapps\ROOT
Apr 13, 2013 11:14:07 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-8080"]
Apr 13, 2013 11:14:07 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["ajp-bio-8009"]
Apr 13, 2013 11:14:07 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 22120 ms
11:14:38,363 [http-bio-8080-exec-7] INFO  org.activiti.explorer.cache.TrieBasedU
serCache  - Caching users 0 to 25


[udoderk]

I started H2 with the following settings:
Generic H2 (Embedded)
org.h2.Driver
jdbc:h2:tcp://localhost/activiti
sa
port 8082

but I get the following error message:
What could I change that its working ?
Fehler beim Öffnen der Datenbank: "Could not save properties C:/Program Files (x86)/H2/bin/activiti.lock.db"Caused by: java.io.FileNotFoundException: C:\Program Files (x86)\H2\bin\activiti
[b].lock.db [b](Zugriff verweigert)[/b][/b]



h2 don't have needed authority roles during start

[tomi87]

Ok now it works. But I still don't get my "old" groups and users.
Do I have to copy any files from the old h2 folder ?

[udoderk]

Ok now it works. But I still don't get my "old" groups and users.
Do I have to copy any files from the old h2 folder ?

yes, try to do it,