NetBeans Forums

 FAQFAQ   SearchSearch   MemberlistMemberlist   RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
  

java.lang.RuntimeException: Number of conflicts while synchronizing: 1 SyncResolver.UPDATE_ROW_CONFLICT row 0 attempt to update a row that has been updated or deleted by another user

 
Post new topic   Reply to topic    NetBeans Forums -> NetBeans Users
View previous topic :: View next topic  
Author Message
pscamara
Posted via mailing list.





PostPosted: Mon Mar 02, 2009 3:39 pm    Post subject: java.lang.RuntimeException: Number of conflicts while synchronizing: 1 SyncResolver.UPDATE_ROW_CONFLICT row 0 attempt to update a row that has been updated or deleted by another user Reply with quote

Please, I need you help!

I cant continue my project cuz this msg appears all time!

java.lang.RuntimeException: Number of conflicts while synchronizing: 1
SyncResolver.UPDATE_ROW_CONFLICT row 0 attempt to update a row that has been
updated or deleted by another user

Everytime! No solution on net.

I ve tried all solutions but none helps me!

--
View this message in context: http://www.nabble.com/java.lang.RuntimeException%3A-Number-of-conflicts-while-synchronizing%3A-1-SyncResolver.UPDATE_ROW_CONFLICT-row-0-attempt-to-update-a-row-that-has-been-updated-or-deleted-by-another-user-tp22290429p22290429.html
Sent from the Netbeans IDE Users mailing list archive at Nabble.com.
Back to top
Melongo Annabel
Posted via mailing list.





PostPosted: Mon Mar 02, 2009 9:15 pm    Post subject: java.lang.RuntimeException: Number of conflicts while synchronizing: 1 SyncResolver.UPDATE_ROW_CONFLICT row 0 attempt to update a row that has been updated or deleted by another user Reply with quote

What do you try to do? It seems you try to update an non-existing table row.


From: pscamara <address-removed>
To: address-removed
Sent: Monday, March 2, 2009 9:39:07 AM
Subject: [nbusers] java.lang.RuntimeException: Number of conflicts while synchronizing: 1 SyncResolver.UPDATE_ROW_CONFLICT row 0 attempt to update a row that has been updated or deleted by another user


Please, I need you help!

I cant continue my project cuz this msg appears all time!

java.lang.RuntimeException: Number of conflicts while synchronizing: 1
SyncResolver.UPDATE_ROW_CONFLICT row 0 attempt to update a row that has been
updated or deleted by another user

Everytime! No solution on net.

I ve tried all solutions but none helps me!

--
View this message in context: http://www.nabble.com/java.lang.RuntimeException%3A-Number-of-conflicts-while-synchronizing%3A-1-SyncResolver.UPDATE_ROW_CONFLICT-row-0-attempt-to-update-a-row-that-has-been-updated-or-deleted-by-another-user-tp22290429p22290429.html
Sent from the Netbeans IDE Users mailing list archive at Nabble.com.
Back to top
constantin drabo
Posted via mailing list.





PostPosted: Tue Mar 03, 2009 9:34 am    Post subject: java.lang.RuntimeException: Number of conflicts while synchronizing: 1 SyncResolver.UPDATE_ROW_CONFLICT row 0 attempt to update a row that has been updated or deleted by another user Reply with quote

Hi Camara
Could you send us a snippet code of your application (just a fragment of code where you try to update the row).
Thanks

Back to top
pscamara
Posted via mailing list.





PostPosted: Tue Mar 03, 2009 12:53 pm    Post subject: java.lang.RuntimeException: Number of conflicts while synchronizing: 1 SyncResolver.UPDATE_ROW_CONFLICT row 0 attempt to update a row that has been updated or deleted by another user Reply with quote

At my application i am trying to update just one field: descricao_smp. (as
textfield)
Its a simple form whit :

messagegroup,
textfield
button

Thats the code i've tried.

public String save_action() {
RowKey rk = smprDataProvider.getCursorRow();
smprDataProvider.setCursorRow(rk);
smprDataProvider.commitChanges();
smprDataProvider.refresh();
info("Registro Salvo!");
return null;
}

And...

public String save_action() {
smprDataProvider.cursorFisrt();
smprDataProvider.commitChanges();
smprDataProvider.refresh();
info("Registro Salvo!");
return null;
}


I am using oracle 8i as database.
I am trying to update this table.

CREATE TABLE smpr
(
numero_smp VARCHAR2(20),
sequencia_smp NUMBER(4),
registro_emissor NUMBER(5) NOT NULL,
codigo_depa_smp NUMBER(2) NOT NULL,
codigo_unid_smp NUMBER(2) NOT NULL,
codigo_seto_smp NUMBER(2) NOT NULL,
tipo VARCHAR2(1) NOT NULL,
data_inicio_smp DATE NOT NULL,
data_fim_smp DATE,
descricao_smp VARCHAR2(1000) NOT NULL,
justificativa_smp VARCHAR2(1000) NOT NULL,
data_emissao_smp DATE NOT NULL,
valor_smp NUMBER(12,2),
codigo_status_smp NUMBER(2) NOT NULL,
tipo_perigo VARCHAR2(15),
tipo_mudanca VARCHAR2(15),
tipo_risco VARCHAR2(15),
codigo_ativ_smp NUMBER(2) NOT NULL,
cod_empr_smp NUMBER(2) NOT NULL,
cod_fili_smp NUMBER(2) NOT NULL,
nome_emissor VARCHAR2(50) NOT NULL,
fg_emergencia VARCHAR2(1) NOT NULL,
registro_aprovador_emergencia NUMBER(5),
nome_aprovador_emergencia VARCHAR2(50),
sequencia_controle NUMBER(9) NOT NULL,
controle NUMBER(1),
data_aprovacao_unidade DATE,
observacao_unidade VARCHAR2(100),
data_envio_unidade DATE,
fg_aspp VARCHAR2(1)
)


INSERT INTO smpr
(NUMERO_SMP,SEQUENCIA_SMP,REGISTRO_EMISSOR,CODIGO_DEPA_SMP,CODIGO_UNID_SMP,CODIGO_SETO_SMP,TIPO,DATA_INICIO_SMP,
DATA_FIM_SMP,DESCRICAO_SMP,JUSTIFICATIVA_SMP,DATA_EMISSAO_SMP,VALOR_SMP,CODIGO_STATUS_SMP,TIPO_PERIGO,
TIPO_MUDANCA,TIPO_RISCO,CODIGO_ATIV_SMP,COD_EMPR_SMP,COD_FILI_SMP,NOME_EMISSOR,FG_EMERGENCIA,REGISTRO_APROVADOR_EMERGENCIA,
NOME_APROVADOR_EMERGENCIA,SEQUENCIA_CONTROLE,CONTROLE,DATA_APROVACAO_UNIDADE,OBSERVACAO_UNIDADE,DATA_ENVIO_UNIDADE,
FG_ASPP)
VALUES
('DILIC-001/2009
',1,4298,2,5,4,'P','18-FEB-09','','jghjg','gjgf','10-FEB-09',0,4,'3','1','2',
1,1,1,'JOAO DA SILVA','N',NULL,'',305,1,'','','','N')
/



Thats the full message erro:

Manipulador de exceções

Descrição: Ocorreu uma exceção não manipulada durante a execução do
aplicativo da Web. Consulte o seguinte rastreamento da pilha para obter mais
informações relativas ao erro.

Detalhes da exceção: javax.sql.rowset.spi.SyncProviderException
Number of conflicts while synchronizing: 1

Possível origem de erro:
Nome da classe: com.sun.sql.rowset.internal.CachedRowSetXWriter
Nome do arquivo: CachedRowSetXWriter.java
Nome do método: writeData
Número de linha: 530
Origem não disponível. Informações relativas à localização da exceção podem
ser identificadas por meio do rastreamento da pilha de exeções abaixo.


Rastreamento da pilha:
com.sun.sql.rowset.internal.CachedRowSetXWriter.writeData(CachedRowSetXWriter.java:530)
com.sun.sql.rowset.CachedRowSetXImpl5.acceptChanges(CachedRowSetXImpl5.java:955)
com.sun.data.provider.impl.CachedRowSetDataProvider.commitChanges(CachedRowSetDataProvider.java:959)
smpr.Solicitacao.Smpr.save_action(Smpr.java:523)
sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:585)
org.apache.el.parser.AstValue.invoke(AstValue.java:131)
org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
org.apache.jasper.el.JspMethodExpression.invoke(JspMethodExpression.java:6Cool
javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:77)
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:91)
com.sun.rave.web.ui.appbase.faces.ActionListenerImpl.processAction(ActionListenerImpl.java:91)
javax.faces.component.UICommand.broadcast(UICommand.java:383)
com.sun.webui.jsf.component.WebuiCommand.broadcast(WebuiCommand.java:160)
javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:447)
javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:752)
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)
com.sun.faces.extensions.avatar.lifecycle.PartialTraversalLifecycle.execute(PartialTraversalLifecycle.java:94)
javax.faces.webapp.FacesServlet.service(FacesServlet.java:244)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
com.sun.webui.jsf.util.UploadFilter.doFilter(UploadFilter.java:267)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
java.lang.Thread.run(Thread.java:595)


Detalhes da exceção: java.lang.RuntimeException
Number of conflicts while synchronizing: 1
SyncResolver.UPDATE_ROW_CONFLICT row 0 attempt to update a row that has been
updated or deleted by another user

Possível origem de erro:
Nome da classe: com.sun.data.provider.impl.CachedRowSetDataProvider
Nome do arquivo: CachedRowSetDataProvider.java
Nome do método: commitChanges
Número de linha: 1004
Origem não disponível. Informações relativas à localização da exceção podem
ser identificadas por meio do rastreamento da pilha de exeções abaixo.


Rastreamento da pilha:
com.sun.data.provider.impl.CachedRowSetDataProvider.commitChanges(CachedRowSetDataProvider.java:1004)
smpr.Solicitacao.Smpr.save_action(Smpr.java:523)
sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:585)
org.apache.el.parser.AstValue.invoke(AstValue.java:131)
org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
org.apache.jasper.el.JspMethodExpression.invoke(JspMethodExpression.java:6Cool
javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:77)
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:91)
com.sun.rave.web.ui.appbase.faces.ActionListenerImpl.processAction(ActionListenerImpl.java:91)
javax.faces.component.UICommand.broadcast(UICommand.java:383)
com.sun.webui.jsf.component.WebuiCommand.broadcast(WebuiCommand.java:160)
javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:447)
javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:752)
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)
com.sun.faces.extensions.avatar.lifecycle.PartialTraversalLifecycle.execute(PartialTraversalLifecycle.java:94)
javax.faces.webapp.FacesServlet.service(FacesServlet.java:244)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
com.sun.webui.jsf.util.UploadFilter.doFilter(UploadFilter.java:267)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
java.lang.Thread.run(Thread.java:595)


Detalhes da exceção: javax.faces.el.EvaluationException
java.lang.RuntimeException: Number of conflicts while synchronizing: 1
SyncResolver.UPDATE_ROW_CONFLICT row 0 attempt to update a row that has been
updated or deleted by another user

Possível origem de erro:
Nome da classe:
javax.faces.component.MethodBindingMethodExpressionAdapter
Nome do arquivo: MethodBindingMethodExpressionAdapter.java
Nome do método: invoke
Número de linha: 91
Origem não disponível. Informações relativas à localização da exceção podem
ser identificadas por meio do rastreamento da pilha de exeções abaixo.


Rastreamento da pilha:
javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:91)
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:91)
com.sun.rave.web.ui.appbase.faces.ActionListenerImpl.processAction(ActionListenerImpl.java:91)
javax.faces.component.UICommand.broadcast(UICommand.java:383)
com.sun.webui.jsf.component.WebuiCommand.broadcast(WebuiCommand.java:160)
javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:447)
javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:752)
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)
com.sun.faces.extensions.avatar.lifecycle.PartialTraversalLifecycle.execute(PartialTraversalLifecycle.java:94)
javax.faces.webapp.FacesServlet.service(FacesServlet.java:244)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
com.sun.webui.jsf.util.UploadFilter.doFilter(UploadFilter.java:267)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
java.lang.Thread.run(Thread.java:595)


Detalhes da exceção: javax.faces.FacesException
#{Solicitacao$Smpr.save_action}: java.lang.RuntimeException: Number of
conflicts while synchronizing: 1 SyncResolver.UPDATE_ROW_CONFLICT row 0
attempt to update a row that has been updated or deleted by another user

Possível origem de erro:
Nome da classe: com.sun.faces.application.ActionListenerImpl
Nome do arquivo: ActionListenerImpl.java
Nome do método: processAction
Número de linha: 107
Origem não disponível. Informações relativas à localização da exceção podem
ser identificadas por meio do rastreamento da pilha de exeções abaixo.


Rastreamento da pilha:
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:107)
com.sun.rave.web.ui.appbase.faces.ActionListenerImpl.processAction(ActionListenerImpl.java:91)
javax.faces.component.UICommand.broadcast(UICommand.java:383)
com.sun.webui.jsf.component.WebuiCommand.broadcast(WebuiCommand.java:160)
javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:447)
javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:752)
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)
com.sun.faces.extensions.avatar.lifecycle.PartialTraversalLifecycle.execute(PartialTraversalLifecycle.java:94)
javax.faces.webapp.FacesServlet.service(FacesServlet.java:244)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
com.sun.webui.jsf.util.UploadFilter.doFilter(UploadFilter.java:267)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
java.lang.Thread.run(Thread.java:595)


Detalhes da exceção: com.sun.rave.web.ui.appbase.ApplicationException
#{Solicitacao$Smpr.save_action}: java.lang.RuntimeException: Number of
conflicts while synchronizing: 1 SyncResolver.UPDATE_ROW_CONFLICT row 0
attempt to update a row that has been updated or deleted by another user

Possível origem de erro:
Nome da classe: com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl
Nome do arquivo: ViewHandlerImpl.java
Nome do método: cleanup
Número de linha: 603
Origem não disponível. Informações relativas à localização da exceção podem
ser identificadas por meio do rastreamento da pilha de exeções abaixo.


Rastreamento da pilha:
com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl.cleanup(ViewHandlerImpl.java:603)
com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl.renderView(ViewHandlerImpl.java:311)
com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:106)
com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:251)
com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:144)
com.sun.faces.extensions.avatar.lifecycle.PartialTraversalLifecycle.render(PartialTraversalLifecycle.java:106)
javax.faces.webapp.FacesServlet.service(FacesServlet.java:245)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
com.sun.webui.jsf.util.UploadFilter.doFilter(UploadFilter.java:267)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
java.lang.Thread.run(Thread.java:595)
--
View this message in context: http://www.nabble.com/java.lang.RuntimeException%3A-Number-of-conflicts-while-synchronizing%3A-1-SyncResolver.UPDATE_ROW_CONFLICT-row-0-attempt-to-update-a-row-that-has-been-updated-or-deleted-by-another-user-tp22290429p22308117.html
Sent from the Netbeans IDE Users mailing list archive at Nabble.com.
Back to top
Melongo Annabel
Posted via mailing list.





PostPosted: Tue Mar 03, 2009 9:27 pm    Post subject: java.lang.RuntimeException: Number of conflicts while synchronizing: 1 SyncResolver.UPDATE_ROW_CONFLICT row 0 attempt to update a row that has been updated or deleted by another user Reply with quote

I would be lying if I tell you that I understand whatever information you posted. I don't know what language you use and I'm really limited in helping you. However, as I've said, it seems you try to update a row that doesn't exist . Can you search that row in the table using its primary key? or something that uniquely identify it? If the row doesn't exist then you should use an "insert" statement instead of an update and if the row exists, try to find its primary and compare it with the primary key of the row you're trying to update.

From: pscamara <address-removed>
To: address-removed
Sent: Tuesday, March 3, 2009 6:53:08 AM
Subject: Re: [nbusers] java.lang.RuntimeException: Number of conflicts while synchronizing: 1 SyncResolver.UPDATE_ROW_CONFLICT row 0 attempt to update a row that has been updated or deleted by another user


At my application i am trying to update just one field: descricao_smp. (as
textfield)
Its a simple form whit :

messagegroup,
textfield
button

Thats the code i've tried.

public String save_action() {
RowKey rk = smprDataProvider.getCursorRow();
smprDataProvider.setCursorRow(rk);
smprDataProvider.commitChanges();
smprDataProvider.refresh();
info("Registro Salvo!");
return null;
}

And...

public String save_action() {
smprDataProvider.cursorFisrt();
smprDataProvider.commitChanges();
smprDataProvider.refresh();
info("Registro Salvo!");
return null;
}


I am using oracle 8i as database.
I am trying to update this table.

CREATE TABLE smpr
(
numero_smp VARCHAR2(20),
sequencia_smp NUMBER(4),
registro_emissor NUMBER(5) NOT NULL,
codigo_depa_smp NUMBER(2) NOT NULL,
codigo_unid_smp NUMBER(2) NOT NULL,
codigo_seto_smp NUMBER(2) NOT NULL,
tipo VARCHAR2(1) NOT NULL,
data_inicio_smp DATE NOT NULL,
data_fim_smp DATE,
descricao_smp VARCHAR2(1000) NOT NULL,
justificativa_smp VARCHAR2(1000) NOT NULL,
data_emissao_smp DATE NOT NULL,
valor_smp NUMBER(12,2),
codigo_status_smp NUMBER(2) NOT NULL,
tipo_perigo VARCHAR2(15),
tipo_mudanca VARCHAR2(15),
tipo_risco VARCHAR2(15),
codigo_ativ_smp NUMBER(2) NOT NULL,
cod_empr_smp NUMBER(2) NOT NULL,
cod_fili_smp NUMBER(2) NOT NULL,
nome_emissor VARCHAR2(50) NOT NULL,
fg_emergencia VARCHAR2(1) NOT NULL,
registro_aprovador_emergencia NUMBER(5),
nome_aprovador_emergencia VARCHAR2(50),
sequencia_controle NUMBER(9) NOT NULL,
controle NUMBER(1),
data_aprovacao_unidade DATE,
observacao_unidade VARCHAR2(100),
data_envio_unidade DATE,
fg_aspp VARCHAR2(1)
)


INSERT INTO smpr
(NUMERO_SMP,SEQUENCIA_SMP,REGISTRO_EMISSOR,CODIGO_DEPA_SMP,CODIGO_UNID_SMP,CODIGO_SETO_SMP,TIPO,DATA_INICIO_SMP,
DATA_FIM_SMP,DESCRICAO_SMP,JUSTIFICATIVA_SMP,DATA_EMISSAO_SMP,VALOR_SMP,CODIGO_STATUS_SMP,TIPO_PERIGO,
TIPO_MUDANCA,TIPO_RISCO,CODIGO_ATIV_SMP,COD_EMPR_SMP,COD_FILI_SMP,NOME_EMISSOR,FG_EMERGENCIA,REGISTRO_APROVADOR_EMERGENCIA,
NOME_APROVADOR_EMERGENCIA,SEQUENCIA_CONTROLE,CONTROLE,DATA_APROVACAO_UNIDADE,OBSERVACAO_UNIDADE,DATA_ENVIO_UNIDADE,
FG_ASPP)
VALUES
('DILIC-001/2009
',1,4298,2,5,4,'P','18-FEB-09','','jghjg','gjgf','10-FEB-09',0,4,'3','1','2',
1,1,1,'JOAO DA SILVA','N',NULL,'',305,1,'','','','N')
/



Thats the full message erro:

Manipulador de exce
Back to top
pscamara
Posted via mailing list.





PostPosted: Thu Mar 05, 2009 4:48 pm    Post subject: java.lang.RuntimeException: Number of conflicts while synchronizing: 1 SyncResolver.UPDATE_ROW_CONFLICT row 0 attempt to update a row that has been updated or deleted by another user Reply with quote

Any help?

--
View this message in context: http://www.nabble.com/java.lang.RuntimeException%3A-Number-of-conflicts-while-synchronizing%3A-1-SyncResolver.UPDATE_ROW_CONFLICT-row-0-attempt-to-update-a-row-that-has-been-updated-or-deleted-by-another-user-tp22290429p22355572.html
Sent from the Netbeans IDE Users mailing list archive at Nabble.com.
Back to top
pscamara
Posted via mailing list.





PostPosted: Thu Mar 05, 2009 5:42 pm    Post subject: java.lang.RuntimeException: Number of conflicts while synchronizing: 1 SyncResolver.UPDATE_ROW_CONFLICT row 0 attempt to update a row that has been updated or deleted by another user Reply with quote

Hi,

The first thing i do its:

public void prerender() {

Object id = getSessionBean1().getCurrentId(); /* Primary key
value */
getSessionBean1().getSip_buddiesRowSet().setObject(1, id);
getSessionBean1().getSip_buddiesRowSet().execute();
getSessionBean1().getSip_buddiesRowSet().first();

}


Then, the results are ok!
So, if i change someting and press the button save: this message appears:

java.lang.RuntimeException: Number of conflicts while synchronizing: 1
SyncResolver.UPDATE_ROW_CONFLICT row 0 attempt to update a row that has been
updated or deleted by another user

public String save_action() {

try {
sip_buddiesDataProvider.cursorFirst();
sip_buddiesDataProvider.commitChanges();

info("Save. \n");

} catch (Exception e) {
error(e.toString());
}

return null;
}


I cant save my data!
--
View this message in context: http://www.nabble.com/java.lang.RuntimeException%3A-Number-of-conflicts-while-synchronizing%3A-1-SyncResolver.UPDATE_ROW_CONFLICT-row-0-attempt-to-update-a-row-that-has-been-updated-or-deleted-by-another-user-tp22290429p22356672.html
Sent from the Netbeans IDE Users mailing list archive at Nabble.com.
Back to top
Display posts from previous:   
Post new topic   Reply to topic    NetBeans Forums -> NetBeans Users All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB
By use of this website, you agree to the NetBeans Policies and Terms of Use. © 2012, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo