File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Spring and the fly likes SimpleJdbcCall vs. StoredProcedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Frameworks » Spring
Bookmark "SimpleJdbcCall vs. StoredProcedure" Watch "SimpleJdbcCall vs. StoredProcedure" New topic

SimpleJdbcCall vs. StoredProcedure

John Lin

Joined: Feb 22, 2008
Posts: 17

I have some questions about the SimpleJdbcCall class which is one of new classes introduced in 2.5.

1) what are the differences between SimpleJdbcCall and SqlCall/StoredProcedure?

2) Is SimpleJdbcCall preferred since it's new in 2.5?

3) Since SqlCall/StoredProcedure are NOT deprecated, I wonder in what situations SqlCall/StoredProcedure are expected to be used instead of SimpleJdbcCall.

4) Are there anything new in 2.5 to SqlQuery/SqlUpdate as SimpleJdbcCall to SqlCall/StoredProcedure?

(I have posted these questions on Spring forum but no one has replied to it yet...)
I agree. Here's the link:
subject: SimpleJdbcCall vs. StoredProcedure
Similar Threads
How to read object collection as an out parameter of stored procedure(Oracle)?
stored procedures
Spring JDBC and ORACLE: Looking for a way to pass a BOOLEAN to a stored procedure
Execute pl/sql function which is having bind variables in java
How to call Stored Procedure using jdbcTemplate and store result in object DTO/String/List/Result se