cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Adam Ratcliffe" <a...@premasys.com>
Subject Best practice for database access in flow layer
Date Sun, 27 Jun 2004 02:10:09 GMT
I'm looking for a little direction on the most appropriate way to access
a database from the flow layer.
My application requires read-only access to the database only so an O/R
type approach would probably be
overkill.

What I would like to do in the flow layer is something like the
following psuedo code. Do a select query
against the database using a java component.  Test the returned
collection to see if it contains any
elements and use that test to determine whether redisplay the current
page or to break out of the
recursive loop.

Any suggestions?

function searchCategories(locType, class1, class2) {
    var categories = Search.searchCategories(locType, class1, class2);
    if(categories != null) {
       // if search returned categories, search again on expanded
categories
       cocoon.sendPageAndWait("page/showCategories.xml", {"categories" :
categories} );
 
       // when user request arrives
       class1 = cocoon.request.getParameter("class1");
       class2 = cocoon.request.getParameter("class2");
 
       // recursively calls itself with 
       searchCategories(locType, class1, class2);
    }
}


Mime
View raw message