'Restrictions to get main Entity based on another entity from a List

I have a relationship between 2 Entities, UserDefinition and Company. Here is how i map my relationship with hibernate :

@OneToMany
@JoinColumn(name="COMPANY_ID",nullable=true,updatable=true)
private List<UserDefinition> users;

I do have a COMPANY_ID column in my table but not in UserDefinition Entity to avoid recursivity. Here is what i am doing for now :

@Transactional
    public Company retrieveByUser(UserDefinition user) {
        return (Company) getCurrentSession().createCriteria(getClazz()).add(Restrictions.eq("users", user)).uniqueResult();
    }

But i get an error, here is a part of the stack trace :

java.sql.SQLException: Missing IN or OUT parameter at index:: 1
    at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:2086)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3772)
    at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343)
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3822)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1165)
    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:353)
    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:70)
    at org.hibernate.loader.Loader.getResultSet(Loader.java:2122)
    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1905)
    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1881)
    at org.hibernate.loader.Loader.doQuery(Loader.java:925)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:342)
    at org.hibernate.loader.Loader.doList(Loader.java:2622)
    at org.hibernate.loader.Loader.doList(Loader.java:2605)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2434)
    at org.hibernate.loader.Loader.list(Loader.java:2429)
    at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:109)
    at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1787)
    at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:363)
    at org.hibernate.internal.CriteriaImpl.uniqueResult(CriteriaImpl.java:385)
    at XXXX.commons.spring.io.persistence.dao.CompanyDAO.retrieveByUser(CompanyDAO.java:25)

There is probably something wrong with Restrictions.eq("users", user). How can i retrieve the company of one specific user ? After retrieving this company i will use it as a filter by company - e.g. Restrictions.in("userLogin", companyDao.retrieveByUser(user).getUsers()) on another table containing the userLogin. Thanks for your help :)



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source