Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

calling stored prodecure

 
agape jurose
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I know I should be using Servlets instead of JSP but I am trying to do a datatable using stored prodecure. Before even making a table I am not even getting any results. I've tried different sql query because I am thinking maybe the syntax is not right, but nothing wrong...I am missing something ?





I asked this question here http://stackoverflow.com/questions/22978212/stored-procedure-is-not-displaying-results-in-jsp
 
Paul Clapham
Sheriff
Posts: 21579
33
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Looks like the people over there suggested you might be ignoring a ResultSet which the stored procedure returns. But your response seemed to imply that you had no idea whether it was supposed to return a ResultSet or not. So, you ought to find that out. If it does, then you should certainly use a method which returns that ResultSet instead of the method you did use. If not, then the next step is to find out what it does return, if anything.
 
agape jurose
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Paul Clapham wrote:Looks like the people over there suggested you might be ignoring a ResultSet which the stored procedure returns. But your response seemed to imply that you had no idea whether it was supposed to return a ResultSet or not. So, you ought to find that out. If it does, then you should certainly use a method which returns that ResultSet instead of the method you did use. If not, then the next step is to find out what it does return, if anything.



well I thought you would use CallableStatement instead of ResultSet, but I will try it
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic