This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
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
Author

JSTL SQL

Tome Wagese
Greenhorn

Joined: Jan 13, 2007
Posts: 24
Greetings,

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.
Thanks.
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 32481
    
214

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
Bartender

Joined: Jul 06, 2005
Posts: 1517
    
    6
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
Marshal

Joined: Jan 10, 2002
Posts: 63211
    
  69

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] [Bear's FrontMan] [About Bear] [Books by Bear]
Tome Wagese
Greenhorn

Joined: Jan 13, 2007
Posts: 24
Thank.
 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: JSTL SQL
 
It's not a secret anymore!