Search code examples
postgresqlebeanplayframework-2.2

Ebean request giving 2 identic rows

I have one row in my PostgreSQL table with the name I look for, but Ebean query gives me two identic results (same primary key). Each row has a unique name so I must be able to findUnique()

finder.where().eq("name", name).findUnique()

Handmade sql query gives me only one

String sql = "select id, name from totem where name ilike :name";

Any idea to get findUnique() working ? Is it an Ebean bug ?

Solution

  • I have a OnetoOne relationship with table B.

    So Ebean generates an inner join with this table.

    Table B has two entry corresponding the object I'm fetching on table A.

    So the request returns 2 rows.