pax-jdbc-itest
To run all integration tests, you need to set up all the databases:
1) Derby:
$ export DERBY_HOME=/path/to/db-derby-10.14.2.0-bin
$ cd $DERBY_HOME
$ mkdir databases; cd databases
$ java -jar $DERBY_HOME/lib/derbyrun.jar server start
2) MS SQL Server (for official and jtds drivers):
$ podman run -itd --name pax.jdbc.sqlserver -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=PaxJdbc!(*67' -e 'MSSQL_PID=Express' \
-p 1433:1433 -d mcr.microsoft.com/mssql/server:2022-latest
3) MariaDB:
$ podman run --name pax.jdbc.mariadb -p 3306:3306 -e MYSQL_ROOT_PASSWORD=paxjdbc -d mariadb
4) MySQL:
$ podman run --name pax.jdbc.mysql -p 3307:3306 -e MYSQL_ROOT_PASSWORD=paxjdbc -d mysql
5) PostgreSQL:
$ podman run --name pax.jdbc.postgresql -e POSTGRES_USER=paxjdbc -e POSTGRES_PASSWORD=paxjdbc -p 5432:5432 -d postgres:latest
6) Oracle (a bit unofficial):
$ podman run -itd --name pax.jdbc.oracle -p 1521:1521 --privileged=true oracleinanutshell/oracle-xe-11g