Hello everybody!

I just want to make a quit question:

In my DB I have a table Sensor which is connected 1--* with table Parameter (1 Sensor has * Parameters).
I have a value that is a SensorId of table Sensor and I want to get the value of ParameterId in table Parameter, which has the foreign key ID_Sensor.

I'd like to know you is like the HQL query for this kind of select. That is get an Id field of a table starting from an Id field of another table that are connected by a Foreign key of the last table.

Thanks in advance!

P.S: if you know other (better) ways to do this, plz post!

[quote="ivorelvas"]Hello everybody!

I just want to make a quit question:

In my DB I have a table Sensor which is connected 1--* with table Parameter (1 Sensor has * Parameters).
I have a value that is a SensorId of table Sensor and I want to get the value of ParameterId in table Parameter, which has the foreign key ID_Sensor.

I'd like to know you is like the HQL query for this kind of select. That is get an Id field of a table starting from an Id field of another table that are connected by a Foreign key of the last table.

Thanks in advance!

P.S: if you know other (better) ways to do this, plz post![/quote]

Hello Friend:

Can you post ur ona sample? Because, for me is very hard to understand your main idea. Please.

List<Parameter> parametersWithSomeSensor = session.createQuery("from Parameters where ID_sensor = ?").setParameter(parameternumber, someSensor.getID()).list();

parameternumber is zero or one, I'm not sure whether it's zero-based or not.

Define an association 1-M between sensor and parameter.....

use your primary - foreign key relation between two tables

then you can use join queries using HQL to get the values you wanted.

For e.g , you can refer Hibernate ref doc