Hi all,
I have following 3 tables in mysql db
[img]

mysql> select * from person;
+---------+--------+-----------------+-----------------+---------------------+----------+
| user_id | active | email | fullName | joined | password |
+---------+--------+-----------------+-----------------+---------------------+----------+
| bucky | 1 | bucky@abc.com | Bucky Wall | 2017-01-30 12:43:46 | bucky |
| james | 1 | james@abc.com | James Goedic | 2017-01-30 12:43:19 | james |
| praveen | 1 | praveen@abc.com | Praveen Reddy S | 2017-01-30 12:37:40 | praveen |
| priya | 1 | priya@abc.com | Priya Reddy | 2017-01-10 10:30:17 | priya |
+---------+--------+-----------------+-----------------+---------------------+----------+
4 rows in set (0.00 sec)

mysql> select * from tweet;
+----------+---------------------+----------------------------+---------+
| tweet_id | created | message | user_id |
+----------+---------------------+----------------------------+---------+
| 1 | 2017-01-30 12:45:37 | @Bucky!. Meet me in office | james |
| 2 | 2017-01-30 12:45:58 | @James!. How nare you? | praveen |
| 3 | 2017-01-30 12:46:10 | Hi, Every One | praveen |
| 4 | 2017-01-30 12:46:38 | @James: Hellow James | bucky |
| 5 | 2017-01-31 10:30:50 | This is Priya | priya |
+----------+---------------------+----------------------------+---------+
5 rows in set (0.00 sec)

mysql> select * from following;
+---------+--------------+
| user_id | following_id |
+---------+--------------+
| praveen | bucky |
| praveen | james |
+---------+--------------+
2 rows in set (0.00 sec)
[/img]

My Two Entity classes are

Person.java


Tweet.java



Now I want to display messages of user praveen, and also all the messages mapped to praveen user in the following table. That means praveen user have 2 messages and his following users have 2 messages . Total 4 messages should be displayed. I really don't know how to retrieve this info using any technique in Hibernate. Please help me

A native SQL query is like a Magic Wand. You only need HQL for fetching entities that you plan to modify.

Back to your problem, use this native query:



You can also map it to an entity, as explained in the aforementioned article.

Using native SQL i got the output. But my requirement is not use native sql. Please help

The query is just the same with HQL or JPQL:



This query assumes that the Following entity has 2 @ManyToOne associations:

Folowing is my native code. Its working good. But i need HQL

Thanks for the reply. But that query works only for tweetid 1. But i need all tweets whose user name is some thing. So I wanted to list all tweet messages of a user and his following users tweet messages .

If you read the HQL and JPQL User Guide chapter, you'll find the answer for such a trivial question of how to use a named parameter in an entity query.