Accessing java.sql.ResultSet via jxpath

[Jo...@gmx.de]

Hello,

we are thinking how a multi-line result from an SQL-query can be passed
efficiently from the logic layer to the flow layer.
One possibility, that currently works, is to build a List of Java objects 
(one for each row) and access this List via jxpath in the view.

In the view we then have for example:

       <jpath:for-each select="users/list">
                <jpath:value-of select="userName"/>
                <jpath:value-of select="firstName"/>
                <jpath:value-of select="lastName"/>
        </jpath:for-each>       


Unfortunately it is not very efficient to build a new array of Objects, just
to pass the information from the ResultSet to the view layer.

As an alternative we currently try to extend jxpath to be able to handle
java.sql.ResultSet directly.

Is anybody else working on this already, or are other ways to solve the
problem?

Best regards,
Johannes Hofmann

-- 
+++ GMX - Mail, Messaging & more  http://www.gmx.net +++
NEU: Mit GMX ins Internet. Rund um die Uhr für 1 ct/ Min. surfen!


---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org