problem with the demo.start H2 Database

[lordwizard]

Hy guys I encountered a problem during the starting of the "demo.start", in particular with the h2 database.
When I started the demo I understood that the script lunch the database and populate it using the "population file" ->activiti-5.5\setup\files\demo\h2.data. But I saw that in this file there are only the SQL code to populate the tables and not the creation code for the tables. I thought that the "creation code" were generated in another way but using the H2 control panel (connecting before to the db)that the tables mentioned in the h2.data do not exist and this cause malfunction at the activiti system! Have you any ideas about my problem???  :cry: Where I can get the table creation file??? :cry:  :cry:  Thanks in advance for our replies!

[frederikherema1]

The tables are created by the engine itself, not by the demo-setup script. You can find these in the activiti-engine jar, somewhere around:
org/activiti/db/create/activiti.h2.create.engine.sql
The tables should be created automatically, when they don't exist. Do you see any stacktrace when starting the demo clean?

[lordwizard]

Thanks for your replies but where is this file "activiti.h2.create.engine.sql" because I tried to search it… but i didn't find anything in the folder "Activiti-5.5". Another question, where is the log file (with the stacktrace) that you mean ?
In the tomcat manager the only module loaded is "activiti-rest" but I think that should be loaded also activiti-explorer, activiti-modeler etc…

[frederikherema1]

The file I'm referring to is inside the activiti-engine-5.5.jar file, in the path I mentioned earlier. The tomcat-log is in apps/apache-tomcat-6.XX/logs/catalina.out

[lordwizard]

The file I'm referring to is inside the activiti-engine-5.5.jar file, in the path I mentioned earlier. The tomcat-log is in apps/apache-tomcat-6.XX/logs/catalina.out

this the content of the file "catalina"



10-mag-2011 9.25.35 org.apache.catalina.core.AprLifecycleListener init
INFO: Loaded APR based Apache Tomcat Native library 1.1.20.
10-mag-2011 9.25.36 org.apache.catalina.core.AprLifecycleListener init
INFO: APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
10-mag-2011 9.25.38 org.apache.coyote.http11.Http11AprProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
10-mag-2011 9.25.38 org.apache.coyote.ajp.AjpAprProtocol init
INFO: Initializing Coyote AJP/1.3 on ajp-8009
10-mag-2011 9.25.38 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 2945 ms
10-mag-2011 9.25.38 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
10-mag-2011 9.25.38 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.32
10-mag-2011 9.25.38 org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor host-manager.xml
10-mag-2011 9.25.38 org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor manager.xml
10-mag-2011 9.25.39 org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory activiti-rest
10-mag-2011 9.25.39 org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory docs
10-mag-2011 9.25.39 org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory examples
10-mag-2011 9.25.39 org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory ROOT
10-mag-2011 9.25.39 org.apache.coyote.http11.Http11AprProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
10-mag-2011 9.25.39 org.apache.coyote.ajp.AjpAprProtocol start
INFO: Starting Coyote AJP/1.3 on ajp-8009
10-mag-2011 9.25.39 org.apache.catalina.startup.Catalina start
INFO: Server startup in 1378 ms
10-mag-2011 9.59.58 org.apache.coyote.http11.Http11AprProtocol pause
INFO: Pausing Coyote HTTP/1.1 on http-8080
10-mag-2011 9.59.58 org.apache.coyote.ajp.AjpAprProtocol pause
INFO: Pausing Coyote AJP/1.3 on ajp-8009
10-mag-2011 9.59.59 org.apache.catalina.core.StandardService stop
INFO: Stopping service Catalina
10-mag-2011 9.59.59 org.apache.coyote.http11.Http11AprProtocol destroy
INFO: Stopping Coyote HTTP/1.1 on http-8080
10-mag-2011 9.59.59 org.apache.coyote.ajp.AjpAprProtocol destroy
INFO: Stopping Coyote AJP/1.3 on ajp-8009


for the creation file: I found it……

[frederikherema1]

What is in the log-file when you actually use an activiti webapp? I don't see any exception in the log…