What is a Stored Procedure and how do you call it in JDBC?

1.	What is a Stored Procedure and how do you call it in JDBC?
Answer» A stored procedure is a group of SQL statements that form a logical unit and perform a particular task. For example operations on an employee database (hire, fire, promote, lookup) could be coded as stored procedures executed by application code. Stored procedures can be called using CallableStatement class in JDBC API. For example the following code demonstrates this CallableStatement cs = con.prepareCall("{call MY_SAMPLE_STORED_PROC}");ResultSet rs = cs.executeQuery();

Answer»

A stored procedure is a group of SQL statements that form a logical unit and perform a particular task. For example operations on an employee database (hire, fire, promote, lookup) could be coded as stored procedures executed by application code. Stored procedures can be called using CallableStatement class in JDBC API. For example the following code demonstrates this

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

Discussion

No Comment Found

Related InterviewSolutions

What is difference between JDBC, JNDI and Hibernate?
How to Connect to an Excel Spreadsheet using JDBC in Java?
What is Metadata and why should you use it?
Which isolation level prevents dirty read in JDBC, connection class?
What is a "dirty read"?
What are different types of RowSet objects?
What is a RowSet?
What we set the attribute Concurrency in ResultSet?
When you say Class.forName() loads the driver class, does it mean it imports the driver class using import statement?
What does the Class.forName("MyClass") do?

What is a Stored Procedure and how do you call it in JDBC?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment