[jboss-user] [jBPM] - Re: AS 7.1.2, JBPM 5.3 persistence : Getting Large Objects may not be used in auto-commit mode exception

[Vimal Kansal]

Vimal Kansal [https://community.jboss.org/people/vimalkansal] created the discussion

"Re: AS 7.1.2, JBPM 5.3 persistence : Getting Large Objects may not be used in auto-commit mode exception"

To view the discussion, visit: https://community.jboss.org/message/738364#738364

--------------------------------------------------------------
ok, figured out in my Jboss-as 7 cofiguration file (standalone-full.xml), in the datasource definition, I had not turned on the JTA flag on the JBPM datasource.  

Now there is another question out of curiosity : Once my process has executed, I see a delete statement deleting the row from processinstanceinfo. My workflow is a simple HelloWorld workflow. My question is : does jBPM remove the data from ProcessInstanceInfo table once the processinstacne has run ?

127.0.0.1-8080-1) Hibernate: select processins0_.InstanceId as col_0_0_ from ProcessInstanceInfo processins0_ inner join EventTypes eventtypes1_ on processins0_.InstanceId=eventtypes1_.InstanceId where eventtypes1_.eventTypes=?
16:42:43,022 INFO  [stdout] (http-localhost-127.0.0.1-8080-1) Hibernate: insert into SessionInfo (lastModificationDate, rulesByteArray, startDate, OPTLOCK, id) values (?, ?, ?, ?, ?)
16:42:43,106 INFO  [stdout] (http-localhost-127.0.0.1-8080-1) Hibernate: update SessionInfo set lastModificationDate=?, rulesByteArray=?, startDate=?, OPTLOCK=? where id=? and OPTLOCK=?
1*6:42:43,115 INFO  [stdout] (http-localhost-127.0.0.1-8080-1) Hibernate: insert into ProcessInstanceInfo (id, lastModificationDate, lastReadDate, processId, processInstanceByteArray, startDate, state, OPTLOCK, InstanceId) values (?, ?, ?, ?, ?, ?, ?, ?, ?)*
1*6:42:43,129 INFO  [stdout] (http-localhost-127.0.0.1-8080-1) Hibernate: delete from ProcessInstanceInfo where InstanceId=? and OPTLOCK=?*
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/738364#738364]

Start a new discussion in jBPM at Community
[https://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/20120528/f7dec1a1/attachment.html