code: @Override
  	public CProduct[] findByGroupId_PrevAndNext(long CProductId, long groupId,
  		OrderByComparator<CProduct> orderByComparator)
  		throws NoSuchCProductException {
  		CProduct cProduct = findByPrimaryKey(CProductId);
  
  		Session session = null;
  
  		try {
  			session = openSession();
  
  			CProduct[] array = new CProductImpl[3];
  
  			array[0] = getByGroupId_PrevAndNext(session, cProduct, groupId,
  					orderByComparator, true);
  
  			array[1] = cProduct;
  
  			array[2] = getByGroupId_PrevAndNext(session, cProduct, groupId,
  					orderByComparator, false);
  
  			return array;
  		}
  		catch (Exception e) {
  			throw processException(e);
  		}
  		finally {
  			closeSession(session);
  		}
  	}
docs: Returns the c products before and after the current c product in the ordered set where groupId = &#63;.
  
  @param CProductId the primary key of the current c product
  @param groupId the group ID
  @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
  @return the previous, current, and next c product
  @throws NoSuchCProductException if a c product with the primary key could not be found