Reply to thread

Message

<blockquote data-quote="Anonymous_Abstract" data-source="post: 26201269" data-attributes="member: 568286">User Class----------------@Entity@Table(name = &quot;USER90&quot;,schema = Schema.TESTDB,uniqueConstraints = {&nbsp; &nbsp; &nbsp; &nbsp; @UniqueConstraint(name = &quot;userName&quot;,columnNames = &quot;USER_NAME&quot;),&nbsp; &nbsp; &nbsp; &nbsp; @UniqueConstraint(name = &quot;email&quot;,columnNames = &quot;EMAIL&quot;)})@Getter@Setterpublic class User {&nbsp; &nbsp; @Id&nbsp; &nbsp; @SequenceGenerator(name = &quot;USER_ID_GEN&quot;,sequenceName = Schema.TESTDB+&quot;.USER_ID_SEQ&quot;,initialValue = 1003,allocationSize = 1)&nbsp; &nbsp; @GeneratedValue(generator = &quot;USER_ID_GEN&quot;,strategy = GenerationType.SEQUENCE)&nbsp; &nbsp; @Column(name = &quot;USER_ID&quot;)&nbsp; &nbsp; private int userId;&nbsp; &nbsp; @Column(name = &quot;USER_NAME&quot;,nullable = false)&nbsp; &nbsp; private String userName;&nbsp; &nbsp; @Column(name = &quot;PASSWORD&quot;,nullable = false)&nbsp; &nbsp; private String password;&nbsp; &nbsp; @Column(name = &quot;EMAIL&quot;,nullable = false)&nbsp; &nbsp; private String email;&nbsp; &nbsp; @Column(name = &quot;ACTIVE&quot;,nullable = false)&nbsp; &nbsp; private String active;&nbsp; &nbsp; @Column(name = &quot;ACC_NON_EXPIRED&quot;)&nbsp; &nbsp; private String accNonExpired;&nbsp; &nbsp; @Column(name = &quot;CREDENTIAL_NON_EXPIRED&quot;)&nbsp; &nbsp; private String credentialNonExpired;&nbsp; &nbsp; @Column(name = &quot;ACC_NON_LOCKED&quot;)&nbsp; &nbsp; private String accNonLocked;&nbsp; &nbsp; @ManyToMany(cascade = CascadeType.ALL,fetch = FetchType.EAGER)&nbsp; &nbsp; @JoinTable(name = &quot;USER_ROLE&quot;,joinColumns = {@JoinColumn(name = &quot;USER_ID&quot;, referencedColumnName = &quot;USER_ID&quot;)},&nbsp; &nbsp; inverseJoinColumns = {@JoinColumn(name = &quot;ROLE_ID&quot;,referencedColumnName = &quot;ID&quot;)})&nbsp; &nbsp; private Set&lt;Role&gt; roles;}Role class------------------@Entity@Table(name = &quot;ROLE&quot;,schema = Schema.TESTDB,uniqueConstraints = {&nbsp; &nbsp; &nbsp; &nbsp; @UniqueConstraint(name = &quot;name&quot;,columnNames = &quot;NAME&quot;)})@Getter@Setterpublic class Role {&nbsp; &nbsp; @Id&nbsp; &nbsp; @Column(name = &quot;ID&quot;)&nbsp; &nbsp; private long id;&nbsp; &nbsp; @Enumerated(EnumType.STRING)&nbsp; &nbsp; @Column(name = &quot;NAME&quot;)&nbsp; &nbsp; private ERole name;&nbsp; &nbsp; // bi-directional&nbsp;&nbsp; /* @ManyToMany(cascade = CascadeType.ALL,fetch = FetchType.EAGER)&nbsp; &nbsp; private Set&lt;User&gt; users;*/&nbsp; &nbsp; // uni-directional&nbsp; &nbsp; @ManyToMany(cascade = CascadeType.ALL,fetch = FetchType.EAGER)&nbsp; &nbsp; @JoinTable(name = &quot;PERMISSION_ROLE&quot;,joinColumns = {@JoinColumn(name = &quot;ROLE_ID&quot;,referencedColumnName = &quot;ID&quot;)},&nbsp; &nbsp; inverseJoinColumns = {@JoinColumn(name = &quot;PERMISSION_ID&quot;,referencedColumnName = &quot;ID&quot;)})&nbsp; &nbsp; private Set&lt;Permission&gt; permissions;}Permission class-----------------@Entity@Table(name = &quot;PERMISSION&quot;,schema = Schema.TESTDB,uniqueConstraints = {&nbsp; &nbsp; &nbsp; &nbsp; @UniqueConstraint(name = &quot;name&quot;,columnNames = &quot;NAME&quot;)})@Getter@Setterpublic class Permission {&nbsp; &nbsp; @Id&nbsp; &nbsp; @Column(name = &quot;ID&quot;)&nbsp; &nbsp; private long id;&nbsp; &nbsp; @Enumerated(EnumType.STRING)&nbsp; &nbsp; @Column(name = &quot;NAME&quot;)&nbsp; &nbsp; private EPermission name;}<hr />vena venama dala thama thiyenna. aluthin user kenek register karanakota new userta role assign karanna thamai awl yanne. &nbsp;permission names and Id aapahu save karanna oni nehe ne&nbsp;&nbsp; &nbsp; &nbsp;&nbsp; meka thamai matath denaganna ona aluthin user register karanakota oka role reference vidiya ganne khomada kiyala. othanadi venna &quot;alter&quot; veemak venna na aluthin save karanava mata alter venna onajpql valin insert and alter query dekama eka sera ghanna kramayak na na------ Post added on [DATETIME=&quot;UT&quot;]1615346773[/DATETIME]</blockquote>

[QUOTE="Anonymous_Abstract, post: 26201269, member: 568286"] User Class ---------------- @Entity @Table(name = "USER90",schema = Schema.TESTDB,uniqueConstraints = { @UniqueConstraint(name = "userName",columnNames = "USER_NAME"), @UniqueConstraint(name = "email",columnNames = "EMAIL") }) @Getter @Setter public class User { @Id @SequenceGenerator(name = "USER_ID_GEN",sequenceName = Schema.TESTDB+".USER_ID_SEQ",initialValue = 1003,allocationSize = 1) @GeneratedValue(generator = "USER_ID_GEN",strategy = GenerationType.SEQUENCE) @Column(name = "USER_ID") private int userId; @Column(name = "USER_NAME",nullable = false) private String userName; @Column(name = "PASSWORD",nullable = false) private String password; @Column(name = "EMAIL",nullable = false) private String email; @Column(name = "ACTIVE",nullable = false) private String active; @Column(name = "ACC_NON_EXPIRED") private String accNonExpired; @Column(name = "CREDENTIAL_NON_EXPIRED") private String credentialNonExpired; @Column(name = "ACC_NON_LOCKED") private String accNonLocked; @ManyToMany(cascade = CascadeType.ALL,fetch = FetchType.EAGER) @JoinTable(name = "USER_ROLE",joinColumns = {@JoinColumn(name = "USER_ID", referencedColumnName = "USER_ID")}, inverseJoinColumns = {@JoinColumn(name = "ROLE_ID",referencedColumnName = "ID")}) private Set<Role> roles; } [I]Role class[/I] ------------------ @Entity @Table(name = "ROLE",schema = Schema.TESTDB,uniqueConstraints = { @UniqueConstraint(name = "name",columnNames = "NAME") }) @Getter @Setter public class Role { @Id @Column(name = "ID") private long id; @Enumerated(EnumType.STRING) @Column(name = "NAME") private ERole name; // bi-directional /* @ManyToMany(cascade = CascadeType.ALL,fetch = FetchType.EAGER) private Set<User> users;*/ // uni-directional @ManyToMany(cascade = CascadeType.ALL,fetch = FetchType.EAGER) @JoinTable(name = "PERMISSION_ROLE",joinColumns = {@JoinColumn(name = "ROLE_ID",referencedColumnName = "ID")}, inverseJoinColumns = {@JoinColumn(name = "PERMISSION_ID",referencedColumnName = "ID")}) private Set<Permission> permissions; } Permission class ----------------- @Entity @Table(name = "PERMISSION",schema = Schema.TESTDB,uniqueConstraints = { @UniqueConstraint(name = "name",columnNames = "NAME") }) @Getter @Setter public class Permission { @Id @Column(name = "ID") private long id; @Enumerated(EnumType.STRING) @Column(name = "NAME") private EPermission name; } [HR][/HR] vena venama dala thama thiyenna. aluthin user kenek register karanakota new userta role assign karanna thamai awl yanne. permission names and Id aapahu save karanna oni nehe ne meka thamai matath denaganna ona aluthin user register karanakota oka role reference vidiya ganne khomada kiyala. othanadi venna "alter" veemak venna na aluthin save karanava mata alter venna ona jpql valin insert and alter query dekama eka sera ghanna kramayak na na ------ [SIZE=2]Post added on [DATETIME="UT"]1615346773[/DATETIME][/SIZE] [/QUOTE]

Verification

Payakata winadi keeyak tibeda?

Search

Latest ads

Reply to thread