topic Re: to find folder in Alfresco Archive

to find folder

tomi87 — Tue, 09 Apr 2013 09:56:39 GMT

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

Re: to find folder

udoderk — Tue, 09 Apr 2013 12:23:28 GMT

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

Hellow,
user & groups are saved into folder with files ordered to your DBMS or that not saved, because you use in-memory database

Re: to find folder

tomi87 — Wed, 10 Apr 2013 04:15:28 GMT

Hello, I created some user and groups with the explorer. In which folder are this informations saved ?
user & groups are saved into folder with files ordered to your DBMS

Is this a special folder ? If yes, which name has the folder ? And which file type has this ? and which names has the files?

Re: to find folder

udoderk — Wed, 10 Apr 2013 08:27:37 GMT

Hello, I created some user and groups with the explorer. In which folder are this informations saved ?
user & groups are saved into folder with files ordered to your DBMS

Is this a special folder ? If yes, which name has the folder ? And which file type has this ? and which names has the files?

Helow,
readit firstly

Re: to find folder

ronald_van_kuij — Wed, 10 Apr 2013 09:46:59 GMT

I do not understand your replies either…

Re: to find folder

tomi87 — Wed, 10 Apr 2013 10:42:46 GMT

I have the following problem:
I had a correct running activiti explorer. Then I installed an other program which includes tomcat and some other server tools. After install that, I coudn't start the activiti explorer again. So I uninstalled this program and tried again to start the explorer but it doesn't worked. So I downloaded the newest ant, apache tomcat and activiti and installed everything again. Now I tried it with the new installed version and it's working. But I had all my old groups and users in the "old" activiti explorer. I don't know how I can get it from there to my new one.

Old Version:
apache tomcat: 6.0.32
apache-james: 2.3.2
activiti: 5.11
h2: 1.3.168

new Version:
apache tomcat: 7.0.39
activiti: 5.12

If I start the old tomcat in the activiti-5.10\setup directory using ant demo.start I get this:
Maybe you can find which would be the error and I can get to run my old version again.


C:\Program Files (x86)\activiti-5.10\activiti-5.10\setup>ant demo.start
Buildfile: C:\Program Files (x86)\activiti-5.10\activiti-5.10\setup\build.xml

demo.install:

internal.cfg.create:
     [copy] Copying 1 file to C:\Program Files (x86)\activiti-5.10\activiti-5.10
\setup\build\activiti-cfg
      [zip] Building zip: C:\Program Files (x86)\activiti-5.10\activiti-5.10\set
up\build\activiti-cfg.jar
     [echo] copying configuration to ../workspace/activiti-engine-examples/src/m
ain/config
    [unzip] Expanding: C:\Program Files (x86)\activiti-5.10\activiti-5.10\setup\
build\activiti-cfg.jar into C:\Program Files (x86)\activiti-5.10\activiti-5.10\w
orkspace\activiti-engine-examples\src\main\config
    [unzip] Unable to expand to file C:\Program Files (x86)\activiti-5.10\activi
ti-5.10\workspace\activiti-engine-examples\src\main\config\activiti.cfg.xml

internal.classpath.libs:

internal.taskdef.launch:

h2.start:
     [echo] starting H2 database…
   [launch] launching cmd 'C:\Program Files (x86)\activiti-5.10\activiti-5.10\ap
ps\h2\h2.start.bat ' in dir 'C:\Program Files (x86)\activiti-5.10\activiti-5.10\
apps\h2'
   [launch] waiting for launch completion msg 'TCP server running'…
   [launch]   Fehler: Hauptklasse org.h2.tools.Server konnte nicht gefunden oder
 geladen werden
   [launch] launched process completed
     [echo] H2 database started

tomcat.start:
   [launch] launching cmd 'C:\Program Files (x86)\activiti-5.10\activiti-5.10\ap
ps\apache-tomcat-6.0.32\bin\startup.bat ' in dir 'C:\Program Files (x86)\activit
i-5.10\activiti-5.10\apps\apache-tomcat-6.0.32\bin'
   [launch] waiting for launch completion msg 'Using CLASSPATH:'…
   [launch]   Using CATALINA_BASE:   "C:\Program Files (x86)\activiti-5.10\activ
iti-5.10\apps\apache-tomcat-6.0.32"
   [launch]   Using CATALINA_HOME:   "C:\Program Files (x86)\activiti-5.10\activ
iti-5.10\apps\apache-tomcat-6.0.32"
   [launch]   Using CATALINA_TMPDIR: "C:\Program Files (x86)\activiti-5.10\activ
iti-5.10\apps\apache-tomcat-6.0.32\temp"
   [launch]   Using JRE_HOME:        "C:\Program Files (x86)\Java\jdk1.7.0_17"
   [launch]   Using CLASSPATH:       "C:\Program Files (x86)\activiti-5.10\activ
iti-5.10\apps\apache-tomcat-6.0.32\bin\bootstrap.jar"

explorer.browser.open:

demo.start:

BUILD SUCCESSFUL
Total time: 12 seconds

C:\Program Files (x86)\activiti-5.10\activiti-5.10\setup>

        at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProc
essEngine(ProcessEngineConfigurationImpl.java:300)
        at org.activiti.spring.SpringProcessEngineConfiguration.buildProcessEngi
ne(SpringProcessEngineConfiguration.java:60)
        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)
        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:38)
        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:120)
        at org.activiti.engine.ProcessEngines.init(ProcessEngines.java:107)
        at org.activiti.engine.ProcessEngines.getProcessEngine(ProcessEngines.ja
va:222)
        at org.activiti.engine.ProcessEngines.getDefaultProcessEngine(ProcessEng
ines.java:215)
        at org.activiti.rest.servlet.ActivitiServletContextListener.contextIniti
alized(ActivitiServletContextListener.java:39)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:4205)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
704)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:799)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:77
9)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)

        at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.jav
a:1079)
        at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.j
ava:1002)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506
)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1315)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:324)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:142)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1061)

        at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)

        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463
)
        at org.apache.catalina.core.StandardService.start(StandardService.java:5
25)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:754
)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
        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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: java.net.ConnectException: Connection refused: connect
        at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
        at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketI
mpl.java:75)
        at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.ja
va:339)
        at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocket
Impl.java:200)
        at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java
:182)
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:157)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:391)
        at java.net.Socket.connect(Socket.java:579)
        at org.h2.util.NetUtils.createSocket(NetUtils.java:119)
        at org.h2.util.NetUtils.createSocket(NetUtils.java:100)
        at org.h2.engine.SessionRemote.initTransfer(SessionRemote.java:93)
        at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:395)
        … 59 more
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further detail
s.
Apr 10, 2013 6:38:07 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.10/acti
viti-5.10/apps/apache-tomcat-6.0.32/webapps/activiti-rest/WEB-INF/classes/activi
ti-context.xml: null
        at org.activiti.engine.ProcessEngines.initProcessEngineFromSpringResourc
e(ProcessEngines.java:128)
        at org.activiti.engine.ProcessEngines.init(ProcessEngines.java:107)
        at org.activiti.engine.ProcessEngines.getProcessEngine(ProcessEngines.ja
va:222)
        at org.activiti.engine.ProcessEngines.getDefaultProcessEngine(ProcessEng
ines.java:215)
        at org.activiti.rest.servlet.ActivitiServletContextListener.contextIniti
alized(ActivitiServletContextListener.java:39)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:4205)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
704)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:799)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:77
9)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)

        at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.jav
a:1079)
        at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.j
ava:1002)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506
)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1315)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:324)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:142)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1061)

        at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)

        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463
)
        at org.apache.catalina.core.StandardService.start(StandardService.java:5
25)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:754
)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
        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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
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:120)
        … 28 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: Verbindung ist unterbrochen: "java.net.ConnectExcepti
on: Connection refused: connect: localhost"
Connection is broken: "java.net.ConnectException: Connection refused: connect: l
ocalhost" [90067-168]
        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:38)
        … 33 more
Caused by: org.springframework.transaction.CannotCreateTransactionException: Cou
ld not open JDBC Connection for transaction; nested exception is org.h2.jdbc.Jdb
cSQLException: Verbindung ist unterbrochen: "java.net.ConnectException: Connecti
on refused: connect: localhost"
Connection is broken: "java.net.ConnectException: Connection refused: connect: l
ocalhost" [90067-168]
        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:33)
        at org.activiti.engine.impl.ProcessEngineImpl.<init>(ProcessEngineImpl.j
ava:77)
        at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProc
essEngine(ProcessEngineConfigurationImpl.java:301)
        at org.activiti.spring.SpringProcessEngineConfiguration.buildProcessEngi
ne(SpringProcessEngineConfiguration.java:60)
        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)
        … 41 more
Caused by: org.h2.jdbc.JdbcSQLException: Verbindung ist unterbrochen: "java.net.
ConnectException: Connection refused: connect: localhost"
Connection is broken: "java.net.ConnectException: Connection refused: connect: l
ocalhost" [90067-168]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
        at org.h2.message.DbException.get(DbException.java:158)
        at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:399)
        at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.jav
a:287)
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:108)
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:92)
        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)
        … 51 more
Caused by: java.net.ConnectException: Connection refused: connect
        at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
        at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketI
mpl.java:75)
        at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.ja
va:339)
        at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocket
Impl.java:200)
        at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java
:182)
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:157)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:391)
        at java.net.Socket.connect(Socket.java:579)
        at org.h2.util.NetUtils.createSocket(NetUtils.java:119)
        at org.h2.util.NetUtils.createSocket(NetUtils.java:100)
        at org.h2.engine.SessionRemote.initTransfer(SessionRemote.java:93)
        at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:395)
        … 59 more

Apr 10, 2013 6:38:07 PM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
Apr 10, 2013 6:38:07 PM org.apache.catalina.core.StandardContext start
SEVERE: Context [/activiti-rest] startup failed due to previous errors
Apr 10, 2013 6:38:07 PM org.apache.catalina.loader.WebappClassLoader clearRefere
ncesJdbc
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 10, 2013 6:38:07 PM org.apache.catalina.loader.WebappClassLoader clearThread
LocalMap
SEVERE: The web application [/activiti-rest] created a ThreadLocal with key of t
ype [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@1fff19a]) 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. This is very likel
y to create a memory leak.
Apr 10, 2013 6:38:08 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory docs
Apr 10, 2013 6:38:08 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory examples
Apr 10, 2013 6:38:09 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory ROOT
Apr 10, 2013 6:38:09 PM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Apr 10, 2013 6:38:09 PM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
Apr 10, 2013 6:38:09 PM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/60  config=null
Apr 10, 2013 6:38:09 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 42104 ms

I get this error:
HTTP Status 404 -

type Status report

message

description The requested resource () is not available.

Apache Tomcat/6.0.32

Re: to find folder

udoderk — Wed, 10 Apr 2013 11:08:53 GMT

…..

But I had all my old groups and users in the "old" activiti explorer. I don't know how I can get it from there to my new one.

"old" activiti explorer uses DBMS too. Either in-memory DBMS or ordinal DBMS.
Look at the db.properties of "old" and "new" explorer to find, which DBMS was used.
Note, that activiti explorer in activiti 5.10 bundle was configurated with h2-DBMS (that runs in not-memory-mode). The activiti 5.11 uses in-memory mode by default.

If you want to find really file containing the user/groups, search for H2 folder, that contains that files

Re: to find folder

tomi87 — Fri, 12 Apr 2013 07:46:19 GMT

Thank you.
So in my db.properties of "old" is the following:
db=h2
jdbc.driver=org.h2.Driver
jdbc.url=jdbc\:h2\:tcp\://localhost/activiti
jdbc.username=sa
jdbc.password=

But I still don't know how I can use my groups and users in my new downloaded version of activiti explorer. Can you help me further, please ?
this is the db.properties of "new":
db=h2
jdbc.driver=org.h2.Driver
jdbc.url=jdbc:h2:mem:activiti;DB_CLOSE_DELAY=1000
jdbc.username=sa
jdbc.password=

Re: to find folder

udoderk — Fri, 12 Apr 2013 10:55:22 GMT

Thank you.
So in my db.properties of "old" is the following:
db=h2
jdbc.driver=org.h2.Driver
jdbc.url=jdbc\:h2\:tcp\://localhost/activiti
jdbc.username=sa
jdbc.password=

But I still don't know how I can use my groups and users in my new downloaded version of activiti explorer. Can you help me further, please ?
this is the db.properties of "new":
db=h2
jdbc.driver=org.h2.Driver
jdbc.url=jdbc:h2:mem:activiti;DB_CLOSE_DELAY=1000
jdbc.username=sa
jdbc.password=

Change the "jdbc.url=jdbc:h2:mem:activiti;DB_CLOSE_DELAY=1000" to "jdbc.url=jdbc\:h2\:tcp\://localhost/activiti"

Note, that if you use the "mem" (also in memory database configuration, nothing will be saved into hard drive)

Re: to find folder

tomi87 — Fri, 12 Apr 2013 12:13:38 GMT

Thank you.
I changed it, but now I can't reach the activiti explorer.

I get this:

Apr 09, 2013 7:07:31 PM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: c:\Program Files (x86)\Java\jdk1.7.0_17\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;c:\Users\Tomi\bin;.;C:\Program Files (x86)\Git\local\bin;C:\Program Files (x86)\Git\mingw\bin;C:\Program Files (x86)\Git\bin;c:\Program Files\Common Files\Microsoft Shared\Windows Live;c:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live;c:\Windows\system32;c:\Windows;c:\Windows\System32\Wbem;c:\Windows\System32\WindowsPowerShell\v1.0\;c:\Program Files (x86)\MiKTeX 2.9\miktex\bin\;c:\Windows\Microsoft.NET\Framework\v2.0.50727;c:\Program Files (x86)\Calibre2\;c:\Program Files (x86)\ant\bin;c:\Program Files (x86)\Windows Live\Shared;.
Apr 09, 2013 7:07:34 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-bio-8080"]
Apr 09, 2013 7:07:34 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["ajp-bio-8009"]
Apr 09, 2013 7:07:34 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 4656 ms
Apr 09, 2013 7:07:35 PM org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
Apr 09, 2013 7:07:35 PM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.39
Apr 09, 2013 7:07:35 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive C:\Program Files (x86)\activiti-5.12\apache-tomcat-7.0.39\webapps\activiti-explorer.war
Apr 10, 2013 6:02:28 PM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: c:\Program Files (x86)\Java\jdk1.7.0_17\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;c:\Users\Tomi\bin;.;C:\Program Files (x86)\Git\local\bin;C:\Program Files (x86)\Git\mingw\bin;C:\Program Files (x86)\Git\bin;c:\Program Files\Common Files\Microsoft Shared\Windows Live;c:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live;c:\Windows\system32;c:\Windows;c:\Windows\System32\Wbem;c:\Windows\System32\WindowsPowerShell\v1.0\;c:\Program Files (x86)\MiKTeX 2.9\miktex\bin\;c:\Windows\Microsoft.NET\Framework\v2.0.50727;c:\Program Files (x86)\Calibre2\;c:\Program Files (x86)\ant\bin;c:\Program Files (x86)\Windows Live\Shared;.
Apr 10, 2013 6:02:31 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-bio-8080"]
Apr 10, 2013 6:02:31 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["ajp-bio-8009"]
Apr 10, 2013 6:02:31 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 3700 ms
Apr 10, 2013 6:02:31 PM org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
Apr 10, 2013 6:02:31 PM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.39
Apr 10, 2013 6:02:31 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive C:\Program Files (x86)\activiti-5.12\apache-tomcat-7.0.39\webapps\activiti-explorer.war
06:02:49,126 [localhost-startStop-1] INFO  org.springframework.web.context.ContextLoader  - Root WebApplicationContext: initialization started
06:02:49,344 [localhost-startStop-1] INFO  org.springframework.web.context.support.XmlWebApplicationContext  - Refreshing Root WebApplicationContext: startup date [Wed Apr 10 18:02:49 CST 2013]; root of context hierarchy
06:02:49,532 [localhost-startStop-1] INFO  org.springframework.beans.factory.xml.XmlBeanDefinitionReader  - Loading XML bean definitions from ServletContext resource [/WEB-INF/applicationContext.xml]
06:02:50,452 [localhost-startStop-1] INFO  org.springframework.beans.factory.xml.XmlBeanDefinitionReader  - Loading XML bean definitions from ServletContext resource [/WEB-INF/activiti-standalone-context.xml]
06:02:50,561 [localhost-startStop-1] INFO  org.springframework.beans.factory.xml.XmlBeanDefinitionReader  - Loading XML bean definitions from ServletContext resource [/WEB-INF/activiti-ui-context.xml]
06:02:51,014 [localhost-startStop-1] INFO  org.springframework.beans.factory.config.PropertyPlaceholderConfigurer  - Loading properties file from class path resource [db.properties]
06:02:51,029 [localhost-startStop-1] INFO  org.springframework.beans.factory.config.PropertyPlaceholderConfigurer  - Loading properties file from class path resource [ui.properties]
06:02:51,107 [localhost-startStop-1] INFO  org.springframework.beans.factory.support.DefaultListableBeanFactory  - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@aa82b: defining beans [demoDataGenerator,dbProperties,dataSource,transactionManager,processEngineConfiguration,processEngine,repositoryService,runtimeService,taskService,historyService,managementService,identityService,activitiLoginHandler,activitiUiPropertyPlaceholder,navigatorManager,attachmentRendererManager,formPropertyRendererManager,variableRendererManager,componentFactories,processDefinitionFilterFactory,deploymentFilterFactory,userCache,navigationFragmentChangeListener,mainWindow,explorerApp,i18nManager,scopedTarget.messageSource,messageSource,notificationManager,viewManager,workflowDefinitionConversionFactory]; root of factory hierarchy
06:02:56,208 [localhost-startStop-1] INFO  org.activiti.engine.impl.db.DbSqlSession  - performing create on engine with resource org/activiti/db/create/activiti.h2.create.engine.sql
06:02:56,255 [localhost-startStop-1] INFO  org.activiti.engine.impl.db.DbSqlSession  - performing create on history with resource org/activiti/db/create/activiti.h2.create.history.sql
06:02:56,271 [localhost-startStop-1] INFO  org.activiti.engine.impl.db.DbSqlSession  - performing create on identity with resource org/activiti/db/create/activiti.h2.create.identity.sql
06:02:56,271 [localhost-startStop-1] INFO  org.activiti.engine.impl.ProcessEngineImpl  - ProcessEngine default created
06:02:56,271 [localhost-startStop-1] INFO  org.activiti.engine.impl.jobexecutor.JobExecutor  - Starting up the JobExecutor[org.activiti.engine.impl.jobexecutor.DefaultJobExecutor].
06:02:56,302 [Thread-4] INFO  org.activiti.engine.impl.jobexecutor.AcquireJobsRunnable  - JobExecutor[org.activiti.engine.impl.jobexecutor.DefaultJobExecutor] starting to acquire jobs
06:02:56,318 [localhost-startStop-1] INFO  org.activiti.explorer.demo.DemoDataGenerator  - Initializing demo groups
06:02:56,474 [localhost-startStop-1] INFO  org.activiti.explorer.demo.DemoDataGenerator  - Initializing demo users
06:02:56,583 [localhost-startStop-1] INFO  org.activiti.explorer.demo.DemoDataGenerator  - Initializing demo process definitions
06:02:56,786 [localhost-startStop-1] INFO  org.activiti.engine.impl.bpmn.deployer.BpmnDeployer  - Processing resource org/activiti/explorer/demo/process/VacationRequest.png
06:02:56,786 [localhost-startStop-1] INFO  org.activiti.engine.impl.bpmn.deployer.BpmnDeployer  - Processing resource org/activiti/explorer/demo/process/FixSystemFailureProcess.bpmn20.xml
06:02:57,222 [localhost-startStop-1] INFO  org.activiti.engine.impl.bpmn.deployer.BpmnDeployer  - Processing resource org/activiti/explorer/demo/process/FixSystemFailureProcess.png
06:02:57,222 [localhost-startStop-1] INFO  org.activiti.engine.impl.bpmn.deployer.BpmnDeployer  - Processing resource org/activiti/explorer/demo/process/VacationRequest.bpmn20.xml
06:02:57,300 [localhost-startStop-1] INFO  org.activiti.engine.impl.bpmn.deployer.BpmnDeployer  - Processing resource org/activiti/explorer/demo/process/createTimersProcess.bpmn20.xml
06:02:57,347 [localhost-startStop-1] INFO  org.activiti.engine.impl.bpmn.deployer.BpmnDeployer  - Processing resource org/activiti/explorer/demo/process/reviewSalesLead.bpmn20.xml
06:03:00,374 [localhost-startStop-1] INFO  org.activiti.engine.impl.bpmn.deployer.BpmnDeployer  - Processing resource org/activiti/explorer/demo/process/Helpdesk.png
06:03:00,374 [localhost-startStop-1] INFO  org.activiti.engine.impl.bpmn.deployer.BpmnDeployer  - Processing resource org/activiti/explorer/demo/process/Helpdesk.bpmn20.xml
06:03:00,421 [localhost-startStop-1] INFO  org.activiti.engine.impl.bpmn.deployer.BpmnDeployer  - Processing resource org/activiti/explorer/demo/process/simple-approval.bpmn20.xml
06:03:00,608 [localhost-startStop-1] INFO  org.activiti.engine.impl.bpmn.deployer.BpmnDeployer  - Processing resource org/activiti/explorer/demo/process/reports/taskDurationForProcessDefinition.bpmn20.xml
06:03:00,639 [localhost-startStop-1] INFO  org.activiti.engine.impl.bpmn.deployer.BpmnDeployer  - Processing resource org/activiti/explorer/demo/process/reports/employeeProductivity.bpmn20.xml
06:03:00,670 [localhost-startStop-1] INFO  org.activiti.engine.impl.bpmn.deployer.BpmnDeployer  - Processing resource org/activiti/explorer/demo/process/reports/helpdeskFirstLineVsEscalated.bpmn20.xml
06:03:00,701 [localhost-startStop-1] INFO  org.activiti.engine.impl.bpmn.deployer.BpmnDeployer  - Processing resource org/activiti/explorer/demo/process/reports/processInstanceOverview.bpmn20.xml
06:03:00,733 [localhost-startStop-1] INFO  org.activiti.explorer.demo.DemoDataGenerator  - Initializing demo models
06:03:01,403 [localhost-startStop-1] INFO  org.activiti.explorer.demo.DemoDataGenerator  - Initializing demo report data
06:03:01,403 [Thread-7] INFO  org.activiti.engine.impl.jobexecutor.JobExecutor  - Shutting down the JobExecutor[org.activiti.engine.impl.jobexecutor.DefaultJobExecutor].
06:03:01,403 [Thread-4] INFO  org.activiti.engine.impl.jobexecutor.AcquireJobsRunnable  - JobExecutor[org.activiti.engine.impl.jobexecutor.DefaultJobExecutor] stopped job acquisition
06:03:01,637 [localhost-startStop-1] INFO  org.springframework.web.context.ContextLoader  - Root WebApplicationContext: initialization completed in 12480 ms
Apr 10, 2013 6:03:01 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive C:\Program Files (x86)\activiti-5.12\apache-tomcat-7.0.39\webapps\activiti-rest.war
06:03:05,069 [Thread-7] INFO  org.activiti.engine.impl.jobexecutor.JobExecutor  - Starting up the JobExecutor[org.activiti.engine.impl.jobexecutor.DefaultJobExecutor].
06:03:05,069 [Thread-7] INFO  org.activiti.explorer.demo.DemoDataGenerator  - Demo report data generated
06:03:05,069 [Thread-8] INFO  org.activiti.engine.impl.jobexecutor.AcquireJobsRunnable  - JobExecutor[org.activiti.engine.impl.jobexecutor.DefaultJobExecutor] starting to acquire jobs
06:03:05,631 [localhost-startStop-1] INFO  org.activiti.engine.ProcessEngines  - Initializing process engine using Spring configuration 'file:/C:/Program%20Files%20(x86)/activiti-5.12/apache-tomcat-7.0.39/webapps/activiti-rest/WEB-INF/classes/activiti-context.xml'
06:03:05,974 [localhost-startStop-1] INFO  org.springframework.beans.factory.xml.XmlBeanDefinitionReader  - Loading XML bean definitions from URL [file:/C:/Program%20Files%20(x86)/activiti-5.12/apache-tomcat-7.0.39/webapps/activiti-rest/WEB-INF/classes/activiti-context.xml]
06:03:06,068 [localhost-startStop-1] INFO  org.springframework.context.support.GenericXmlApplicationContext  - Refreshing org.springframework.context.support.GenericXmlApplicationContext@faeeb: startup date [Wed Apr 10 18:03:06 CST 2013]; root of context hierarchy
06:03:06,224 [localhost-startStop-1] INFO  org.springframework.beans.factory.config.PropertyPlaceholderConfigurer  - Loading properties file from class path resource [db.properties]
06:03:06,239 [localhost-startStop-1] INFO  org.springframework.beans.factory.support.DefaultListableBeanFactory  - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@fd949e: defining beans [dbProperties,dataSource,transactionManager,processEngineConfiguration,processEngine]; root of factory hierarchy
org.h2.jdbc.JdbcSQLException: Verbindung ist unterbrochen: "java.net.ConnectException: Connection refused: connect: localhost"
Connection is broken: "java.net.ConnectException: Connection refused: connect: localhost" [90067-170]
 at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
 at org.h2.message.DbException.get(DbException.java:158)
 at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:399)
 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.springframework.jdbc.datasource.SimpleDriverDataSource.getConnectionFromDriver(SimpleDriverDataSource.java:140)
 at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:149)
 at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:119)
 at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
 at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:224)
 at com.sun.proxy.$Proxy9.getMetaData(Unknown Source)
 at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.initDatabaseType(ProcessEngineConfigurationImpl.java:587)
 at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.initDataSource(ProcessEngineConfigurationImpl.java:548)
 at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.init(ProcessEngineConfigurationImpl.java:393)
 at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:371)
 at org.activiti.spring.SpringProcessEngineConfiguration.buildProcessEngine(SpringProcessEngineConfiguration.java:64)
 at org.activiti.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:56)
 at org.activiti.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:32)
 at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142)
 at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:102)
 at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1442)
 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(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.getBeansOfType(AbstractApplicationContext.java:1163)
 at org.activiti.spring.SpringConfigurationHelper.buildProcessEngine(SpringConfigurationHelper.java:39)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:601)
 at org.activiti.engine.ProcessEngines.initProcessEngineFromSpringResource(ProcessEngines.java:122)
 at org.activiti.engine.ProcessEngines.init(ProcessEngines.java:109)
 at org.activiti.engine.ProcessEngines.getProcessEngine(ProcessEngines.java:224)
 at org.activiti.engine.ProcessEngines.getDefaultProcessEngine(ProcessEngines.java:217)
 at org.activiti.rest.servlet.ActivitiServletContextListener.contextInitialized(ActivitiServletContextListener.java:32)
 at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4887)
 at org.apache.catalina.core.StandardContext.startInternal(StandardContext.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:877)
 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:471)
 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.net.ConnectException: Connection refused: connect
 at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
 at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:75)
 at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
 at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
 at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
 at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:157)
 at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:391)
 at java.net.Socket.connect(Socket.java:579)
 at org.h2.util.NetUtils.createSocket(NetUtils.java:119)
 at org.h2.util.NetUtils.createSocket(NetUtils.java:100)
 at org.h2.engine.SessionRemote.initTransfer(SessionRemote.java:93)
 at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:395)
 … 49 more
Apr 10, 2013 6:03:11 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Error listenerStart
Apr 10, 2013 6:03:11 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Context [/activiti-rest] startup failed due to previous errors
Apr 10, 2013 6:03:11 PM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
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 prevent a memory leak, the JDBC Driver has been forcibly unregistered.
Apr 10, 2013 6:03:11 PM org.apache.catalina.loader.WebappClassLoader checkThreadLocalMapForLeaks
SEVERE: The web application [/activiti-rest] created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@e9059c]) 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 10, 2013 6:03:11 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\Program Files (x86)\activiti-5.12\apache-tomcat-7.0.39\webapps\docs
Apr 10, 2013 6:03:11 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\Program Files (x86)\activiti-5.12\apache-tomcat-7.0.39\webapps\examples
Apr 10, 2013 6:03:12 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\Program Files (x86)\activiti-5.12\apache-tomcat-7.0.39\webapps\host-manager
Apr 10, 2013 6:03:12 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\Program Files (x86)\activiti-5.12\apache-tomcat-7.0.39\webapps\manager
Apr 10, 2013 6:03:12 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\Program Files (x86)\activiti-5.12\apache-tomcat-7.0.39\webapps\ROOT
Apr 10, 2013 6:03:12 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-8080"]
Apr 10, 2013 6:03:12 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["ajp-bio-8009"]
Apr 10, 2013 6:03:12 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 40987 ms

Re: to find folder

udoderk — Fri, 12 Apr 2013 19:02:40 GMT

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

Re: to find folder

tomi87 — Sat, 13 Apr 2013 14:13:51 GMT

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

Re: to find folder

udoderk — Sat, 13 Apr 2013 19:15:39 GMT

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

Re: to find folder

tomi87 — Sun, 14 Apr 2013 07:53:39 GMT

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 ?

Re: to find folder

udoderk — Sun, 14 Apr 2013 09:11:29 GMT

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,