You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ode.apache.org by mr...@apache.org on 2007/12/01 01:06:48 UTC
svn commit: r600021 -
/ode/trunk/dao-jpa/src/main/java/org/apache/ode/dao/jpa/ProcessInstanceDAOImpl.java
Author: mriou
Date: Fri Nov 30 16:06:47 2007
New Revision: 600021
URL: http://svn.apache.org/viewvc?rev=600021&view=rev
Log:
Simple query rewrite avoiding a full table scan plus an in-memory filtering.
Modified:
ode/trunk/dao-jpa/src/main/java/org/apache/ode/dao/jpa/ProcessInstanceDAOImpl.java
Modified: ode/trunk/dao-jpa/src/main/java/org/apache/ode/dao/jpa/ProcessInstanceDAOImpl.java
URL: http://svn.apache.org/viewvc/ode/trunk/dao-jpa/src/main/java/org/apache/ode/dao/jpa/ProcessInstanceDAOImpl.java?rev=600021&r1=600020&r2=600021&view=diff
==============================================================================
--- ode/trunk/dao-jpa/src/main/java/org/apache/ode/dao/jpa/ProcessInstanceDAOImpl.java (original)
+++ ode/trunk/dao-jpa/src/main/java/org/apache/ode/dao/jpa/ProcessInstanceDAOImpl.java Fri Nov 30 16:06:47 2007
@@ -228,10 +228,7 @@
}
public ScopeDAO getScope(Long scopeInstanceId) {
- Query qry = getEM().createNamedQuery("ScopeById");
- qry.setParameter("sid", scopeInstanceId);
- qry.setParameter("instance", this);
- return (ScopeDAO) qry.getSingleResult();
+ return getEM().find(ScopeDAOImpl.class, scopeInstanceId);
}
public Collection<ScopeDAO> getScopes(String scopeName) {