Hi,
Environment:
-----------
JBoss 3.0.6, EJB 2.0, CMP 2.0
Problem:
---------
Transaction is failing when trying to retrieve data with many records. It times out or rolls back
Description:
-------------
I have a session bean A that needs to return some results packaged in a stub to the client. It gets the results by using a finder method on an entity bean.
Each of the record contains 3 CMF's of type java.net.InetAddress. What i noticed is if the finder method yields more than 40 records i get a transaction roll back or timed out.
The finder method returns a collection, i can even print the size of the collection as below,
Collection coll = sessionBean.findByXYZ(xyz);
System.out.println("The size of collection is " + coll.size() );
I can even get the local interface objects from the collection but cant seem to do any more operation on that object
Can somebody point me in right direction ? Also is there a way i can get only a part of the result set ? As i am using CMP i assume i will not have flexibility to get only a fixed number of records ?
Also, i know about increasing the transaction time out in the xml files but wouldnt really help me, cuz there might be any number of records resulting from finder method
Regards
Meka Toka
