about JDO query filter

[AMELIN Franck]

Hi all,

Here is a sample code  using org.apache.ojb.tutorial5.Product class.

javax.jdo.PersistenceManagerFactory factory = new 
org.apache.ojb.jdori.sql.OjbStorePMF();
javax.jdo.PersistenceManager manager = factory.getPersistenceManager();                
                 
manager.currentTransaction().begin();
javax.jdo.Query query = manager.newQuery(Product.class);
query.setFilter("stock < 30000");
java.util.Collection allProducts = (java.util.Collection)query.execute(); 

java.util.Iterator iter = allProducts.iterator();
if (! iter.hasNext())
{
    System.out.println("No Product entries found!");    
}
while (iter.hasNext())
{
    System.out.println(iter.next());
}
manager.currentTransaction().commit();


It works but  if my table is very big (30 000 enr.)  it's very long 
because the executed query is "SELECT A0.STOCK,A0.PRICE,A0.NAME,A0.ID FROM PRODUCT A0"
This code construct all object Product instances and then apply my filter on the 
object collection.

Is there a way to have the same result but with the sql query : 
        "SELECT A0.STOCK,A0.PRICE,A0.NAME,A0.ID FROM PRODUCT A0 WHERE STOCK < 30000"

Regards,

Franck



--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>