Hi all i am facing an issue where Spring reactive r2dbc throws
nested exception is io.r2dbc.spi.R2dbcBadGrammarException: [942] [42000] ORA-00942: table or view does not exist
but i have verified that all the necessary tables are created in the DB.
i realised that DB connection is point to SYSTEM schema.
how to i change the default schema? Below is my spring properties,
spring.r2dbc.url=r2dbc:oracle:thin://localhost:1521/ORCLCDB
spring.r2dbc.username=system
spring.r2dbc.password=root
spring.r2dbc.name=mycustomschema
sorry oracle noob here!