0

I try to connect to oracle db (v19) via oracle's r2dbc driver and spring data r2dbc but receive Failed to obtain R2DBC Connection error. Did not observe any item or terminal signal within 10000ms in 'Connection Allocation'

I suspect that my r2dbc-pool configuration is not correct. I tried several combinations but none of them fixed the issue. I referred this issue https://github.com/spring-projects/spring-data-r2dbc/issues/810, and adjusted my pool configuration, but it didn't work. I increased max-create-connection-time but i didn't work also.

Spring Boot version: 3.0.1 Spring Boot Data R2DBC: 3.0.0 Project Reactor: 3.5.1 R2DBC SPI: 1.0.0.RELEASE R2DBC Pool: 1.0.0.RELEASE JDK version: 17 this my configuration which I use for connection.

  r2dbc:
    name: demo-db
    url: r2dbc:oracle://192.168.1.98:1521/testdb
    username: testdb
    password: testdb
    pool:
      enabled: true
      initial-size: 10
      validation-query: SELECT 1 FROM DUAL
      max-life-time: 120000
      max-create-connection-time: 10000
      validation-depth: remote
ilham
  • 33
  • 5
  • I replaced the JDK provider with amazon coretto 17.0.6 and it worked. I was using OpenJDK 17.0.1-jdk-slim-ca version previously. – ilham Feb 03 '23 at 10:44

0 Answers0