SchedulerThread.executeTimers() in single tx?

[ralfoeldi]

Hi everybody,

the SchedulerThread.executeTimers() method executes all due Timers in a single transaction.

Now I might be missing something (at least I hope so) but bunching the execution of potentially thousands of Timers in a single tx just isn't going to work for me. Before I start implementing my own executeTimers() method that executes every Timer in a transaction of its own...

does jBPM have any way of seperating Timer execution in seperate transactions?

Greetings from a wet and cold Switzerland without snow (I'm disappointed)

Rainer

[kukeltje]

No snow in Switzerland? Lucky me I go to Austria (Flachau) between Xmas and newyear.

Regarding your question. This to me sounds like an ommision in jBPM. Can you file a jira issue for this?

[ralfoeldi]

Hi Ronald,

well there was snow (as in Germany... :-( ) but its all gone and now its just cold and wet (at least in the Zürich / Winterthur area). I wish you luck for Flachau. It isn't all that high is it? 2000m?

I'm not sure if this is a valid Jira issue. I've been nagging about other transaction issues for the past few weeks now and I seem to be the only one who needs (or wants) that kind of detailed demarcation. (Nobody else out there? ... Oh well.)

The solution would be none trivial anyway as I am just noticing.

I just saw that you seem to be fully aware of the issue http://jira.jboss.com/jira/browse/JBPM-46 where Tom states that

"we only use one transactional resource (jdbc connection) so ..."

Jira feature request: http://jira.jboss.com/jira/browse/JBPM-452

Rainer

[kukeltje]

http://panpic2.feratel.at/panpic2/index.jsp?ID=5216&bgColor=E9F0F4&textColor=000000&stream=on&getLatest=true

[ralfoeldi]

:-) have fun...

[koen.aers]

Rainer,

It is in any case not difficult to create your own timer execution mechanism if you would like to do that. You can do this with other mechanisms than the servlet spawning a thread, if you would prefer to do so. E.g. using an mbean if you are using JBoss AS.

Regards,
Koen

Btw. We (Tom and I) will be for a day in Wengen in two weeks, so it would better snow!

[ralfoeldi]

Hi Koen,

seems like everybody is going skiing except for me. Looks like I'm doing something wrong and got to get my priorities right. I mean I live in Switzerland now!

It isn't all that complicated but it isn't trivial either. Its just a lot of code loading, detaching, reattaching all effected objects to Hibernate without one transaction getting in the way of the other.

I've already seperated the "normal" execution into some SLSBs and MDBs etc. Thats up and running. Read all about it: http://www.jboss.com/index.html?module=bb&op=viewtopic&t=72642 (don't read it, you already commented.)

What I'm doing now is using Quartz to trigger a SLSB that will retrieve the Timers, call another SLSB to execute the Timer and then delete / save the Timer / ProcessInstance. Its basically the Hibernate plumbing.

I was just hoping... maybe it's already there and I just don't see it.

Have fun in Wengen!

Rainer