using StoredProcedure inside struts

[jagan bisoyi]

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]

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]

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]

Hi Merrill!

Thanks to have a quick reply.I got my solution.Best of luck!