Upgrade java 17

[usecase-ui/server.git] / server / src / main / java / org / onap / usecaseui / server / service / impl / AlarmsInformationServiceImpl.java

diff --git a/server/src/main/java/org/onap/usecaseui/server/service/impl/AlarmsInformationServiceImpl.java b/server/src/main/java/org/onap/usecaseui/server/service/impl/AlarmsInformationServiceImpl.java
index 7bd444a..f48133e 100755 (executable)
--- a/server/src/main/java/org/onap/usecaseui/server/service/impl/AlarmsInformationServiceImpl.java
+++ b/server/src/main/java/org/onap/usecaseui/server/service/impl/AlarmsInformationServiceImpl.java
@@ -18,12 +18,11 @@ package org.onap.usecaseui.server.service.impl;
 \r
 import java.util.ArrayList;\r
 import java.util.List;\r
-import javax.persistence.EntityManagerFactory;\r
-import javax.transaction.Transactional;\r
-import org.hibernate.Query;\r
+import jakarta.persistence.EntityManagerFactory;\r
+import jakarta.transaction.Transactional;\r
+import org.hibernate.query.Query;\r
 import org.hibernate.Session;\r
 import org.hibernate.SessionFactory;\r
-import org.hibernate.Transaction;\r
 import org.onap.usecaseui.server.bean.AlarmsInformation;\r
 import org.onap.usecaseui.server.bean.maxAndMinTimeBean;\r
 import org.onap.usecaseui.server.service.AlarmsInformationService;\r
@@ -156,15 +155,15 @@ public class AlarmsInformationServiceImpl implements AlarmsInformationService {
                                hql += " and (CASE WHEN a.startEpochMicrosec=:zero THEN a.lastEpochMicroSec ELSE a.startEpochMicrosec END) between :startTime and :endTime ";\r
                        }\r
                        Query query = session.createQuery(hql);\r
-                       query.setString("zero",zero);\r
+                       query.setParameter("zero",zero);\r
                        if (sourceName != null && !"".equals(sourceName)){\r
-                               query.setString("sourceName",sourceName);\r
+                               query.setParameter("sourceName",sourceName);\r
                        }\r
                        if (UuiCommonUtil.isNotNullOrEmpty(status)){\r
-                               query.setString("status",status);\r
+                               query.setParameter("status",status);\r
                        }\r
                        if (startTime != null && !"".equals(startTime) && endTime != null && !"".equals(endTime)){\r
-                               query.setString("startTime", startTime).setString("endTime", endTime);\r
+                               query.setParameter("startTime", startTime).setParameter("endTime", endTime);\r
                        }\r
                        long num=(long) query.uniqueResult();\r
                        return (int)num;\r
@@ -180,7 +179,7 @@ public class AlarmsInformationServiceImpl implements AlarmsInformationService {
                Session session = getSession();\r
                try {\r
                        String sql = "select MAX(startEpochMicrosec),MIN(startEpochMicrosec) FROM alarms_commoneventheader";\r
-                       Query query = session.createSQLQuery(sql);\r
+                       Query query = session.createNativeQuery(sql);\r
                        list = query.list();\r
                        session.flush();\r
                }catch (Exception e){\r
@@ -198,7 +197,7 @@ public class AlarmsInformationServiceImpl implements AlarmsInformationService {
                try {\r
                        String string = "from AlarmsInformation a where 1=1 and a.headerId=:headerId";\r
                        Query query = session.createQuery(string);\r
-                       query.setString("headerId",headerId);\r
+                       query.setParameter("headerId",headerId);\r
                        List<AlarmsInformation> list = query.list();\r
                        session.flush();\r
                        return list;\r