[DaGuy]

I'm really stuck with this one.

1. After querying an Oracle database (backend) via a Servlet (in the middle tier), I get an object of type ResultSet.

2. I place that object of type ResultSet in the session.

3. I can verify that such object made it into the session.

4. From a frontend JSP (that shares the above session), I need to display the results of the query.

So far this has been a great challenge...

Can someone provide a code snipplet on this matter? I tried various taglibs without success... I guess the issue is knowing how to iterate through that object. The taglibs that I've seen require you do the query from the presentation layer and I'm trying to avoid that (see 1 above). Thanks in advance.

[neoTony]

You need to enumerate the resultset:

while (ResultSet.next()) {

Use the ResultSet.getXXX (ResultSet.getString, etc) methods to retrieve field info from each ResultSet result.

}

Email me if you're still having trouble, but basically, know what the format of the data you're getting back is, then use the above code to feed the information into some other container/variable.

[Kristoff]

You should really consider implementing a ValueListHandler (Pattern) from the Core J2EE patterns.