Menu

#2 Possible overworking HQL query

open
nobody
None
5
2008-05-26
2008-05-26
Anonymous
No

Hi guys!

I am porting netbpm 0.8.8.1 to Silverlight! Lot of fun :D.
In the ExecutionContextImpl class I found a HQL query named queryFindAttributeInstanceByName. The query is the following:
select ai
from ai in class NetBpm.Workflow.Execution.Impl.AttributeInstanceImpl
f in class NetBpm.Workflow.Execution.Impl.FlowImpl
where ai.Scope = f.id and
ai.Attribute.Name = ? and
f.id = ? "

Why is FlowImpl in the query? The only use of the flow is the its id. But. If ai.Scope == f.id and f.id == ? then (equivalence is transitive relation) ai.Scope == ? too. So there is no need of the flow.
The only usefulness I can image is that doing this way it is ensured that there is a flow in the db with id ai.Scope (the parameter '?').
Though I think if this is the case it is said if there are attribute instances playing around in the db without a correspoing flow.

Ofcoz, thanks for porting from Java, my job is lot easier this way. Good luck for your work!

By,
Zsolt Világos from Hungary

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.