Michael Wagner [
http://community.jboss.org/people/michael.wagner] created the discussion
"Re: H2 database problems, running jBPM 5.1 demo"
To view the discussion, visit:
http://community.jboss.org/message/612983#612983
--------------------------------------------------------------
Hi,
I am still running into this problems after I deleted everything, downloading again and
just create a new process over the console.
Here is my transcript:
C:\jbpm-installer>ant install.demo Buildfile: C:\jbpm-installer\build.xml
download.jboss.check: [echo] Checking JBoss AS download ... download.jboss:
[echo] Getting JBoss AS ... [get] Getting:
http://downloads.sourceforge.net/jboss/jboss-5.1.0.GA.zip
http://downloads.sourceforge.net/jboss/jboss-5.1.0.GA.zip [get] To:
C:\jbpm-installer\lib\jboss-5.1.0.GA.zip [get]
http://downloads.sourceforge.net/jboss/jboss-5.1.0.GA.zip
http://downloads.sourceforge.net/jboss/jboss-5.1.0.GA.zip permanently moved to
http://downloads.sourceforge http://downloads.sourceforge.
net/project/jboss/JBoss/JBoss-5.1.0.GA/jboss-5.1.0.GA.zip [get]
http://downloads.sourceforge.net/project/jboss/JBoss/JBoss-5.1.0.GA/jboss...
http://downloads.sourceforge.net/project/jboss/JBoss/JBoss-5.1.0.GA/jboss...
moved to
http://switc http://switc
h.dl.sourceforge.net/project/jboss/JBoss/JBoss-5.1.0.GA/jboss-5.1.0.GA.zip
install.jboss: [unzip] Expanding: C:\jbpm-installer\lib\jboss-5.1.0.GA.zip into
C:\jbpm-installer download.drools.guvnor.check: [echo] Checking Drools Guvnor
download ... download.drools.guvnor: install.guvnor.into.jboss: check.jboss.version:
install.guvnor.into.jboss.5: [mkdir] Created dir:
C:\jbpm-installer\target\drools-guvnor [unzip] Expanding:
C:\jbpm-installer\lib\guvnor-distribution-wars-5.2.0.Final-jboss-as-5.1.war into
C:\jbpm-installe r\target\drools-guvnor [zip] Building zip:
C:\jbpm-installer\target\drools-guvnor.war [copy] Copying 1 file to
C:\jbpm-installer\jboss-5.1.0.GA\server\default\deploy [delete] Deleting directory
C:\jbpm-installer\target check.jboss.version: install.guvnor.into.jboss.other:
download.designer.check: [echo] Checking Designer download ... download.designer:
install.designer.into.jboss: [copy] Copying 1 file to
C:\jbpm-installer\jboss-5.1.0.GA\server\default\deploy download.h2.check: [echo]
Checking h2 download ... download.h2: [echo] Getting h2 ... [get] Getting:
http://repo1.maven.org/maven2/com/h2database/h2/1.2.124/h2-1.2.124.jar
http://repo1.maven.org/maven2/com/h2database/h2/1.2.124/h2-1.2.124.jar [get] To:
C:\jbpm-installer\db\driver\h2.jar check.birt: download.birt.check: download.birt:
download.jBPM.gwt-console.check: [echo] Checking jBPM gwt-console download ...
download.jBPM.gwt-console: install.jBPM-gwt-console.into.jboss: [mkdir] Created dir:
C:\jbpm-installer\target [unzip] Expanding:
C:\jbpm-installer\lib\jbpm-5.1.0.Final-gwt-console.zip into C:\jbpm-installer\target
[mkdir] Created dir: C:\jbpm-installer\target\jbpm-gwt-console-server-war [unzip]
Expanding: C:\jbpm-installer\target\jbpm-gwt-console-server-5.1.0.Final.war into
C:\jbpm-installer\target\jb pm-gwt-console-server-war [copy] Copying 1 file to
C:\jbpm-installer\target\jbpm-gwt-console-server-war\WEB-INF\classes [copy] Copying 1
file to C:\jbpm-installer\target\jbpm-gwt-console-server-war\WEB-INF\classes\META-INF
[copy] Copying 2 files to
C:\jbpm-installer\target\jbpm-gwt-console-server-war\WEB-INF\classes [zip] Building
zip: C:\jbpm-installer\target\jbpm-gwt-console-server-5.1.0.Final.war [copy] Copying
1 file to C:\jbpm-installer\jboss-5.1.0.GA\server\default\deploy [copy] Copying 1
file to C:\jbpm-installer\jboss-5.1.0.GA\server\default\deploy [delete] Deleting
directory C:\jbpm-installer\target [copy] Copying 1 file to
C:\jbpm-installer\jboss-5.1.0.GA\server\default\deploy [copy] Copying 1 file to
C:\jbpm-installer\jboss-5.1.0.GA\server\default\lib [copy] Copying 1 file to
C:\jbpm-installer\jboss-5.1.0.GA\server\default\conf [copy] Copying 1 file to
C:\jbpm-installer\jboss-5.1.0.GA\server\default\conf check.birt:
install.reporting.into.jboss: download.eclipse.check: [echo] Checking Eclipse
download ... download.eclipse: download.eclipse.gef.check: [echo] Checking Eclipse
GEF download ... download.eclipse.gef: [echo] Getting Eclipse GEF ... [get]
Getting:
http://download.eclipse.org/tools/gef/downloads/drops/3.6.2/R201102251600...
http://download.eclipse.org/tools/gef/downloads/drops/3.6.2/R201102251600...
[get] To: C:\jbpm-installer\lib\GEF-SDK-3.6.2.zip install.eclipse: unzipEclipse:
[unzip] Expanding: C:\jbpm-installer\lib\eclipse-java-helios-SR2-win32.zip into
C:\jbpm-installer untarEclipse: [unzip] Expanding:
C:\jbpm-installer\lib\GEF-SDK-3.6.2.zip into C:\jbpm-installer
download.jBPM.eclipse.check: [echo] Checking jBPM Eclipse download ...
download.jBPM.eclipse: install.jBPM-eclipse.into.eclipse: [unzip] Expanding:
C:\jbpm-installer\lib\jbpm-5.1.0.Final-eclipse-all.zip into C:\jbpm-installer\eclipse
download.jBPM.bin.check: [echo] Checking jBPM binaries download ...
download.jBPM.bin: install.jBPM.runtime: [mkdir] Created dir:
C:\jbpm-installer\runtime [unzip] Expanding:
C:\jbpm-installer\lib\jbpm-5.1.0.Final-bin.zip into C:\jbpm-installer\runtime
download.drools.eclipse.check: [echo] Checking Drools Eclipse download ...
download.drools.eclipse: install.drools-eclipse.into.eclipse: [mkdir] Created dir:
C:\jbpm-installer\eclipse\drools-update-site [unzip] Expanding:
C:\jbpm-installer\lib\org.drools.updatesite-5.2.0.Final-assembly.zip into
C:\jbpm-installer\eclip se\drools-update-site [copy] Copying 3 files to
C:\jbpm-installer\eclipse\features [copy] Copying 4 files to
C:\jbpm-installer\eclipse\plugins [delete] Deleting directory
C:\jbpm-installer\eclipse\drools-update-site install.demo: BUILD SUCCESSFUL Total time:
11 minutes 45 seconds C:\jbpm-installer>ant start.demo Buildfile:
C:\jbpm-installer\build.xml download.h2.check: [echo] Checking h2 download ...
download.h2: start.h2: start.jboss: start.eclipse: start.human.task: [mkdir]
Created dir: C:\jbpm-installer\task-service\target [javac]
C:\jbpm-installer\build.xml:500: warning: 'includeantruntime' was not set,
defaulting to build.sysclasspath= last; set to false for repeatable builds [javac]
Compiling 1 source file to C:\jbpm-installer\task-service\target [javac]
C:\jbpm-installer\task-service\src\org\jbpm\DemoTaskService.java:49: warning: [unchecked]
unchecked cast [javac] found : java.lang.Object [javac] required:
java.util.Map [javac] Map users = ( Map ) eval( reader, vars );
[javac] ^ [javac]
C:\jbpm-installer\task-service\src\org\jbpm\DemoTaskService.java:54: warning: [unchecked]
unchecked cast [javac] found : java.lang.Object [javac] required:
java.util.Map [javac] Map groups = ( Map ) eval( reader, vars );
[javac] ^ [javac] Note:
C:\jbpm-installer\task-service\src\org\jbpm\DemoTaskService.java uses or overrides a
deprecated API. [javac] Note: Recompile with -Xlint:deprecation for details.
[javac] 2 warnings [copy] Copying 2 files to
C:\jbpm-installer\task-service\target [java] SLF4J: Failed to load class
"org.slf4j.impl.StaticLoggerBinder". [java] SLF4J: Defaulting to
no-operation (NOP) logger implementation [java] SLF4J: See
http://www.slf4j.org/codes.html#StaticLoggerBinder
http://www.slf4j.org/codes.html#StaticLoggerBinder for further details. [java] Task
service started correctly ! [java] Task service running ... [java]
javax.persistence.RollbackException: Error while commiting the transaction [java]
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:71) [java] at
org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:820)
[java] at
org.jbpm.task.service.TaskServiceSession.addTask(TaskServiceSession.java:134)
[java] at
org.jbpm.task.service.TaskServerHandler.messageReceived(TaskServerHandler.java:109)
[java] at
org.jbpm.task.service.mina.MinaTaskServerHandler.messageReceived(MinaTaskServerHandler.java:41)
[java] at
org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain
.java:713) [java] at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.ja
va:434) [java] at
org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)
[java] at
org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChai
n.java:793) [java] at
org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(ProtocolCodecFilter.
java:375) [java] at
org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:229)
[java] at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.ja
va:434) [java] at
org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)
[java] at
org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChai
n.java:793) [java] at
org.apache.mina.filter.logging.LoggingFilter.messageReceived(LoggingFilter.java:176)
[java] at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.ja
va:434) [java] at
org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)
[java] at
org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChai
n.java:793) [java] at
org.apache.mina.core.filterchain.IoFilterAdapter.messageReceived(IoFilterAdapter.java:119)
[java] at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.ja
va:434) [java] at
org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(DefaultIoFilterChain.java:4
26) [java] at
org.apache.mina.core.polling.AbstractPollingIoProcessor.read(AbstractPollingIoProcessor.java:638)
[java] at
org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:598)
[java] at
org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:587)
[java] at
org.apache.mina.core.polling.AbstractPollingIoProcessor.access$400(AbstractPollingIoProcessor.java:61
) [java] at
org.apache.mina.core.polling.AbstractPollingIoProcessor$Processor.run(AbstractPollingIoProcessor.java
:969) [java] at
org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:64)
[java] at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
[java] at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
[java] at java.lang.Thread.run(Thread.java:662) [java] Caused by:
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch
update [java] at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
[java] at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
[java] at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) [java]
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266) [java]
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168) [java]
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener
.java:321) [java] at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
[java] at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027) [java]
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365) [java] at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137) [java]
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54) [java] ...
29 more [java] Caused by: org.h2.jdbc.JdbcBatchUpdateException: Referentielle
Integritõt verletzt: "FK27A9A59E619A0: PUBLIC .TASK FOREIGN KEY(CREATEDBY_ID)
REFERENCES PUBLIC.ORGANIZATIONALENTITY(ID)" [java] Referential integrity
constraint violation: "FK27A9A59E619A0: PUBLIC.TASK FOREIGN KEY(CREATEDBY_ID)
REFERENC ES PUBLIC.ORGANIZATIONALENTITY(ID)"; SQL statement: [java] update Task
set allowedToDelegate=?, taskInitiator_id=?, priority=?, activationTime=?,
actualOwner_id=?, cre atedBy_id=?, createdOn=?, documentAccessType=?, documentContentId=?,
documentType=?, expirationTime=?, faultAccessType=? , faultContentId=?, faultName=?,
faultType=?, outputAccessType=?, outputContentId=?, outputType=?, parentId=?, previousS
tatus=?, processInstanceId=?, skipable=?, status=?, workItemId=? where id=?
[23002-124] [java] at
org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1082)
[java] at
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) [java]
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
[java] ... 37 more
Are there any right I have to set? Where exactly is the db file stored? Michael
--------------------------------------------------------------
Reply to this message by going to Community
[
http://community.jboss.org/message/612983#612983]
Start a new discussion in jBPM at Community
[
http://community.jboss.org/choose-container!input.jspa?contentType=1&...]