JPQL with specific column returning Object array

Question

I have repository method where i am trying to fetch specific column from table. when i call findAllNamesAndID method i get Object array in return where i am expecting List of Customwidgets.

I am not sure whats wrong with below code.

I can use use constructor of Customwidgets in query annotation but i want to avoid that. Is there any workaround.

I have below domain class :-

public class Customwidgets implements Serializable {
    @Id
    private UUID id;

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

---
---
}

My Repository class :-

@Repository
public interface CustomwidgetsRepository extends JpaRepository<Customwidgets, UUID>, JpaSpecificationExecutor<Customwidgets> {

    @Query("select o.id, o.name from Customwidgets o")
    List<Customwidgets> findAllNamesAndID();

}

Daniel Pereira · Accepted Answer · 2019-01-21 06:33:45Z

1

You can create an interface to define your projection. For instance:

public interface CustomWidgetsProjection {

   String getId();

   String getName();

}

Then you can return this interface you created instead of CustomWidgets:

@Query("select o.id, o.name from Customwidgets o")
List<CustomWidgetsProjection> findAllNamesAndID();

answered Jan 21, 2019 at 6:33

Daniel Pereira

2,7852 gold badges32 silver badges40 bronze badges

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

Collectives™ on Stack Overflow

JPQL with specific column returning Object array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related