[jboss-user] [jBPM] - Re: H2 database problems, running jBPM 5.1 demo
Michael Wagner
do-not-reply at jboss.com
Fri Jul 1 09:34:29 EDT 2011
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-5.1.0.GA.zip http://downloads.sourceforge.net/project/jboss/JBoss/JBoss-5.1.0.GA/jboss-5.1.0.GA.zip 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/GEF-SDK-3.6.2.zip http://download.eclipse.org/tools/gef/downloads/drops/3.6.2/R201102251600/GEF-SDK-3.6.2.zip [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&containerType=14&container=2034]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20110701/2f667adb/attachment-0001.html
More information about the jboss-user
mailing list