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.
|
