aspose file tools*
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


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30352
    
150

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


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Stefan Evans
Bartender

Joined: Jul 06, 2005
Posts: 1018
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: 61043
    
  66

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 agree. Here's the link: http://aspose.com/file-tools
 
subject: JSTL SQL