1

I have a spring boot project with a MySql DB already configured along with the migration scripts.

I have a new requirement where I have to configure an Oracle database(part of another application) to my application.

I understand that we can configure multiple databases in spring boot project. But I need to configure Oracle DB such that the migration scripts writtrn for MySQL doesn't apply onto it as I have to perform only select queries on Oracle database.

I am expecting to configure the Oracle database as a read only database without affecting the existing configuration for MySQL database.

Improve this question
3
  • Are you using Spring Data JPA or Spring Data JDBC? Commented Feb 26, 2023 at 13:24
  • Spring Data JPA Commented Feb 26, 2023 at 14:10
  • And to clarify you are already running migration scripts using a tool like Flyway on the MySQL but you don't want the migration tool to run on Oracle? Commented Feb 26, 2023 at 21:49

1 Answer 1

Reset to default
1

The easiest solution would be creating a read-only user in the Oracle database, and in the application.properties file, you should replace the old database user information with the read-only user's information.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.