Do not carry my list on page XHTML

[Alan Duke]

Can not display XHTML page in the result of my query. I suspect that my bean is wrong, or I am not able to connect me with PostgreSQL. Below my files and beans.

My ManagedBean(MB)

@ManagedBean(value="MostraEsc")
@SessionScoped
public class MostraEscolaAtiva {
	
	private static final int List = 0;
	private static final int Escola = 0;
	private DataModel listaEscola;
	private List<Escola> escolas;	 
	
	public void handleToggle(ToggleEvent event) {  
        FacesMessage msg = new FacesMessage(FacesMessage.SEVERITY_INFO, "Fieldset Toggled", "Visibility:" + event.getVisibility());    
        FacesContext.getCurrentInstance().addMessage(null, msg);  
    } 	
	public void setListaEscola(DataModel listaEscola) {
		this.listaEscola = listaEscola;
	}
	public DataModel getListaEscola(){
		List<Escola> lista = new EscolaDaoImp().findAll();
		listaEscola = new ListDataModel(lista);
		return listaEscola;
	}
	public List<Escola> getEscolas() {
		return escolas;
	}
	public void setEscolas(List<Escola> escolas) {
		this.escolas = escolas;
	}	
}

My DAO

public interface DAO<T> {
	public void Inserir(T t);
	public void Deletar(T t);
	public void Atualizar(T t);
	public List<T> list();
}

My DAOImplementation

public class EscolaDaoImp implements EscolaDAO{
	private EntityManager em;	
	@Override
	public Class<Escola> getEntityType() {
		return Escola.class;
	}
	public List<Escola> list() {
        Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction t = session.beginTransaction();
        List lista = session.createQuery("from Escola").list();
        t.commit();
        return lista;
	}	
	public EntityManager getEm() {
		return em;
	}
	public void setEm(EntityManager em) {
		this.em = em;
	}	
	protected EntityManager getEntityManager()  
    {  
        if (this.em == null)  
            throw new IllegalStateException("Erro");  
        return this.em;  
    }      
   @PersistenceContext  
   public void setEntityManager(EntityManager em) {  
       this.em = em;  
   }       
    public List<Escola> findAll() {    
              Query query =  getEntityManager().createQuery("select distinct e.nome " +     
                                                            "from " +    
                                                            "pessoa p inner join professor f on (p.idpessoa = f.idpessoa) " +    
                                                            "inner join matricula m on (m.idprofessor = f.idprofessor) " +    
                                                            "inner join escola e on (e.idescola = m.idescola)" +    
                                                            "where m.situacao = 'A'");    
              return (List<Escola>) query.getResultList();    
    }
}

My AbstractDAO(Implementation of DAO)

public abstract class AbstractDAO<T extends Object> implements DAO<T> {
	@Override
    public void Inserir(T obj) {
        Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction t = session.beginTransaction();
        session.save(obj);
        t.commit();       
    }
    @Override
    public void Deletar(T obj) {
        Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction t = session.beginTransaction();
        session.delete(obj);
        t.commit();
    }
    @Override
    public void Atualizar(T obj) {
        Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction t = session.beginTransaction();
        session.update(obj);
        t.commit();           
    }
    @Override
    public List<T> list() {
        Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction t = session.beginTransaction();
        List lista = session.createQuery("from "+getEntityType().getSimpleName()).list();
        t.commit();
        return lista;
    }
       protected abstract Class<T> getEntityType();
}

My XHTML(I posted one piece of code)

<h:form>    
    <p:graphicImage value="/Images/ico.jpg" /> 						
      <p:dataList value="#{MostraEsc.getListaEscola}" var="escola" type="ordered">  
         #{escola.nome}[color=red]//This show my result[/color]  
      </p:dataList>   
</h:form>

And my Persistence

<?xml version="1.0" encoding="UTF-8"?>  
<persistence xmlns="http://java.sun.com/xml/ns/persistence"  
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  
    xsi:schemaLocation="http://java.sun.com/xml/ns/persistence               
                       http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"  
    version="1.0">  
    <persistence-unit name="maindatabasePU"  
        transaction-type="RESOURCE_LOCAL">   
        <properties>  
            <property name="hibernate.connection.driver_class" value="org.postgresql.Driver" />  
            <property name="hibernate.connection.username" value="postgres" />  
            <property name="hibernate.connection.password" value="123" />  
            <property name="hibernate.connection.url" value="jdbc:postgresql://localhost:5435/Escola" />  
            <property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect" />  
            <property name="hibernate.show_sql" value="true" />  
        </properties>  
    </persistence-unit>  
</persistence> 

[Alan Duke]

nothing.

[fred rosenberger]

You've got 100+ lines of code, and no clear question anywhere. I'm not surprised you haven't gotten a response.

Your job, when you post a question, is to make it as EASY as possible for folks to help you. the easier you make it, the more likely you are to get that help.

Is there any way you can reduce the amount of code someone would need to look at?

The statement "I suspect that my bean is wrong, or I am not able to connect me with PostgreSQL" seems rather broad as well. If you suspect that your bean is wrong, in what way do you think this is so? What evidence do you have to make such a statement - or is that simply a WAG?

"I am not able to connect me with PostgreSQL" - does that mean you think the technology is incapable, or does it mean you think your specific implementation doesn't work? And again, what evidence do you have to make such statements?