Can I pass Java Object in JpaRepository Class?

Question

import org.springframework.stereotype.Repository;

@Repository
public interface CustomRepository extends JpaRepository<Object, Long> {

     @Query(value = "SELECT name FROM student", nativeQuery = true)
    List<String> getAllStudentNames();
}

Will this work if not what will be the solution for this? I don't want to create student Entity.

I do not understand why you do not want a Student Entity. Create one just with the field name and the query you entered will work simply by removing the "nativeQuery = true" — Calabacin, Jul 20 '23 at 16:05
so my Student class will have only one field right but actual table have more fields so this wont be a issue and also not using id wont give any error? — Zahid shaikh, Jul 20 '23 at 16:17
`id` is required, but yes, you can just include `name` as a field. — Christopher Schneider, Jul 20 '23 at 16:23

Calabacin · Accepted Answer · 2023-07-20T17:04:14.993

0

If you do not have a Student class then you should not make a JpaRepository for it. This is my suggestion:

@Repository
public class StudentRepository {
    @PersistenceContext
    private EntityManager em;

    public List<String> findAllStudentNames() {
        return em.createNativeQuery("SELECT name FROM student").getResultList();
    }
}

edited Jul 20 '23 at 17:04

answered Jul 20 '23 at 16:41

Calabacin

725
2
8
19

Can I pass Java Object in JpaRepository Class?

1 Answers1