hi

I have a table called course_user in thsi shape

courseId userId
2 1
3 1

in sql we can do this

select courseId from course_user where userId = 1 ;

how ca we do that in hibernate ?

thanks a lot

Amir

amir55,

Here is the way you can select in Hibernate:

select courseuser.courseId from course_user courseuser where courseuser.userId = 1 ;

Do let us know how it works for you.

hi dear Shirani

many thanks

the code of quering a table is not working
queryString = "select course.courseId from course_user where course.user.userId = 1" ;

the error is
course_user is not mapped

because the course_user is a table and not a class. Can you kindly enquire one of your hibernate team on how hibernate execute standard sql statements

many thanks with high appreciations

Amir

Amir,

Please go through this link.
http://www.roseindia.net/hibernate/selectclause.shtml