if you want to just select values, you can use the select statement

select value1, value2, from table1 table2 where condition 1 and/or condition 2

i.e.

select u.name, j.title from User u, job j where u.name = 'john' and j.code = 3

Also, you can join tables in a join statement (page 147 in the manual)

select mother, offspr, mate.name
from DomesticCat as mother
inner join mother.mate as mate
left outer join mother.kittens as offspr

hi,

If it's possible to write in the Spring Application.

my Problem is I have 3 Different POJO's i want to retrieve the Value from that.


Bala

I am not sure of what you are asking. Are you trying to eager fetch all of the three objects?

If you want to eager fetch, you can call

Hibernate.initialize() to initialize your objects before you close your session.

hi,
[/color]

The above is my code.

Based on the Company_ID i retreive the Value from the Company_Address table in one scenario.

In my second scenarion i want to retrieve the Country name and State name from the table Country and state respectively based on the Company_Code
how can i do it.


Bala

Does the company_address table has a relationship to country table and the sate table?

Yes, three tables are interlinked,

Company_Address - Country_code and State_id is available

Country - Country_Code is Primary Key

State - State_ID is primary Key

Bala

try this:

select c.ean_company_address, c.state.name, c.country.name from companyAddress c where c.company_code = 87

" from CompanyAddress EAN_COMPANY_ADDRESS where COMPANY_ID = ? "

one info in the above line CompanyAddress is my POJO name and EAN_COMPANY_ADDRESS is my table name.

if i using that line in which POJO i will use to retrieve it.


Bala

You have to look into your .hbn configuration file. Each table should be mapped to a Bean, and each table column should be mapped to a Bean property. You don't use table name in HQL, you use the Bean name and its properties.

I couldn't know that how will i proceed that.

Bala