Do you have any constraints? How does your db handle them? Some dbs lock the entire table or column if you don't have an index supporting the constraint.
What isolation level are you using? Regards, Adrian On Thu, 2003-08-14 at 12:09, Muraly R wrote: > Hi Gurus, > I have faced another scenario with the same symptoms. > > Clould anyone please advise? > Cheers > Muraly > > At 12:06 14/08/2003 +0530, you wrote: > > Hi Gurus, > > I am having a strange scenario. > > Here I have a Table, which stores the interfaces of a > > device. When I first add the device the trnasaction gets complted > > successfully. > > In the next transaction, when I update the device with a new > > interface, and start a transaction to update device details, I can > > see all the existing interface updated correctly. Plus the new > > interface been added to the database. > > Here start the probs. > > Immediatly after the ejbCreate() for the new interface a > > call for ejbStore() starts. > > Here a prepared statement is created and sets the necessary > > value. > > But the point of execution, stmt.executeUpdate(), the whole > > code flow is stuck. > > I tried various options like 'Insatnce per Transaction > > EntiyBean' for the EntityBean. > > > > Could some please tell me what could I do wrong? > > > > Cheers > > Muraly > > > > > > > > ------------------------------------------------------- > > 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 -- xxxxxxxxxxxxxxxxxxxxxxxx Adrian Brock Director of Support Back Office JBoss Group, LLC xxxxxxxxxxxxxxxxxxxxxxxx ------------------------------------------------------- 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
