Erro Entrada em lote 0
28/11/2011
0
java.sql.BatchUpdateException: Entrada em lote 0 insert into sanidade_r6 (idcontrolequalidade, sa6_doenca, sa6_dosagem, sa6_produto, sa6_recomendacoes, sa6_regulagem_equipamento, sa6_saca_60, sa6_tipo_aplicacao, sa6_total_saca, idsanidade_r6) values (4, 1, 1, 1, 1, 1, 1, 1, 1, 2) foi abortada. Chame getNextException para ver a causa.
org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2598)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737)
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
DAO.GenericoDAO.saveOrUpdatePojo(GenericoDAO.java:35)
DAO.Sanidade_r6DAO.addSanidade_r6(Sanidade_r6DAO.java:17)
Faces.Sanidade_r6Face.finishAddNewSanidade_r6(Sanidade_r6Face.java:52)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:601)
org.apache.el.parser.AstValue.invoke(AstValue.java:262)
org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:278)
org.apache.jasper.el.JspMethodExpression.invoke(JspMethodExpression.java:70)
javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:77)
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:91)
javax.faces.component.UICommand.broadcast(UICommand.java:383)
org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:329)
org.ajax4jsf.component.AjaxViewRoot.broadcastEventsForPhase(AjaxViewRoot.java:304)
org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:261)
org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:474)
com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:97)
com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:251)
com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)
javax.faces.webapp.FacesServlet.service(FacesServlet.java:244)
org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:206)
org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:290)
org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:388)
org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:515)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:393)
att tavinho
org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2598)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737)
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
DAO.GenericoDAO.saveOrUpdatePojo(GenericoDAO.java:35)
DAO.Sanidade_r6DAO.addSanidade_r6(Sanidade_r6DAO.java:17)
Faces.Sanidade_r6Face.finishAddNewSanidade_r6(Sanidade_r6Face.java:52)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:601)
org.apache.el.parser.AstValue.invoke(AstValue.java:262)
org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:278)
org.apache.jasper.el.JspMethodExpression.invoke(JspMethodExpression.java:70)
javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:77)
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:91)
javax.faces.component.UICommand.broadcast(UICommand.java:383)
org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:329)
org.ajax4jsf.component.AjaxViewRoot.broadcastEventsForPhase(AjaxViewRoot.java:304)
org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:261)
org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:474)
com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:97)
com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:251)
com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)
javax.faces.webapp.FacesServlet.service(FacesServlet.java:244)
org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:206)
org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:290)
org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:388)
org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:515)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:393)
att tavinho
Luiz Silva
Curtir tópico
+ 0
Responder
Posts
28/11/2011
Davi Costa
Geralmente esse erro acontecepor erro de chave estrangeiro ou de primary key. Dá uma olhada nisso.
Att Davi
Att Davi
Responder
30/11/2011
Luiz Silva
Parece k estão corretas
public class Floracao implements Serializable{
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(generator=seq_id)
@Column(name=idfloracao)
private Integer idfloracao;
@ManyToOne(optional=false)
@JoinColumn(name=idcontrolequalidade)
private ControleQualidade controleQualidade;
----------------------------------------------------
public class ControleQualidade implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(generator = seq_id)
@Column(name = idcontrolequalidade)
private Integer idcontrolequalidade;
@OneToMany(mappedBy = controleQualidade, fetch = FetchType.LAZY)
private List<Floracao> floracao;
----------------------------------------------------
att Tavinho
public class Floracao implements Serializable{
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(generator=seq_id)
@Column(name=idfloracao)
private Integer idfloracao;
@ManyToOne(optional=false)
@JoinColumn(name=idcontrolequalidade)
private ControleQualidade controleQualidade;
----------------------------------------------------
public class ControleQualidade implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(generator = seq_id)
@Column(name = idcontrolequalidade)
private Integer idcontrolequalidade;
@OneToMany(mappedBy = controleQualidade, fetch = FetchType.LAZY)
private List<Floracao> floracao;
----------------------------------------------------
att Tavinho
Responder
06/12/2011
Luiz Silva
Resolvido, era erro de tipos, no net beans estava como int e no banco estava como character
Att.
Tavinho
Att.
Tavinho
Responder
Clique aqui para fazer login e interagir na Comunidade :)
