Answer / 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 connection pooling?

6 Answers   Wipro,

---

Why resultset is used in java?

0 Answers  

---

What is ODBC and JDBC? How do you connect the Database?

0 Answers  

---

What is the limitation of PreparedStatement and how to overcome it?

0 Answers  

---

Does jdbc use odbc?

0 Answers  

---

What is batch processing and how to perform batch processing in jdbc?

0 Answers  

---

What are the different types of lockings in jdbc?

0 Answers  

---

How do we call a stored procedure from jdbc?

0 Answers  

---

java.lang.ClassNotFoundException:oracle.jdbc.driver.OracleDr iver? I get this error at run time.I used oracle10G. I set CLASS PATH:C:\oraclexe\app\oracle\product\10.2.0 \server\jdbc\lib\ojdbc14.jar; I write JDBC PROGRAM like import java.sql.*; class Example { public static void main(String args[]) { try { Class.forName ("oracle.jdbc.driver.OracleDriver"); System.out.println("Driver Loaded"); Connection con=DriverManager.getConnection ("jdbc:oracle:thin:@localhost:1521:xe","system","salmas"); System.out.println("Driver Connected"); Statement st=con.createStatement(); ResultSet rs=st.executeQuery("select * from emp"); while(rs.next()) { System.out.println(rs.getInt(1)); System.out.println(rs.getString(2)); System.out.println(rs.getString(3)); } st.close(); con.close(); } catch(Exception e) { System.out.println(e); } finally { System.out.println("it's finally block executed"); } } }

6 Answers   CTS,

---

What do you understand by DDL and DML statements?

0 Answers  

---

What is jdbc databasemetadata interface?

0 Answers  

---

Can I set up a connection pool with multiple user IDs? The single ID we are forced to use causes problems when debugging the DBMS.

0 Answers  

---