You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@openmeetings.apache.org by so...@apache.org on 2017/08/25 05:13:43 UTC

openmeetings git commit: no jira: Sessiondata find(String SID) method is corrected to work with MSSql server

Repository: openmeetings
Updated Branches:
  refs/heads/master 53ce7cf03 -> c86fb051f


no jira: Sessiondata find(String SID) method is corrected to work with MSSql server


Project: http://git-wip-us.apache.org/repos/asf/openmeetings/repo
Commit: http://git-wip-us.apache.org/repos/asf/openmeetings/commit/c86fb051
Tree: http://git-wip-us.apache.org/repos/asf/openmeetings/tree/c86fb051
Diff: http://git-wip-us.apache.org/repos/asf/openmeetings/diff/c86fb051

Branch: refs/heads/master
Commit: c86fb051fd911dbece4aea73e77ddaafe0e8138d
Parents: 53ce7cf
Author: Maxim Solodovnik <so...@gmail.com>
Authored: Fri Aug 25 12:13:33 2017 +0700
Committer: Maxim Solodovnik <so...@gmail.com>
Committed: Fri Aug 25 12:13:33 2017 +0700

----------------------------------------------------------------------
 .../apache/openmeetings/db/dao/server/SessiondataDao.java   | 9 ++++++---
 1 file changed, 6 insertions(+), 3 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/openmeetings/blob/c86fb051/openmeetings-db/src/main/java/org/apache/openmeetings/db/dao/server/SessiondataDao.java
----------------------------------------------------------------------
diff --git a/openmeetings-db/src/main/java/org/apache/openmeetings/db/dao/server/SessiondataDao.java b/openmeetings-db/src/main/java/org/apache/openmeetings/db/dao/server/SessiondataDao.java
index 96f3cad..7f547e2 100644
--- a/openmeetings-db/src/main/java/org/apache/openmeetings/db/dao/server/SessiondataDao.java
+++ b/openmeetings-db/src/main/java/org/apache/openmeetings/db/dao/server/SessiondataDao.java
@@ -89,12 +89,15 @@ public class SessiondataDao {
 	}
 
 	/**
+	 * Serches {@link Sessiondata} object by sessionId
 	 *
-	 * @param SID
-	 * @return
+	 * @param SID - sessionId
+	 * @return {@link Sessiondata} with sessionId == SID, or null if not found
 	 */
 	public Sessiondata find(String SID) {
-		List<Sessiondata> sessions = em.createNamedQuery("getSessionById", Sessiondata.class).setParameter("sessionId", SID).getResultList();
+		//MSSql find nothing in case SID is passed as-is without wildcarting '%SID%'
+		List<Sessiondata> sessions = em.createNamedQuery("getSessionById", Sessiondata.class)
+				.setParameter("sessionId", String.format("%%%s%%", SID)).getResultList();
 
 		Sessiondata sd = null;
 		if (sessions != null && sessions.size() > 0) {