I have a project class that has a set of userstories called userStories12many
im having trouble trying to get the project that has a certain userstory in its set getComponent(int userStoryID)

I think im on the right track but i dont know what i did wrong

public Projects getComponent(int userStoryID)
{
Session session = SessionFactoryHelper.getSessionFactory()
.getCurrentSession();
session.beginTransaction();

List<Projects> compo = session.createQuery("select p "
+"from Projects as p inner join fetch p.userStories12many as u "
+"where u.storyId='"+userStoryID+"'").list();
session.getTransaction().commit();
return compo.get(0);

}

no reply!

◎◎◎◎◎

Did you get an error?

try something like that

List<Projects> compo =
s.createQuery(new StringBuffer("SELECT a, b FROM ")
.append(Projects .class.getName() + " a, ")
.append(userStories12many .class.getName() + " b ")
.append(" WHERE a.storyId. = buserStoryID. ")
.toString())
.list();