How to create counter in Spring

[Molayo Decker]

Hi,
I am trying to create a counter using the JPQL in spring so that when the user save a form it counts by one.
This what i did but it's not working.

@Repository
public interface ExamsDao extends CrudRepository<Exams,Long>{
    @Query("select e from Exams e join e.user u where u.id= ?#{principal.id}")
    List<Exams> findAll();

    @Query("update Exams SET counter = counter + 1")
    Exams counter();
}

@Service
public class ExamServiceImpl implements ExamService {

    @Autowired
    private ExamsDao examsDao;

    @Override
    public Iterable<Exams> findAll() {
        return examsDao.findAll();
    }

    @Override
    public Exams findOne(Long id) {
        return examsDao.findOne(id);
    }

    @Override
    public void toggleComplete(Long id) {
        Exams exams = examsDao.findOne(id);
        exams.setComplete(!exams.isComplete());
        examsDao.save(exams);
    }

    @Override
    public void save(Exams exams) {
        examsDao.save(exams);
    }

    @Override
    public Exams counter() {
        return examsDao.counter();
    }


}

[Ankit Garg]

Hi Molayo, can you add more details to your question. Which part doesn't work, does the spring context comes up and the save doesn't work?