File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JSP and the fly likes JSTL SQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSP
Bookmark "JSTL SQL" Watch "JSTL SQL" New topic


Tome Wagese

Joined: Jan 13, 2007
Posts: 24

I am using JSTL to execute stored procedure.
Everything is cool except I do not see a way to do multiple result sets.
My Stored Procedure returns more multiple/ Unknown result sets.
Please advice.
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33130

I think this is more about JSTL than JDBC so I'm moving the thread to our JSP forum.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Stefan Evans

Joined: Jul 06, 2005
Posts: 1580
There is no way to do this with JSTL.
The JSTL sql support is minimal, and intended only for small/simple applications and prototyping.

If you're returning multiple result sets your app is probably not trivial
Most likely you will have to write some java code to do this for you.
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63868

Indeed, even the framers of the JSTL Specification essentially say "Don't use the SQL tags in anything real".

You'd be best served to factor the database access for your web application into a proper MVC pattern.

This article might be helpful in learning about web application structure patterns and techniques.

[Asking smart questions] [About Bear] [Books by Bear]
Tome Wagese

Joined: Jan 13, 2007
Posts: 24
I agree. Here's the link:
subject: JSTL SQL
It's not a secret anymore!