Answer Posted / suresh

CallableStatement object is used to call the stored
procedure and stored procedure is nothing but it's block of
code and it's identified unique name

ex

CallableStatement cs=con.prepareCall();
cs.executeUpdate(Call"{procedure name}");


con is a Connection object
It has three parameter

IN
OUT
INOUT

IN parameter used to store any value to stored procedure
using setXX() method..

OUT parameter used to get the information or values from the
stored procedure using getXX() method,that object to
registered using registerOutParameter()

INOUT used to both store and get the information...

What is preparedstatement in jdbc?

962

---

What do you mean by two phase commits?

1085

---

What are the jdbc api components?

1154

---

What is database deadlock ? How can we avoid them?

1062

---

Explain the difference between resultset and rowset in jdbc

1010

---

How can I connect mysql or oracle with java?

967

---

What are the differences between setmaxrows(int) and setfetchsize(int)?

1067

---

What is a jdbc connection?

900

---

Does jdbc use ssl?

940

---

What is correlated subquery?

2334

---

What is the return type of execute, executequery and executeupdate?

1114

---

How can I retrieve a String or other object type without creating a new object each time?

1192

---

Explain jdbc savepoint?

982

---

How does jdbc work?

894

---

Is jdbc connection secure?

960

---