Spring JPA repository doesn't return List of entities

Question

I try to get simple List of Rawtype entities with help of findBy method in the myMethod. But I get nothing - rawtypes doesn't contain any entity. Although findAll method works fine. Please tell we where is my mistake.

Rawtype.java

@Entity
@Table(name="rawtype")
public class Rawtype implements Serializable {

    private static final long serialVersionUID = 1L;

    @Id
    @Column(name="rtid", nullable = false)
    @GeneratedValue
    private int rtId;

    @Column(name="rtname", nullable = false)
    private String rtName;

    //getters and setters

RawtypeRepository.java

public interface RawtypeRepository extends JpaRepository<Rawtype, Integer> {
    List<Rawtype> findByRtName(String rtName);
}

RawtypeServiceImpl.java

@Service
@Transactional
public class RawtypeServiceImpl implements RawtypeService {
    @Autowired
    RawtypeRepository rawtypeRepository;

    public List<Rawtype> findAll() {
        return rawtypeRepository.findAll();
    }

    public myMethod(){
        List<Rawtype> rawtypes = rawtypeRepository.findByRtName("RawName");
    }
}

Why not write a test that adds an entity with rtName set to "RawName" then tries to findByRtName()? BTW, I don't think it needs @Transactional, your operations are currently read-only. — Todd W Crone
– Todd W Crone, Commented Mar 14, 2016 at 1:37
@todd-w-crone Thank you for your answer. I'm going to add some CRUD methods in the RawtypeServiceImpl(). Consequently I will need in that annotation. — Valentyn Grygoriev
– Valentyn Grygoriev, Commented Mar 14, 2016 at 9:33

Darshan Mehta · Accepted Answer · 2016-03-13 22:55:37Z

1

Can you try printing rtName of all the entities returned by findAll() method? May be there isn't any record with 'RawName' as rtName.

Also, you can enable logging for JPA to see the generated query.

answered Mar 13, 2016 at 22:55

Darshan Mehta

31k14 gold badges75 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Valentyn Grygoriev Over a year ago

Thank you for your answer. It was a mistake in importing data from Excel to MySql. This import added some non visual symbols like "\n". As the result findByRtName return wrong values.

Collectives™ on Stack Overflow

Spring JPA repository doesn't return List of entities

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related