How do you call a Stored Procedure from JDBC?

Java database interview questions

1. How do you call a Stored Procedure from JDBC?

The first step is to create a CallableStatement object. As with Statement and PreparedStatement objects, this is done with an open Connection object. A CallableStatement object contains a call to a stored procedure.

CallableStatement cs =
con.prepareCall("{call SHOW_SUPPLIERS}");
ResultSet rs = cs.executeQuery();

(Continued on next question...)

Other Interview Questions

• How do you call a Stored Procedure from JDBC?
• Is the JDBC-ODBC Bridge multi-threaded?
• Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?
• What is cold backup, hot backup, warm backup recovery?
• When we will Denormalize data?
• What is the advantage of using PreparedStatement?
• What is a “dirty read”?
• What is Metadata and why should I use it?
• What are different types of Transaction Isolation Levels?
• What is 2-phase commit?
• How do you handle your own transaction ?
• What is the normal procedure followed by a java client to access the db.?
• What is a data source?
• What are collection pools? What are the advantages?
• How do you get Column names only for a table (SQL Server)?