Estou usando DateChooserCombo na data porem quando aperto no botao de gravar aparece o erro abaixo:
[code]botao1.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e1) {
// Persistir dados
// inclusão de um novo registro
if (caixa1.getText().trim().equals("")) {
JOptionPane.showMessageDialog(null,
“Informe o código do cliente!”);
caixa1.requestFocus();
}//else if (d.getText().trim().equals("")) {
// JOptionPane.showMessageDialog(null, “Informe a Data!”);
// d.requestFocus();
// }
else if (caixa3.getText().trim().equals("")) {
JOptionPane.showMessageDialog(null,
“Informe o Nome Completo do Cliente!”);
caixa3.requestFocus();
} else if (caixa5.getText().trim().equals("")) {
JOptionPane.showMessageDialog(null,
"Informe o Endereço do Cliente!");
caixa5.requestFocus();
} else if (caixa6.getText().trim().equals("")) {
JOptionPane.showMessageDialog(null,
"Informe o Cpf do Cliente!");
caixa6.requestFocus();
} else if (caixa7.getText().trim().equals("")) {
JOptionPane.showMessageDialog(null,
"Informe o Bairro do Cliente!");
caixa7.requestFocus();
} else if (caixa8.getText().trim().equals("")) {
JOptionPane.showMessageDialog(null,
"Informe a Cidade do Cliente!");
caixa8.requestFocus();
} else if (caixa9.getText().trim().equals("")) {
JOptionPane.showMessageDialog(null,
"Informe a Uf do Cliente!");
caixa9.requestFocus();
} else if (caixa10.getText().trim().equals("")) {
JOptionPane.showMessageDialog(null,
"Informe o Cep do Cliente!");
caixa10.requestFocus();
} else if (caixa11.getText().trim().equals("")) {
JOptionPane.showMessageDialog(null,
"Informe o Telefone do Cliente!");
caixa11.requestFocus();
} else if (caixa12.getText().trim().equals("")) {
JOptionPane.showMessageDialog(null,
"Informe o Complemento!");
caixa12.requestFocus();
} else if (caixa13.getText().trim().equals("")) {
JOptionPane.showMessageDialog(null,
"Informe o Email do Cliente!");
caixa13.requestFocus();
} else if (caixa14.getText().trim().equals("")) {
JOptionPane.showMessageDialog(null,
"Informe o Rg do Cliente!");
caixa14.requestFocus();
}// else if (b.getText().trim().equals("")) {
//JOptionPane.showMessageDialog(null,
// "Informe a Data de Nascimento do Cliente!");
// b.requestFocus();
// }
else {
//SimpleDateFormat dataf = new SimpleDateFormat("yyyy-MM-dd");
//SimpleDateFormat formatador = new SimpleDateFormat("yyyy-MM-dd");
// SimpleDateFormat formatador2 = new SimpleDateFormat("yyyy-MM-dd");
// Transforma uma String em um Date
//Date data1 = formatador.parse(caixa2.getText());
// @SuppressWarnings("unused")
//java.sql.Date dataSql = null;
// @SuppressWarnings("unused")
//java.sql.Date dataSql2 = null;
// try {
// Date data1 = formatador.parse(d.getText());
// Date data2 = formatador2.parse(b.getText());
// data1 = new java.sql.Date(data1.getTime());
// data2 = new java.sql.Date(data2.getTime());
// dataSql = (java.sql.Date) data1;
// dataSql2 = (java.sql.Date) data2;
// } catch (ParseException e2) {
// TODO Auto-generated catch block
// e2.printStackTrace();
// JOptionPane.showMessageDialog(null, "Erro ao converte data para sql: " + ((Throwable) e2).getMessage());
// }return;
// }
Cliente objetoCliente = new Cliente();
objetoCliente.setCodcliente(Integer.parseInt(caixa1.getText()));
objetoCliente.setData(d);
objetoCliente.setNomeCompleto(caixa3.getText());
objetoCliente.setEndereco(caixa5.getText());
objetoCliente.setCpf(Double.parseDouble(caixa6.getText()));
objetoCliente.setBairro(caixa7.getText());
objetoCliente.setCidade(caixa8.getText());
objetoCliente.setUf(caixa9.getText());
objetoCliente.setCep(Integer.parseInt(caixa10.getText()));
objetoCliente.setTelefone(Integer.parseInt(caixa11.getText()));
objetoCliente.setComplemento(caixa12.getText());
objetoCliente.setEmail(caixa13.getText());
objetoCliente.setRg(Double.parseDouble(caixa14.getText()));
objetoCliente.setDatadenascimento(b);
gerenciador.getTransaction().begin();
gerenciador.persist(objetoCliente);
gerenciador.getTransaction().commit();
JOptionPane.showMessageDialog(null,
"Cliente Incluído com Sucesso!");
caixa1.setText(null);d.setText(null);
caixa3.setText(null);caixa5.setText(null);
caixa6.setText(null); caixa7.setText(null);caixa8.setText(null);caixa9.setText(null);caixa10.setText(null);
caixa11.setText(null);caixa12.setText(null);caixa13.setText(null);caixa14.setText(null);b.setText(null);
}
}
}); [/code]
erro:
Hibernate: select cliente0_.codcliente as codcliente0_0_, cliente0_.Bairro as Bairro0_0_, cliente0_.Cidade as Cidade0_0_, cliente0_.NomeCompleto as NomeComp4_0_0_, cliente0_.cep as cep0_0_, cliente0_.complemento as compleme6_0_0_, cliente0_.cpf as cpf0_0_, cliente0_.data as data0_0_, cliente0_.datadenascimento as datadena9_0_0_, cliente0_.email as email0_0_, cliente0_.endereco as endereco0_0_, cliente0_.rg as rg0_0_, cliente0_.telefone as telefone0_0_, cliente0_.uf as uf0_0_ from Cliente cliente0_ where cliente0_.codcliente=?
Hibernate: insert into Cliente (Bairro, Cidade, NomeCompleto, cep, complemento, cpf, data, datadenascimento, email, endereco, rg, telefone, uf, codcliente) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
- SQL Error: 0, SQLState: 42804
- Entrada em lote 0 insert into Cliente (Bairro, Cidade, NomeCompleto, cep, complemento, cpf, data, datadenascimento, email, endereco, rg, telefone, uf, codcliente) values (ghfg, ghfh, cv, 675, jhj, 656.0, <stream of 84933 bytes>, <stream of 84933 bytes>, hjgh, vx, 6756.0, 6756, hfh, 2) foi abortada. Chame getNextException para ver a causa.
- SQL Error: 0, SQLState: 42804
- ERRO: coluna “data” é do tipo date mas expressão é do tipo bytea
- Could not synchronize database state with session
org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)
at JanelaCliente$4.actionPerformed(JanelaCliente.java:405)
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.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.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$000(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(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.sql.BatchUpdateException: Entrada em lote 0 insert into Cliente (Bairro, Cidade, NomeCompleto, cep, complemento, cpf, data, datadenascimento, email, endereco, rg, telefone, uf, codcliente) values (ghfg, ghfh, cv, 675, jhj, 656.0, <stream of 84933 bytes>, <stream of 84933 bytes>, hjgh, vx, 6756.0, 6756, hfh, 2) foi abortada. Chame getNextException para ver a causa.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2510)
at org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutorImpl.java:393)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1341)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:341)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2573)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
… 45 more
Exception in thread “AWT-EventQueue-0” javax.persistence.RollbackException: Error while commiting the transaction
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:71)
at JanelaCliente$4.actionPerformed(JanelaCliente.java:405)
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.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.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$000(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(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: org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)
… 37 more
Caused by: java.sql.BatchUpdateException: Entrada em lote 0 insert into Cliente (Bairro, Cidade, NomeCompleto, cep, complemento, cpf, data, datadenascimento, email, endereco, rg, telefone, uf, codcliente) values (ghfg, ghfh, cv, 675, jhj, 656.0, <stream of 84933 bytes>, <stream of 84933 bytes>, hjgh, vx, 6756.0, 6756, hfh, 2) foi abortada. Chame getNextException para ver a causa.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2510)
at org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutorImpl.java:393)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1341)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:341)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2573)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
… 45 more