Hello, After migrating a project from our initial MySql development server to the MS SQL Server 2000 install of our client, we experience a deadlock in the default UserActionTest. This deadlock also occurs in a newly created project, when created as follows:
1) mvn archetype:create -DarchetypeGroupId=org.appfuse.archetypes -DarchetypeArtifactId=appfuse-basic-struts -DremoteRepositories=http://static.appfuse.org/releases -DarchetypeVersion=2.0.2 -DgroupId=com.mycompany.app -DartifactId=myproject 2) mvn appfuse:full-source 3) Set the url/username/password of the sql server in the sqlserver profile in the POM If you now run the UserActionTest as: mvn clean install -P sqlserver -Dtest=UserActionTest then a deadlock will occur upon invocation of user.save() on line 71 in the UserActionTest. The test simply hangs indefinitely. The problem is that it is trying to read a row that is currently locked in a transaction. The transaction is started while executing line 55 (final User user = userManager.getUserByUsername("manager");). The Sql Server management console shows two connections to the database in question, one being the transaction and the other waiting for a lock to be released. So this means that somewhere in the Spring/Hibernate configuration, something seems to be incompatible with MS SQL Server. I'm guessing it should either finalize the previous transaction or it should reuse the connection and execute the save() within the same transaction. However, I have not been able to find what this might be. Has anyone else experienced this or does anyone know what may be the problem? BTW, you can comment lines 57,63 and 67-69 in the test and still get this behaviour. 72-74 are never reached and can also be removed for simplicity best regards, -- Ivo Wever -- View this message in context: http://www.nabble.com/Default-UserActionTest-deadlocks-on-MS-SQL-Server-2000-tp24601593s2369p24601593.html Sent from the AppFuse - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@appfuse.dev.java.net For additional commands, e-mail: users-h...@appfuse.dev.java.net
