how to insert data in one to many relationship in spring jpa

Question

I am new in Spring. I want to insert the data into the AUDIT table. There is a one-two-many relationship between USER and AUDIT tables.

For every login and logout data should be inserted into the AUDIT table. How can I do that?

The user entity:

@Table(name="USER") public class User { @Id @GeneratedValue(strategy=GenerationType.AUTO) @Column(name="USERID") private Long id; private String username; private String email; private Long phone; private String password; private int OTP; private boolean activation_flag; @OneToMany(cascade=CascadeType.ALL) @JoinColumn(name="USERID") private Set<Audit> audit; @ManyToOne @JoinColumn(name="ADDRESSID") private Address address; @ManyToMany(fetch = FetchType.EAGER) @JoinTable( name = "USER_AUTHORITY", joinColumns = {@JoinColumn(name = "USER_ID", referencedColumnName = "USERID")}, inverseJoinColumns = {@JoinColumn(name = "AUTHORITY_ID", referencedColumnName = "ID")}) private List<Authority> authorities;

The audit entity:

@Entity @Table(name="AUDIT") public class Audit { @Id @GeneratedValue(strategy=GenerationType.AUTO) @Column(name="AUDITID") private long auditid; @Column(name="GEOLOCATION") private String geolocation; @Column(name="ACTION") private String action; @Column(name="DATETIME") private Date datetime; @Column(name="DEVICEID") private long deviceid; @Column(name="ACTIONSUCCESS_FAIL") private boolean actionsuccess_fail; @Column(name="JWT_TOKEN") @Type(type="text") private String JWT_token; @ManyToOne private User user;

The audit repository:

public interface AuditRepository extends JpaRepository<Audit, Long> { }

The user repository:

public interface UserRepository extends JpaRepository<User, Long> { User findByUsername(String username); User findByEmail(String email); User findByPhone(Long phone); User findById(Long id); }

I've improved formatting (for better readability and hopefully more answers) — Thomas Fritsch
– Thomas Fritsch, Commented Sep 9, 2017 at 13:44

LetsBeFrank · Accepted Answer · 2017-09-10 01:33:45Z

1

Add the audit to the user you want the audit associated with, then save.

answered Sep 10, 2017 at 1:33

LetsBeFrank

79211 silver badges31 bronze badges

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

3 Comments

Rahul Chavan Over a year ago

Thanku letsBeFrank..can you please tell me how can I insert data in one to many relationships..

LetsBeFrank Over a year ago

user.getAudits().add(newAudit); then userRepository.save(user);

Rahul Chavan Over a year ago

any one have answer i want to add through REST api

Collectives™ on Stack Overflow

how to insert data in one to many relationship in spring jpa

1 Answer 1

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Related