File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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: 29225
    
135

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: 1016
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: 60049
    
  65

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
 
Similar Threads
why we require execute() method?
IBM 484 : Stmt.execute(Str) - multiple result sets?
SQL Procedures
JPA and multiple result sets
Java servlet accessing DB2 cobol stored procedure