Connecting MYSQL server database and Oracle database using Liquibase command

1

I could connect to db2 type database successfully using below command and executed successfully. now i want to know how we can connect to mysql db and oracle on prem databases by following same method?
liquibase --url=“jdbc:$(db_type)://$(db_server_name)” --searchPath="$(Build.SourcesDirectory)\$(changeset_master_file_path)"
–changeLogFile=“changeset_master.xml” --username="$(account-id)"
–password=

what are the changes need to be done to above command ?

Please share exact commands. Thank you

2

The only change would be to the url structure and value. You’ll need to provide a valid jdbc string for each platform, I don’t think this structure will work for oracle (not sure about mysql):

“jdbc:$(db_type)://$(db_server_name)”

3

then what is the strucutre will work for oracle and mysql?

can you point me to the document or to the person who knows about it?

4

You just need to provide a jdbc URL that is valid for the platform. There are many ways to form a valid string for oracle:

jdbc:oracle:thin:@::

jdbc:oracle:thin:@//:/<service_name>

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=)(HOST=)(PORT=))(CONNECT_DATA=(SERVICE_NAME=<service_name>)))

jdbc:oracle:thin:@?TNS_ADMIN=

5

Can you please share the relevant Liquibase document for the whatever you have shared.