SELECT *
FROM   java.io.File
WHERE  lower (name) LIKE '%.html'
AND    length BETWEEN (10 * 1024) + (20 * 1024)
ORDER BY  lastModified DESC, length DESC

File d = new File (dirName);

Query q = new Query ();
q.parse (queryText);

QueryResults qr = q.execute (new ArrayList (d.listFiles ()));

SELECT * result
FROM   GoogleSearchResultWrapper
GROUP BY  urlObj.host
GROUP BY ORDER :_allobjs.size DESC
EXECUTE ON GROUP_BY_RESULTS avg (cachedSizeAsInt) cachedAvgSize

GoogleSearch search = new GoogleSearch();

// Set mandatory attributes.
search.setKey("000000000000000000000000");

// Set the query string.
search.setQueryString("josql+site%3Asourceforge.net+OR+site%3Afreshmeat.net");

// Invoke the actual search
GoogleSearchResult result = search.doSearch();    

// Get the result.
GoogleSearchResultElement[] els = result.getResultElements ();

List l = new ArrayList ();

// Convert to our wrapper object and prepare for JoSQL call.
for (int i = 0; i < els.length i++)
{

    l.add (new GoogleSearchResultWrapper (els[i]));

}

Query q = new Query ();
q.parse (queryText);

QueryResults qr = q.execute (l);

// Now iterate over the results.
List josqlRes = qr.getResults ();

// Note: here we are iterating over the group by results, so each list
// here will contain a single column that is the "host".
for (int i = 0; i < josqlRes.size (); i++)
{

    List h = josqlRes.get (i);

    String host = h.get (0);

    // Get the results associated with this host.
    List hostResults = (Map) qr.getGroupByResults ().get (h);

    // Get the save values associated with this host.
    Map saveValues = qr.getGroupBySaveValues (h);

    // Get the average cache size.
    double avgCacheSize = ((Number) saveValues.get ("avgCacheSize")).doubleValue ();

    // Now do something with the results!

}

SELECT DISTINCT urlObj.host
FROM   GoogleSearchResultWrapper

SELECT * 
FROM   java.lang.StackTraceElement
WHERE  className LIKE 'org.josql.%'

public static Exception filterAndRethrow (Exception e)
{

   // Assume that the query has been parsed already when the class was inited.
   try
   {

       QueryResult qr = stackTraceFilterQuery.execute (Arrays.asList (e.getStackTrace ()));

       // Note: this line probably won't work, for some reason I haven't been
       // able to cast to a "StackTracElement[]", if anyone can explain 
       // why please let me know!
       e.setStackTrace ((StackTraceElement[]) qr.getResults ().toArray ());

   } catch (Exception ex) {

       // Just throw the exception we have been unable to filter and
       // we are already (probably) in an error chain so it's not wise to
       // "lose" this exception by throwing a JoSQL problem which should
       // be handled by another mechanism.

   }

   throw e;

}

/**
 * Note: we assume here that the listener interface is called: ObjectListener
 * and events of type: ObjectEvent will be dispatched to the listener via a:
 * handleEvent method.
 *
 * The mechanism would be the same for ANY type of object used to capture
 * details about an "event".  
 *
 * It is also possible (of course) to create a configurable dispatcher that allows
 * configuration of the specific event method to be fired, but that is beyond the
 * scope of this discussion!
 */
public class RuleEventDispatcher 
{

   private Map listeners = new LinkedHashMap ();

   /**
    * The method needs to be synchronized because JoSQL query objects are
    * NOT thread-safe.
    *
    * @param o The event object.
    * @throws JoSQLExecutionException If the where clause cannot be evaluated against
    *                                 the event object.
    */
   public synchronized void fireEvent (ObjectEvent o)
                                       throws      JoSQLExecutionException
   {

       Iterator iter = this.listeners.keySet ().iterator ();

       while (iter.hasNext ())
       {

           ObjectListener ol = (ObjectListener) iter.next ();

           DefaultObjectFilter dof = (DefaultObjectFilter) this.listeners.get (ol);

           // See if the listener is interested in this event.
           if (dof.accept (o))
           {

               // Yes they are, send them the event.
               ol.handleEvent (o);

           } else {

               // See if an exception has occurred.
               if (dof.getException () != null)
               {

                  // Wrap the exception to provide more details.
                  JoSQLExecutionException ee = 
                     new JoSQLExecutionException ("Unable to execute WHERE clause for listener: " +
                                                  ol.getClass ().getName () + 
                                                  " against event: " +
                                                  o.getClass ().getName () + 
                                                  " using statement: " +
                                                  dof.getQuery (),
                                                  dof.getException ());

                  // Reset the exception.
                  dof.clearException ();

                  throw ee;

               }

           }

       }

   }

   public synchronized void addListener (ObjectListener o,
                                         String         whereClause)
                                         throws         JoSQLParseException
   {

      DefaultObjectFilter f = new DefaultObjectFilter (whereClause,
                                                       ObjectEvent.class);

      this.listeners.put (o,
                          f);
           
   }

   public synchronized void removeListener (ObjectListener o)
   {

       this.listeners.remove (o);

   }

}