[jboss-user] [jBPM] - jBPM 4.4 : search by execution variable stored as LOB

michal pisanko do-not-reply at jboss.com
Mon Jan 3 06:46:15 EST 2011

michal pisanko [http://community.jboss.org/people/milnauf] created the discussion

"jBPM 4.4 : search by execution variable stored as LOB"

To view the discussion, visit: http://community.jboss.org/message/578162#578162

Hello Everyone,
I need to search the JBPM4_VARIABLE for a variable that's stored in JBPM4_LOB - by contents.
I want to avoid the standard API calls - and instead am using Command<T> in order to execute a custom HQL query.
As long as I search for string or numeric values (stored in variables table itself) - it works allright.
The problem I face is that as soon as I try searching on the LOB relation (variable.lob = lob.dbid) - I don't get any results.
I probably should be using the public API - but I feel that iterating through every execution in search of a variable might become serious overkill once there are many executions.
Anyone solved this problem before?
Thanks in advance and a jolly new year!

Reply to this message by going to Community

Start a new discussion in jBPM at Community

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20110103/115edc88/attachment.html 

More information about the jboss-user mailing list