diff options
author | kaixiliu <liukaixi@chinamobile.com> | 2023-11-06 16:21:31 +0800 |
---|---|---|
committer | Kaixi LIU <liukaixi@chinamobile.com> | 2023-11-13 01:35:29 +0000 |
commit | 8a580106ff22e2d207d52ee2618a76996f3fce1e (patch) | |
tree | 40d582e994fcd3a768278d78633e4fef7671dea3 /server/src/main/java/org/onap/usecaseui/server/service/lcm/impl/DefaultServiceLcmService.java | |
parent | 129d4c91b9c517b0ac8604607ccdc974ef1367a9 (diff) |
Upgrade java 17
Issue-ID: USECASEUI-823
Change-Id: I935b08e9221b1dc17aa16d573efe5e3757609d3b
Signed-off-by: kaixiliu <liukaixi@chinamobile.com>
Diffstat (limited to 'server/src/main/java/org/onap/usecaseui/server/service/lcm/impl/DefaultServiceLcmService.java')
-rw-r--r-- | server/src/main/java/org/onap/usecaseui/server/service/lcm/impl/DefaultServiceLcmService.java | 32 |
1 files changed, 15 insertions, 17 deletions
diff --git a/server/src/main/java/org/onap/usecaseui/server/service/lcm/impl/DefaultServiceLcmService.java b/server/src/main/java/org/onap/usecaseui/server/service/lcm/impl/DefaultServiceLcmService.java index bfd79b5f..0866471a 100644 --- a/server/src/main/java/org/onap/usecaseui/server/service/lcm/impl/DefaultServiceLcmService.java +++ b/server/src/main/java/org/onap/usecaseui/server/service/lcm/impl/DefaultServiceLcmService.java @@ -22,14 +22,12 @@ import java.io.IOException; import java.util.ArrayList; import java.util.List; -import javax.persistence.EntityManager; -import javax.persistence.EntityManagerFactory; -import javax.persistence.PersistenceContext; -import javax.servlet.http.HttpServletRequest; +import jakarta.persistence.EntityManagerFactory; +import jakarta.servlet.http.HttpServletRequest; import com.google.common.base.Throwables; -import javax.transaction.Transactional; -import org.hibernate.Query; +import jakarta.transaction.Transactional; +import org.hibernate.query.Query; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.Transaction; @@ -189,8 +187,8 @@ public class DefaultServiceLcmService implements ServiceLcmService { try { String string = "update ServiceBean set status=:status where 1=1 and serviceInstanceId=:serviceInstanceId"; Query q = session.createQuery(string); - q.setString("status", status); - q.setString("serviceInstanceId", serviceInstanceId); + q.setParameter("status", status); + q.setParameter("serviceInstanceId", serviceInstanceId); q.executeUpdate(); session.flush(); } catch (Exception e) { @@ -208,7 +206,7 @@ public class DefaultServiceLcmService implements ServiceLcmService { String string = "from ServiceBean where 1=1 and serviceInstanceId=:serviceInstanceId"; Query q = session.createQuery(string); - q.setString("serviceInstanceId", serviceInstanceId); + q.setParameter("serviceInstanceId", serviceInstanceId); List<ServiceBean> list = q.list(); session.flush(); if (list.size() > 0) { @@ -232,7 +230,7 @@ public class DefaultServiceLcmService implements ServiceLcmService { String string = "from ServiceBean where 1=1 and parentServiceInstanceId=:parentServiceInstanceId"; Query q = session.createQuery(string); - q.setString("parentServiceInstanceId", parentServiceInstanceId); + q.setParameter("parentServiceInstanceId", parentServiceInstanceId); list = q.list(); session.flush(); } catch (Exception e) { @@ -272,10 +270,10 @@ public class DefaultServiceLcmService implements ServiceLcmService { try { String hql = "select a.* from service_instance_operations a where service_instance_id =:serviceId and operation_type =:operationType and start_time = (select max(start_time) from service_instance_operations where service_instance_id=:serviceInstanceId )"; - Query q = session.createSQLQuery(hql).addEntity(ServiceInstanceOperations.class); - q.setString("serviceId", serviceInstanceId); - q.setString("serviceInstanceId", serviceInstanceId); - q.setString("operationType", operationType); + Query q = session.createNativeQuery(hql).addEntity(ServiceInstanceOperations.class); + q.setParameter("serviceId", serviceInstanceId); + q.setParameter("serviceInstanceId", serviceInstanceId); + q.setParameter("operationType", operationType); list = q.list(); ServiceInstanceOperations serviceOperation = list.get(0); serviceOperation.setOperationResult(operationResult); @@ -301,9 +299,9 @@ public class DefaultServiceLcmService implements ServiceLcmService { try { String hql = "select a.* from service_instance_operations a where service_instance_id =:serviceId and start_time = (select max(start_time) from service_instance_operations where service_instance_id=:serviceInstanceId)"; - Query q = session.createSQLQuery(hql).addEntity(ServiceInstanceOperations.class); - q.setString("serviceId", serviceId); - q.setString("serviceInstanceId", serviceId); + Query q = session.createNativeQuery(hql).addEntity(ServiceInstanceOperations.class); + q.setParameter("serviceId", serviceId); + q.setParameter("serviceInstanceId", serviceId); q.list(); list = q.list(); if (!list.isEmpty()) { |