Other databases
The following examples demonstrate how to configure a connection to
Microsoft SQL Server
and Oracle Database 11g
. Username and password
fields are omitted for brevity. These fields are part of the platform
installation guides.
Microsoft SQL Server with default instance
relution:
database:
type: mssql
url: 'jdbc:sqlserver://localhost:1433;databaseName=relution'
Microsoft SQL Server with custom instance
relution:
database:
type: mssql
url: 'jdbc:sqlserver://localhost\<INSTANCE>:1433;databaseName=relution'
Oracle 11g with SID
relution:
database:
type: oracle
url: 'jdbc:oracle:thin:@localhost:1521:<SID>'
Oracle 11g with service name
relution:
database:
type: oracle
url: 'jdbc:oracle:thin:@//localhost:1521/<SERVICE_NAME>'
Dedicated Liquibase DB user
By default the relution.database.*
connection & credentials are used to
perform all Liquibase changes, but a dedicated DB user can be configured to
perform them.
First you create a new user in the database and assign him the corresponding DB permissions to perform DDL operations. Then you extend the Relution yaml configuration with the credentials like seen below:
spring:
#datasource: # this is defined in relution.database.*
liquibase:
#default-schema: # this is defined in relution.database.*
user: <liquibaseUser>
password: <liquibaseUserPassword>