Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

asynchronous pl/sql call from JSP  RSS feed

 
Kanu Dialani
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a situation where i need to make a asynchronous ps/sql stored proc. call from my JSP page (I just have JSP pages in the APP). When the user clicks on a link (hyperlink1.jsp), this pl-sql call must be made and then the hyperlink1.jsp should be executed. I can think of the following three ways to do this.
1) Using ajax, send a request to make the pl/sql call and immediately forward to hyperlink1.jsp
2) in hyperlink1.jsp, create a new thread and make the pl/sql call.
3) create a table in DB add a trigger to it which calls the pl/sql stored proc. hyperlink1.jsp inserts a row in this table.

Please suggest which is the best way to do this.

Thank you
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 36406
454
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Kanu,
The best way to do this is to use a Servlet and not a JSP. Even more importantly, I don't see how you are making a PL/SQL call from a JSP. Do you mean you have JDBC code in your JSP?
 
Kanu Dialani
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes, i have JDBC code in a JSP. I am making changes to Oracle Apps e-business suite. the code is almost 8-10 years old. I know i should use a servlet, but the entire application is written in JSPs. This is required for client specific customization.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!