There is no problem with reading the pages only ..but right after i add a
new row to the
table that the largeSelect browses it starts to get my rows doubled or
throwing
exception: java.util.ConcurrentModificationException
or just not updates the resultset (the added record is not shown)
----- Original Message -----
From: "G�schl,Siegfried" <[EMAIL PROTECTED]>
To: "Apache Torque Users List" <[EMAIL PROTECTED]>
Sent: Tuesday, January 13, 2004 12:57
Subject: RE: LargeSelect problems
Don't know if this helps
public void testLargeResultSet()
{
int resultSize1 = 0;
int resultSize2 = 0;
try
{
// Make a query with a given country and unlimited result set
Criteria criteria1 = new Criteria();
criteria1.addAscendingOrderByColumn( CountryPeer.SORTSEQUENCE );
List countryList = CountryPeer.doSelect( criteria1 );
resultSize1 = countryList.size();
// Make the same query as large select and paging through the reseult set
Criteria criteria2 = new Criteria();
criteria2.setDbName( "WEBSHOP" );
CountryPeer.addSelectColumns( criteria2 );
criteria2.addAscendingOrderByColumn( CountryPeer.SORTSEQUENCE );
LargeSelect largeSelect = new LargeSelect( criteria2, 10, 5,
CountryPeer.class.getName() );
while( largeSelect.getNextResultsAvailable() )
{
countryList = largeSelect.getNextResults();
resultSize2 = resultSize2 + countryList.size();
// System.out.println( ">>> " + largeSelect.getPageProgressText() + "
<<<" );
// System.out.println( "Got the following number of countries : " +
countryList.size() );
}
assertEquals( "The result set of a simple query and large select was
different", resultSize1, resultSize2 );
}
catch( Exception e )
{
e.printStackTrace();
fail( e.getMessage() );
}
}
-----Original Message-----
From: Bogdan Vatkov [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 13, 2004 11:23 AM
To: TORQUE_LIST
Subject: LargeSelect problems
Hi All,
I have the following code snipplet..
public List getList() {
try {
return VpbxPeer.populateObjects(businessObjectList);
} catch (Exception e) {
logError(e);
return null;
}
}
private void LoadLargeSelect(Criteria parameter) {
largeSelect = new LargeSelect(parameter, PAGE_SIZE,
PAGES_FETCH_COUNT);
largeSelect.run();
try {
largeSelect.getNextResults();
} catch (Exception e) {
logError(e);
}
}
Problem1:
After executing LoadLargeSelect() and one of the getNext/PreviuosResults
methods i have the rows doubled in my list..i've checked the debug prints of
the LargeSelect ..its rowcount is doubled itself.
- what i am doing wrong ? what might be the reason for this row duplication.
Problem2:
Too often (i use the code above in a JSP/Servlet environment) i get the
java.util.ConcurrentModificationException
when executing the getList() method.
What I am missing?
Is there any tutorial for LargeSelect (a simple example of using this
class)?
With best regards,
Bogdan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
