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 are the different types of interfaces in the api component?

958

---

Does jpa use jdbc?

904

---

What is the benefit of having jdbcrowset implementation? Why do we need a jdbcrowset like wrapper around resultset?

935

---

Explain the difference between resultset and rowset in jdbc

985

---

What is the use of statement in jdbc?

904

---

How do I retrieve a whole row of data at once, instead of calling an individual ResultSet.getXXX method for each column?

1041

---

What does the jdbc resultset interface?

954

---

What are the benefits of PreparedStatement over Statement?

993

---

what is the meaning of following code snippets Class c=class.forName(driverClassName); Driver d=(driver)c.newInstance();

5012

---

What are restrictions on triggers?

2201

---

What is statement and preparedstatement in java?

853

---

What are drivers available?

1006

---

What is a jdbc connection?

878

---

What are 4 drivers available in JDBC? At what situation are four of the drivers used?

937

---

How can I know when I reach the last record in a table, since JDBC doesn't provide an EOF method?

971

---