Hi,

Want to implement a feature to allow a user to block a list of other users. The use case is for any given user id, find the list of users he blocks.

I use a many-to-many relationship table to map the relationship:
user1_id, user2_id

Since there might be a huge long list of users a user want to block, I don't want to keep a list of blockedUsers inside my user data object. May even need to implement pagination to show the list of blocked users.

What's the best way I can use Hibernate to maintain the relationship and answer query like: findBlockedUserListByUserId(userId).

Should I use native SQL with addEntity? Is there a better way?

thanks!

Any idea? It should be a common problem. If the same question has been asked, a pointer to that thread would also help.

if the case is like this.... one admin user can block n number of users and one user can be blocked by many admin users..
then the relation can be defined in following way...

User_table
*User_id
User_Name

Admin_Table
*admin_id
*user_id

both of the above id refer to user_id in user_table...


this will be a bi-diectional one-to-many relation.

ur findBlockedUserListByUserId(userId) will fire a query on user_table and probably return list of user_id's

Thanks. Don't think it is the answer I am looking for. It is not about Admin user. Any user can block any user (from sending message to them and ...).

Again, I don't want to keep a list of blockedUsers in my user data object. What's the best way to map the relationship and build a query like findBlockedUsersByUserId() using hibernate?

I can only think about using native query.