From c345945c36b4c93f2f436cf61f89495577d072ea Mon Sep 17 00:00:00 2001
From: soshial <soshial@gmail.com>
Date: Sat, 18 Sep 2021 21:15:24 +0200
Subject: improve SQL query

---
 src/main/java/org/traccar/database/DataManager.java | 9 ++-------
 1 file changed, 2 insertions(+), 7 deletions(-)

(limited to 'src/main/java/org/traccar/database/DataManager.java')

diff --git a/src/main/java/org/traccar/database/DataManager.java b/src/main/java/org/traccar/database/DataManager.java
index 15c67cb74..75ec70ea7 100644
--- a/src/main/java/org/traccar/database/DataManager.java
+++ b/src/main/java/org/traccar/database/DataManager.java
@@ -329,15 +329,10 @@ public class DataManager {
     }
 
     public Position getPrecedingPosition(long deviceId, Date date) throws SQLException {
-        Collection<Position> positions = QueryBuilder.create(dataSource, getQuery("database.selectPrecedingPosition"))
+        return QueryBuilder.create(dataSource, getQuery("database.selectPrecedingPosition"))
                 .setLong("deviceId", deviceId)
                 .setDate("time", date)
-                .executeQuery(Position.class);
-        if (positions.isEmpty()) {
-            return null;
-        } else {
-            return positions.iterator().next();
-        }
+                .executeQuerySingle(Position.class);
     }
 
     public void updateLatestPosition(Position position) throws SQLException {
-- 
cgit v1.2.3