luc boudreau wrote:
Err, we need more details than that. Logs, complete mappings, domain model details, etc, etc.
Sorry luc boudreau, this is my 1st time asking for help
Mapping
Code:
<class name="User" table="User">
<id name="UID" column="UID" type="int">
<generator class="native"/>
</id>
<property name="username" type="string" />
<property name="password" type="string"/>
<property name="email" type="string"/>
<set name="roles" table="users_roles" cascade="save-update" inverse="false">
<key column="UID"/>
<many-to-many column="RID" class="Role"/>
</set>
</class>
<class name="Role" table="Role" >
<id name="RID" type="int">
<generator class="native" />
</id>
<property name="name" type="string" column="name"/>
<set name="users" table="users_roles" >
<key column="RID"/>
<many-to-many column="UID" class="User" />
</set>
</class>
Domain modelCode:
public class Role {
private int RID;
private String name;
private Set users;
...
}
public class User {
private int UID;
private String username;
private String password;
private String name;
private String email;
private Set roles;
...
}
Log messageCode:
class java.lang.String
{1,3}
21:49:02,328 DEBUG SessionImpl:222 - opened session at timestamp: 4799100282109952
21:49:02,328 DEBUG DefaultLoadEventListener:154 - loading entity: [com.mufic.mufix.multiuser.beans.Role#1]
21:49:02,328 DEBUG DefaultLoadEventListener:309 - attempting to resolve: [com.mufic.mufix.multiuser.beans.Role#1]
21:49:02,328 DEBUG DefaultLoadEventListener:345 - object not resolved in any cache: [com.mufic.mufix.multiuser.beans.Role#1]
21:49:02,328 DEBUG AbstractEntityPersister:2814 - Fetching entity: [com.mufic.mufix.multiuser.beans.Role#1]
21:49:02,375 DEBUG Loader:1777 - loading entity: [com.mufic.mufix.multiuser.beans.Role#1]
21:49:02,375 DEBUG AbstractBatcher:358 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
21:49:02,375 DEBUG ConnectionManager:415 - opening JDBC connection
21:49:02,375 DEBUG DriverManagerConnectionProvider:93 - total checked-out connections: 1
21:49:02,375 DEBUG DriverManagerConnectionProvider:99 - using pooled JDBC connection, pool size: 0
21:49:02,375 DEBUG SQL:393 - select role0_.RID as RID2_0_, role0_.name as name2_0_ from Role role0_ where role0_.RID=?
Hibernate: select role0_.RID as RID2_0_, role0_.name as name2_0_ from Role role0_ where role0_.RID=?
21:49:02,375 DEBUG AbstractBatcher:476 - preparing statement
21:49:02,390 DEBUG AbstractBatcher:374 - about to open ResultSet (open ResultSets: 0, globally: 0)
21:49:02,390 DEBUG Loader:682 - processing result set
21:49:02,390 DEBUG Loader:687 - result set row: 0
21:49:02,390 DEBUG Loader:1164 - result row: EntityKey[com.mufic.mufix.multiuser.beans.Role#1]
21:49:02,390 DEBUG Loader:1347 - Initializing object from ResultSet: [com.mufic.mufix.multiuser.beans.Role#1]
21:49:02,390 DEBUG AbstractEntityPersister:1944 - Hydrating entity: [com.mufic.mufix.multiuser.beans.Role#1]
21:49:02,390 DEBUG Loader:709 - done processing result set (1 rows)
21:49:02,390 DEBUG AbstractBatcher:381 - about to close ResultSet (open ResultSets: 1, globally: 1)
21:49:02,390 DEBUG AbstractBatcher:366 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
21:49:02,390 DEBUG AbstractBatcher:525 - closing statement
21:49:02,390 DEBUG Loader:839 - total objects hydrated: 1
21:49:02,390 DEBUG TwoPhaseLoad:107 - resolving associations for [com.mufic.mufix.multiuser.beans.Role#1]
21:49:02,390 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.mufic.mufix.multiuser.beans.Role.users#1]
21:49:02,390 DEBUG TwoPhaseLoad:206 - done materializing entity [com.mufic.mufix.multiuser.beans.Role#1]
21:49:02,390 DEBUG StatefulPersistenceContext:748 - initializing non-lazy collections
21:49:02,390 DEBUG Loader:1808 - done entity load
21:49:02,390 DEBUG JDBCContext:226 - after autocommit
21:49:02,390 DEBUG ConnectionManager:398 - aggressively releasing JDBC connection
21:49:02,390 DEBUG ConnectionManager:435 - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
21:49:02,406 DEBUG DriverManagerConnectionProvider:129 - returning connection to pool, pool size: 1
21:49:02,406 DEBUG SessionImpl:275 - closing session
21:49:02,406 DEBUG ConnectionManager:369 - connection already null in cleanup : no action
21:49:02,406 DEBUG SessionImpl:222 - opened session at timestamp: 4799100282494976
21:49:02,406 DEBUG DefaultLoadEventListener:154 - loading entity: [com.mufic.mufix.multiuser.beans.Role#3]
21:49:02,406 DEBUG DefaultLoadEventListener:309 - attempting to resolve: [com.mufic.mufix.multiuser.beans.Role#3]
21:49:02,406 DEBUG DefaultLoadEventListener:345 - object not resolved in any cache: [com.mufic.mufix.multiuser.beans.Role#3]
21:49:02,406 DEBUG AbstractEntityPersister:2814 - Fetching entity: [com.mufic.mufix.multiuser.beans.Role#3]
21:49:02,406 DEBUG Loader:1777 - loading entity: [com.mufic.mufix.multiuser.beans.Role#3]
21:49:02,421 DEBUG AbstractBatcher:358 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
21:49:02,421 DEBUG ConnectionManager:415 - opening JDBC connection
21:49:02,421 DEBUG DriverManagerConnectionProvider:93 - total checked-out connections: 1
21:49:02,421 DEBUG DriverManagerConnectionProvider:99 - using pooled JDBC connection, pool size: 0
21:49:02,421 DEBUG SQL:393 - select role0_.RID as RID2_0_, role0_.name as name2_0_ from Role role0_ where role0_.RID=?
Hibernate: select role0_.RID as RID2_0_, role0_.name as name2_0_ from Role role0_ where role0_.RID=?
21:49:02,421 DEBUG AbstractBatcher:476 - preparing statement
21:49:02,421 DEBUG AbstractBatcher:374 - about to open ResultSet (open ResultSets: 0, globally: 0)
21:49:02,421 DEBUG Loader:682 - processing result set
21:49:02,421 DEBUG Loader:687 - result set row: 0
21:49:02,421 DEBUG Loader:1164 - result row: EntityKey[com.mufic.mufix.multiuser.beans.Role#3]
21:49:02,421 DEBUG Loader:1347 - Initializing object from ResultSet: [com.mufic.mufix.multiuser.beans.Role#3]
21:49:02,421 DEBUG AbstractEntityPersister:1944 - Hydrating entity: [com.mufic.mufix.multiuser.beans.Role#3]
21:49:02,421 DEBUG Loader:709 - done processing result set (1 rows)
21:49:02,421 DEBUG AbstractBatcher:381 - about to close ResultSet (open ResultSets: 1, globally: 1)
21:49:02,421 DEBUG AbstractBatcher:366 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
21:49:02,421 DEBUG AbstractBatcher:525 - closing statement
21:49:02,421 DEBUG Loader:839 - total objects hydrated: 1
21:49:02,437 DEBUG TwoPhaseLoad:107 - resolving associations for [com.mufic.mufix.multiuser.beans.Role#3]
21:49:02,437 DEBUG CollectionLoadContext:141 - creating collection wrapper:[com.mufic.mufix.multiuser.beans.Role.users#3]
21:49:02,437 DEBUG TwoPhaseLoad:206 - done materializing entity [com.mufic.mufix.multiuser.beans.Role#3]
21:49:02,437 DEBUG StatefulPersistenceContext:748 - initializing non-lazy collections
21:49:02,437 DEBUG Loader:1808 - done entity load
21:49:02,437 DEBUG JDBCContext:226 - after autocommit
21:49:02,437 DEBUG ConnectionManager:398 - aggressively releasing JDBC connection
21:49:02,437 DEBUG ConnectionManager:435 - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
21:49:02,437 DEBUG DriverManagerConnectionProvider:129 - returning connection to pool, pool size: 1
21:49:02,437 DEBUG SessionImpl:275 - closing session
21:49:02,437 DEBUG ConnectionManager:369 - connection already null in cleanup : no action
21:49:02,437 DEBUG SessionImpl:222 - opened session at timestamp: 4799100282621952
21:49:02,437 DEBUG JDBCTransaction:54 - begin
21:49:02,437 DEBUG ConnectionManager:415 - opening JDBC connection
21:49:02,437 DEBUG DriverManagerConnectionProvider:93 - total checked-out connections: 1
21:49:02,437 DEBUG DriverManagerConnectionProvider:99 - using pooled JDBC connection, pool size: 0
21:49:02,437 DEBUG JDBCTransaction:59 - current autocommit status: false
21:49:02,437 DEBUG JDBCContext:203 - after transaction begin
21:49:02,437 DEBUG IdentifierValue:104 - id unsaved-value: 0
21:49:02,437 DEBUG AbstractSaveEventListener:489 - transient instance of: com.mufic.mufix.multiuser.beans.User
21:49:02,453 DEBUG DefaultSaveOrUpdateEventListener:161 - saving transient instance
21:49:02,453 DEBUG AbstractSaveEventListener:152 - saving [com.mufic.mufix.multiuser.beans.User#<null>]
21:49:02,453 DEBUG AbstractSaveEventListener:240 - executing insertions
21:49:02,453 DEBUG Cascade:237 - processing cascade ACTION_SAVE_UPDATE for: com.mufic.mufix.multiuser.beans.User
21:49:02,453 DEBUG Cascade:259 - done processing cascade ACTION_SAVE_UPDATE for: com.mufic.mufix.multiuser.beans.User
21:49:02,453 DEBUG WrapVisitor:87 - Wrapped collection in role: com.mufic.mufix.multiuser.beans.User.roles
21:49:02,453 DEBUG AbstractSaveEventListener:289 - executing identity-insert immediately
21:49:02,453 DEBUG AbstractEntityPersister:2030 - Inserting entity: com.mufic.mufix.multiuser.beans.User (native id)
21:49:02,453 DEBUG AbstractBatcher:358 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
21:49:02,453 DEBUG SQL:393 - insert into User (username, password, email) values (?, ?, ?)
Hibernate: insert into User (username, password, email) values (?, ?, ?)
21:49:02,453 DEBUG AbstractBatcher:476 - preparing statement
21:49:02,453 DEBUG AbstractEntityPersister:1905 - Dehydrating entity: [com.mufic.mufix.multiuser.beans.User#<null>]
21:49:02,453 DEBUG AbstractBatcher:366 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
21:49:02,453 DEBUG AbstractBatcher:525 - closing statement
21:49:02,453 DEBUG AbstractBatcher:358 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
21:49:02,453 DEBUG SQL:393 - select last_insert_id()
Hibernate: select last_insert_id()
21:49:02,453 DEBUG AbstractBatcher:476 - preparing statement
21:49:02,468 DEBUG IdentifierGeneratorFactory:37 - Natively generated identity: 15
21:49:02,468 DEBUG AbstractBatcher:366 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
21:49:02,484 DEBUG AbstractBatcher:525 - closing statement
21:49:02,500 DEBUG Cascade:237 - processing cascade ACTION_SAVE_UPDATE for: com.mufic.mufix.multiuser.beans.User
21:49:02,500 DEBUG Cascade:285 - cascade ACTION_SAVE_UPDATE for collection: com.mufic.mufix.multiuser.beans.User.roles
21:49:02,500 DEBUG CascadingAction:133 - cascading to saveOrUpdate: com.mufic.mufix.multiuser.beans.Role
21:49:02,500 DEBUG IdentifierValue:104 - id unsaved-value: 0
21:49:02,500 DEBUG AbstractSaveEventListener:498 - detached instance of: com.mufic.mufix.multiuser.beans.Role
21:49:02,500 DEBUG DefaultSaveOrUpdateEventListener:203 - updating detached instance
21:49:02,500 DEBUG DefaultSaveOrUpdateEventListener:249 - updating [com.mufic.mufix.multiuser.beans.Role#1]
21:49:02,500 DEBUG DefaultSaveOrUpdateEventListener:298 - updating [com.mufic.mufix.multiuser.beans.Role#1]
21:49:02,500 DEBUG CascadingAction:133 - cascading to saveOrUpdate: com.mufic.mufix.multiuser.beans.Role
21:49:02,500 DEBUG IdentifierValue:104 - id unsaved-value: 0
21:49:02,500 DEBUG AbstractSaveEventListener:498 - detached instance of: com.mufic.mufix.multiuser.beans.Role
21:49:02,500 DEBUG DefaultSaveOrUpdateEventListener:203 - updating detached instance
21:49:02,500 DEBUG DefaultSaveOrUpdateEventListener:249 - updating [com.mufic.mufix.multiuser.beans.Role#3]
21:49:02,500 DEBUG DefaultSaveOrUpdateEventListener:298 - updating [com.mufic.mufix.multiuser.beans.Role#3]
21:49:02,500 DEBUG Cascade:300 - done cascade ACTION_SAVE_UPDATE for collection: com.mufic.mufix.multiuser.beans.User.roles
21:49:02,500 DEBUG Cascade:259 - done processing cascade ACTION_SAVE_UPDATE for: com.mufic.mufix.multiuser.beans.User
21:49:02,515 DEBUG JDBCTransaction:103 - commit
21:49:02,515 DEBUG SessionImpl:339 - automatically flushing session
21:49:02,515 DEBUG AbstractFlushingEventListener:58 - flushing session
21:49:02,515 DEBUG AbstractFlushingEventListener:111 - processing flush-time cascades
21:49:02,515 DEBUG Cascade:237 - processing cascade ACTION_SAVE_UPDATE for: com.mufic.mufix.multiuser.beans.User
21:49:02,515 DEBUG Cascade:285 - cascade ACTION_SAVE_UPDATE for collection: com.mufic.mufix.multiuser.beans.User.roles
21:49:02,515 DEBUG CascadingAction:133 - cascading to saveOrUpdate: com.mufic.mufix.multiuser.beans.Role
21:49:02,515 DEBUG AbstractSaveEventListener:463 - persistent instance of: com.mufic.mufix.multiuser.beans.Role
21:49:02,515 DEBUG DefaultSaveOrUpdateEventListener:105 - ignoring persistent instance
21:49:02,515 DEBUG DefaultSaveOrUpdateEventListener:142 - object already associated with session: [com.mufic.mufix.multiuser.beans.Role#1]
21:49:02,515 DEBUG CascadingAction:133 - cascading to saveOrUpdate: com.mufic.mufix.multiuser.beans.Role
21:49:02,515 DEBUG AbstractSaveEventListener:463 - persistent instance of: com.mufic.mufix.multiuser.beans.Role
21:49:02,515 DEBUG DefaultSaveOrUpdateEventListener:105 - ignoring persistent instance
21:49:02,515 DEBUG DefaultSaveOrUpdateEventListener:142 - object already associated with session: [com.mufic.mufix.multiuser.beans.Role#3]
21:49:02,515 DEBUG Cascade:300 - done cascade ACTION_SAVE_UPDATE for collection: com.mufic.mufix.multiuser.beans.User.roles
21:49:02,515 DEBUG Cascade:259 - done processing cascade ACTION_SAVE_UPDATE for: com.mufic.mufix.multiuser.beans.User
21:49:02,515 DEBUG AbstractFlushingEventListener:153 - dirty checking collections
21:49:02,515 DEBUG AbstractFlushingEventListener:170 - Flushing entities and processing referenced collections
21:49:02,515 DEBUG Collections:176 - Collection found: [com.mufic.mufix.multiuser.beans.User.roles#15], was: [<unreferenced>] (initialized)
21:49:02,515 DEBUG DefaultFlushEntityEventListener:229 - Updating entity: [com.mufic.mufix.multiuser.beans.Role#1]
21:49:02,531 DEBUG Collections:176 - Collection found: [com.mufic.mufix.multiuser.beans.Role.users#1], was: [com.mufic.mufix.multiuser.beans.Role.users#1] (uninitialized)
21:49:02,531 DEBUG DefaultFlushEntityEventListener:229 - Updating entity: [com.mufic.mufix.multiuser.beans.Role#3]
21:49:02,531 DEBUG Collections:176 - Collection found: [com.mufic.mufix.multiuser.beans.Role.users#3], was: [com.mufic.mufix.multiuser.beans.Role.users#3] (uninitialized)
21:49:02,531 DEBUG AbstractFlushingEventListener:209 - Processing unreferenced collections
21:49:02,531 DEBUG AbstractFlushingEventListener:223 - Scheduling collection removes/(re)creates/updates
21:49:02,531 DEBUG AbstractFlushingEventListener:85 - Flushed: 0 insertions, 2 updates, 0 deletions to 3 objects
21:49:02,531 DEBUG AbstractFlushingEventListener:91 - Flushed: 1 (re)creations, 0 updates, 0 removals to 3 collections
21:49:02,531 DEBUG Printer:83 - listing entities:
21:49:02,531 DEBUG Printer:90 - com.mufic.mufix.multiuser.beans.Role{users=<uninitialized>, name=role3, RID=3}
21:49:02,531 DEBUG Printer:90 - com.mufic.mufix.multiuser.beans.Role{users=<uninitialized>, name=role 1, RID=1}
21:49:02,531 DEBUG Printer:90 - com.mufic.mufix.multiuser.beans.User{username=biso, email=ooo, UID=15, roles=[com.mufic.mufix.multiuser.beans.Role#1, com.mufic.mufix.multiuser.beans.Role#3], password=bi}
21:49:02,531 DEBUG AbstractFlushingEventListener:289 - executing flush
21:49:02,531 DEBUG ConnectionManager:463 - registering flush begin
21:49:02,531 DEBUG AbstractEntityPersister:2211 - Updating entity: [com.mufic.mufix.multiuser.beans.Role#1]
21:49:02,531 DEBUG AbstractBatcher:358 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
21:49:02,531 DEBUG SQL:393 - update Role set name=? where RID=?
Hibernate: update Role set name=? where RID=?
21:49:02,531 DEBUG AbstractBatcher:476 - preparing statement
21:49:02,531 DEBUG AbstractEntityPersister:1905 - Dehydrating entity: [com.mufic.mufix.multiuser.beans.Role#1]
21:49:53,000 DEBUG AbstractBatcher:366 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
21:49:53,000 DEBUG AbstractBatcher:525 - closing statement
21:49:53,000 DEBUG JDBCExceptionReporter:63 - could not update: [com.mufic.mufix.multiuser.beans.Role#1] [update Role set name=? where RID=?]
java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1160)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:685)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1400)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1314)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1299)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2268)
at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2180)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2450)
at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:91)
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:297)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:993)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:340)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at com.mufic.mufix.multiuser.UserFacade.saveUser(UserFacade.java:34)
at com.mufic.mufix.multiuser.actions.PostInsertUser.execute(PostInsertUser.java:33)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:368)
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.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
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.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:619)
21:49:53,109 WARN JDBCExceptionReporter:71 - SQL Error: 1205, SQLState: 41000
21:49:53,109 ERROR JDBCExceptionReporter:72 - Lock wait timeout exceeded; try restarting transaction
21:49:53,109 ERROR AbstractFlushingEventListener:300 - Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: could not update: [com.mufic.mufix.multiuser.beans.Role#1]
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2290)
at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2180)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2450)
at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:91)
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:297)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:993)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:340)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at com.mufic.mufix.multiuser.UserFacade.saveUser(UserFacade.java:34)
at com.mufic.mufix.multiuser.actions.PostInsertUser.execute(PostInsertUser.java:33)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:368)
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.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
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.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1160)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:685)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1400)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1314)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1299)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2268)
... 36 more
21:49:53,359 DEBUG ConnectionManager:472 - registering flush end
21:49:53,359 WARN RequestProcessor:528 - Unhandled Exception thrown: class org.hibernate.exception.GenericJDBCException
21:49:53,484 ERROR [action]:253 - Servlet.service() for servlet action threw exception
org.hibernate.exception.GenericJDBCException: could not update: [com.mufic.mufix.multiuser.beans.Role#1]
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2290)
at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2180)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2450)
at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:91)
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:297)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:993)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:340)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at com.mufic.mufix.multiuser.UserFacade.saveUser(UserFacade.java:34)
at com.mufic.mufix.multiuser.actions.PostInsertUser.execute(PostInsertUser.java:33)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:368)
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.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
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.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1160)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:685)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1400)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1314)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1299)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2268)
... 36 more
Thanks in advance
BISO