commit dc2f0fd934cb8db00401975f6228bd79580685c9
author Mahdi Ben Alaya <benalaya@sensinov.com> Tue Nov 14 04:57:24 2017 -0500
committer Gerrit Code Review @ Eclipse.org <gerrit@eclipse.org> Tue Nov 14 04:57:24 2017 -0500
tree 38af6bdc79a0a4ea349ba2123bc3e9b4354ab490
parent ca29eb6678b1e29357f949c2143a6c9f764aad6d
parent 94a906bf4483cd4a8f1289a2194ab72b97aa6956

Merge "sdt.home: fix minor bugs." into dev

org.eclipse.om2m.persistence.eclipselink/src/main/java/org/eclipse/om2m/persistence/eclipselink/internal/dao/OldestDAO.java

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();