Spring Projects Issues

**[Oliver Drotbohm](https://jira.spring.io/secure/ViewProfile.jspa?name=olivergierke)** commented New insight: there's been a significant improvement in the application of the read-only in a recent PostgreSQL JDBC driver (anything equal or better than 42.2.9 should be...

**[Jens Schauder](https://jira.spring.io/secure/ViewProfile.jspa?name=schauder)** commented Specifications aren't really intended for arbitrary manipulation of the query. Instead they should just provide the where clause of a query. In any case could you provide...

**[Dimitri](https://jira.spring.io/secure/ViewProfile.jspa?name=newdimitri)** commented I made a small maven project that shows the problem. [^datajpa-1573.zip]

**[Michael Simons](https://jira.spring.io/secure/ViewProfile.jspa?name=michael.simons)** commented Using ``` partnerRepository.findDistinct(new Sort("merchants.name")); ``` should give you the result you want without a custom implementation. I think the implementation is correct as is, you explained the...

**[HerrDerb](https://jira.spring.io/secure/ViewProfile.jspa?name=herrderb)** commented `@Michael` Simons I'm afraid that not a workaround as `findDistinct` is not accepted by Spring

**[Jens Schauder](https://jira.spring.io/secure/ViewProfile.jspa?name=schauder)** commented The correct method should be `findDistinctBy(Sort sort);` In case this isn't clear: you have to declare that yourself in your repository interface. Please confirm if this solves...

**[HerrDerb](https://jira.spring.io/secure/ViewProfile.jspa?name=herrderb)** commented I'm not sure if this should be `findDistinctBy(Sort sort)` as I do not provide a filter criterion. If I still do so, it gives me a `NoElementsFoundException`. In...

**[Akuka](https://jira.spring.io/secure/ViewProfile.jspa?name=akuka)** commented Same here I tried add some generic queries for distinct: ```java List findDistinct(@Nullable Specification var1); Page findDistinct(@Nullable Specification var1, Pageable var2); List findDistinct(@Nullable Specification var1, Sort var2); ```  ...

**[Hayrol Reyes](https://jira.spring.io/secure/ViewProfile.jspa?name=hayrolr)** commented Was this left stuck without solution? I am having the same problem... for example this: Page\ findAll(`@Nullable` Specification\ spec, Pageable pageable); Or the one with "Sort" version...

**[cxq1058577403](https://jira.spring.io/secure/ViewProfile.jspa?name=JIRAUSER49527)** commented [Jens Schauder](https://jira.spring.io/secure/ViewProfile.jspa?name=schauder) Do you have any updates for this issue as I met this issue? Or Is there any workaround to solve it? I'm looking forward your reply