Discussoes de Programacao e Tecnologia

Erro em consulta

11 respostas
M
mrsmylle

Bom dia!!Estou penando em uma consulta até então simples, mas agora não consegui achar o erro!!Este é o erro que me retorna:

org.hibernate.PropertyAccessException: Exception occurred inside setter of svl.pojos.Cliente.cidade
	at org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:65)
	at org.hibernate.tuple.entity.AbstractEntityTuplizer.setPropertyValues(AbstractEntityTuplizer.java:337)
	at org.hibernate.tuple.entity.PojoEntityTuplizer.setPropertyValues(PojoEntityTuplizer.java:200)
	at org.hibernate.persister.entity.AbstractEntityPersister.setPropertyValues(AbstractEntityPersister.java:3499)
	at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:129)
	at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:842)
	at org.hibernate.loader.Loader.doQuery(Loader.java:717)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
	at org.hibernate.loader.Loader.doList(Loader.java:2144)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028)
	at org.hibernate.loader.Loader.list(Loader.java:2023)
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393)
	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
	at svl.daos.ClienteDao.lista(ClienteDao.java:58)
	at svl.visao.cons.ConsultaCliente.consulta(ConsultaCliente.java:157)
	at svl.visao.cons.ConsultaCliente.keyPressed(ConsultaCliente.java:126)
	at java.awt.Component.processKeyEvent(Unknown Source)
	at javax.swing.JComponent.processKeyEvent(Unknown Source)
	at java.awt.Component.processEvent(Unknown Source)
	at java.awt.Container.processEvent(Unknown Source)
	at java.awt.Component.dispatchEventImpl(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.KeyboardFocusManager.redispatchEvent(Unknown Source)
	at java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(Unknown Source)
	at java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(Unknown Source)
	at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(Unknown Source)
	at java.awt.DefaultKeyboardFocusManager.dispatchEvent(Unknown Source)
	at java.awt.Component.dispatchEventImpl(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Window.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.awt.Dialog$1.run(Unknown Source)
	at java.awt.Dialog$3.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.awt.Dialog.show(Unknown Source)
	at java.awt.Component.show(Unknown Source)
	at java.awt.Component.setVisible(Unknown Source)
	at java.awt.Window.setVisible(Unknown Source)
	at java.awt.Dialog.setVisible(Unknown Source)
	at svl.visao.cons.ConsultaCliente.<init>(ConsultaCliente.java:119)
	at svl.visao.FormCliente.consulta(FormCliente.java:332)
	at svl.visao.FormCliente.actionPerformed(FormCliente.java:293)
	at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
	at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
	at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
	at java.awt.Component.processMouseEvent(Unknown Source)
	at javax.swing.JComponent.processMouseEvent(Unknown Source)
	at java.awt.Component.processEvent(Unknown Source)
	at java.awt.Container.processEvent(Unknown Source)
	at java.awt.Component.dispatchEventImpl(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Window.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.lang.reflect.InvocationTargetException
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:42)
	... 75 more
Caused by: java.lang.NullPointerException
	at svl.pojos.Cliente.setCidade(Cliente.java:95)
	... 80 more
Exception occurred during event dispatching:
java.lang.NullPointerException
	at svl.visao.cons.ConsultaCliente.consulta(ConsultaCliente.java:157)
	at svl.visao.cons.ConsultaCliente.keyPressed(ConsultaCliente.java:126)
	at java.awt.Component.processKeyEvent(Unknown Source)
	at javax.swing.JComponent.processKeyEvent(Unknown Source)
	at java.awt.Component.processEvent(Unknown Source)
	at java.awt.Container.processEvent(Unknown Source)
	at java.awt.Component.dispatchEventImpl(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.KeyboardFocusManager.redispatchEvent(Unknown Source)
	at java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(Unknown Source)
	at java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(Unknown Source)
	at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(Unknown Source)
	at java.awt.DefaultKeyboardFocusManager.dispatchEvent(Unknown Source)
	at java.awt.Component.dispatchEventImpl(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Window.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.awt.Dialog$1.run(Unknown Source)
	at java.awt.Dialog$3.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.awt.Dialog.show(Unknown Source)
	at java.awt.Component.show(Unknown Source)
	at java.awt.Component.setVisible(Unknown Source)
	at java.awt.Window.setVisible(Unknown Source)
	at java.awt.Dialog.setVisible(Unknown Source)
	at svl.visao.cons.ConsultaCliente.<init>(ConsultaCliente.java:119)
	at svl.visao.FormCliente.consulta(FormCliente.java:332)
	at svl.visao.FormCliente.actionPerformed(FormCliente.java:293)
	at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
	at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
	at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
	at java.awt.Component.processMouseEvent(Unknown Source)
	at javax.swing.JComponent.processMouseEvent(Unknown Source)
	at java.awt.Component.processEvent(Unknown Source)
	at java.awt.Container.processEvent(Unknown Source)
	at java.awt.Component.dispatchEventImpl(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Window.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.run(Unknown Source)

Aonde será que está o tal erro!?Obrigado!!

Alura Desenvolvimento Back-End Java Sua Carreira em desenvolvimento back-end Java: dos fundamentos à arquitetura de sistemas...

11 Respostas

regisbten
regisbten 
Caused by: java.lang.NullPointerException
 	at svl.pojos.Cliente.setCidade(Cliente.java:95)

Bom pelo que parece essa consulta está retornando null e o class não está conseguindo fazer o Cliente.setCidade. Faça um Debug e verifique se realmente existe o parametro. Abraço.

M
mrsmylle

Olá, tem sim, é porque minha classe cliente faz relacionamento com a cidade,
1cliente -> 1Cidade e 1Cidade -> N Cliente!!Relacao um para muitos!!Mas soh estou fazendo uma consulta de cliente?!Preciso carregar a cidade?Como fazer isso!?

marcosbrandao
marcosbrandao

provavelmente vc esta tentando acessar um objeto nulo.
Coloca o trecho do codigo que ta gerando esse erro pra gente poder ajudar melhor…

marcosbrandao
marcosbrandao

Se vc esta fazendo uma consulta somente de clientes, não precisa carregar a cidade junto.
Não sei o que vc está usando, mas se for uma consulta SQL eh + ou - assim:

sql = "select * from cliente where cliente = ?";
PreparedStatement ps = suaConecxao.preparedStatemen(sql);
ps.setString(1, cliente);
M
mrsmylle

Então, estou usando hibernate para fazer a consulta!!
ClienteDao

public List lista() {
	try{
		lista= HibUtil.getSession().createQuery("from Cliente order by nome").list();	
		HibUtil.getSession().beginTransaction().commit();
	}catch( HibernateException ex){ex.printStackTrace();}
		return lista;
	}
Veneno
Veneno

vc quer trazer todos os clientes ou um especifico?

M
mrsmylle

Queria buscasse todos, ou se não que buscasse informando só as iniciais!!

Veneno
Veneno

Tenta fazer algo assim:

public static List recupera() {
        Session session = HibernateUtil.currentSession();
        Query q;
        List lista;
        try{
            q = session.createQuery("from VOGerencia");
            lista = q.list();
        }finally {
            HibernateUtil.closeSession();
        }
        return lista;
    }

pra consulta nao tem beginTransaction e nem commit …

flw

M
mrsmylle
Saquei o beginTransaction, fiz o mapemanto assim: Classe Cidade 
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
	"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
	"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="svl.pojos">
  <class name="Cidade">
  	<id name="id" column="id" type="long" >
  		<generator class="increment">
  		   <param name="clientes"/>
  		</generator>
  		
  	</id>
  	<property name="nome" column="nome"/>
  	<property name="uf" column="uf"/>
  	<set name="clientes" cascade="all">
  		<key column="id"/>
  	  	<one-to-many class="svl.pojos.Cliente" />
  	</set>
  </class>
</hibernate-mapping>
Classe cliente 
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
	"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
	"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="svl.pojos">
  <class name="Cliente">
  	<id name="id" column="id" type="long">
  		<generator class="increment"/>
  	</id>
  	<one-to-one name="cidade" class="svl.pojos.Cidade" cascade="all"/>
  	<property name="nome"/> 
  	<property name="endereco"/>
  	<property name="rg"/>
  	<property name="cpf"/>
  	<property name="celular"/>
  	<property name="telefone"/>
  	<property name="email"/>
  	<property name="bairro"/>
  	<property name="cep"/>
  	<property name="cid"/>
  </class>
</hibernate-mapping>
Veneno
Veneno

mas ta dando erro ainda ???
qual é o erro?

M
mrsmylle

Kra, funcionou agora, esta bexiga!!!Valeu ai!!

Criado 25 de junho de 2007
Ultima resposta 25 de jun. de 2007
Respostas 11
Participantes 4

Topicos relacionados

Como saber se um mes tem 4 ou 5 semanas?[RESOLVIDO] 31 respostas Como converter inteiro para string! 13 respostas Comando SELECT para selecionar intervalo de data SQL SERVER 12 respostas &, &&, |, ||. Qndo usar? 6 respostas O método split 12 respostas
Alura Sistemas operacionais: entenda seu conceito e suas funções Descubra o que são sistemas operacionais, suas funções e tipos. Aprenda tudo de forma clara e objetiva. Não perca tempo!
Casa do Codigo Orientacao a Objetos: Aprenda seus conceitos e suas... Por Thiago Leite e Carvalho — Casa do Codigo