Good evening everyone, I am bundled here in a logic, I made the DAO for all the CRUD of my project only in that it will not only have the search by the ID and also I am trying to do some method that searches the request by the ID and also by the date registered. But at the time of doing the research it is giving this return:
Exception in thread "AWT-EventQueue-0" java.lang.IllegalArgumentException: Provided id of the wrong type for class com.exemplo.model.Pedido. Expected: class java.lang.Long, got class java.sql.Date
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:1135)
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:1068)
at com.exemplo.repositorio.MySQLPedidoDAO.pesquisarPorData(MySQLPedidoDAO.java:82)
at com.exemplo.view.ViewPedidos.btBuscarActionPerformed(ViewPedidos.java:322)
at com.exemplo.view.ViewPedidos.access$000(ViewPedidos.java:23)
at com.exemplo.view.ViewPedidos$1.actionPerformed(ViewPedidos.java:106)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
at java.awt.Component.processMouseEvent(Component.java:6533)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
at java.awt.Component.processEvent(Component.java:6298)
at java.awt.Container.processEvent(Container.java:2236)
at java.awt.Component.dispatchEventImpl(Component.java:4889)
at java.awt.Container.dispatchEventImpl(Container.java:2294)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4525)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)
at java.awt.Container.dispatchEventImpl(Container.java:2280)
at java.awt.Window.dispatchEventImpl(Window.java:2746)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)
at java.awt.EventQueue$4.run(EventQueue.java:731)
at java.awt.EventQueue$4.run(EventQueue.java:729)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
Caused by: org.hibernate.TypeMismatchException: Provided id of the wrong type for class com.exemplo.model.Pedido. Expected: class java.lang.Long, got class java.sql.Date
at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:133)
at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1066)
at org.hibernate.internal.SessionImpl.access$2000(SessionImpl.java:176)
at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.load(SessionImpl.java:2540)
at org.hibernate.internal.SessionImpl.get(SessionImpl.java:951)
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:1110)
... 41 moreMy methods look like this: DAO class:
public interface DAO <T, K> {
public void inserir(T o);
public void alterar(T o);
public void excluir(T o);
public T pesquisar(K id);
public List<T> listar();
}OrderOd:
public interface PedidoDAO extends DAO <Pedido, Long> {
public Pedido pesquisarPorData(Date dataCadastro);
}MySQLPayment:
public class MySQLPedidoDAO implements PedidoDAO {
public ConnectionFactory cf = null;
public MySQLPedidoDAO(ConnectionFactory cf) {
this.cf = cf;
}
@Override
public Pedido pesquisar(Long id) {
cf.createEm().getTransaction().begin();
Pedido pedido = cf.createEm().find(Pedido.class, id);
cf.createEm().getTransaction().commit();
//erro ao deletar pois o factory já está fechado
//emf.close();
return pedido;
}
@Override
public Pedido pesquisarPorData(Date dataCadastro) {
cf.createEm().getTransaction().begin();
// ERRO ABAIXO!!!!!
// ERRO ABAIXO!!!!!
Pedido pedido = cf.createEm().find(Pedido.class, dataCadastro);
cf.createEm().getTransaction().commit();
//erro ao deletar pois o factory já está fechado
//emf.close();
return pedido;
}
}ViewPasses:
public class ViewPedidos extends javax.swing.JInternalFrame {
private MySQLPedidoDAO mspdao;
private Pedido ped;
private boolean editavel;
/* Getters e Setters de editavel e ped */
private void btPesquisaActionPerformed(java.awt.event.ActionEvent evt) {
habilitarApenasOSeData();
limparCampos();
tfPedido.setEditable(true);
tfPedido.requestFocus();
btBuscar.setEnabled(true);
}
private void btBuscarActionPerformed(java.awt.event.ActionEvent evt) {
ConnectionFactory cf = new ConnectionFactory();
MySQLPedidoDAO mspdao = new MySQLPedidoDAO(cf);
Pedido ped = new Pedido();
if(tfPedido.getText().length() == 0 && tfDataCad.getText().length() == 0){
JOptionPane.showMessageDialog(rootPane, "Não é possível pesquisar, Favor preencher os campos", "", JOptionPane.INFORMATION_MESSAGE);
} else {
ped = mspdao.pesquisar(Long.parseLong(tfPedido.getText()));
ped = mspdao.pesquisarPorData(new java.sql.Date(((java.util.Date)tfDataCad.getValue()).getTime()));
setPed(ped);
setEditable(true);
carregarCampos();
habilitarTextFieldEBotoes();
}
}
} I tested the codes that involve the date field and ran without problems by searching for the id, hence in this part I invented trying to do a "gambiarra" to get the search for the id and date and came that error above in the stack trace. Would you like to know where I should change? Thanks!