-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Projects » Search, Validator, Shards

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 10 posts ] 
  Previous topic | Next topic 
Author Message
bcorbett8769
 Post subject: EJB3 Hibernate problem - org.hibernate.StaleStateException
PostPosted: Thu Feb 08, 2007 5:38 pm 
Newbie

Joined: Mon Feb 05, 2007 1:12 pm
Posts: 7
I am experiencing problems when trying to do an update.
I am using EJB3 with JBoss 4.0.5. By looking at the following log would anyone know what is going on.

Code:
2007-02-08 15:26:01,341 DEBUG [org.hibernate.impl.SessionImpl] opened session at timestamp: 4796292961652736
2007-02-08 15:26:01,341 DEBUG [org.hibernate.ejb.AbstractEntityManagerImpl] Looking for a JTA transaction to join
2007-02-08 15:26:01,341 DEBUG [org.hibernate.jdbc.JDBCContext] successfully registered Synchronization
2007-02-08 15:26:01,341 DEBUG [org.hibernate.ejb.AbstractEntityManagerImpl] Looking for a JTA transaction to join
2007-02-08 15:26:01,341 DEBUG [org.hibernate.ejb.AbstractEntityManagerImpl] Transaction already joined
2007-02-08 15:26:01,341 DEBUG [org.hibernate.loader.Loader] loading entity: [usermanager.menu400.entities.M4puser#CHCOPY]
2007-02-08 15:26:01,341 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 1)
2007-02-08 15:26:01,341 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC connection
2007-02-08 15:26:01,341 DEBUG [org.hibernate.SQL] select m4puser0_.user as user2_0_, m4puser0_.umnsty as umnsty2_0_, m4puser0_.brkmq as brkmq2_0_, m4puser0_.atnpgm as atnpgm2_0_, m4puser0_.mnulvl as mnulvl2_0_, m4puser0_.grpmnu as grpmnu2_0_, m4puser0_.setpgm as setpgm2_0_, m4puser0_.usrf3 as usrf8_2_0_, m4puser0_.sysreq as sysreq2_0_, m4puser0_.atnlib as atnlib2_0_, m4puser0_.rstcpb as rstcpb2_0_, m4puser0_.rsttrm as rsttrm2_0_, m4puser0_.menu as menu2_0_, m4puser0_.userpw as userpw2_0_, m4puser0_.usrsts as usrsts2_0_, m4puser0_.uname as uname2_0_, m4puser0_.setlib as setlib2_0_, m4puser0_.usrnpw as usrnpw2_0_, m4puser0_.acctcd as acctcd2_0_, m4puser0_.brktrm as brktrm2_0_, m4puser0_.usrssn as usrssn2_0_, m4puser0_.hlplvl as hlplvl2_0_, m4puser0_.usrnpd as usrnpd2_0_, m4puser0_.brkmql as brkmql2_0_, m4puser0_.userpd as userpd2_0_ from menu400tdi.M4PUSER m4puser0_ where m4puser0_.user=?
2007-02-08 15:26:01,419 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0)
2007-02-08 15:26:01,419 DEBUG [org.hibernate.loader.Loader] result row: EntityKey[usermanager.menu400.entities.M4puser#CHCOPY]
2007-02-08 15:26:01,419 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close ResultSet (open ResultSets: 1, globally: 1)
2007-02-08 15:26:01,419 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 2)
2007-02-08 15:26:01,419 DEBUG [org.hibernate.jdbc.ConnectionManager] aggressively releasing JDBC connection
2007-02-08 15:26:01,419 DEBUG [org.hibernate.jdbc.ConnectionManager] releasing JDBC connection [ (open PreparedStatements: 0, globally: 1) (open ResultSets: 0, globally: 0)]
2007-02-08 15:26:01,419 DEBUG [org.hibernate.engine.TwoPhaseLoad] resolving associations for [usermanager.menu400.entities.M4puser#CHCOPY]
2007-02-08 15:26:01,419 DEBUG [org.hibernate.engine.TwoPhaseLoad] done materializing entity [usermanager.menu400.entities.M4puser#CHCOPY]
2007-02-08 15:26:01,419 DEBUG [org.hibernate.engine.StatefulPersistenceContext] initializing non-lazy collections
2007-02-08 15:26:01,419 DEBUG [org.hibernate.loader.Loader] done entity load
2007-02-08 15:26:01,419 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] processing flush-time cascades
2007-02-08 15:26:01,419 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] dirty checking collections
2007-02-08 15:26:01,419 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 insertions, 1 updates, 0 deletions to 1 objects
2007-02-08 15:26:01,419 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
2007-02-08 15:26:01,419 DEBUG [org.hibernate.pretty.Printer] listing entities:
2007-02-08 15:26:01,419 DEBUG [org.hibernate.pretty.Printer] usermanager.menu400.entities.M4puser{usrssn=0, usrsts=A, sysreq=N, setlib=, mnulvl=, acctcd=, brkmql=, usrnpw=, setpgm=, menu=*NONE, usrnpd=0, userpw=CHCOPY, userpd=0, atnpgm=, user=CHCOPY, rsttrm=N, rstcpb=Y, uname=Copy Shooter Profile - CH - Test, brktrm=N, grpmnu=N, atnlib=, usrf3=N, umnsty=F, brkmq=, hlplvl=}
2007-02-08 15:26:01,419 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 1)
2007-02-08 15:26:01,419 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC connection
2007-02-08 15:26:01,419 DEBUG [org.hibernate.SQL] update menu400tdi.M4PUSER set umnsty=?, brkmq=?, atnpgm=?, mnulvl=?, grpmnu=?, setpgm=?, usrf3=?, sysreq=?, atnlib=?, rstcpb=?, rsttrm=?, menu=?, userpw=?, usrsts=?, uname=?, setlib=?, usrnpw=?, acctcd=?, brktrm=?, usrssn=?, hlplvl=?, usrnpd=?, brkmql=?, userpd=? where user=?
2007-02-08 15:26:01,497 ERROR [org.hibernate.event.def.AbstractFlushingEventListener] Could not synchronize database state with session
org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
   at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:61)
   at org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:46)
   at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:24)
   at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2338)
   at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2242)
   at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2542)
   at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:92)
   at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
   at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
   at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
   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.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:515)
   at org.jboss.tm.TransactionImpl.doBeforeCompletion(TransactionImpl.java:1491)
   at org.jboss.tm.TransactionImpl.beforePrepare(TransactionImpl.java:1110)
   at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:324)
   at org.jboss.tm.TxManager.commit(TxManager.java:240)
   at org.jboss.aspects.tx.TxPolicy.endTransaction(TxPolicy.java:175)
   at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:87)
   at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:191)
   at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
   at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
   at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
   at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)
   at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
   at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77)
   at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:102)
   at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
   at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:47)
   at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
   at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
   at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
   at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:263)
   at org.jboss.ejb3.remoting.IsLocalInterceptor.invoke(IsLocalInterceptor.java:58)
   at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
   at org.jboss.ejb3.stateless.StatelessRemoteProxy.invoke(StatelessRemoteProxy.java:102)
   at $Proxy83.updateUser(Unknown Source)
   at usermanager.web.UserControllerBean.updateUserAction(UserControllerBean.java:60)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:585)
   at com.sun.el.parser.AstValue.invoke(AstValue.java:130)
   at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:274)
   at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
   at com.sun.facelets.el.LegacyMethodBinding.invoke(LegacyMethodBinding.java:69)
   at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:63)
   at javax.faces.component.UICommand.broadcast(UICommand.java:106)
   at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:94)
   at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:168)
   at org.apache.myfaces.lifecycle.LifecycleImpl.invokeApplication(LifecycleImpl.java:343)
   at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:86)
   at com.icesoft.faces.webapp.xmlhttp.BlockingServlet.renderCycle(BlockingServlet.java:438)
   at com.icesoft.faces.webapp.xmlhttp.BlockingServlet.receiveUpdates(BlockingServlet.java:426)
   at com.icesoft.faces.webapp.xmlhttp.BlockingServlet.service(BlockingServlet.java:269)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
   at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
   at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
   at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
   at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
   at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
   at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
   at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
   at java.lang.Thread.run(Thread.java:595)



Any help would be appreciated.

Brian
Top
 Profile  
 
emmanuel
 Post subject:
PostPosted: Fri Feb 09, 2007 3:51 pm 
Hibernate Team
Hibernate Team

Joined: Sun Sep 14, 2003 3:54 am
Posts: 7256
Location: Paris, France
and your app should receive an optimisticlockexception later on.

2 persons are updating the same object in parallel, one has to be bounced

_________________
Emmanuel

Top
 Profile  
 
bcorbett8769
 Post subject:
PostPosted: Tue Feb 13, 2007 6:55 pm 
Newbie

Joined: Mon Feb 05, 2007 1:12 pm
Posts: 7
This exception is occurring when I am the only one using the webapp.
Top
 Profile  
 
emmanuel
 Post subject:
PostPosted: Thu Feb 15, 2007 8:02 pm 
Hibernate Team
Hibernate Team

Joined: Sun Sep 14, 2003 3:54 am
Posts: 7256
Location: Paris, France
ah so your driver might be buggy. Try again with
hibernate.jdbc.batch_size 0
or
hibernate.jdbc.batch_versioned_data false

_________________
Emmanuel

Top
 Profile  
 
bcorbett8769
 Post subject:
PostPosted: Mon Feb 19, 2007 7:22 pm 
Newbie

Joined: Mon Feb 05, 2007 1:12 pm
Posts: 7
Still no luck with these suggested options.

my persistence.xml is :
Code:
<?xml version="1.0" encoding="UTF-8"?>
<persistence xmlns="http://java.sun.com/xml/ns/persistence"
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1.0"
   xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
   <persistence-unit name="menu400">
      <provider>org.hibernate.ejb.HibernatePersistence</provider>
      <jta-data-source>java:/DB2-400DS</jta-data-source>
      <properties>
         <property name="hibernate.dialect" value="org.hibernate.dialect.DB2400Dialect" />
         <property name="hibernate.ejb.cfgfile" value="/menu400/hibernate.cfg.xml" />
      </properties>
   </persistence-unit>
</persistence>


my hibernate.cfg.xml is :

Code:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
      "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
      "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory name="M4SessionFactoryName">
        <property name="hibernate.connection.driver_class">com.ibm.as400.access.AS400JDBCDriver</property>
        <property name="hibernate.connection.password">jboss</property>
        <property name="hibernate.connection.url">jdbc:as400://tdidev</property>
        <property name="hibernate.connection.username">jboss</property>
        <property name="hibernate.connection.autocommit">false</property>
        <property name="hibernate.connection.transaction isolation">read committed</property>
        <property name="hibernate.default_schema">menu400tdi</property>
        <property name="hibernate.dialect">org.hibernate.dialect.DB2400Dialect</property>
        <property name="hibernate.jdbc.batch_size">0</property>
        <property name="hibernate.jdbc.batch_versioned_data">false</property>
    </session-factory>
</hibernate-configuration>


The reported jdbc information is :

Code:
17:19:08,200 INFO  [SettingsFactory] RDBMS: DB2 UDB for AS/400, version: 05.03.0000 V5R3m0
17:19:08,200 INFO  [SettingsFactory] JDBC driver: AS/400 Toolbox for Java JDBC Driver, version: 7.0
17:19:08,200 INFO  [Dialect] Using dialect: org.hibernate.dialect.DB2400Dialect


Brian
Top
 Profile  
 
emmanuel
 Post subject:
PostPosted: Tue Feb 20, 2007 8:10 pm 
Hibernate Team
Hibernate Team

Joined: Sun Sep 14, 2003 3:54 am
Posts: 7256
Location: Paris, France
But the exception is different, right?

_________________
Emmanuel

Top
 Profile  
 
bcorbett8769
 Post subject:
PostPosted: Wed Feb 21, 2007 12:18 pm 
Newbie

Joined: Mon Feb 05, 2007 1:12 pm
Posts: 7
I am still getting the same exception, the log is posted below.

Code:
2007-02-21 10:06:06,903 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2007-02-21 10:06:06,903 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC connection
2007-02-21 10:06:06,903 DEBUG [org.hibernate.SQL] select m4puser0_.user as user2_, m4puser0_.umnsty as umnsty2_, m4puser0_.brkmq as brkmq2_, m4puser0_.atnpgm as atnpgm2_, m4puser0_.mnulvl as mnulvl2_, m4puser0_.grpmnu as grpmnu2_, m4puser0_.setpgm as setpgm2_, m4puser0_.usrf3 as usrf8_2_, m4puser0_.sysreq as sysreq2_, m4puser0_.atnlib as atnlib2_, m4puser0_.rstcpb as rstcpb2_, m4puser0_.rsttrm as rsttrm2_, m4puser0_.menu as menu2_, m4puser0_.userpw as userpw2_, m4puser0_.usrsts as usrsts2_, m4puser0_.uname as uname2_, m4puser0_.setlib as setlib2_, m4puser0_.usrnpw as usrnpw2_, m4puser0_.acctcd as acctcd2_, m4puser0_.brktrm as brktrm2_, m4puser0_.usrssn as usrssn2_, m4puser0_.hlplvl as hlplvl2_, m4puser0_.usrnpd as usrnpd2_, m4puser0_.brkmql as brkmql2_, m4puser0_.userpd as userpd2_ from menu400tdi.M4PUSER m4puser0_ where m4puser0_.user=? order by m4puser0_.user
2007-02-21 10:06:07,012 DEBUG [org.hibernate.loader.hql.QueryLoader] bindNamedParameters() CHCOPY -> user [1]
2007-02-21 10:06:07,137 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0)
2007-02-21 10:06:07,137 DEBUG [org.hibernate.loader.Loader] result row: EntityKey[usermanager.menu400.entities.M4puser#CHCOPY    ]
2007-02-21 10:06:07,137 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close ResultSet (open ResultSets: 1, globally: 1)
2007-02-21 10:06:07,137 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2007-02-21 10:06:07,137 DEBUG [org.hibernate.jdbc.ConnectionManager] aggressively releasing JDBC connection
2007-02-21 10:06:07,137 DEBUG [org.hibernate.jdbc.ConnectionManager] releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2007-02-21 10:06:07,153 DEBUG [org.hibernate.engine.TwoPhaseLoad] resolving associations for [usermanager.menu400.entities.M4puser#CHCOPY    ]
2007-02-21 10:06:07,153 DEBUG [org.hibernate.engine.TwoPhaseLoad] done materializing entity [usermanager.menu400.entities.M4puser#CHCOPY    ]
2007-02-21 10:06:07,153 DEBUG [org.hibernate.engine.StatefulPersistenceContext] initializing non-lazy collections
2007-02-21 10:06:07,153 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] processing flush-time cascades
2007-02-21 10:06:07,153 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] dirty checking collections
2007-02-21 10:06:07,168 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 insertions, 1 updates, 0 deletions to 1 objects
2007-02-21 10:06:07,168 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
2007-02-21 10:06:07,168 DEBUG [org.hibernate.pretty.Printer] listing entities:
2007-02-21 10:06:07,168 DEBUG [org.hibernate.pretty.Printer] usermanager.menu400.entities.M4puser{brkmq=, rstcpb=Y, usrnpd=0, usrsts=A, sysreq=N, grpmnu=N, rsttrm=N, userpd=0, hlplvl=, usrnpw=, uname=Copy Shooter Profile - CH - Test, brktrm=N, menu=*NONE, usrssn=0, acctcd=, setpgm=, userpw=CHCOPY, atnpgm=, atnlib=, mnulvl=, setlib=, brkmql=, usrf3=N, user=CHCOPY    , umnsty=F}
2007-02-21 10:06:07,184 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2007-02-21 10:06:07,184 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC connection
2007-02-21 10:06:07,184 DEBUG [org.hibernate.SQL] update menu400tdi.M4PUSER set umnsty=?, brkmq=?, atnpgm=?, mnulvl=?, grpmnu=?, setpgm=?, usrf3=?, sysreq=?, atnlib=?, rstcpb=?, rsttrm=?, menu=?, userpw=?, usrsts=?, uname=?, setlib=?, usrnpw=?, acctcd=?, brktrm=?, usrssn=?, hlplvl=?, usrnpd=?, brkmql=?, userpd=? where user=?
2007-02-21 10:06:07,418 ERROR [org.hibernate.event.def.AbstractFlushingEventListener] Could not synchronize database state with session
org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
   at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:61)
   at org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:46)
   at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:24)
   at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2338)
   at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2242)
   at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2542)
   at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:92)
   at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
   at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
   at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
   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.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:296)
   at org.jboss.ejb3.entity.TransactionScopedEntityManager.flush(TransactionScopedEntityManager.java:204)
   at usermanager.menu400.session.MenuUserControllerBean.updateUser(MenuUserControllerBean.java:131)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
   at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
   at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
   at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
   at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)
   at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
   at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:46)
   at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
   at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
   at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:191)
   at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
   at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
   at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
   at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)
   at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
   at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77)
   at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:102)
   at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
   at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:47)
   at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
   at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
   at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
   at org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:211)
   at org.jboss.ejb3.stateless.StatelessLocalProxy.invoke(StatelessLocalProxy.java:79)
   at $Proxy85.updateUser(Unknown Source)
   at usermanager.web.UserControllerBean.updateUserAction(UserControllerBean.java:59)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at com.sun.el.parser.AstValue.invoke(AstValue.java:130)
   at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:274)
   at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
   at com.sun.facelets.el.LegacyMethodBinding.invoke(LegacyMethodBinding.java:69)
   at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:63)
   at javax.faces.component.UICommand.broadcast(UICommand.java:106)
   at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:94)
   at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:168)
   at org.apache.myfaces.lifecycle.LifecycleImpl.invokeApplication(LifecycleImpl.java:343)
   at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:86)
   at com.icesoft.faces.webapp.xmlhttp.BlockingServlet.renderCycle(BlockingServlet.java:456)
   at com.icesoft.faces.webapp.xmlhttp.BlockingServlet.receiveUpdates(BlockingServlet.java:444)
   at com.icesoft.faces.webapp.xmlhttp.BlockingServlet.executeRequest(BlockingServlet.java:314)
   at com.icesoft.faces.webapp.xmlhttp.BlockingServlet.service(BlockingServlet.java:186)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
   at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
   at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
   at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
   at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
   at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
   at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
   at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
   at java.lang.Thread.run(Thread.java:619)
2007-02-21 10:06:07,700 DEBUG [org.hibernate.jdbc.ConnectionManager] aggressively releasing JDBC connection
2007-02-21 10:06:07,700 DEBUG [org.hibernate.jdbc.ConnectionManager] releasing JDBC connection [ (open PreparedStatements: 1, globally: 1) (open ResultSets: 0, globally: 0)]
2007-02-21 10:06:07,700 DEBUG [org.hibernate.ejb.AbstractEntityManagerImpl] mark transaction for rollback
2007-02-21 10:06:07,762 DEBUG [org.jboss.ejb3.entity.ManagedEntityManagerFactory] ************** closing entity managersession **************
2007-02-21 10:06:07,762 ERROR [STDERR] javax.ejb.EJBException: javax.persistence.OptimisticLockException: org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
2007-02-21 10:06:07,762 ERROR [STDERR]    at org.jboss.ejb3.tx.Ejb3TxPolicy.handleExceptionInOurTx(Ejb3TxPolicy.java:69)
2007-02-21 10:06:07,762 ERROR [STDERR]    at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:83)
2007-02-21 10:06:07,762 ERROR [STDERR]    at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:191)
2007-02-21 10:06:07,762 ERROR [STDERR]    at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
2007-02-21 10:06:07,762 ERROR [STDERR]    at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
2007-02-21 10:06:07,762 ERROR [STDERR]    at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
2007-02-21 10:06:07,762 ERROR [STDERR]    at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)
2007-02-21 10:06:07,762 ERROR [STDERR]    at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
2007-02-21 10:06:07,762 ERROR [STDERR]    at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77)
2007-02-21 10:06:07,762 ERROR [STDERR]    at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:102)
2007-02-21 10:06:07,762 ERROR [STDERR]    at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
2007-02-21 10:06:07,762 ERROR [STDERR]    at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:47)
2007-02-21 10:06:07,762 ERROR [STDERR]    at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
2007-02-21 10:06:07,793 ERROR [STDERR]    at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
2007-02-21 10:06:07,793 ERROR [STDERR]    at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
2007-02-21 10:06:07,793 ERROR [STDERR]    at org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:211)
2007-02-21 10:06:07,793 ERROR [STDERR]    at org.jboss.ejb3.stateless.StatelessLocalProxy.invoke(StatelessLocalProxy.java:79)
2007-02-21 10:06:07,793 ERROR [STDERR]    at $Proxy85.updateUser(Unknown Source)
2007-02-21 10:06:07,793 ERROR [STDERR]    at usermanager.web.UserControllerBean.updateUserAction(UserControllerBean.java:59)
2007-02-21 10:06:07,793 ERROR [STDERR]    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2007-02-21 10:06:07,793 ERROR [STDERR]    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
2007-02-21 10:06:07,809 ERROR [STDERR]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2007-02-21 10:06:07,809 ERROR [STDERR]    at java.lang.reflect.Method.invoke(Method.java:597)
2007-02-21 10:06:07,809 ERROR [STDERR]    at com.sun.el.parser.AstValue.invoke(AstValue.java:130)
2007-02-21 10:06:07,809 ERROR [STDERR]    at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:274)
2007-02-21 10:06:07,809 ERROR [STDERR]    at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
2007-02-21 10:06:07,840 ERROR [STDERR]    at com.sun.facelets.el.LegacyMethodBinding.invoke(LegacyMethodBinding.java:69)
2007-02-21 10:06:07,840 ERROR [STDERR]    at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:63)
2007-02-21 10:06:07,840 ERROR [STDERR]    at javax.faces.component.UICommand.broadcast(UICommand.java:106)
2007-02-21 10:06:07,840 ERROR [STDERR]    at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:94)
2007-02-21 10:06:07,840 ERROR [STDERR]    at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:168)
2007-02-21 10:06:07,840 ERROR [STDERR]    at org.apache.myfaces.lifecycle.LifecycleImpl.invokeApplication(LifecycleImpl.java:343)
2007-02-21 10:06:07,840 ERROR [STDERR]    at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:86)
2007-02-21 10:06:07,840 ERROR [STDERR]    at com.icesoft.faces.webapp.xmlhttp.BlockingServlet.renderCycle(BlockingServlet.java:456)
2007-02-21 10:06:07,840 ERROR [STDERR]    at com.icesoft.faces.webapp.xmlhttp.BlockingServlet.receiveUpdates(BlockingServlet.java:444)
2007-02-21 10:06:07,840 ERROR [STDERR]    at com.icesoft.faces.webapp.xmlhttp.BlockingServlet.executeRequest(BlockingServlet.java:314)
2007-02-21 10:06:07,872 ERROR [STDERR]    at com.icesoft.faces.webapp.xmlhttp.BlockingServlet.service(BlockingServlet.java:186)
2007-02-21 10:06:07,872 ERROR [STDERR]    at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
2007-02-21 10:06:07,872 ERROR [STDERR]    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
2007-02-21 10:06:07,872 ERROR [STDERR]    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
2007-02-21 10:06:07,872 ERROR [STDERR]    at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
2007-02-21 10:06:07,872 ERROR [STDERR]    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
2007-02-21 10:06:07,872 ERROR [STDERR]    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
2007-02-21 10:06:07,872 ERROR [STDERR]    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
2007-02-21 10:06:07,872 ERROR [STDERR]    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
2007-02-21 10:06:07,872 ERROR [STDERR]    at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
2007-02-21 10:06:07,903 ERROR [STDERR]    at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
2007-02-21 10:06:07,903 ERROR [STDERR]    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
2007-02-21 10:06:07,903 ERROR [STDERR]    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
2007-02-21 10:06:07,903 ERROR [STDERR]    at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
2007-02-21 10:06:07,903 ERROR [STDERR]    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
2007-02-21 10:06:07,903 ERROR [STDERR]    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
2007-02-21 10:06:07,903 ERROR [STDERR]    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
2007-02-21 10:06:07,903 ERROR [STDERR]    at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
2007-02-21 10:06:07,903 ERROR [STDERR]    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
2007-02-21 10:06:07,934 ERROR [STDERR]    at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
2007-02-21 10:06:07,934 ERROR [STDERR]    at java.lang.Thread.run(Thread.java:619)
2007-02-21 10:06:07,934 ERROR [STDERR] Caused by: javax.persistence.OptimisticLockException: org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
2007-02-21 10:06:07,934 ERROR [STDERR]    at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:617)
2007-02-21 10:06:07,934 ERROR [STDERR]    at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:299)
2007-02-21 10:06:07,934 ERROR [STDERR]    at org.jboss.ejb3.entity.TransactionScopedEntityManager.flush(TransactionScopedEntityManager.java:204)
2007-02-21 10:06:07,934 ERROR [STDERR]    at usermanager.menu400.session.MenuUserControllerBean.updateUser(MenuUserControllerBean.java:131)
2007-02-21 10:06:07,934 ERROR [STDERR]    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2007-02-21 10:06:07,965 ERROR [STDERR]    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
2007-02-21 10:06:07,965 ERROR [STDERR]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2007-02-21 10:06:07,965 ERROR [STDERR]    at java.lang.reflect.Method.invoke(Method.java:597)
2007-02-21 10:06:07,965 ERROR [STDERR]    at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
2007-02-21 10:06:07,965 ERROR [STDERR]    at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
2007-02-21 10:06:07,965 ERROR [STDERR]    at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
2007-02-21 10:06:07,965 ERROR [STDERR]    at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
2007-02-21 10:06:07,965 ERROR [STDERR]    at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)
2007-02-21 10:06:07,965 ERROR [STDERR]    at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
2007-02-21 10:06:07,997 ERROR [STDERR]    at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:46)
2007-02-21 10:06:07,997 ERROR [STDERR]    at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
2007-02-21 10:06:07,997 ERROR [STDERR]    at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
2007-02-21 10:06:07,997 ERROR [STDERR]    ... 55 more
2007-02-21 10:06:07,997 ERROR [STDERR] Caused by: org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
2007-02-21 10:06:07,997 ERROR [STDERR]    at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:61)
2007-02-21 10:06:07,997 ERROR [STDERR]    at org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:46)
2007-02-21 10:06:07,997 ERROR [STDERR]    at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:24)
2007-02-21 10:06:07,997 ERROR [STDERR]    at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2338)
2007-02-21 10:06:08,028 ERROR [STDERR]    at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2242)
2007-02-21 10:06:08,028 ERROR [STDERR]    at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2542)
2007-02-21 10:06:08,028 ERROR [STDERR]    at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:92)
2007-02-21 10:06:08,028 ERROR [STDERR]    at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
2007-02-21 10:06:08,028 ERROR [STDERR]    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
2007-02-21 10:06:08,028 ERROR [STDERR]    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
2007-02-21 10:06:08,028 ERROR [STDERR]    at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
2007-02-21 10:06:08,028 ERROR [STDERR]    at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
2007-02-21 10:06:08,043 ERROR [STDERR]    at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
2007-02-21 10:06:08,043 ERROR [STDERR]    at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:296)
2007-02-21 10:06:08,043 ERROR [STDERR]    ... 70 more
Top
 Profile  
 
emmanuel
 Post subject:
PostPosted: Tue Feb 27, 2007 7:07 pm 
Hibernate Team
Hibernate Team

Joined: Sun Sep 14, 2003 3:54 am
Posts: 7256
Location: Paris, France
Seems like your driver doesn't follow the JDBC rules, maybe there is a proeprty you need to set up to enable proper update return result.
Or really you are using 2 different concurrent sessions (even with one user).

_________________
Emmanuel

Top
 Profile  
 
bcorbett8769
 Post subject:
PostPosted: Mon Mar 26, 2007 4:19 pm 
Newbie

Joined: Mon Feb 05, 2007 1:12 pm
Posts: 7
Is there a way to check whether multiple connections are being created?

Are there any examples of a proper way to perform an update on a record from a table?

In the webapp, to execute a search to show a user list by user id like:
Code:
   public List<MenuUserDetails> findUsersById(String user) {
      ArrayList<MenuUserDetails> users = new ArrayList<MenuUserDetails>();
      String userParam = user.trim() + '%';
      String queryString = "SELECT u FROM M4puser u WHERE (u.user LIKE :user) ORDER BY u.user";
      Query q = entityManager.createQuery(
               queryString).setParameter("user", userParam);
     
      // Load results into list.
      for (Object po : q.getResultList()){
         users.add(new MenuUserDetails((M4puser)po));
      }
     
      entityManager.clear();
      return users;
   }



This shows a list of users. The user of the app can select which "user" record to select. After selection is made, webapp shows the details of the "user" record selected. Then, changes are made and submitted.

The source to perform this update is :
Code:
   @TransactionAttribute(TransactionAttributeType.REQUIRED)
   public void updateUser(MenuUserDetails rec) {
      String queryString = "SELECT u FROM M4puser u WHERE (u.user = :user) ORDER BY u.user";
      Query q = entityManager.createQuery(
               queryString).setParameter("user", rec.getUser());
      M4puser req = (M4puser)q.getSingleResult();
     
      if (req != null) {
         req.setUname(rec.getUname());
         ...
      }
      entityManager.merge(req);
      entityManager.flush();
   }

Anyway, did I do something wrong here? Is the second select query necessary before the merge() is performed?
[/code]
Top
 Profile  
 
bcorbett8769
 Post subject:
PostPosted: Tue Mar 27, 2007 4:39 pm 
Newbie

Joined: Mon Feb 05, 2007 1:12 pm
Posts: 7
Thanks for the help provided. I discovered my mistake. My primary key is USER and it is a keyword of some sort on iseries files. Once I placed double quotes around USER, then everything worked great.
Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 10 posts ] 

Board index » Projects » Search, Validator, Shards

All times are UTC - 5 hours [ DST ]

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

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.