Interested to Buy Any Domain ? << Click Here >> for more details...
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
Differentiate between stored procedure and functions?
How do I check in my code whether a maximum limit of database connections have been reached?
What is jdbc odbc?
Is jdbc object oriented?
What are the considerations for deciding on transaction boundaries?
What is the meaning of connection?
Explain how to make updates to the updatable resultsets.
What is 2 phase commit?
State the three different ways in which you can create a table?
What is the benefit of having jdbcrowset implementation?
What is the benefit of having jdbcrowset implementation? Why do we need a jdbcrowset like wrapper around resultset?
How to achieve JDBC Connection Pooling using JDBC DataSource and JNDI in Apache Tomcat Server?
What do you mean by two phase commits?
Can we have foreign key reference to a non primary key column ?
What is the full form of jdbc?
