Interested to Buy Any Domain ? << Click Here >> for more details...
callable is interface or class ?
- 9 Answers
- 17384 Views
- Fidelity, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mrangababu
callable is an interface . purpose is to call procedures.
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / anjani kumar jha
always remember,there r three types of statement interface
in java
1)statement
2)prepared statement
3)callable statement
| Is This Answer Correct ? | 7 Yes | 1 No |
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 |
Answer / kuldeep raaj sharma
The Statement is an interface and its subclasses are
PreparedStatement and CallableStatement.
The Statement interface defines methods for executing SQL
statements that do not contain parameter markers. The
PreparedStatement interface adds methods for setting input
parameters, and the CallableStatement interface adds
methods for retrieving output parameter values returned
from stored procedures.
The CallableStatement interface extends PreparedStatement
with methods for executing and retrieving results from
stored procedures.
Creating a CallableStatement Object
As with Statement and PreparedStatement objects,
CallableStatement objects are created by Connection
objects. CODE EXAMPLE 13-18 shows the creation of a
CallableStatement object for calling the stored
procedure ‘validate’, which has a return parameter and two
other parameters.
CallableStatement cstmt = conn.prepareCall(
“{? = call validate(?, ?)}”);
Setting Parameters
CallableStatement objects may take three types of
parameters: IN, OUT, and
INOUT. The parameter can be specified as either an ordinal
parameter or a named
parameter. A value must be set for each parameter marker in
the statement.
The number, type, and attributes of parameters to a stored
procedure can be
determined using the DatabaseMetaData method
getProcedureColumns.
Parameter ordinals, which are integers passed to the
approriate setter method, refer to the parameter markers
("?") in the statement, starting at one. Literal parameter
values in the statement do not increment the ordinal value
of the parameter markers.
In CODE EXAMPLE the two parameter markers have the ordinal
values 1 and 2.
CallableStatement cstmt = con.prepareCall(
"{CALL PROC(?, "Literal_Value", ?)}");
cstmt.setString(1, "First");
cstmt.setString(2, "Third");
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / samsudeen
its interface , used for call the procedure, and able to
call the query
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / anjani kumar jha
yes
1)statement
2)prepared statement
3)callable statement
all r interface
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / vikaas
Callable is an Interface, used to call Stored Procedures.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is a rollback in jdbc?
Differentiate between a statement and a preparedstatement.
What is a statement in java?
What is JDBC ResultSet?
How to move the cursor in scrollable resultset ?
Is jdbc faster than hibernate?
Can we have foreign key reference to a non primary key column ?
Why is jdbc used?
Explain how to make updates to the updatable resultsets.
Explain about Join?
What is setautocommit in jdbc?
what is the best way, in terms of performance, to do multiple insert/update statements, a PreparedStatement or Batch Updates?
Core Java 
