Running a local dockerized database
Postgres
Codeblock |
---|
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
Codeblock |
---|
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
Codeblock |
---|
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
Codeblock |
---|
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!)