sessionFactory null when trying to select in the database

Question

Good morning,
I’m using Spring and JSF. I wanted to query the database and return the data from a table, but in the method I do the search, when calling sessionFactory, it is null. I really couldn’t find the problem.

/*classe DAO*/

package br.com.racionalgames.pta.dao;
import java.util.List;
import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.EnableTransactionManagement;
import org.springframework.transaction.annotation.Transactional;
import br.com.racionalgames.pta.model.UploadFiles;

@Repository("ListPlanilhasDao")
@Transactional
@EnableTransactionManagement
public class ListPlanilhasDaoImpl implements ListPlanilhasDao {

    @SuppressWarnings("unchecked")
    @Override
    public List<UploadFiles> getListPlanilha() throws Exception {

        List<UploadFiles> lista = null;
        String sql = "SELECT * FROM pta.criterios_multiskill";

        try {
            lista = sessionFactory.getCurrentSession().createSQLQuery(sql).list();

        } catch (Exception e) {
            System.out.println("Erro no DAO: " + e);
        }

        return (List<UploadFiles>) lista;
    }

    @Autowired
    private SessionFactory sessionFactory;

    public SessionFactory getSessionFactory() {
        return sessionFactory;
    }

    public void setSessionFactory(SessionFactory sessionFactory) {
        this.sessionFactory = sessionFactory;
    }
}

    *spring-config.xml  <bean id="ListPlanilhasDao" class="br.com.racionalgames.pta.dao.ListPlanilhasDaoImpl" />
*/

Answer 1

thanks for the answer, I found the problem. I was forgetting the injection @Managedproperty("#{listPlanilhasDao}"). With this would come null always.