Spring-jdbc 5.0.5 NamedParameterJdbcTemplate.batchUpdate ORA-01000 [SPR-16814]

[spring-projects-issues]

Fedor opened SPR-16814 and commented

After migrating from Spring 4.1.7 to Spring 5.0.5 we have ORA-01000: maximum open cursors exceeded when using with Oracle 12c and ojdbc7-driver.

Exception raised after following code

@SuppressWarnings("unchecked")
private void updateHiddenOffers(Map<String, Object>[] updateBatchParams) {
 int[] updateResults = namedJdbcTemplate.batchUpdate(UPDATE_HIDDEN_OFFER_SQL, updateBatchParams);

The issue is very similar to #20687. 

But we dont have ability to update ojdbc driver.

Is it fixed in 5.0.6 version?

---

Affects: 5.0.5

Issue Links:

• Doc: ParameterMetaData.getParameterType performance on Oracle 12c [SPR-16139] #20687 Doc: ParameterMetaData.getParameterType performance on Oracle 12c

[spring-projects-issues]

Juergen Hoeller commented

There hasn't been any recent work on this. Since this is effectively a bug in the Oracle JDBC driver, I'm afraid we won't be introducing a workaround for an older driver at this point.

You could try setting spring.jdbc.getParameterType.ignore=true as a system property on in a spring.properties file in the root of your classpath, or use spring-jdbc-4.3.17 for the time being... with all other jars set to 5.0.6 (which isn't officially supported but should work fine in practice). I strongly recommend upgrading the JDBC driver though.