Deprecate SimpleJdbcTemplate in favor of JdbcTemplate [SPR-6922]

[spring-projects-issues]

Chris Beams opened SPR-6922 and commented

also add public int[] batchUpdate(String sql, List<Object[]> batchArgs) as well as any other methods that exist only on SimpleJdbcTemplate at that time.

---

Issue Links:

• Merge JdbcTemplate and SimpleJdbcTemplate, deprecate SimpleJdbcTemplate [SPR-6440] #11106 Merge JdbcTemplate and SimpleJdbcTemplate, deprecate SimpleJdbcTemplate ("is duplicated by")
• Deprecate SimpleJdbcTestUtils in favor of JdbcTestUtils [SPR-9235] #13873 Deprecate SimpleJdbcTestUtils in favor of JdbcTestUtils
• Delete deprecated SimpleJdbc* classes [SPR-11895] #16514 Delete deprecated SimpleJdbc* classes
• Provide JdbcTemplate in abstract transactional base classes in the TestContext framework [SPR-8990] #13630 Provide JdbcTemplate in abstract transactional base classes in the TestContext framework

Referenced from: commits f5f738f

[spring-projects-issues]

adrian commented

Hello,

I want just to better understand this issue SimpleJdbcTemplate is being deprecated.

So :

• when using named parameters in my sql, I should use NamedParameterJdbcTemplate ? Or will it be deprecated to ?
• when I don't need named parameters, yoyu confirm I should just use JdbcTemplate ?

Thanks for the info !

[spring-projects-issues]

Thomas Risberg commented

Hi Adrian,

Yes to both. NamedParameterJdbcTemplate is remaining and should be used for named parameter use. If you don't want to create two templates you can always call getJdbcOperations() on the NamedParameterJdbcTemplate to get access to the regular JdbcOperations interface of the JdbcTemplate.

The SimpleJdbcTemplate was initially added to provide some Java 5 syntax sugar and we later added the named parameter support. There really is no need for three different template implementations any longer.

So, use the JdbcTemplate unless you need the named parameter support in which case you should use the NamedParameterJdbcTemplate.

-Thomas

[spring-projects-issues]

adrian commented

Thanks very much Thomas for the explanation

[spring-projects-issues]

Hans Desmet commented

Does this mean SimpleJdbcInsert will also be deprecated ? I don't know of methods as convenient as the simpleJdbcInsert methods in JdbcTemplate.

[spring-projects-issues]

Thomas Risberg commented

No, SimpleJdbcInsert and SimpleJdbcCall will remain. Like you said there is no other implementation that provides these features. SimpleJdbcTemplate was the odd man out since its feature set was mostly replicated in JdbcTemplate and NamedParameterJdbcTemplate.

-Thomas

[spring-projects-issues]

Srinivasan Duraiswamy commented

org.springframework.test.context.junit4.AbstractTransactionalJUnit4SpringContextTests still uses SimpleJdbcTemplate. May I know when this class will be updated to using JdbcTemplate?
Spring version : 3.1.0 M2

[spring-projects-issues]

Chris Beams commented

@Srinivasan - feel free to open a new issue about this, but no further action will be taken on this particular issue.