java - working with views in hibernate -

I am joining 4 tables in total and am making a scene.

Details of the tables are given below,

  System: Integer System ID; String system value; Customers: Integer Customer ID; String login_username client system: integer client system id; Integer system id; Login: string login_username;  

To join the above 4 tables (joining the left and joining the right) I have created a view that means the view does not mean to identify any row (this is not a primary key Is), because this query includes left and right, some columns will be empty.

But in hibernation the primary key is expected

I tried the following methods:

1. Composite considering each column of the view Prepare primary key.
2. Tried for the sequence

The first approach I faced was the issue, whenever I tried to query, I received the tuples equal to the number of tuples I used to do that when I run the query manually, the workspace, but all the objects will be empty.

I thought about trying another approach, but after Googling it was found that MySQL does not support sequence, so the only way I have to write the stored procedure is

P> I have added United Nations login and system I ) Then it will be the primary key for the scene.

This problem is now resolved.