[Bug 526616] Update ol attribute of container correctly
The SPQL request was not ordering the content instances in the
OldestDAO class. It is now ordered by creationTime.
Change-Id: If13607bbb11ded2be3bc055889f2f0f493424d1f
Signed-off-by: Francois Aissaoui <aissaoui@laas.fr>
diff --git a/org.eclipse.om2m.persistence.eclipselink/src/main/java/org/eclipse/om2m/persistence/eclipselink/internal/dao/OldestDAO.java b/org.eclipse.om2m.persistence.eclipselink/src/main/java/org/eclipse/om2m/persistence/eclipselink/internal/dao/OldestDAO.java
index 983b162..ffa9478 100644
--- a/org.eclipse.om2m.persistence.eclipselink/src/main/java/org/eclipse/om2m/persistence/eclipselink/internal/dao/OldestDAO.java
+++ b/org.eclipse.om2m.persistence.eclipselink/src/main/java/org/eclipse/om2m/persistence/eclipselink/internal/dao/OldestDAO.java
@@ -19,6 +19,7 @@
import javax.persistence.Query;
import org.eclipse.om2m.commons.constants.DBEntities;
+import org.eclipse.om2m.commons.constants.ShortName;
import org.eclipse.om2m.commons.entities.ContentInstanceEntity;
import org.eclipse.om2m.persistence.eclipselink.internal.DBTransactionJPAImpl;
import org.eclipse.om2m.persistence.service.DBTransaction;
@@ -41,7 +42,7 @@
DBTransactionJPAImpl transaction = (DBTransactionJPAImpl) dbTransaction;
String req = "SELECT r FROM " + DBEntities.CONTENTINSTANCE_ENTITY
- + " r WHERE r.parentID = '"+ id + "'";
+ + " r WHERE r.parentID = '"+ id + "' ORDER BY r.creationTime";
Query q = transaction.getEm().createQuery(req);
List<ContentInstanceEntity> resultList = q.setMaxResults(1).getResultList();