java.lang.IllegalArgumentException: Can not set java.lang.Long field com.mypackage.User.id to java.lang.Long

Question

I am using Java 8 with JPA2/Hibernate5 and MySQL.

  tables
 +--------+    +----------------+    +--------------+ 
 | User   |    |  OrgMember     |    | Organization |
 +--------+    +----------------+    +--------------+ 
 | ID     |    | ID             |    |  ID          |
 | NAME   |    | userId         |    +--------------+ 
 +--------+    | orgId          |
               +----------------+

Here is the join table definition

@Entity         
@Table(name = "org_members")
public class OrgMember implements Serializable
{
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "userId", referencedColumnName = "id")
    private User user;

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "orgId", referencedColumnName = "id")
    private Organization organization;

Here is the definition for the User table:

@Entity
@Table(name = "user")
public class User implements Serializable
{
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

Finally, here is the definition for the Organization table

@Entity
@Table(name = "organization")
public class User implements Serializable
{
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

I am using the Spring 5 data repository for the OrgMemberRepository

 @Repository("organizationMemberRepo")
 public interface OrganizationMemberRepository extends JpaRepository<OrgMember, Long>
 {
     List<OrgMember> findByUser(Long userId);
     List<OrgMember> findByOrganization(Long orgId);
 }

And it is the unit tests that are breaking:

 @Test
 public void testFindByOrganization()
 {
     Long orgId = 1L;
     List<OrgMember> orgMemberList = 
             organizationMemberRepository.findByOrganization(orgId);
     assertNotNull(orgMemberList);
     assertEquals(true, orgMemberList.size() > 0);
 }

 @Test
 public void testFindByUser()
 {
     Long userId = 3L;
     List<OrgMember> orgMemberList = organizationMemberRepository.findByUser(userId);
     assertNotNull(orgMemberList);
    assertEquals(true, orgMemberList.size() > 0);
 }

I am sure this should be a simple task, and I am sure there is a simple fix. I'll play around with this a bit more, and make sure I am looking for the right things.

Thanks!

Midhun Mohan · Accepted Answer · 2021-07-21 06:00:03Z

1

Did you tried like below

@Repository("organizationMemberRepo")
 public interface OrganizationMemberRepository extends JpaRepository<OrgMember, Long>
 {
     List<OrgMember> findByUserId(Long userId);// or findByUser_Id
     List<OrgMember> findByOrganizationId(Long orgId);// or findByOrganization_Id
 }

Because In this case the query generation during the interface to implementation will be User.Id and Organization.Id and there the Long argument will work as expected.

And for the user keyword issue that may come, try to change it from @Table(name = "user") to @Table(name = "`user`")

edited Jul 21, 2021 at 6:00

answered Jul 21, 2021 at 5:50

Midhun Mohan

6721 gold badge5 silver badges14 bronze badges

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

2 Comments

tjholmes66 Over a year ago

Yes, the two methods you suggest did work for me. I kept the original two methods, but then I just passed in an Object to both and that worked also. Thanks!

Midhun Mohan Over a year ago

@tjholmes66 ya the object level will also work depends on the equals implementation of User

Alien · Accepted Answer · 2021-07-21 03:00:14Z

0

user is a reserved keyword in SQL.

Try by changing it to something else and see if the error goes away.

answered Jul 21, 2021 at 3:00

Alien

16k8 gold badges43 silver badges64 bronze badges

Comments

tjholmes66 · Accepted Answer · 2021-07-21 19:39:40Z

0

Yep, as described by @MindhunMohan I changed the definitions and it worked.

The methods I have now are as follows:

@Repository("organizationMemberRepo")
public interface OrganizationMemberRepository extends JpaRepository<OrgMember, Long>
{
    List<OrgMember> findByUser(User user);
    List<OrgMember> findByOrganization(Organization org);

    List<OrgMember> findByUserId(Long userId);
    List<OrgMember> findByOrganizationId(Long orgId);
}

These methods worked now, and the unit tests for these now work also.

Thanks!

answered Jul 21, 2021 at 19:39

tjholmes66

2,0404 gold badges44 silver badges80 bronze badges

Collectives™ on Stack Overflow

java.lang.IllegalArgumentException: Can not set java.lang.Long field com.mypackage.User.id to java.lang.Long

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest