Spring Data findAllById not work properly

user_6522169 0
Viewed 3255

I use spring-data-jpa-2.0.9.RELEASE lib. When I'd like to use JpaRepository.findAllById(Iterable ids) with 2 ids debug show me error 

org.eclipse.persistence.exceptions.DatabaseException: 
Internal Exception: java.sql.SQLException: Operand should contain 1 column(s)
Error Code: 1241
Call: SELECT ID, CONFIGURATION, IMPORT_ID, NAME, STATE FROM TB_MARKET WHERE (ID IN ((?,?)))
Query: ReadAllQuery(referenceClass=MarketEntity sql="SELECT ID, CONFIGURATION, IMPORT_ID, NAME, STATE FROM TB_MARKET WHERE (ID IN (?))")

Error code 1241 for MySQL say that to much ( )

spring-data spring-data-jpa spring
1 Answers

First Id try updating to the latest Spring data jpa library which is 2.1.1.RELEASE

for Maven:

<!-- https://mvnrepository.com/artifact/org.springframework.data/spring-data-jpa -->
<dependency>
    <groupId>org.springframework.data</groupId>
    <artifactId>spring-data-jpa</artifactId>
    <version>2.1.1.RELEASE</version>
</dependency>

If you are unable to update the libraries it might be better to roll your own query in your repository if this is a known issue in the version you're using:

In your repository in question add:

List<Entity> findByIdIn(Set<Integer> ids);

Having the id's as a set will prevent duplicate id's from being in the final query when it gets translated to the sql statement.

user_18309160
Related