Re: [JBoss-user] ejbCreate() followed by ejbStore() locks, EntityBean!!!

[Muraly R]

Hi Adrian, Alexy,
        The version of JBoss is 3.0.7 and database I am using is Sybase7.0.3.
        I can explain the scenario in a general way.
        The first scenario I explained is resolved. Actually I had to try only a work around.
        The solution is set a flag after the ejbCreate(). So in ejbStore() I check whether the flag is set, then don't execute the contents of ejbStore(). Please suggest if this work around has any effects. As I see it since, the data has been inserted in to the DB, the additional update is an overhead. Please bear my ignorance;-)
        The next scenario I am facing is also with the ejbStore. But here there is no preceding ejbCreate(). Here it is a setXXX() method which updates the VO.
        Putting this both scenario's and their behavior, I think its the level of locking with the DB.

        But I am not able to pinpoint the source of error. Actually I am new to this platform itself but I am catching up:-).
        Could you please tell where should I look :
1. for the isolation level(may be I know it, but not familiar with the term)
2. what is the locking mechanism used?

Thanks for the EXCELLENT Support,
Muraly

        
        
At 11:13 14/08/2003 +0300, Alexey Loubyansky wrote:

Hello Muraly,

I am sorry, I would like to help you, but I can't understand what you
are writting about. Could you rewrite it with EJB terms or post a
testcase reproducing the problem?
Also, please, let us know what JBoss version and database you are
using.

alex

Thursday, August 14, 2003, 9:36:11 AM, Muraly R 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



-------------------------------------------------------
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