aspose file tools*
The moose likes JDBC and the fly likes How To Call Stored Procedure in JSP. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How To Call Stored Procedure in JSP." Watch "How To Call Stored Procedure in JSP." New topic

How To Call Stored Procedure in JSP.

bobby reddy

Joined: Nov 05, 2007
Posts: 27
Hello everyone,
I have written a stored procedure in Toad. Now I have to call this stored procedure in JSP. Could any one provide the url where I can find the examples of how to call the stored procedure in JSP?

Jeanne Boyarsky
internet detective

Joined: May 26, 2003
Posts: 29287

Take a look at the JDBC tutorial for callable statements.

Note that it is considered bad practice to make JDBC calls from a JSP. It is better to put this code in a Java class.

[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
I agree. Here's the link:
subject: How To Call Stored Procedure in JSP.
Similar Threads
Stored Procedure + JSP
stored procedure
Problem using Callable Statement
%rowtype mapping in java
@NamedNativeQuery and choosing the correct resultClass