Answer Posted / hazarath k
Yes Callable is an interface. Actually 3 ineterfaces are
provided in java for retreiving the data from DB.Those are:
1.Statement
2.PreparedStatement
3.Callable Statement
Every vendor provide their own implementations for these
interfaces.
If we use Statement object, then the SQL query is parsed
and executed each and every time when the request comes.
If the SQL statement is same but with different values <--
in this scenario no need of parsing each time,only
execution is needed, because same statement is sending to
the server several times but with different values.In this
scenario it is better to parse the statement for first time
only, later onwards it is better to send only values. So in
this situations, it is better to go for
PreparedStatement.It increases the speed also.
If you are planing to call the stored procedures from front
end, then it is better to use Callable statement.
EX(syntax):
Connection con=DriverManager.getConnection("----
","userID","pwd"):
CallableStatement cstmt=con.prepareCall('{call
procedureName}');
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is difference between statement and preparedstatement in jdbc?
What are the common jdbc exceptions?
What are the jdbc statements?
What class.forname will do while loading drivers of jdbc?
What are the advantages of using jdbc datasource?
What is a java driver?
How can you create jdbc statements?
What's the benefit for specifying constraints like not null, primary key explicitly instead of specifying it against the column ?
How many rowset are available in jdbc?
What causes the "No suitable driver" error?
What is the role of the jdbc drivermanager class?
How can we store the file in the oracle database?
Is jdbc open source?
How to use JDBC to connect Microsoft Access?
What is jdbc in java?