[JBoss jBPM] - Re: EJB-JBPM: transaction clash (rollbacks)
by Johan.Parent
Thanks for the reaction guys!
The queries contain some sensitive/personal data and I just don't want my head chopped off by my boss :-P
Well I can post an edited (and somewhat shorter version of the output). It contains JBPM log info but also the queries, I don't think it is confusing. The "select" at the very beginning is the last query produced by the app. After that it's jbpm code. I removed the inserts for the variable instances but all is fine there. I did not leave any commit notifications out.
The way I interpret the output: after the final save() of the process instance the connection is rolled back. I got no clue why this happens, I don't understand nearly enough about dbs to be sure about this "conclusion". What I'm sure about it that there is not trace left in the db afterwards.
Regards,
Johan
| 1,874ms executing PreparedStatement: SELECT WL0.Oid, WL0.CreDate, WL0.CreUserId, WL0.Domain, WL0.Identifier, WL0.isActive, WL0.ModDate, WL0.ModUserId, WL0.ServiceId, WL0.SettingId, WL0.SettingValue, WL0.Description, WL0.Version FROM user_db..ServiceSettings WL0 WHERE ( WL0.ServiceId = 'FER' )
| creating jbpm context with service factories '[message, scheduler, logging, persistence, authentication]'
| creating JbpmContext
| creating persistence service
| 2,037ms executing PreparedStatement: select processdef0_.ID_ as ID1_2_, processdef0_.NAME_ as NAME2_2_, processdef0_.VERSION_ as VERSION3_2_, processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_2_, processdef0_.STARTSTATE_ as STARTSTATE5_2_ from JBPM_PROCESSDEFINITION processdef0_ where processdef0_.NAME_='createReadReport' order by processdef0_.VERSION_ desc
| closing JbpmContext
| closing service 'persistence': org.jbpm.persistence.db.DbPersistenceService@8d7e43
| creating jbpm context with service factories '[message, scheduler, logging, persistence, authentication]'
| creating JbpmContext
| creating persistence service
| 0,936ms executing PreparedStatement: select processdef0_.ID_ as ID1_2_, processdef0_.NAME_ as NAME2_2_, processdef0_.VERSION_ as VERSION3_2_, processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_2_, processdef0_.STARTSTATE_ as STARTSTATE5_2_ from JBPM_PROCESSDEFINITION processdef0_ where processdef0_.NAME_='createReadReport' order by processdef0_.VERSION_ desc
| 2,591ms executing PreparedStatement: insert into JBPM_TOKEN (VERSION_, NAME_, START_, END_, NODEENTER_, NEXTLOGINDEX_, ISABLETOREACTIVATEPARENT_, ISTERMINATIONIMPLICIT_, ISSUSPENDED_, NODE_, PROCESSINSTANCE_, PARENT_, SUBPROCESSINSTANCE_) values (0, null, '2007-07-13 13:51:48.533', null, null, 0, true, false, false, 95, null, null, null)
| select @@identity
| 1,169ms executing PreparedStatement: insert into JBPM_PROCESSINSTANCE (VERSION_, START_, END_, ISSUSPENDED_, PROCESSDEFINITION_, ROOTTOKEN_, SUPERPROCESSTOKEN_) values (0, '2007-07-13 13:51:48.533', null, false, 22, 328, null)
| select @@identity
| 1,146ms executing PreparedStatement: select definition0_.PROCESSDEFINITION_ as PROCESSD4_1_, definition0_.ID_ as ID1_1_, definition0_.NAME_ as NAME3_1_, definition0_.ID_ as ID1_15_0_, definition0_.NAME_ as NAME3_15_0_, definition0_.PROCESSDEFINITION_ as PROCESSD4_15_0_, definition0_.STARTTASK_ as STARTTASK5_15_0_, definition0_.CLASS_ as CLASS2_15_0_ from JBPM_MODULEDEFINITION definition0_ where definition0_.PROCESSDEFINITION_=22
| event 'process-start' on 'ProcessDefinition(createReadReport)' for 'Token(/)'
| 1,405ms executing PreparedStatement: select events0_.PROCESSDEFINITION_ as PROCESSD5_1_, events0_.ID_ as ID1_1_, events0_.EVENTTYPE_ as EVENTTYPE2_1_, events0_.ID_ as ID1_5_0_, events0_.EVENTTYPE_ as EVENTTYPE2_5_0_, events0_.TYPE_ as TYPE3_5_0_, events0_.GRAPHELEMENT_ as GRAPHELE4_5_0_ from JBPM_EVENT events0_ where events0_.PROCESSDEFINITION_=22
| executing default save operations
| saving process instance
| flushing logs to logging service.
| 2,191ms executing PreparedStatement: insert into JBPM_LOG (INDEX_, DATE_, TOKEN_, PARENT_, CLASS_) values (0, '2007-07-13 13:51:48.593', 328, null, 'I')
| select @@identity
| cascading save of 'org.jbpm.graph.exe.ProcessInstance@15c9b76'
| executing default save operations
| saving process instance
| flushing logs to logging service.
| cascading save of 'org.jbpm.graph.exe.ProcessInstance@15c9b76'
| closing JbpmContext
| closing service 'persistence': org.jbpm.persistence.db.DbPersistenceService@db7371
| closing service 'logging': org.jbpm.logging.db.DbLoggingService@1782201
| creating jbpm context with service factories '[message, scheduler, logging, persistence, authentication]'
| creating JbpmContext
| creating persistence service
| create variable ...
| ... EDITED TO REMOVE CUSTOMER
| 2,270ms executing PreparedStatement: insert into JBPM_VARIABLEINSTANCE (NAME_, CONVERTER_, TOKEN_, TOKENVARIABLEMAP_, PROCESSINSTANCE_, STRINGVALUE_, CLASS_) values ('MEDICAL_SERVICE', null, 328, null, 328, 'FER', 'S')
| select @@identity
| 1,822ms executing PreparedStatement: insert into JBPM_LOG (INDEX_, DATE_, TOKEN_, PARENT_, VARIABLEINSTANCE_, CLASS_) values (1, '2007-07-13 13:51:48.804', 328, null, 5764, 'R')
| select @@identity
| 1,773ms executing PreparedStatement: insert into JBPM_LOG (INDEX_, DATE_, TOKEN_, PARENT_, VARIABLEINSTANCE_, OLDSTRINGVALUE_, NEWSTRINGVALUE_, CLASS_) values (2, '2007-07-13 13:51:48.804', 328, null, 5764, null, 'FER', 'U')
| select @@identity
| ... EDITED HERE TOO
| selected transition name 'createNewProcess'
| 0,889ms executing PreparedStatement: select leavingtra0_.FROM_ as FROM4_1_, leavingtra0_.ID_ as ID1_1_, leavingtra0_.FROMINDEX_ as FROMINDEX6_1_, leavingtra0_.ID_ as ID1_4_0_, leavingtra0_.NAME_ as NAME2_4_0_, leavingtra0_.PROCESSDEFINITION_ as PROCESSD3_4_0_, leavingtra0_.FROM_ as FROM4_4_0_, leavingtra0_.TO_ as TO5_4_0_ from JBPM_TRANSITION leavingtra0_ where leavingtra0_.FROM_=96
| event 'node-leave' on 'Decision(Check creation needed)' for 'Token(/)'
| event 'transition' on 'Transition(createNewProcess)' for 'Token(/)'
| 0,865ms executing PreparedStatement: select events0_.TRANSITION_ as TRANSITION7_1_, events0_.ID_ as ID1_1_, events0_.EVENTTYPE_ as EVENTTYPE2_1_, events0_.ID_ as ID1_5_0_, events0_.EVENTTYPE_ as EVENTTYPE2_5_0_, events0_.TYPE_ as TYPE3_5_0_, events0_.GRAPHELEMENT_ as GRAPHELE4_5_0_ from JBPM_EVENT events0_ where events0_.TRANSITION_=86
| 0,952ms executing PreparedStatement: select node0_.ID_ as ID1_3_0_, node0_.NAME_ as NAME3_3_0_, node0_.PROCESSDEFINITION_ as PROCESSD4_3_0_, node0_.ISASYNC_ as ISASYNC5_3_0_, node0_.ACTION_ as ACTION6_3_0_, node0_.SUPERSTATE_ as SUPERSTATE7_3_0_, node0_.SUBPROCESSDEFINITION_ as SUBPROCE8_3_0_, node0_.DECISIONEXPRESSION_ as DECISION9_3_0_, node0_.DECISIONDELEGATION as DECISIO10_3_0_, node0_.SIGNAL_ as SIGNAL11_3_0_, node0_.CREATETASKS_ as CREATET12_3_0_, node0_.ENDTASKS_ as ENDTASKS13_3_0_, node
| 0_.CLASS_ as CLASS2_3_0_ from JBPM_NODE node0_ where node0_.ID_=97
| event 'node-enter' on 'Node(Create Report)' for 'Token(/)'
| 1,033ms executing PreparedStatement: select events0_.NODE_ as NODE6_1_, events0_.ID_ as ID1_1_, events0_.EVENTTYPE_ as EVENTTYPE2_1_, events0_.ID_ as ID1_5_0_, events0_.EVENTTYPE_ as EVENTTYPE2_5_0_, events0_.TYPE_ as TYPE3_5_0_, events0_.GRAPHELEMENT_ as GRAPHELE4_5_0_ from JBPM_EVENT events0_ where events0_.NODE_=97
| 2,085ms executing PreparedStatement: select action0_.ID_ as ID1_6_0_, action0_.NAME_ as NAME3_6_0_, action0_.ISPROPAGATIONALLOWED_ as ISPROPAG4_6_0_, action0_.ACTIONEXPRESSION_ as ACTIONEX5_6_0_, action0_.ISASYNC_ as ISASYNC6_6_0_, action0_.REFERENCEDACTION_ as REFERENC7_6_0_, action0_.ACTIONDELEGATION_ as ACTIONDE8_6_0_, action0_.EVENT_ as EVENT9_6_0_, action0_.PROCESSDEFINITION_ as PROCESS10_6_0_, action0_.TIMERNAME_ as TIMERNAME11_6_0_, action0_.DUEDATE_ as DUEDATE12_6_0_, action0_.REPEAT_ as REPEAT13_6_0_, action0_.TRANSITIONNAME_ as TRANSIT14_6_0_, action0_.TIMERACTION_ as TIMERAC15_6_0_, action0_.EXPRESSION_ as EXPRESSION16_6_0_, action0_.class as class6_0_ from JBPM_ACTION action0_ where action0_.ID_=66
| 0,791ms executing PreparedStatement: select delegation0_.ID_ as ID1_8_0_, delegation0_.CLASSNAME_ as CLASSNAME2_8_0_, delegation0_.CONFIGURATION_ as CONFIGUR3_8_0_, delegation0_.CONFIGTYPE_ as CONFIGTYPE4_8_0_, delegation0_.PROCESSDEFINITION_ as PROCESSD5_8_0_ from JBPM_DELEGATION delegation0_ where delegation0_.ID_=66
| 1,464ms executing PreparedStatement: insert into JBPM_MODULEINSTANCE (PROCESSINSTANCE_, TASKMGMTDEFINITION_, CLASS_) values (328, 44, 'T')
| select @@identity
| 0,739ms executing PreparedStatement: insert into JBPM_MODULEINSTANCE (PROCESSINSTANCE_, CLASS_) values (328, 'C')
| select @@identity
| 0,848ms executing PreparedStatement: insert into JBPM_TOKENVARIABLEMAP (TOKEN_, CONTEXTINSTANCE_) values (328, 656)
| select @@identity
| 1,614ms executing PreparedStatement: select processdef0_.ID_ as ID1_2_, processdef0_.NAME_ as NAME2_2_, processdef0_.VERSION_ as VERSION3_2_, processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_2_, processdef0_.STARTSTATE_ as STARTSTATE5_2_ from JBPM_PROCESSDEFINITION processdef0_ where processdef0_.NAME_='stresstest_ReadReport' order by processdef0_.VERSION_ desc
| 1,312ms executing PreparedStatement: select exceptionh0_.NODE_ as NODE7_1_, exceptionh0_.ID_ as ID1_1_, exceptionh0_.GRAPHELEMENTINDEX_ as GRAPHELE6_1_, exceptionh0_.ID_ as ID1_7_0_, exceptionh0_.EXCEPTIONCLASSNAME_ as EXCEPTIO2_7_0_, exceptionh0_.TYPE_ as TYPE3_7_0_, exceptionh0_.GRAPHELEMENT_ as GRAPHELE4_7_0_ from JBPM_EXCEPTIONHANDLER exceptionh0_ where exceptionh0_.NODE_=97
| 0,783ms executing PreparedStatement: select exceptionh0_.PROCESSDEFINITION_ as PROCESSD5_1_, exceptionh0_.ID_ as ID1_1_, exceptionh0_.GRAPHELEMENTINDEX_ as GRAPHELE6_1_, exceptionh0_.ID_ as ID1_7_0_, exceptionh0_.EXCEPTIONCLASSNAME_ as EXCEPTIO2_7_0_, exceptionh0_.TYPE_ as TYPE3_7_0_, exceptionh0_.GRAPHELEMENT_ as GRAPHELE4_7_0_ from JBPM_EXCEPTIONHANDLER exceptionh0_ where exceptionh0_.PROCESSDEFINITION_=22
| closing JbpmContext
| closing service 'persistence': org.jbpm.persistence.db.DbPersistenceService@1d3bb7b
| Rolling back connection: com.sybase.jdbc2.jdbc.SybConnection@118d722
| 4,033ms executing PreparedStatement: SELECT RequisitionNo,PerformingServiceId,SequenceNo,FollowUpState,ScheduledTime,Mnemonic,ItemGroupId,PerformingResourceId,AccessNo,RequisitionTime,OriginId,PresriberId,PrescriberName,EventServer,EventTable,EventPK,PatientId,MedServiceId,EventDefName,RelEventDefLevelId,Status,PatientLastName,PatientFirstName,HospitalisationNo,EventRefPK,VerwServiceId FROM ref_db..OrderComEventReferenceView WHERE AccessNo = '07B03406' and PerformingServiceId = 'LABA' ORDER B
| Y RequisitionTime DESC
| Committing connection: com.sybase.jdbc2.jdbc.SybConnection@118d722
|
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4064007#4064007
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4064007
19Â years
[JBoss jBPM] - Re: complex process definition
by kukeltje
regarding the levels of complexity, I was referring to your first post (I was reading that and typing a response when your second one came in.
Thanks for referring to the patterns. It can make the discussion much clearer. Some of these patterns are new (it is a revised and better document). So that is why there is no example of this (yet) and the numbers have changed, so we should do something with that in the testcases.
>From what I read, it is not just a structured loop for what you want. Triggers, cancellations, deferred choice etc.. that is what makes it, like you said in the subject ;-) a complex process. Not to complex, but not straightforward certainly not if there is some kind of nesting.
My remark 'do you need bpm at all' was wrong, I should have said do you want to do ALL of this IN bpm. Sometimes using just java for some parts, an esb for others and bpm at a third level is better (although not always easier to maintain in a combination)
One of the most important question is what triggers the one-of-three transitions. And What if no trigger comes in. The second one is why multiple messages could come in and what should happen then (also with the already triggered flow)? And the answer should not be how you think to model it, just in functional terms
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4064005#4064005
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4064005
19Â years
[Clustering/JBoss] - JBoss instances don't find each other
by elko
I have following problem: wenn I start my jboss-instances, they see each other, but don't recognize each other to be members of the same cluster.
Any suggestions? thnx
ServerLog (host: pavullo, other host: sacuzzo):
...
-------------------------------------------------------
GMS: address is 172.30.5.82:32828
-------------------------------------------------------
20:55:33,216 INFO [TreeCache] TreeCache local address is 172.30.5.82:32828
20:55:37,678 INFO [TreeCache] viewAccepted(): [sacuzzo:32808|1] [sacuzzo:32808, 172.30.5.82:32828]
20:55:47,778 INFO [TreeCache] received the state (size=1024 bytes)
20:55:48,091 INFO [TreeCache] state was retrieved successfully (in 14874 milliseconds)
20:55:48,092 INFO [TreeCache] parseConfig(): PojoCacheConfig is empty
20:55:50,668 INFO [DefaultPartition] Initializing
20:55:56,212 INFO [STDOUT]
-------------------------------------------------------
GMS: address is 172.30.5.82:32831 (additional data: 16 bytes)
-------------------------------------------------------
20:55:58,252 INFO [DefaultPartition] Number of cluster members: 1
20:55:58,252 INFO [DefaultPartition] Other members: 0
20:55:58,252 INFO [DefaultPartition] Fetching state (will wait for 30000 milliseconds):
20:55:58,261 INFO [DefaultPartition] New cluster view for partition DefaultPartition (id: 0, delta: 0) : [172.30.5.82:1099]
20:55:58,274 INFO [DefaultPartition] State could not be retrieved (we are the first member in group)
20:55:58,412 INFO [DefaultPartition] I am (172.30.5.82:1099) received membershipChanged event:
20:55:58,412 INFO [DefaultPartition] Dead members: 0 ([])
20:55:58,413 INFO [DefaultPartition] New Members : 0 ([])
20:55:58,413 INFO [DefaultPartition] All Members : 1 ([172.30.5.82:1099])
20:55:58,961 INFO [HANamingService] Started ha-jndi bootstrap jnpPort=1100, backlog=50, bindAddress=/172.30.5.82
20:55:59,449 INFO [DetachedHANamingService$AutomaticDiscovery] Listening on /172.30.5.82:1102, group=230.0.0.4, HA-JNDI address=172.30.5.82:1100
...
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4064003#4064003
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4064003
19Â years
[JBoss Seam] - ui:param and navigation into seam (like seam dvd store examp
by grdzeli_kaci
hi all, i use seam project.
facelets for navigation.
i saw dvd store example into seam examples.
i like it very much, i need menu like there. there is menu build on and
| <ul>
| <li id="page_home"><s:link view="/home.xhtml" value="Home" propagation="none"/></li>
| ..............
| ...............
| </ul>^
|
i did also this into my example, but i have richfaces toolbar component for menu (rendered as html table).
| <rich:toolBar id="menuTableId" height="15" itemSeparator="line" separatorClass="sepClass">
| <rich:toolBarGroup itemSeparator="line">
| <s:link id="home" view="/jguru/issue/content/topmenu/home.xhtml" value="Home" propagation="none">
| <ui:param name="page" value="home" />
| </s:link>
| </rich:toolBarGroup>
| <rich:toolBarGroup itemSeparator="line">
| <s:link id="brproj" view="/jguru/issue/content/topmenu/browseproject.xhtml" value="Browse Project" propagation="none">
| <ui:param name="page" value="brproj" />
| </s:link>
| </rich:toolBarGroup>
| <rich:toolBarGroup itemSeparator="line">
| <s:link id="findissue" view="/jguru/issue/content/topmenu/findissue.xhtml" value="Find Issue" propagation="none">
| <ui:param name="page" value="findissue" />
| </s:link>
| </rich:toolBarGroup>
| <rich:toolBarGroup itemSeparator="line">
| <s:link id="newissue" view="/jguru/issue/content/topmenu/newissue.xhtml" value="Create New Issue" propagation="none">
| <ui:param name="page" value="newissue" />
| </s:link>
| </rich:toolBarGroup>
| <rich:toolBarGroup itemSeparator="line">
| <s:link id="admin" view="/jguru/issue/content/admin/body.xhtml" value="Administration" propagation="none">
| <ui:param name="page" value="admin" />
| </s:link>
| </rich:toolBarGroup>
| </rich:toolBar>
|
after this into example there is javascript code and get this component and set background for this.
| <script language="JavaScript">
| function setClass(id, className) {
| var obj = document.getElementById(id);
| if (obj != null) {
| obj.className = className;
| }
| }
| setClass("page_:" + "#{page}", "current");
| </script>
|
every page set the parameter into example, for example :
| <ui:include src="/WEB-INF/incl/store_nav.xhtml">
| <ui:param name="page" value="home" />
| </ui:include>
|
but different in my example and sample is that into example there is full html pages:
home.xhtml, chackout.xhtml, browse.xhtml, but into my example i have not entire html pages, i have page fragments and i build it into template :
1.template:
| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
| <html xmlns="http://www.w3.org/1999/xhtml"
| xmlns:ui="http://java.sun.com/jsf/facelets">
| <head>
| <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
| <title>Billing</title>
| <link href="/Billing/css/default.css" rel="stylesheet" type="text/css" />
| <link href="/Billing/css/cssLayout.css" rel="stylesheet" type="text/css" />
| <link href="/Billing/css/theme.css" rel="stylesheet" type="text/css" />
| <script src="/Billing/javascript/main.js" type="text/javascript"></script>
| </head>
|
| <body>
| <table border="0" cellpadding="0" cellspacing="0" width="100%">
| <tr>
| <td>
| <ui:include src="/jguru/issue/content/static/header.xhtml"/>
| </td>
| </tr>
| <tr>
| <td>
| <ui:include src="/jguru/issue/content/static/subheader.xhtml"/>
| </td>
| </tr>
| <tr>
| <td>
| <ui:insert name="body">Content Of Body</ui:insert>
| </td>
| </tr>
| <tr>
| <td align="center">
| <ui:include src="/jguru/issue/content/static/footers.xhtml"/>
| </td>
| </tr>
| </table>
| </body>
| </html>
|
|
problem any link click time i got parameter value "admin". i don't understand why :(, can anybody help me ?
description: i have menu build on s:link and i wont set selected background.
sorry for my english.
______________
Regards,
Paata.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4064000#4064000
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4064000
19Â years