SecondaryTable Mapping

[Anup Om]

Hello Everybody,

I am trying to map following tables to a single class User. Is my mapping alright? Nowhere I specify that user_roles has a composite primary key. Will this work?

create table users (
user_name varchar(15) not null primary key,
user_pass varchar(15) not null
);

create table user_roles (
user_name varchar(15) not null,
role_name varchar(15) not null,
primary key (user_name, role_name)
);

@Entity
@Table(name="Users")
@SecondaryTable(name="USER_ROLES",
		pkJoinColumns=@PrimaryKeyJoinColumn(name="USER_NAME", referencedColumnName="USER_NAME")          
		)
		
public class User {
	
	@Id
	@Column(name="USER_NAME")
	private String userName;	
	@Column(name="USER_PASS")
	private String password;
	private String email;
	private String gender;

	@Column(name="ROLE_NAME", table="USER_ROLES")
	private String accountType;	

	private String promotionalCode;
	
	//getters and setters
	

}

Thanks,

[James Sutherland]

It will work if the user_name is unique in the role table.

If a user has multiple roles as the schema allows, then it may work for some situations, but is not a very good idea. A OneToMany to Role would be better.

[Anup Om]

Thank you so much. I understand better now. Secondary table mapping may be used for table if they have same primary key.