can you use both hibernate mappings and native sql in the project at or not...

how do make many to many relationship between three tables and a link table in hibernate

select rf.name, rf.category, ap.name from ref_data rf, app
ap, roles r
where rf.id=rr.ref_id and ap.id=rr.ar_id
and ap.name='Manager' and rf.system='Task'
order by rf.name


i tried a manny to many from my role table to my other two but the mappings dont work

yes