How to call a Stored Procedure from JDBC?
Answers were Sorted based on User's Feedback
Answer / rama krishna dwadasi
By using CallableStatement we can call a stored Procedure
from JDBC
CallableStatement:- is an interface available in java.sql
package and is extending PreparedStatement interface.
•It is used to execute stored procedures available in the
database.
•Following is the way to create the CallableStatement object.
a)CallableStatement cs = con.prepareCall(sql);
b)CallableStatement cs = con.prepareCall(sql,int,int);
•One CallableStatement object can be used to invoke one
stored procedure only.
•CallableStatement also provides placeholder mechanism
•Following is the way to invoke the stored procedure.
CallableStatement cs = con.prepareCall(“{call p1 (?,?)}”);
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / gajendra
We can use CallableStatement interface to call a stored
procedure.Use the following steps.
1. crate the escape syntax like
String sql="{call procname(?,?,?);
2.CallableStatement cst=con.prepareCall(sql);
3.Set the inparameters using setXXX methods like
cst.setInt(1,10);
cst.setString(2,"abc");
4.Register the out parameter
cst.registerOutParameter(1,Types.Float);
5.Submit the statement using
cst.execute();
6. We can get the data from stored procedure using getXXX
methods
Is This Answer Correct ? | 4 Yes | 4 No |
What is string array?
why Java does not support multiple inheritances?
difference between byte stream class and character stream class?
How the elements are organized in BorderLayout?
Why are the methods of the Math class are static?
Where is const variable stored?
Explain about automatic type conversion in java?
What is the locale class in java programming?
How much is a java license?
Does java support Operator Overloading?
You're given a Boolean 2D matrix, can you find the number of islands?
Why charat is used in java?