[Cse-ip-svn-commits] SF.net SVN: cse-ip:[402] trunk/sandbox/lsf-adapter-demo/CSECore-ejb/src/ java/de/campussource/cse/core/IdentityManagerImpl.java

[<pka...@us...>]

Revision: 402
          http://cse-ip.svn.sourceforge.net/cse-ip/?rev=402&view=rev
Author:   pkasprzak
Date:     2009-07-29 21:52:23 +0000 (Wed, 29 Jul 2009)

Log Message:
-----------
* Fix EJBQL query processing

Modified Paths:
--------------
    trunk/sandbox/lsf-adapter-demo/CSECore-ejb/src/java/de/campussource/cse/core/IdentityManagerImpl.java

Modified: trunk/sandbox/lsf-adapter-demo/CSECore-ejb/src/java/de/campussource/cse/core/IdentityManagerImpl.java
===================================================================
--- trunk/sandbox/lsf-adapter-demo/CSECore-ejb/src/java/de/campussource/cse/core/IdentityManagerImpl.java	2009-07-29 21:51:41 UTC (rev 401)
+++ trunk/sandbox/lsf-adapter-demo/CSECore-ejb/src/java/de/campussource/cse/core/IdentityManagerImpl.java	2009-07-29 21:52:23 UTC (rev 402)
@@ -2,6 +2,8 @@
 package de.campussource.cse.core;
 
 import de.campussource.cse.core.pdm.Mapping;
+import java.util.List;
+import java.util.logging.Logger;
 import javax.ejb.Stateless;
 import javax.persistence.EntityManager;
 import javax.persistence.PersistenceContext;
@@ -16,24 +18,33 @@
     @PersistenceContext
     private EntityManager em;
 
+    private final static Logger logger = Logger.getLogger("de.campussource.cse.core.IdentityManager");
+
     // ----------------------------------------------------------------------------------------------------------------
     public Integer getIdBySystemId(String system, String systemId) {
 
-        Integer cseId = (Integer) em.createNamedQuery(Mapping.QUERY_getIdBySystemId).   setParameter("system",      system).
-                                                                                        setParameter("systemId",    systemId).
-                                                                                        getSingleResult();
+        List<Integer> ids = em.createNamedQuery(Mapping.QUERY_getIdBySystemId). setParameter("system",      system).
+                                                                                setParameter("systemId",    systemId).
+                                                                                getResultList();
+        if (ids.isEmpty()) {
+            return null;
+        }
 
-        return cseId;
+        return ids.get(0);
     }
 
     // ----------------------------------------------------------------------------------------------------------------
     public String getSystemIdById(String system, Integer cseId) {
 
-        String systemId = (String) em.createNamedQuery(Mapping.QUERY_getSystemIdById).  setParameter("system",      system).
-                                                                                        setParameter("cseId",       cseId).
-                                                                                        getSingleResult();
+        List<String> ids = em.createNamedQuery(Mapping.QUERY_getSystemIdById).  setParameter("system",      system).
+                                                                                setParameter("cseId",       cseId).
+                                                                                getResultList();
 
-        return systemId;
+        if (ids.isEmpty()) {
+            return null;
+        }
+
+        return ids.get(0);
     }
 
     // ----------------------------------------------------------------------------------------------------------------


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.