Olá estou tendo um problema em consulta usando o JSF e Hibernate. Estar tudo certo... porém nao estou adivinhando o erro.
As paginas são essas:
<%@ page language="java" contentType="text/html"
pageEncoding="ISO-8859-1"
%>
<%@ taglib uri="http://java.sun.com/jsf/core" prefix="f" %>
<%@ taglib uri="http://java.sun.com/jsf/html" prefix="h" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Resultado de Pesquisas de Clientes</title>
</head>
<body>
<f:view>
<h:messages />
<h3>Cliente(s) Encontrado(s)</h3>
<h:form>
<h:dataTable value='#{RelbugsController.buscarCliente}'
var='item' border="1" cellpadding="2" cellspacing="0">
<h:column>
<f:facet name="header">
<h:outputText value="codigo"/>
</f:facet>
<h:outputText value="#{item.codigo}"/>
</h:column>
<h:column>
<f:facet name="header">
<h:outputText value="Cliente"/>
</f:facet>
<h:outputText value="#{item.cliente}"/>
</h:column>
</h:dataTable>
</h:form>
</f:view>
</body>
</html>
<%@ page language="java" contentType="text/html"
pageEncoding="ISO-8859-1"
%>
<%@ taglib uri="http://java.sun.com/jsf/core" prefix="f" %>
<%@ taglib uri="http://java.sun.com/jsf/html" prefix="h" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Busca Clientes</title>
</head>
<body>
<f:view>
<h:form id="buscar">
<h:panelGrid columns="2">
<f:facet name="header">
<h:outputText value="Busca de Cliente"/>
</f:facet>
<h:outputText value="Cliente: "/>
<h:inputText size="30" id="cliente" value="#{RelbugsController.keysearch}"/>
</h:panelGrid>
<h:commandButton value="Consultar" action="pesquisado"/>
</h:form>
</f:view>
</body>
</html>
E tenho essa pra fazer a consulta:
package relbugs.dao;
import java.util.List;
import javax.management.Query;
import pontualtecnologia.Cliente;
import relbugs.util.ConnectRelbugsFactory;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.Transaction;
public class RelbugsDAO implements InterfaceRelbugs {
private Session session;
public void salvar(Cliente cliente){
session = ConnectRelbugsFactory.getInstance();
Transaction t = null;
try {
t = session.beginTransaction();
session.save(cliente);
t.commit();
} catch (HibernateException e) {
e.printStackTrace();
t.rollback();
}
finally{
session.close();
}
}
public void excluir(Cliente cliente){
session = ConnectRelbugsFactory.getInstance();
Transaction t = null;
try {
t = session.beginTransaction();
session.delete(cliente);
t.commit();
} catch (HibernateException e) {
e.printStackTrace();
t.rollback();
}
finally{
session.close();
}
}
public void atualizar(Cliente cliente){
session = ConnectRelbugsFactory.getInstance();
Transaction t = null;
try {
t = session.beginTransaction();
session.update(cliente);
t.commit();
} catch (HibernateException e) {
e.printStackTrace();
t.rollback();
}
finally{
session.close();
}
}
public List todosClientes(){
session = ConnectRelbugsFactory.getInstance();
List list = session.createQuery("from Cliente").list();
return list;
}
public List consultarClientes(String cliente){
session = ConnectRelbugsFactory.getInstance();
org.hibernate.Query query = session.createQuery(
"from Cliente cli where cli.cliente like :cliente");
List list = query.setString("cliente", "%"+cliente+"%").list();
return list;
}
}
Então o que estar errado no codigo... ja fiz varias modificações e nada...
