wood burning stoves 2.0*
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...)
subject: SimpleJdbcCall vs. StoredProcedure
Similar Threads
How to call Stored Procedure using jdbcTemplate and store result in object DTO/String/List/Result se
How to read object collection as an out parameter of stored procedure(Oracle)?
Execute pl/sql function which is having bind variables in java
Spring JDBC and ORACLE: Looking for a way to pass a BOOLEAN to a stored procedure
stored procedures