Hello Sven, this your sequence: > client -> a.init() "required" -> a.initMessage() "required" -> > message.create() "required" -> sequenceService.getNextSequenceNumber() > "required" -> sequence.getValueAfterIncrementingBy "RequiresNew"
after entity bean is created, it is locked by the tx in which it was created. The lock will be released when the tx commits or rolls back. Later in sequence, sequence.getValueAfterIncrementingBy starts a new tx and tries to access the created entity which is locked and it waits for the lock to be released. As you see, it is just a deadlock. alex Thursday, July 24, 2003, 1:51:26 PM, Sven Scheil wrote: SS> hi scott, SS> we are suing mysql-connector 3.0.8. but i've created a test scenario where SS> this error occurs with cloudscape and mysql the same way. SS> the implmentation of the sequence pattern comes from the book 'EJB Design SS> Patterns' from floyd marinescu. SS> the tx timeout only occurs when the SequenceService have to create a new SS> Sequence entity. that means each time when we introduce a new sequence to SS> the app the server hangs up. SS> i think the reason for this is: the creation of a new sequence entity has to SS> be committed before the subsequent call of SS> sequence.getValueAfterIncrementingBy() on the newly created entity can be SS> excuted. SS> using a transactional setting of requiresNew for the create method of SS> sequence solves the problem. SS> sven SS> -----Urspr�ngliche Nachricht----- SS> Von: Scott M Stark [mailto:[EMAIL PROTECTED] SS> Gesendet: Mittwoch, 23. Juli 2003 03:00 SS> An: [EMAIL PROTECTED] SS> Betreff: Re: AW: [JBoss-user] problems with mysql and transactions SS> Remove the INFO threshold on the server.log to see if there is any SS> additional SS> information about the cause of the tx timeout. What jdbc driver version is SS> being SS> used here? If you have an example that reproduces this create a bug report SS> on SS> sourceforge with it as an attachment. ------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
