Problem with sql - java.sql.SQLException: Operand should contain 1 column(s) (once

Question

I'm using Spring Data for select operation on MySql DataBase.

I'm trying to get all Institutions by listOfWhomHelp. I expected all records(institutions) which contain listOfWhomHelp, but if I choose more than one element in listOfWhomHelp it throws me:

java.sql.SQLException: Operand should contain 1 column(s)
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:963)

Repository method

List<Institution> findAllByWhomHelp(List<InstitutionListOfWhomHelp> institutionListOfWhomHelp);

Service method

public List<Institution> findInstitutions(Institution institution) throws NullPointerException {

    if(institution.getInstitutionLocations().isEmpty()){
        return institutionRepository.findAllByWhomHelp(institution.getWhomHelp());
    }
}

There is also list of InstitutionLocation, but I always choose on of them

Institution

@NotEmpty
@ManyToMany
private List<InstitutionListOfWhomHelp> whomHelp;

InstitutionListOfWhomHelp

@NotBlank
private String whomHelp;

@ManyToMany(mappedBy = "whomHelp")
private List<Institution> institution;

don't you think it should use ! like ` if(! institution.getWhomHelp().isEmpty()){ return institutionRepository.findAllByWhomHelp(institution.getWhomHelp()); }` — RAHUL ROY
– RAHUL ROY, Commented Mar 26, 2019 at 5:03
But the problem is that institution.getWhomHelp() isn't empty - i checked this before.This is the way when list institution.getInstitutionLocations() is empty and whomHelp isn't. I've also take care of NullPointerException — Michał Tomala
– Michał Tomala, Commented Mar 26, 2019 at 6:03

Musa Ay · Accepted Answer · 2019-03-26 07:15:05Z

1

Can you try like bottom

instituonRepository.findAllByWhomHelpIn

Thanks

answered Mar 26, 2019 at 7:15

Musa Ay

1645 bronze badges

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

Collectives™ on Stack Overflow

Problem with sql - java.sql.SQLException: Operand should contain 1 column(s) (once

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related