I have 2 Java POJO files The database has a FK mapping between FilterVariable.id and ValueVariable.valueListId. Inserts into the table work perfectly, i have a single transaction that inserts into both tables separately. While retrieving the data using select and join, I only receive the first row from the table in the database. Database Tables: The method in the interface