Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes Struts and the fly likes using StoredProcedure inside struts Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "using StoredProcedure inside struts" Watch "using StoredProcedure inside struts" New topic
Author

using StoredProcedure inside struts

jagan bisoyi
Greenhorn

Joined: Mar 09, 2008
Posts: 15
Hi guys!

I am currently accessing database using datasource inside struts enabled application. I am also writing all SQL codes inside my java program.
now i want to use stored procedure inside my application so that my java codes will look simple.any Idea? pls. I am using netbeans6.0+struts2+SQLserver2005

thanks in advance. :roll: :roll: :roll:
Merrill Higginson
Ranch Hand

Joined: Feb 15, 2005
Posts: 4864
You access stored procedures through the java.sql.CallableStatement interface. This is no different in a Struts application than it is in any other Java application using the JDBC API.

JavaRanch has a forum devoted to JDBC. If you have more detailed questions about stored procedures, it would probably be best to ask them in that forum.
[ April 03, 2008: Message edited by: Merrill Higginson ]

Merrill
Consultant, Sima Solutions
jagan bisoyi
Greenhorn

Joined: Mar 09, 2008
Posts: 15
Originally posted by Merrill Higginson:
You access stored procedures through the java.sql.CallableStatement interface. This is no different in a Struts application than it is in any other Java application using the JDBC API.

JavaRanch has a forum devoted to JDBC. If you have more detailed questions about stored procedures, it would probably be best to ask them in that forum.

[ April 03, 2008: Message edited by: Merrill Higginson ]
jagan bisoyi
Greenhorn

Joined: Mar 09, 2008
Posts: 15
Hi Merrill!

Thanks to have a quick reply.I got my solution.Best of luck!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: using StoredProcedure inside struts
 
Similar Threads
How can I have a TAB inside my JSP
Code Samples !!
Configuring org.apache.commons.pool.impl.GenericObjectPool
does not contain handler parameter named 'method'. This may be caused by whitespace
Problem in config. JPA in JBOSS