• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

using StoredProcedure inside struts

 
jagan bisoyi
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 4864
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Merrill!

Thanks to have a quick reply.I got my solution.Best of luck!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic