Bugs item #722539, was opened at 2003-04-16 18:16
Message generated for change (Comment added) made by loubyansky
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=722539&group_id=22866

Category: JBossCMP
Group: v3.2
>Status: Closed
>Resolution: Fixed
Priority: 5
Submitted By: Simone (milasx)
>Assigned to: Alexey Loubyansky (loubyansky)
Summary: JDBCOptimisticLocking looses preload data

Initial Comment:
In the following scenario, when using
JDBCOptimisticLocking, 

startTransaction 
 Collection c = findSomeStuff();
 for(Iterator iter = c.iterator(); iter.hasNext(); )
 {
     MyEJB e = (MyEJB)iter.next();
     log.info(e.getMyStuff);
 }
 commitTransaction

All the preload data is lost after each iteration of
the loop.

----------------------------------------------------------------------

>Comment By: Alexey Loubyansky (loubyansky)
Date: 2003-05-27 19:38

Message:
Logged In: YES 
user_id=543482

Fixed.

alex

----------------------------------------------------------------------

Comment By: Simone (milasx)
Date: 2003-05-15 13:35

Message:
Logged In: YES 
user_id=698828

Is it clear enough now?  Please let me know.
Thanks!

----------------------------------------------------------------------

Comment By: Simone (milasx)
Date: 2003-05-07 12:01

Message:
Logged In: YES 
user_id=698828

Assumptions:
    The finder method finds 100 entities
    We use a read-ahead with page size of 50

Under this assumpions JBoss should issue 2 select statements
to retrieve all the Entities.  What actually happens is that
JBoss correctely issues an SQL statements to preload 50
Entities:
SELECT from table .... WHERE PK=1st AND PK=2nd .... AND
PK=50th and loads all the 50 Entities.
Then reads the first Entity.getStuff().
On the next loops iteration when doing Entity.getStuff() for
PK=2nd does not find the preloaded data (lost!) and issues
anothe SQL statements now from 2 to 51 and so on for a total
of 100 SQL Select each loading 50 Entities and loosing all
of them after each iteration.

----------------------------------------------------------------------

Comment By: Anil Saldhana (osdchicago)
Date: 2003-05-07 03:26

Message:
Logged In: YES 
user_id=768753

Can you elaborate on this problem? 

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=722539&group_id=22866


-------------------------------------------------------
This SF.net email is sponsored by: ObjectStore.
If flattening out C++ or Java code to make your application fit in a
relational database is painful, don't do it! Check out ObjectStore.
Now part of Progress Software. http://www.objectstore.net/sourceforge
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

Reply via email to