Skip to content

Re-enable JdbcAggregateTemplateSchemaIntegrationTests for Oracle #2362

Open

Description

@mp911de

After upgrading the Oracle driver to 23.26.3.0.0 (#2358), the test started to fail in the context of multi-schema key generation.

[ERROR] org.springframework.data.jdbc.core.JdbcAggregateTemplateSchemaIntegrationTests.insertFindUpdateDelete -- Time elapsed: 0.009 s <<< ERROR!
  org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [INSERT INTO "OTHER"."DUMMY_ENTITY" ("NAME") VALUES (?)]
  	at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:112)
  	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:102)
  	at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1549)
  	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:689)
  	at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:997)
  	at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.update(NamedParameterJdbcTemplate.java:367)
  	at org.springframework.data.jdbc.core.convert.IdGeneratingInsertStrategy.execute(IdGeneratingInsertStrategy.java:65)
  	at org.springframework.data.jdbc.core.convert.DefaultDataAccessStrategy.insert(DefaultDataAccessStrategy.java:133)
  	at org.springframework.data.jdbc.core.JdbcAggregateChangeExecutionContext.executeInsertRoot(JdbcAggregateChangeExecutionContext.java:76)
  	at org.springframework.data.jdbc.core.AggregateChangeExecutor.execute(AggregateChangeExecutor.java:89)
  	at org.springframework.data.jdbc.core.AggregateChangeExecutor.lambda$executeSave$0(AggregateChangeExecutor.java:62)
  	at java.base/java.util.ArrayList.forEach(ArrayList.java:1511)
  	at org.springframework.data.relational.core.conversion.SaveBatchingAggregateChange.forEachAction(SaveBatchingAggregateChange.java:70)
  	at org.springframework.data.jdbc.core.AggregateChangeExecutor.executeSave(AggregateChangeExecutor.java:62)
  	at org.springframework.data.jdbc.core.JdbcAggregateTemplate.performSave(JdbcAggregateTemplate.java:598)
  	at org.springframework.data.jdbc.core.JdbcAggregateTemplate.save(JdbcAggregateTemplate.java:211)
  	at org.springframework.data.jdbc.core.JdbcAggregateTemplateSchemaIntegrationTests.insertFindUpdateDelete(JdbcAggregateTemplateSchemaIntegrationTests.java:50)
  Caused by: java.sql.SQLSyntaxErrorException: ORA-04043: Object "OTHER" does not exist.
  
  https://docs.oracle.com/error-help/db/ora-04043/
  	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:719)
  	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:614)
  	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:609)
  	at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:1687)
  	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:972)
  	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:788)
  	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:241)
  	at oracle.jdbc.driver.T4C8Odsy.doODSY(T4C8Odsy.java:211)
  	at oracle.jdbc.driver.T4C8Odsy.doODSYTable(T4C8Odsy.java:150)
  	at oracle.jdbc.driver.T4CConnection.getColumnMetaData(T4CConnection.java:9203)
  	at oracle.jdbc.driver.T4CConnection.doDescribeTable(T4CConnection.java:9191)
  	at oracle.jdbc.driver.AutoKeyInfo.initialize(AutoKeyInfo.java:553)
  	at oracle.jdbc.driver.OraclePreparedStatement.initializeAutoKeyInfo(OraclePreparedStatement.java:12399)
  	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3966)
  	at oracle.jdbc.driver.OraclePreparedStatement.doExecuteLargeUpdate(OraclePreparedStatement.java:4352)
  	at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:4329)
  	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:4304)
  	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1008)
  	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
  	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
  	at org.springframework.jdbc.core.JdbcTemplate.lambda$update$1(JdbcTemplate.java:998)
  	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:670)
  	... 13 more

Activity

  1. schauder commented on Aug 11, 2026

    @schauder
    Contributor

    This is caused by a bug in the Oracle JDBC driver. See https://github.com/schauder/bug-oracle-id-generation-cross-schema-with-quoted-names for a Reproducer.

  2. self-assigned this
    on Aug 13, 2026
  3. schauder commented on Aug 13, 2026

    @schauder
    Contributor

    Paul Parkinson created a Bug 39871134 in Oracles internal Bug tracker for us.

  4. loiclefevre commented on Sep 24, 2026

    @loiclefevre
    Contributor

    Paul Parkinson created a Bug 39871134 in Oracles internal Bug tracker for us.

    bug fix should come in next October release of the JDBC driver...

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions