• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JSTL SQL

 
Tome Wagese
Greenhorn
Posts: 24
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 34870
369
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think this is more about JSTL than JDBC so I'm moving the thread to our JSP forum.
 
Stefan Evans
Bartender
Posts: 1782
10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 65129
92
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Tome Wagese
Greenhorn
Posts: 24
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic