@Override public SQLQuery createSynchronizedSQLQuery(String queryString) throws ORMException { Thread currentThread = Thread.currentThread(); ClassLoader contextClassLoader = currentThread.getContextClassLoader(); try { if (contextClassLoader != _classLoader) { currentThread.setContextClassLoader(_classLoader); } return _session.createSynchronizedSQLQuery(queryString); } finally { if (contextClassLoader != _classLoader) { currentThread.setContextClassLoader(contextClassLoader); } } }
@Override public SQLQuery createSynchronizedSQLQuery( String queryString, boolean strictName) throws ORMException { Thread currentThread = Thread.currentThread(); ClassLoader contextClassLoader = currentThread.getContextClassLoader(); try { if (contextClassLoader != _classLoader) { currentThread.setContextClassLoader(_classLoader); } return _session.createSynchronizedSQLQuery(queryString, strictName); } finally { if (contextClassLoader != _classLoader) { currentThread.setContextClassLoader(contextClassLoader); } } }
sb.append(" <= ?"); SQLQuery sqlQuery = session.createSynchronizedSQLQuery( sb.toString());
sb.append(" >= ?"); SQLQuery sqlQuery = session.createSynchronizedSQLQuery( sb.toString());
sb.append(" > 0"); SQLQuery sqlQuery = session.createSynchronizedSQLQuery( sb.toString());
sb.append(" >= ?"); SQLQuery sqlQuery = session.createSynchronizedSQLQuery( sb.toString());
sb.append(" <= ?"); SQLQuery sqlQuery = session.createSynchronizedSQLQuery( sb.toString());
session = _basePersistenceImpl.openSession(); SQLQuery sqlQuery = session.createSynchronizedSQLQuery( sb.toString());
session = _basePersistenceImpl.openSession(); SQLQuery sqlQuery = session.createSynchronizedSQLQuery( sb.toString());
SQLQuery q = session.createSynchronizedSQLQuery(sql);
@Override public List<JournalArticle> findByNoPermissions() { Session session = null; try { session = openSession(); String sql = _customSQL.get(getClass(), FIND_BY_NO_PERMISSIONS); SQLQuery q = session.createSynchronizedSQLQuery(sql); q.addEntity("JournalArticle", JournalArticleImpl.class); QueryPos qPos = QueryPos.getInstance(q); qPos.add(ResourceConstants.SCOPE_INDIVIDUAL); return q.list(true); } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } }
@Override public List<JournalArticle> findByNoAssets() { Session session = null; try { session = openSession(); String sql = _customSQL.get(getClass(), FIND_BY_NO_ASSETS); SQLQuery q = session.createSynchronizedSQLQuery(sql); q.addEntity("JournalArticle", JournalArticleImpl.class); QueryPos qPos = QueryPos.getInstance(q); qPos.add(PortalUtil.getClassNameId(JournalArticle.class)); return q.list(true); } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } }
@Override public List<JournalFolder> findF_ByNoAssets() { Session session = null; try { session = openSession(); String sql = _customSQL.get(getClass(), FIND_F_BY_NO_ASSETS); SQLQuery q = session.createSynchronizedSQLQuery(sql); q.addEntity(JournalFolderImpl.TABLE_NAME, JournalFolderImpl.class); QueryPos qPos = QueryPos.getInstance(q); qPos.add(PortalUtil.getClassNameId(JournalFolder.class)); return q.list(true); } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } }
session = openSession(); SQLQuery q = session.createSynchronizedSQLQuery(sql);
session = openSession(); SQLQuery q = session.createSynchronizedSQLQuery(sql);
session = openSession(); SQLQuery q = session.createSynchronizedSQLQuery(sql);
session = openSession(); SQLQuery q = session.createSynchronizedSQLQuery(sql);
@Override public List<JournalArticle> findByExpirationDate( long classNameId, Date expirationDateLT, QueryDefinition<JournalArticle> queryDefinition) { Timestamp expirationDateLT_TS = CalendarUtil.getTimestamp( expirationDateLT); Session session = null; try { session = openSession(); String sql = _customSQL.get( getClass(), FIND_BY_EXPIRATION_DATE, queryDefinition); SQLQuery q = session.createSynchronizedSQLQuery(sql); q.addEntity( JournalArticleImpl.TABLE_NAME, JournalArticleImpl.class); QueryPos qPos = QueryPos.getInstance(q); qPos.add(classNameId); qPos.add(queryDefinition.getStatus()); qPos.add(expirationDateLT_TS); return q.list(true); } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } }
@Override public List<JournalArticle> findByReviewDate( long classNameId, Date reviewDateLT, Date reviewDateGT) { Timestamp reviewDateLT_TS = CalendarUtil.getTimestamp(reviewDateLT); Timestamp reviewDateGT_TS = CalendarUtil.getTimestamp(reviewDateGT); Session session = null; try { session = openSession(); String sql = _customSQL.get(getClass(), FIND_BY_REVIEW_DATE); SQLQuery q = session.createSynchronizedSQLQuery(sql); q.addEntity( JournalArticleImpl.TABLE_NAME, JournalArticleImpl.class); QueryPos qPos = QueryPos.getInstance(q); qPos.add(classNameId); qPos.add(reviewDateGT_TS); qPos.add(reviewDateLT_TS); return q.list(true); } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } }
SQLQuery q = session.createSynchronizedSQLQuery(sql);