aspose file tools*
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
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
Problem in config. JPA in JBOSS
How can I have a TAB inside my JSP
Configuring org.apache.commons.pool.impl.GenericObjectPool
Code Samples !!
does not contain handler parameter named 'method'. This may be caused by whitespace