R2DBC can not read the URL of oracle database

Question

I try to config the oracle's connection by using application.properties file but it gives me an IllegalArgumentException with message "Invalid URL: r2dbc:oracle:thin:@localhost:1521:orcl", it was fine when I set with the MySql URL. Here is my application.properties:

spring.r2dbc.url=r2dbc:oracle:thin:@localhost:1521:orcl
spring.r2dbc.username=account
spring.r2dbc.password=account

please give me an explanation or solution for this, thank you.

Can you add your pom.xml or build.gradle file ? – Shawrup Aug 28 '21 at 15:22 — Shawrup, Aug 28 '21 at 15:22

score 7 · Accepted Answer · answered Aug 28 '21 at 15:48

7

Please try with

spring.r2dbc.url=r2dbc:oracle:thin://localhost:1521:orcl

answered Aug 28 '21 at 15:48

Shawrup

2,478
2
12
21

oh dear, you've saved my day. Thank you very much – Xuân Dũng Đoàn Aug 28 '21 at 17:01
I'm using xepdb1 service instead of XE or orcl. What should be the url then? – Ankit Aug 24 '22 at 06:15

R2DBC can not read the URL of oracle database

1 Answers1