From 020035e91913dc034f338c88fa09a3b0b41faa7c Mon Sep 17 00:00:00 2001
From: ralph isenmann
Date: Tue, 18 Aug 2020 11:33:25 +0200
Subject: [server] Modify sql Statement to receive  metadata

Left Join on os_x_virt table because there is no combination of osid and virtid for docker.
---
 .../src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java  | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java
index a57be8da..e0799c29 100644
--- a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java
+++ b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLecture.java
@@ -567,7 +567,7 @@ public class DbLecture {
 					+ "                      FROM lecture l                 "
 					+ " INNER JOIN imageversion i USING (imageversionid)"
 					+ " INNER JOIN imagebase b USING (imagebaseid)"
-					+ " INNER JOIN os_x_virt o USING (osid, virtid)" + " WHERE l.lectureid = :lectureid");
+					+ " LEFT JOIN os_x_virt o USING (osid, virtid)" + " WHERE l.lectureid = :lectureid");
 			stmt.setString("lectureid", lectureId);
 			ResultSet rs = stmt.executeQuery();
 			long now = Util.unixTime();
-- 
cgit v1.2.3-55-g7522