Running a local database
Postgres
docker run \ -e POSTGRES_PASSWORD=mysecretpassword \ -p 5432:5432 \ --name postgres \ postgres:12.3
cmsbs.database.url = "jdbc:postgresql://localhost:5432/" cmsbs.database.user = "postgres" cmsbs.database.password = "secret"
JDBC Driver: https://jdbc.postgresql.org/download.html
MySQL
docker run \ -e MYSQL_DATABASE=um -e MYSQL_ROOT_PASSWORD=secret \ -p 3306:3306 \ --name mysql \ mysql:8.0
cmsbs.database.url = "jdbc:mysql://localhost:3306/um?allowPublicKeyRetrieval=true" cmsbs.database.user = "root" cmsbs.database.password = "secret" cmsbs.database.mysql.Unicode = true
JDBC Driver: https://dev.mysql.com/downloads/connector/j/
MSSQL
docker run \ -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=S3cre7pw' -e 'MSSQL_PID=Express' \ -p 1433:1433 \ --name mssql2017 \ mcr.microsoft.com/mssql/server:2017-latest-ubuntu
cmsbs.database.url = "jdbc:sqlserver://localhost:1433" cmsbs.database.user = "sa" cmsbs.database.password = "S3cre7pw" cmsbs.database.mssql.Unicode = true
JDBC Driver: https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15
Oracle
docker run \ -p 1521:1521 \ --name oracle-xe-11g \ oracleinanutshell/oracle-xe-11g:latest
cmsbs.database.url = "jdbc:oracle:thin:@localhost:1521:xe" cmsbs.database.user = "system" cmsbs.database.password = "oracle"
JDBC Driver: https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html (Oracle account required!)