@Override @SuppressWarnings("unchecked") public ExplicitParameterInfo registerExplicitParameter(ParameterExpression<?> criteriaQueryParameter) { ExplicitParameterInfo parameterInfo = explicitParameterInfoMap.get( criteriaQueryParameter ); if ( parameterInfo == null ) { if ( StringHelper.isNotEmpty( criteriaQueryParameter.getName() ) ) { parameterInfo = new ExplicitParameterInfo( criteriaQueryParameter.getName(), null, criteriaQueryParameter.getJavaType() ); } else if ( criteriaQueryParameter.getPosition() != null ) { parameterInfo = new ExplicitParameterInfo( null, criteriaQueryParameter.getPosition(), criteriaQueryParameter.getJavaType() ); } else { parameterInfo = new ExplicitParameterInfo( generateParameterName(), null, criteriaQueryParameter.getJavaType() ); } explicitParameterInfoMap.put( criteriaQueryParameter, parameterInfo ); } return parameterInfo; }
@AggrEventsTransactional @Override public void deleteEventSession(String eventSessionId) { final Query query = this.getEntityManager().createQuery(this.deleteByEventSessionIdQuery); query.setParameter(this.eventSessionIdParameter.getName(), eventSessionId); query.executeUpdate(); }
@Override @RawEventsTransactional public int deletePortalEventsBefore(DateTime time) { final Query query = this.getEntityManager().createQuery(this.deleteQuery); query.setParameter(this.endTimeParameter.getName(), time); return query.executeUpdate(); }
@Override public void visitParameterExpression(ParameterExpression<?> parameterExpression) { if (parameterExpression.getName() == null) { ParameterExpressionImpl<?> parameterExpressionImpl = (ParameterExpressionImpl<?>)parameterExpression; if (!parameterExpressionImpl.setPosition(++this.parameterPositionSequence)) { throw new IllegalProgramException(unnamedParameterCanNotBeUsedTwice()); } this.unnamedParameters.add(parameterExpression); } else { this.namedParameters.put(parameterExpression.getName(), parameterExpression); } }
public String registerExplicitParameter(ParameterExpression<?> criteriaQueryParameter) { final String jpaqlParameterName; if ( explicitParameterMapping.containsKey( criteriaQueryParameter ) ) { jpaqlParameterName = explicitParameterMapping.get( criteriaQueryParameter ); } else { jpaqlParameterName = generateParameterName(); explicitParameterMapping.put( criteriaQueryParameter, jpaqlParameterName ); } if ( StringHelper.isNotEmpty( criteriaQueryParameter.getName() ) ) { explicitParameterNameMapping.put( criteriaQueryParameter.getName(), criteriaQueryParameter ); } return jpaqlParameterName; }
@Override public String registerExplicitParameter(ParameterExpression<?> criteriaQueryParameter) { final String jpaqlParameterName; if (explicitParameterMapping.containsKey(criteriaQueryParameter)) { jpaqlParameterName = explicitParameterMapping.get(criteriaQueryParameter); } else { if (criteriaQueryParameter.getName() == null || criteriaQueryParameter.getName().isEmpty()) { if (criteriaQueryParameter.getPosition() != null) { throw new IllegalArgumentException("Positional parameters are not supported in criteria queries!"); } else { jpaqlParameterName = generateParameterName(); ((ParameterExpressionImpl<?>) criteriaQueryParameter).setName(jpaqlParameterName); } } else { jpaqlParameterName = criteriaQueryParameter.getName(); } explicitParameterNameMapping.put(jpaqlParameterName, criteriaQueryParameter); explicitParameterMapping.put(criteriaQueryParameter, jpaqlParameterName); } return jpaqlParameterName; }
@Override public String registerExplicitParameter(ParameterExpression<?> criteriaQueryParameter) { final String jpaqlParameterName; if (explicitParameterMapping.containsKey(criteriaQueryParameter)) { jpaqlParameterName = explicitParameterMapping.get(criteriaQueryParameter); } else { if (criteriaQueryParameter.getName() == null || criteriaQueryParameter.getName().isEmpty()) { if (criteriaQueryParameter.getPosition() != null) { throw new IllegalArgumentException("Positional parameters are not supported in criteria queries!"); } else { jpaqlParameterName = generateParameterName(); ((ParameterExpressionImpl<?>) criteriaQueryParameter).setName(jpaqlParameterName); } } else { jpaqlParameterName = criteriaQueryParameter.getName(); } explicitParameterNameMapping.put(jpaqlParameterName, criteriaQueryParameter); explicitParameterMapping.put(criteriaQueryParameter, jpaqlParameterName); } return jpaqlParameterName; }
final Query deletePortletCookieQuery = entityManager.createQuery(this.deletePortletCookieQueryString); deletePortletCookieQuery.setParameter(this.nowParameter.getName(), now); final int deletedPortletCookies = deletePortletCookieQuery.executeUpdate(); logger.debug( expiredByParentCookiesQuery.setParameter(this.nowParameter.getName(), now); final List<PortletCookieImpl> indirectlyExpiredCookies = expiredByParentCookiesQuery.getResultList(); deletePortalCookieQuery.setParameter(this.nowParameter.getName(), now); final int deletedPortalCookies = deletePortalCookieQuery.executeUpdate(); logger.debug( deleteEmptyPortalCookieQuery.setParameter(this.nowParameter.getName(), emptyExpiration); final int deletedEmptyPortalCookies = deleteEmptyPortalCookieQuery.executeUpdate(); logger.debug(
query.setParameter(pName.getName(), value);
query.setParameter(pName.getName(), value);
/** * Get the parameter object corresponding to the declared parameter of the given name. This method is not required * to be supported for native queries. * * @throws IllegalArgumentException * if the parameter of the specified name does not exist * @throws IllegalStateException * if invoked on a native query */ public Parameter<?> getParameter(String name) { if (isNative()) { throw new IllegalStateException(_loc.get("param-named-non-native", name).getMessage()); } Parameter<?> param = getDeclaredParameters().get(name); if (param == null) { Set<ParameterExpression> exps = getDeclaredParameterKeys(ParameterExpression.class); for (ParameterExpression<?> e : exps) { if (name.equals(e.getName())) return e; } throw new IllegalArgumentException(_loc.get("param-missing-name", name, getQueryString(), getDeclaredParameterKeys()).getMessage()); } return param; }
/** * Get the parameter object corresponding to the declared parameter of the given name. This method is not required * to be supported for native queries. * * @throws IllegalArgumentException * if the parameter of the specified name does not exist * @throws IllegalStateException * if invoked on a native query */ public Parameter<?> getParameter(String name) { if (isNative()) { throw new IllegalStateException(_loc.get("param-named-non-native", name).getMessage()); } Parameter<?> param = getDeclaredParameters().get(name); if (param == null) { Set<ParameterExpression> exps = getDeclaredParameterKeys(ParameterExpression.class); for (ParameterExpression<?> e : exps) { if (name.equals(e.getName())) return e; } throw new IllegalArgumentException(_loc.get("param-missing-name", name, getQueryString(), getDeclaredParameterKeys()).getMessage()); } return param; }
/** * Get the parameter object corresponding to the declared parameter of the given name. This method is not required * to be supported for native queries. * * @throws IllegalArgumentException * if the parameter of the specified name does not exist * @throws IllegalStateException * if invoked on a native query */ public Parameter<?> getParameter(String name) { if (isNative()) { throw new IllegalStateException(_loc.get("param-named-non-native", name).getMessage()); } Parameter<?> param = getDeclaredParameters().get(name); if (param == null) { Set<ParameterExpression> exps = getDeclaredParameterKeys(ParameterExpression.class); for (ParameterExpression<?> e : exps) { if (name.equals(e.getName())) return e; } throw new IllegalArgumentException(_loc.get("param-missing-name", name, getQueryString(), getDeclaredParameterKeys()).getMessage()); } return param; }
/** * Get the parameter object corresponding to the declared parameter of the given name. This method is not required * to be supported for native queries. * * @throws IllegalArgumentException * if the parameter of the specified name does not exist * @throws IllegalStateException * if invoked on a native query */ public Parameter<?> getParameter(String name) { if (isNative()) { throw new IllegalStateException(_loc.get("param-named-non-native", name).getMessage()); } Parameter<?> param = getDeclaredParameters().get(name); if (param == null) { Set<ParameterExpression> exps = getDeclaredParameterKeys(ParameterExpression.class); for (ParameterExpression<?> e : exps) { if (name.equals(e.getName())) return e; } throw new IllegalArgumentException(_loc.get("param-missing-name", name, getQueryString(), getDeclaredParameterKeys()).getMessage()); } return param; }
@Override public void getPortalEvents( DateTime startTime, DateTime endTime, int maxEvents, FunctionWithoutResult<PortalEvent> handler) { final Session session = this.getEntityManager().unwrap(Session.class); final org.hibernate.Query query = session.createQuery(this.selectQuery); query.setParameter(this.startTimeParameter.getName(), startTime); query.setParameter(this.endTimeParameter.getName(), endTime); if (maxEvents > 0) { query.setMaxResults(maxEvents); } for (final ScrollableResults results = query.scroll(ScrollMode.FORWARD_ONLY); results.next(); ) { final PersistentPortalEvent persistentPortalEvent = (PersistentPortalEvent) results.get(0); final PortalEvent portalEvent = this.toPortalEvent( persistentPortalEvent.getEventData(), persistentPortalEvent.getEventType()); handler.apply(portalEvent); persistentPortalEvent.setAggregated(true); session.evict(persistentPortalEvent); } }
if (metadata.getExpression().getName() == null) { query.setParameter((Parameter) metadata.getExpression(), (Date) metadata.prepare(value), parameter.getTemporalType()); } else { query.setParameter(metadata.getExpression().getName(), (Date) metadata.prepare(value), parameter.getTemporalType()); if (metadata.getExpression().getName() == null) { query.setParameter(metadata.getExpression(), metadata.prepare(value)); } else { query.setParameter(metadata.getExpression().getName(), metadata.prepare(value));
if (metadata.getExpression().getName() == null) { query.setParameter((Parameter) metadata.getExpression(), (Date) metadata.prepare(value), parameter.getTemporalType()); } else { query.setParameter(metadata.getExpression().getName(), (Date) metadata.prepare(value), parameter.getTemporalType()); if (metadata.getExpression().getName() == null) { query.setParameter(metadata.getExpression(), metadata.prepare(value)); } else { query.setParameter(metadata.getExpression().getName(), metadata.prepare(value));