Move parallelism level for the importing process from the record level to the data chunk level #6096

Workflow file for this run

	name: CI
	run-name: "${{ github.event_name == 'workflow_dispatch' && format('Dispatch : Run integration test with JDK {0} ({1})', inputs.INT_TEST_JAVA_RUNTIME_VERSION, inputs.INT_TEST_JAVA_RUNTIME_VENDOR) \|\| '' }}"

	on:
	pull_request:
	workflow_dispatch:
	inputs:
	INT_TEST_JAVA_RUNTIME_VERSION:
	description: JDK version used to run the integration test
	type: choice
	required: false
	default: '8'
	options:
	- '8'
	- '11'
	- '17'
	- '21'
	INT_TEST_JAVA_RUNTIME_VENDOR:
	description: Vendor of the JDK used to run the integration test
	type: choice
	required: false
	default: 'temurin'
	options:
	- 'corretto'
	- 'microsoft'
	- 'oracle'
	- 'temurin'

	env:
	TERM: dumb
	JAVA_VERSION: '8'
	JAVA_VENDOR: 'temurin'
	INT_TEST_JAVA_RUNTIME_VERSION: "${{ github.event_name != 'workflow_dispatch' && '8' \|\| inputs.INT_TEST_JAVA_RUNTIME_VERSION }}"
	INT_TEST_JAVA_RUNTIME_VENDOR: "${{ github.event_name != 'workflow_dispatch' && 'temurin' \|\| inputs.INT_TEST_JAVA_RUNTIME_VENDOR }}"
	# Gradle will parse 'ORG_GRADLE_PROJECT_<project_property_name>' environment variables as project properties.
	# The following variables configure the 'com.scalar.db.jdk-configuration' Gradle plugin.
	ORG_GRADLE_PROJECT_javaVersion: '8'
	ORG_GRADLE_PROJECT_javaVendor: 'temurin'
	ORG_GRADLE_PROJECT_integrationTestJavaRuntimeVersion: "${{ github.event_name != 'workflow_dispatch' && '8' \|\| inputs.INT_TEST_JAVA_RUNTIME_VERSION }}"
	ORG_GRADLE_PROJECT_integrationTestJavaRuntimeVendor: "${{ github.event_name != 'workflow_dispatch' && 'temurin' \|\| inputs.INT_TEST_JAVA_RUNTIME_VENDOR }}"
	# This variable evaluates to: if {!(Temurin JDK 8) && !(Oracle JDK)} then {true} else {false}
	# Oracle JDK that are linux compatible and publicly available through direct download exist for all LTS versions
	SET_UP_INT_TEST_RUNTIME_NON_ORACLE_JDK: "${{ (github.event_name == 'workflow_dispatch' && !(inputs.INT_TEST_JAVA_RUNTIME_VERSION == '8' && inputs.INT_TEST_JAVA_RUNTIME_VENDOR == 'temurin') && !(inputs.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle')) && 'true' \|\| 'false' }}"
	INT_TEST_GRADLE_OPTIONS_FOR_GROUP_COMMIT: '"-Dscalardb.consensus_commit.coordinator.group_commit.enabled=true" "-Dscalardb.consensus_commit.coordinator.group_commit.old_group_abort_timeout_millis=15000" --tests ".ConsensusCommit"'

	jobs:
	check:
	name: Gradle check
	runs-on: ubuntu-latest
	steps:
	- uses: actions/checkout@v4

	- name: Set up JDK ${{ env.JAVA_VERSION }} (${{ env.JAVA_VENDOR }})
	uses: actions/setup-java@v4
	with:
	java-version: ${{ env.JAVA_VERSION }}
	distribution: ${{ env.JAVA_VENDOR }}

	- name: Setup Gradle
	uses: gradle/actions/setup-gradle@v4

	- name: Execute Gradle 'check' task
	run: ./gradlew check buildSrc:check

	- name: Save Gradle test reports
	if: always()
	run: \|
	mkdir -p /tmp/gradle_test_reports/core
	mkdir -p /tmp/gradle_test_reports/schema-loader
	cp -a core/build/reports/tests/test /tmp/gradle_test_reports/core/
	cp -a schema-loader/build/reports/tests/test /tmp/gradle_test_reports/schema-loader/

	- name: Upload Gradle test reports
	if: always()
	uses: actions/upload-artifact@v4
	with:
	name: gradle_check_reports
	path: /tmp/gradle_test_reports

	- name: Save SpotBugs reports
	if: always()
	run: \|
	mkdir -p /tmp/gradle_spotbugs_reports/core
	mkdir -p /tmp/gradle_spotbugs_reports/schema-loader
	mkdir -p /tmp/gradle_spotbugs_reports/integration-test
	cp -a core/build/reports/spotbugs /tmp/gradle_spotbugs_reports/core/
	cp -a schema-loader/build/reports/spotbugs /tmp/gradle_spotbugs_reports/schema-loader/
	cp -a integration-test/build/reports/spotbugs /tmp/gradle_spotbugs_reports/integration-test/

	- name: Upload Spotbugs reports
	if: always()
	uses: actions/upload-artifact@v4
	with:
	name: gradle_spotbugs_reports
	path: /tmp/gradle_spotbugs_reports

	dockerfile-lint:
	name: Lint dockerfiles
	runs-on: ubuntu-latest

	steps:
	- uses: actions/checkout@v4

	- name: Set up JDK ${{ env.JAVA_VERSION }} (${{ env.JAVA_VENDOR }})
	uses: actions/setup-java@v4
	with:
	java-version: ${{ env.JAVA_VERSION }}
	distribution: ${{ env.JAVA_VENDOR }}

	- name: Setup Gradle
	uses: gradle/actions/setup-gradle@v4

	- name: Dockerfile Lint for ScalarDB Schema Loader
	run: ./gradlew schema-loader:dockerfileLint

	integration-test-for-cassandra-3-0:
	name: Cassandra 3.0 integration test (${{ matrix.mode.label }})
	runs-on: ubuntu-latest

	services:
	cassandra:
	image: cassandra:3.0
	env:
	MAX_HEAP_SIZE: 2048m
	HEAP_NEWSIZE: 512m
	ports:
	- 9042:9042

	strategy:
	matrix:
	mode:
	- label: default
	group_commit_enabled: false
	- label: with_group_commit
	group_commit_enabled: true

	steps:
	- uses: actions/checkout@v4

	- name: Set up JDK ${{ env.JAVA_VERSION }} (${{ env.JAVA_VENDOR }})
	uses: actions/setup-java@v4
	with:
	java-version: ${{ env.JAVA_VERSION }}
	distribution: ${{ env.JAVA_VENDOR }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}) to run integration test
	uses: actions/setup-java@v4
	if: ${{ env.SET_UP_INT_TEST_RUNTIME_NON_ORACLE_JDK == 'true'}}
	with:
	java-version: ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}
	distribution: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}

	- name: Login to Oracle container registry
	uses: docker/login-action@v3
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	with:
	registry: container-registry.oracle.com
	username: ${{ secrets.OCR_USERNAME }}
	password: ${{ secrets.OCR_TOKEN }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (oracle) to run the integration test
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	run: \|
	container_id=$(docker create "container-registry.oracle.com/java/jdk:${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}")
	docker cp -L "$container_id:/usr/java/default" /usr/lib/jvm/oracle-jdk && docker rm "$container_id"

	- name: Setup Gradle
	uses: gradle/actions/setup-gradle@v4

	- name: Execute Gradle 'integrationTestCassandra' task
	run: ./gradlew integrationTestCassandra ${{ matrix.mode.group_commit_enabled && env.INT_TEST_GRADLE_OPTIONS_FOR_GROUP_COMMIT \|\| '' }}

	- name: Upload Gradle test reports
	if: always()
	uses: actions/upload-artifact@v4
	with:
	name: cassandra_3.0_integration_test_reports_${{ matrix.mode.label }}
	path: core/build/reports/tests/integrationTestCassandra

	integration-test-for-cassandra-3-11:
	name: Cassandra 3.11 integration test (${{ matrix.mode.label }})
	runs-on: ubuntu-latest

	services:
	cassandra:
	image: cassandra:3.11
	env:
	MAX_HEAP_SIZE: 2048m
	HEAP_NEWSIZE: 512m
	ports:
	- 9042:9042

	strategy:
	matrix:
	mode:
	- label: default
	group_commit_enabled: false
	- label: with_group_commit
	group_commit_enabled: true

	steps:
	- uses: actions/checkout@v4

	- name: Set up JDK ${{ env.JAVA_VERSION }} (${{ env.JAVA_VENDOR }})
	uses: actions/setup-java@v4
	with:
	java-version: ${{ env.JAVA_VERSION }}
	distribution: ${{ env.JAVA_VENDOR }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}) to run integration test
	uses: actions/setup-java@v4
	if: ${{ env.SET_UP_INT_TEST_RUNTIME_NON_ORACLE_JDK == 'true'}}
	with:
	java-version: ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}
	distribution: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}

	- name: Login to Oracle container registry
	uses: docker/login-action@v3
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	with:
	registry: container-registry.oracle.com
	username: ${{ secrets.OCR_USERNAME }}
	password: ${{ secrets.OCR_TOKEN }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (oracle) to run the integration test
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	run: \|
	container_id=$(docker create "container-registry.oracle.com/java/jdk:${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}")
	docker cp -L "$container_id:/usr/java/default" /usr/lib/jvm/oracle-jdk && docker rm "$container_id"

	- name: Setup Gradle
	uses: gradle/actions/setup-gradle@v4

	- name: Execute Gradle 'integrationTestCassandra' task
	run: ./gradlew integrationTestCassandra ${{ matrix.mode.group_commit_enabled && env.INT_TEST_GRADLE_OPTIONS_FOR_GROUP_COMMIT \|\| '' }}

	- name: Upload Gradle test reports
	if: always()
	uses: actions/upload-artifact@v4
	with:
	name: cassandra_3.11_integration_test_reports_${{ matrix.mode.label }}
	path: core/build/reports/tests/integrationTestCassandra

	integration-test-for-cosmos:
	name: Cosmos DB integration test (${{ matrix.mode.label }})
	runs-on: windows-latest
	env:
	# Official Oracle JDK images that are windows compatible and publicly available through direct download do not exist for JDK 8 and 11 so we use instead cached versions hosted on the Scalar container registry.
	# This variable evaluates to: if {!(Temurin JDK 8) && !(Oracle JDK 8 or 11)} then {true} else {false}
	SET_UP_INT_TEST_RUNTIME_JDK_WHEN_NOT_ORACLE_8_OR_11: "${{ (github.event_name == 'workflow_dispatch' && !(inputs.INT_TEST_JAVA_RUNTIME_VERSION == '8' && inputs.INT_TEST_JAVA_RUNTIME_VENDOR == 'temurin') && !(inputs.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' && (inputs.INT_TEST_JAVA_RUNTIME_VERSION == '8' \|\| inputs.INT_TEST_JAVA_RUNTIME_VERSION == '11'))) && 'true' \|\| 'false' }}"
	SET_UP_INT_TEST_RUNTIME_ORACLE_JDK_8_OR_11: "${{ ((inputs.INT_TEST_JAVA_RUNTIME_VERSION == '8' \|\| inputs.INT_TEST_JAVA_RUNTIME_VERSION == '11') && inputs.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle') && 'true' \|\| 'false' }}"

	strategy:
	matrix:
	mode:
	- label: default
	group_commit_enabled: false
	- label: with_group_commit
	group_commit_enabled: true

	steps:
	- uses: actions/checkout@v4

	- name: Set up JDK ${{ env.JAVA_VERSION }} (${{ env.JAVA_VENDOR }})
	uses: actions/setup-java@v4
	with:
	java-version: ${{ env.JAVA_VERSION }}
	distribution: ${{ env.JAVA_VENDOR }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}) to run integration test
	uses: actions/setup-java@v4
	if: ${{ env.SET_UP_INT_TEST_RUNTIME_JDK_WHEN_NOT_ORACLE_8_OR_11 == 'true'}}
	with:
	java-version: ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}
	distribution: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}

	- name: Login to GitHub Container Registry
	uses: docker/login-action@v3
	if: ${{ env.SET_UP_INT_TEST_RUNTIME_ORACLE_JDK_8_OR_11 == 'true'}}
	with:
	registry: ghcr.io
	username: ${{ github.repository_owner }}
	password: ${{ secrets.CR_PAT }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (oracle) to run the integration test
	if: ${{ env.SET_UP_INT_TEST_RUNTIME_ORACLE_JDK_8_OR_11 == 'true'}}
	run: \|
	$container_id=$(docker create "ghcr.io/scalar-labs/oracle/jdk:${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}-windows")
	docker cp "${container_id}:oracle-jdk.exe" .
	docker rm "$container_id"
	Write-Host "Install Oracle JDK"
	Start-Process "oracle-jdk.exe" -NoNewWindow -Wait -ArgumentList "/s"
	Write-Host "Oracle JDK installation successful"
	if ( ${env:INT_TEST_JAVA_RUNTIME_VERSION} -eq '8' ) {
	$jdk_root_dir = "jdk-1.8"
	} else {
	$jdk_root_dir = "jdk-11"
	}
	echo "JAVA_HOME=C:\Program Files\Java\${jdk_root_dir}" >> ${env:GITHUB_ENV}

	- name: Start Azure Cosmos DB emulator
	run: \|
	Write-Host "Launching Cosmos DB Emulator"
	Import-Module "$env:ProgramFiles\Azure Cosmos DB Emulator\PSModules\Microsoft.Azure.CosmosDB.Emulator"
	# Set startup timeout to 10min (600s), the default is 4min
	Start-CosmosDbEmulator -Consistency Strong -Timeout 600

	- name: Install TLS/SSL certificate
	run: \|
	$cert = Get-ChildItem Cert:\LocalMachine\My \| where{$_.FriendlyName -eq 'DocumentDbEmulatorCertificate'}
	$params = @{
	Cert = $cert
	Type = "CERT"
	FilePath = "$home/tmp-cert.cer"
	NoClobber = $true
	}
	Export-Certificate @params
	certutil -encode $home/tmp-cert.cer $home/cosmosdbcert.cer
	Remove-Item $home/tmp-cert.cer
	# Setting the keystore option differs between Java 8 and Java 11+
	if ( ${env:INT_TEST_JAVA_RUNTIME_VERSION} -eq '8' ) {
	$keystore = "-keystore", "${env:JAVA_HOME}/jre/lib/security/cacerts"
	} else {
	$keystore = "-cacerts"
	}
	& ${env:JAVA_HOME}/bin/keytool.exe $keystore -storepass 'changeit' -importcert -noprompt -alias cosmos_emulator -file $home/cosmosdbcert.cer
	& ${env:JAVA_HOME}/bin/keytool.exe $keystore -storepass 'changeit' -list -alias cosmos_emulator

	- name: Setup Gradle
	uses: gradle/actions/setup-gradle@v4

	- name: Execute Gradle 'integrationTestCosmos' task
	run: ./gradlew.bat integrationTestCosmos "-Dscalardb.cosmos.uri=https://localhost:8081/" "-Dscalardb.cosmos.password=C2y6yDjf5/R+ob0N8A7Cgv30VRDJIWEHLM+4QDU5DE2nQ9nDuVTqobD4b8mGGyPMbIZnqyMsEcaGQy67XIw/Jw==" "-Dfile.encoding=UTF-8" ${{ matrix.mode.group_commit_enabled && env.INT_TEST_GRADLE_OPTIONS_FOR_GROUP_COMMIT \|\| '' }}

	- name: Upload Gradle test reports
	if: always()
	uses: actions/upload-artifact@v4
	with:
	name: cosmos_integration_test_reports_${{ matrix.mode.label }}
	path: core/build/reports/tests/integrationTestCosmos

	integration-test-for-dynamo:
	name: DynamoDB integration test (${{ matrix.mode.label }})
	runs-on: ubuntu-latest

	services:
	dynamodb:
	image: amazon/dynamodb-local:1.17.0
	ports:
	- 8000:8000

	strategy:
	matrix:
	mode:
	- label: default
	group_commit_enabled: false
	- label: with_group_commit
	group_commit_enabled: true

	steps:
	- uses: actions/checkout@v4

	- name: Set up JDK ${{ env.JAVA_VERSION }} (${{ env.JAVA_VENDOR }})
	uses: actions/setup-java@v4
	with:
	java-version: ${{ env.JAVA_VERSION }}
	distribution: ${{ env.JAVA_VENDOR }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}) to run integration test
	uses: actions/setup-java@v4
	if: ${{ env.SET_UP_INT_TEST_RUNTIME_NON_ORACLE_JDK == 'true'}}
	with:
	java-version: ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}
	distribution: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}

	- name: Login to Oracle container registry
	uses: docker/login-action@v3
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	with:
	registry: container-registry.oracle.com
	username: ${{ secrets.OCR_USERNAME }}
	password: ${{ secrets.OCR_TOKEN }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (oracle) to run the integration test
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	run: \|
	container_id=$(docker create "container-registry.oracle.com/java/jdk:${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}")
	docker cp -L "$container_id:/usr/java/default" /usr/lib/jvm/oracle-jdk && docker rm "$container_id"

	- name: Setup Gradle
	uses: gradle/actions/setup-gradle@v4

	- name: Execute Gradle 'integrationTestDynamo' task
	run: ./gradlew integrationTestDynamo ${{ matrix.mode.group_commit_enabled && env.INT_TEST_GRADLE_OPTIONS_FOR_GROUP_COMMIT \|\| '' }}

	- name: Upload Gradle test reports
	if: always()
	uses: actions/upload-artifact@v4
	with:
	name: dynamo_integration_test_reports_${{ matrix.mode.label }}
	path: core/build/reports/tests/integrationTestDynamo

	integration-test-for-jdbc-mysql-5-7:
	name: MySQL 5.7 integration test (${{ matrix.mode.label }})
	runs-on: ubuntu-latest

	strategy:
	matrix:
	mode:
	- label: default
	group_commit_enabled: false
	- label: with_group_commit
	group_commit_enabled: true

	steps:
	- name: Run MySQL 5.7
	run: \|
	docker run -e MYSQL_ROOT_PASSWORD=mysql -p 3306:3306 -d mysql:5.7 --character-set-server=utf8mb4 --collation-server=utf8mb4_bin

	- uses: actions/checkout@v4

	- name: Set up JDK ${{ env.JAVA_VERSION }} (${{ env.JAVA_VENDOR }})
	uses: actions/setup-java@v4
	with:
	java-version: ${{ env.JAVA_VERSION }}
	distribution: ${{ env.JAVA_VENDOR }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}) to run integration test
	uses: actions/setup-java@v4
	if: ${{ env.SET_UP_INT_TEST_RUNTIME_NON_ORACLE_JDK == 'true'}}
	with:
	java-version: ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}
	distribution: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}

	- name: Login to Oracle container registry
	uses: docker/login-action@v3
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	with:
	registry: container-registry.oracle.com
	username: ${{ secrets.OCR_USERNAME }}
	password: ${{ secrets.OCR_TOKEN }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (oracle) to run the integration test
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	run: \|
	container_id=$(docker create "container-registry.oracle.com/java/jdk:${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}")
	docker cp -L "$container_id:/usr/java/default" /usr/lib/jvm/oracle-jdk && docker rm "$container_id"

	- name: Setup Gradle
	uses: gradle/actions/setup-gradle@v4

	- name: Execute Gradle 'integrationTestJdbc' task
	run: ./gradlew integrationTestJdbc ${{ matrix.mode.group_commit_enabled && env.INT_TEST_GRADLE_OPTIONS_FOR_GROUP_COMMIT \|\| '' }}

	- name: Upload Gradle test reports
	if: always()
	uses: actions/upload-artifact@v4
	with:
	name: mysql_5.7_integration_test_reports_${{ matrix.mode.label }}
	path: core/build/reports/tests/integrationTestJdbc

	integration-test-for-jdbc-mysql-8-0:
	name: MySQL 8.0 integration test (${{ matrix.mode.label }})
	runs-on: ubuntu-latest

	strategy:
	matrix:
	mode:
	- label: default
	group_commit_enabled: false
	- label: with_group_commit
	group_commit_enabled: true

	steps:
	- name: Run MySQL 8.0
	run: \|
	docker run -e MYSQL_ROOT_PASSWORD=mysql -p 3306:3306 -d mysql:8.0 --character-set-server=utf8mb4 --collation-server=utf8mb4_bin

	- uses: actions/checkout@v4

	- name: Set up JDK ${{ env.JAVA_VERSION }} (${{ env.JAVA_VENDOR }})
	uses: actions/setup-java@v4
	with:
	java-version: ${{ env.JAVA_VERSION }}
	distribution: ${{ env.JAVA_VENDOR }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}) to run integration test
	uses: actions/setup-java@v4
	if: ${{ env.SET_UP_INT_TEST_RUNTIME_NON_ORACLE_JDK == 'true'}}
	with:
	java-version: ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}
	distribution: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}

	- name: Login to Oracle container registry
	uses: docker/login-action@v3
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	with:
	registry: container-registry.oracle.com
	username: ${{ secrets.OCR_USERNAME }}
	password: ${{ secrets.OCR_TOKEN }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (oracle) to run the integration test
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	run: \|
	container_id=$(docker create "container-registry.oracle.com/java/jdk:${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}")
	docker cp -L "$container_id:/usr/java/default" /usr/lib/jvm/oracle-jdk && docker rm "$container_id"

	- name: Setup Gradle
	uses: gradle/actions/setup-gradle@v4

	- name: Execute Gradle 'integrationTestJdbc' task
	run: ./gradlew integrationTestJdbc ${{ matrix.mode.group_commit_enabled && env.INT_TEST_GRADLE_OPTIONS_FOR_GROUP_COMMIT \|\| '' }}

	- name: Upload Gradle test reports
	if: always()
	uses: actions/upload-artifact@v4
	with:
	name: mysql_8.0_integration_test_reports_${{ matrix.mode.label }}
	path: core/build/reports/tests/integrationTestJdbc

	integration-test-for-jdbc-mysql-8-4:
	name: MySQL 8.4 integration test (${{ matrix.mode.label }})
	runs-on: ubuntu-latest

	strategy:
	matrix:
	mode:
	- label: default
	group_commit_enabled: false
	- label: with_group_commit
	group_commit_enabled: true

	steps:
	- name: Run MySQL 8.4
	run: \|
	docker run -e MYSQL_ROOT_PASSWORD=mysql -p 3306:3306 -d mysql:8.4 --character-set-server=utf8mb4 --collation-server=utf8mb4_bin

	- uses: actions/checkout@v4

	- name: Set up JDK ${{ env.JAVA_VERSION }} (${{ env.JAVA_VENDOR }})
	uses: actions/setup-java@v4
	with:
	java-version: ${{ env.JAVA_VERSION }}
	distribution: ${{ env.JAVA_VENDOR }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}) to run integration test
	uses: actions/setup-java@v4
	if: ${{ env.SET_UP_INT_TEST_RUNTIME_NON_ORACLE_JDK == 'true'}}
	with:
	java-version: ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}
	distribution: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}

	- name: Login to Oracle container registry
	uses: docker/login-action@v3
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	with:
	registry: container-registry.oracle.com
	username: ${{ secrets.OCR_USERNAME }}
	password: ${{ secrets.OCR_TOKEN }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (oracle) to run the integration test
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	run: \|
	container_id=$(docker create "container-registry.oracle.com/java/jdk:${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}")
	docker cp -L "$container_id:/usr/java/default" /usr/lib/jvm/oracle-jdk && docker rm "$container_id"

	- name: Setup Gradle
	uses: gradle/actions/setup-gradle@v4

	- name: Execute Gradle 'integrationTestJdbc' task
	run: ./gradlew integrationTestJdbc ${{ matrix.mode.group_commit_enabled && env.INT_TEST_GRADLE_OPTIONS_FOR_GROUP_COMMIT \|\| '' }}

	- name: Upload Gradle test reports
	if: always()
	uses: actions/upload-artifact@v4
	with:
	name: mysql_8.4_integration_test_reports_${{ matrix.mode.label }}
	path: core/build/reports/tests/integrationTestJdbc

	integration-test-for-jdbc-postgresql-13:
	name: PostgreSQL 13 integration test (${{ matrix.mode.label }})
	runs-on: ubuntu-latest

	services:
	postgres:
	image: postgres:13-alpine
	env:
	POSTGRES_USER: postgres
	POSTGRES_PASSWORD: postgres
	ports:
	- 5432:5432

	strategy:
	matrix:
	mode:
	- label: default
	group_commit_enabled: false
	- label: with_group_commit
	group_commit_enabled: true

	steps:
	- uses: actions/checkout@v4

	- name: Set up JDK ${{ env.JAVA_VERSION }} (${{ env.JAVA_VENDOR }})
	uses: actions/setup-java@v4
	with:
	java-version: ${{ env.JAVA_VERSION }}
	distribution: ${{ env.JAVA_VENDOR }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}) to run integration test
	uses: actions/setup-java@v4
	if: ${{ env.SET_UP_INT_TEST_RUNTIME_NON_ORACLE_JDK == 'true'}}
	with:
	java-version: ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}
	distribution: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}

	- name: Login to Oracle container registry
	uses: docker/login-action@v3
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	with:
	registry: container-registry.oracle.com
	username: ${{ secrets.OCR_USERNAME }}
	password: ${{ secrets.OCR_TOKEN }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (oracle) to run the integration test
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	run: \|
	container_id=$(docker create "container-registry.oracle.com/java/jdk:${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}")
	docker cp -L "$container_id:/usr/java/default" /usr/lib/jvm/oracle-jdk && docker rm "$container_id"

	- name: Setup Gradle
	uses: gradle/actions/setup-gradle@v4

	- name: Execute Gradle 'integrationTestJdbc' task
	run: ./gradlew integrationTestJdbc -Dscalardb.jdbc.url=jdbc:postgresql://localhost:5432/ -Dscalardb.jdbc.username=postgres -Dscalardb.jdbc.password=postgres ${{ matrix.mode.group_commit_enabled && env.INT_TEST_GRADLE_OPTIONS_FOR_GROUP_COMMIT \|\| '' }}

	- name: Upload Gradle test reports
	if: always()
	uses: actions/upload-artifact@v4
	with:
	name: postgresql_13_integration_test_reports_${{ matrix.mode.label }}
	path: core/build/reports/tests/integrationTestJdbc

	integration-test-for-jdbc-postgresql-14:
	name: PostgreSQL 14 integration test (${{ matrix.mode.label }})
	runs-on: ubuntu-latest

	services:
	postgres:
	image: postgres:14-alpine
	env:
	POSTGRES_USER: postgres
	POSTGRES_PASSWORD: postgres
	ports:
	- 5432:5432

	strategy:
	matrix:
	mode:
	- label: default
	group_commit_enabled: false
	- label: with_group_commit
	group_commit_enabled: true

	steps:
	- uses: actions/checkout@v4

	- name: Set up JDK ${{ env.JAVA_VERSION }} (${{ env.JAVA_VENDOR }})
	uses: actions/setup-java@v4
	with:
	java-version: ${{ env.JAVA_VERSION }}
	distribution: ${{ env.JAVA_VENDOR }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}) to run integration test
	uses: actions/setup-java@v4
	if: ${{ env.SET_UP_INT_TEST_RUNTIME_NON_ORACLE_JDK == 'true'}}
	with:
	java-version: ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}
	distribution: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}

	- name: Login to Oracle container registry
	uses: docker/login-action@v3
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	with:
	registry: container-registry.oracle.com
	username: ${{ secrets.OCR_USERNAME }}
	password: ${{ secrets.OCR_TOKEN }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (oracle) to run the integration test
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	run: \|
	container_id=$(docker create "container-registry.oracle.com/java/jdk:${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}")
	docker cp -L "$container_id:/usr/java/default" /usr/lib/jvm/oracle-jdk && docker rm "$container_id"

	- name: Setup Gradle
	uses: gradle/actions/setup-gradle@v4

	- name: Execute Gradle 'integrationTestJdbc' task
	run: ./gradlew integrationTestJdbc -Dscalardb.jdbc.url=jdbc:postgresql://localhost:5432/ -Dscalardb.jdbc.username=postgres -Dscalardb.jdbc.password=postgres ${{ matrix.mode.group_commit_enabled && env.INT_TEST_GRADLE_OPTIONS_FOR_GROUP_COMMIT \|\| '' }}

	- name: Upload Gradle test reports
	if: always()
	uses: actions/upload-artifact@v4
	with:
	name: postgresql_14_integration_test_reports_${{ matrix.mode.label }}
	path: core/build/reports/tests/integrationTestJdbc

	integration-test-for-jdbc-postgresql-15:
	name: PostgreSQL 15 integration test (${{ matrix.mode.label }})
	runs-on: ubuntu-latest

	services:
	postgres:
	image: postgres:15-alpine
	env:
	POSTGRES_USER: postgres
	POSTGRES_PASSWORD: postgres
	ports:
	- 5432:5432

	strategy:
	matrix:
	mode:
	- label: default
	group_commit_enabled: false
	- label: with_group_commit
	group_commit_enabled: true

	steps:
	- uses: actions/checkout@v4

	- name: Set up JDK ${{ env.JAVA_VERSION }} (${{ env.JAVA_VENDOR }})
	uses: actions/setup-java@v4
	with:
	java-version: ${{ env.JAVA_VERSION }}
	distribution: ${{ env.JAVA_VENDOR }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}) to run integration test
	uses: actions/setup-java@v4
	if: ${{ env.SET_UP_INT_TEST_RUNTIME_NON_ORACLE_JDK == 'true'}}
	with:
	java-version: ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}
	distribution: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}

	- name: Login to Oracle container registry
	uses: docker/login-action@v3
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	with:
	registry: container-registry.oracle.com
	username: ${{ secrets.OCR_USERNAME }}
	password: ${{ secrets.OCR_TOKEN }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (oracle) to run the integration test
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	run: \|
	container_id=$(docker create "container-registry.oracle.com/java/jdk:${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}")
	docker cp -L "$container_id:/usr/java/default" /usr/lib/jvm/oracle-jdk && docker rm "$container_id"

	- name: Setup Gradle
	uses: gradle/actions/setup-gradle@v4

	- name: Execute Gradle 'integrationTestJdbc' task
	run: ./gradlew integrationTestJdbc -Dscalardb.jdbc.url=jdbc:postgresql://localhost:5432/ -Dscalardb.jdbc.username=postgres -Dscalardb.jdbc.password=postgres ${{ matrix.mode.group_commit_enabled && env.INT_TEST_GRADLE_OPTIONS_FOR_GROUP_COMMIT \|\| '' }}

	- name: Upload Gradle test reports
	if: always()
	uses: actions/upload-artifact@v4
	with:
	name: postgresql_15_integration_test_reports_${{ matrix.mode.label }}
	path: core/build/reports/tests/integrationTestJdbc

	integration-test-for-jdbc-postgresql-16:
	name: PostgreSQL 16 integration test (${{ matrix.mode.label }})
	runs-on: ubuntu-latest

	services:
	postgres:
	image: postgres:16-alpine
	env:
	POSTGRES_USER: postgres
	POSTGRES_PASSWORD: postgres
	ports:
	- 5432:5432

	strategy:
	matrix:
	mode:
	- label: default
	group_commit_enabled: false
	- label: with_group_commit
	group_commit_enabled: true

	steps:
	- uses: actions/checkout@v4

	- name: Set up JDK ${{ env.JAVA_VERSION }} (${{ env.JAVA_VENDOR }})
	uses: actions/setup-java@v4
	with:
	java-version: ${{ env.JAVA_VERSION }}
	distribution: ${{ env.JAVA_VENDOR }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}) to run integration test
	uses: actions/setup-java@v4
	if: ${{ env.SET_UP_INT_TEST_RUNTIME_NON_ORACLE_JDK == 'true'}}
	with:
	java-version: ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}
	distribution: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}

	- name: Login to Oracle container registry
	uses: docker/login-action@v3
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	with:
	registry: container-registry.oracle.com
	username: ${{ secrets.OCR_USERNAME }}
	password: ${{ secrets.OCR_TOKEN }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (oracle) to run the integration test
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	run: \|
	container_id=$(docker create "container-registry.oracle.com/java/jdk:${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}")
	docker cp -L "$container_id:/usr/java/default" /usr/lib/jvm/oracle-jdk && docker rm "$container_id"

	- name: Setup Gradle
	uses: gradle/actions/setup-gradle@v4

	- name: Execute Gradle 'integrationTestJdbc' task
	run: ./gradlew integrationTestJdbc -Dscalardb.jdbc.url=jdbc:postgresql://localhost:5432/ -Dscalardb.jdbc.username=postgres -Dscalardb.jdbc.password=postgres ${{ matrix.mode.group_commit_enabled && env.INT_TEST_GRADLE_OPTIONS_FOR_GROUP_COMMIT \|\| '' }}

	- name: Upload Gradle test reports
	if: always()
	uses: actions/upload-artifact@v4
	with:
	name: postgresql_16_integration_test_reports_${{ matrix.mode.label }}
	path: core/build/reports/tests/integrationTestJdbc

	integration-test-for-jdbc-postgresql-17:
	name: PostgreSQL 17 integration test (${{ matrix.mode.label }})
	runs-on: ubuntu-latest

	services:
	postgres:
	image: postgres:17-alpine
	env:
	POSTGRES_USER: postgres
	POSTGRES_PASSWORD: postgres
	ports:
	- 5432:5432

	strategy:
	matrix:
	mode:
	- label: default
	group_commit_enabled: false
	- label: with_group_commit
	group_commit_enabled: true

	steps:
	- uses: actions/checkout@v4

	- name: Set up JDK ${{ env.JAVA_VERSION }} (${{ env.JAVA_VENDOR }})
	uses: actions/setup-java@v4
	with:
	java-version: ${{ env.JAVA_VERSION }}
	distribution: ${{ env.JAVA_VENDOR }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}) to run integration test
	uses: actions/setup-java@v4
	if: ${{ env.SET_UP_INT_TEST_RUNTIME_NON_ORACLE_JDK == 'true'}}
	with:
	java-version: ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}
	distribution: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}

	- name: Login to Oracle container registry
	uses: docker/login-action@v3
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	with:
	registry: container-registry.oracle.com
	username: ${{ secrets.OCR_USERNAME }}
	password: ${{ secrets.OCR_TOKEN }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (oracle) to run the integration test
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	run: \|
	container_id=$(docker create "container-registry.oracle.com/java/jdk:${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}")
	docker cp -L "$container_id:/usr/java/default" /usr/lib/jvm/oracle-jdk && docker rm "$container_id"

	- name: Setup Gradle
	uses: gradle/actions/setup-gradle@v4

	- name: Execute Gradle 'integrationTestJdbc' task
	run: ./gradlew integrationTestJdbc -Dscalardb.jdbc.url=jdbc:postgresql://localhost:5432/ -Dscalardb.jdbc.username=postgres -Dscalardb.jdbc.password=postgres ${{ matrix.mode.group_commit_enabled && env.INT_TEST_GRADLE_OPTIONS_FOR_GROUP_COMMIT \|\| '' }}

	- name: Upload Gradle test reports
	if: always()
	uses: actions/upload-artifact@v4
	with:
	name: postgresql_17_integration_test_reports_${{ matrix.mode.label }}
	path: core/build/reports/tests/integrationTestJdbc

	integration-test-for-jdbc-oracle-19:
	name: Oracle 19 integration test (${{ matrix.mode.label }})
	runs-on: ubuntu-latest

	services:
	oracle:
	image: ghcr.io/scalar-labs/oracle/db-prebuilt:19
	credentials:
	username: ${{ github.repository_owner }}
	password: ${{ secrets.CR_PAT }}
	ports:
	- 1521:1521

	strategy:
	matrix:
	mode:
	- label: default
	group_commit_enabled: false
	- label: with_group_commit
	group_commit_enabled: true

	steps:
	- uses: actions/checkout@v4

	- name: Set up JDK ${{ env.JAVA_VERSION }} (${{ env.JAVA_VENDOR }})
	uses: actions/setup-java@v4
	with:
	java-version: ${{ env.JAVA_VERSION }}
	distribution: ${{ env.JAVA_VENDOR }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}) to run integration test
	uses: actions/setup-java@v4
	if: ${{ env.SET_UP_INT_TEST_RUNTIME_NON_ORACLE_JDK == 'true'}}
	with:
	java-version: ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}
	distribution: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}

	- name: Login to Oracle container registry
	uses: docker/login-action@v3
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	with:
	registry: container-registry.oracle.com
	username: ${{ secrets.OCR_USERNAME }}
	password: ${{ secrets.OCR_TOKEN }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (oracle) to run the integration test
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	run: \|
	container_id=$(docker create "container-registry.oracle.com/java/jdk:${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}")
	docker cp -L "$container_id:/usr/java/default" /usr/lib/jvm/oracle-jdk && docker rm "$container_id"

	- name: Setup Gradle
	uses: gradle/actions/setup-gradle@v4

	- name: Execute Gradle 'integrationTestJdbc' task
	run: ./gradlew integrationTestJdbc -Dscalardb.jdbc.url=jdbc:oracle:thin:@//localhost:1521/ORCLPDB1 -Dscalardb.jdbc.username=SYSTEM -Dscalardb.jdbc.password=Oracle ${{ matrix.mode.group_commit_enabled && env.INT_TEST_GRADLE_OPTIONS_FOR_GROUP_COMMIT \|\| '' }}

	- name: Upload Gradle test reports
	if: always()
	uses: actions/upload-artifact@v4
	with:
	name: oracle_19_integration_test_reports_${{ matrix.mode.label }}
	path: core/build/reports/tests/integrationTestJdbc

	integration-test-for-jdbc-oracle-21:
	name: Oracle 21 integration test (${{ matrix.mode.label }})
	runs-on: ubuntu-latest

	services:
	oracle:
	image: ghcr.io/scalar-labs/oracle/db-prebuilt:21
	credentials:
	username: ${{ github.repository_owner }}
	password: ${{ secrets.CR_PAT }}
	env:
	ORACLE_PWD: Oracle
	ports:
	- 1521:1521
	options: >-
	--health-cmd "/opt/oracle/checkDBStatus.sh"
	--health-interval 10s
	--health-timeout 5s
	--health-retries 120

	strategy:
	matrix:
	mode:
	- label: default
	group_commit_enabled: false
	- label: with_group_commit
	group_commit_enabled: true

	steps:
	- uses: actions/checkout@v4

	- name: Set up JDK ${{ env.JAVA_VERSION }} (${{ env.JAVA_VENDOR }})
	uses: actions/setup-java@v4
	with:
	java-version: ${{ env.JAVA_VERSION }}
	distribution: ${{ env.JAVA_VENDOR }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}) to run integration test
	uses: actions/setup-java@v4
	if: ${{ env.SET_UP_INT_TEST_RUNTIME_NON_ORACLE_JDK == 'true'}}
	with:
	java-version: ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}
	distribution: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}

	- name: Login to Oracle container registry
	uses: docker/login-action@v3
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	with:
	registry: container-registry.oracle.com
	username: ${{ secrets.OCR_USERNAME }}
	password: ${{ secrets.OCR_TOKEN }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (oracle) to run the integration test
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	run: \|
	container_id=$(docker create "container-registry.oracle.com/java/jdk:${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}")
	docker cp -L "$container_id:/usr/java/default" /usr/lib/jvm/oracle-jdk && docker rm "$container_id"

	- name: Setup Gradle
	uses: gradle/actions/setup-gradle@v4

	- name: Execute Gradle 'integrationTestJdbc' task
	run: ./gradlew integrationTestJdbc -Dscalardb.jdbc.url=jdbc:oracle:thin:@//localhost:1521/XEPDB1 -Dscalardb.jdbc.username=SYSTEM -Dscalardb.jdbc.password=Oracle ${{ matrix.mode.group_commit_enabled && env.INT_TEST_GRADLE_OPTIONS_FOR_GROUP_COMMIT \|\| '' }}

	- name: Upload Gradle test reports
	if: always()
	uses: actions/upload-artifact@v4
	with:
	name: oracle_21_integration_test_reports_${{ matrix.mode.label }}
	path: core/build/reports/tests/integrationTestJdbc

	integration-test-for-jdbc-oracle-23:
	name: Oracle 23 integration test (${{ matrix.mode.label }})
	runs-on: ubuntu-latest

	strategy:
	matrix:
	mode:
	- label: default
	group_commit_enabled: false
	- label: with_group_commit
	group_commit_enabled: true

	steps:
	- name: Free up ~14GB of disk space by removing the Android SDK
	run: \|
	echo "Storage available before deletion"
	df -h /
	echo
	sudo rm -r /usr/local/lib/android
	echo "Storage available after deletion"
	df -h /

	- name: Login to GitHub Container Registry
	uses: docker/login-action@v3
	with:
	registry: ghcr.io
	username: ${{ github.repository_owner }}
	password: ${{ secrets.CR_PAT }}

	- name: Start Oracle 23 container
	run: docker run -d --name oracle-23 -p 1521:1521 ghcr.io/scalar-labs/oracle/db-prebuilt:23

	- name: Wait for the container to be ready
	timeout-minutes: 5
	run : \|
	while [ "`docker inspect -f {{.State.Health.Status}} oracle-23`" != "healthy" ]
	do
	sleep 10
	echo "Container is not yet ready"
	done
	echo "Container is ready"

	- uses: actions/checkout@v4

	- name: Set up JDK ${{ env.JAVA_VERSION }} (${{ env.JAVA_VENDOR }})
	uses: actions/setup-java@v4
	with:
	java-version: ${{ env.JAVA_VERSION }}
	distribution: ${{ env.JAVA_VENDOR }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}) to run integration test
	uses: actions/setup-java@v4
	if: ${{ env.SET_UP_INT_TEST_RUNTIME_NON_ORACLE_JDK == 'true'}}
	with:
	java-version: ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}
	distribution: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}

	- name: Login to Oracle container registry
	uses: docker/login-action@v3
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	with:
	registry: container-registry.oracle.com
	username: ${{ secrets.OCR_USERNAME }}
	password: ${{ secrets.OCR_TOKEN }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (oracle) to run the integration test
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	run: \|
	container_id=$(docker create "container-registry.oracle.com/java/jdk:${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}")
	docker cp -L "$container_id:/usr/java/default" /usr/lib/jvm/oracle-jdk && docker rm "$container_id"

	- name: Setup Gradle
	uses: gradle/actions/setup-gradle@v4

	- name: Execute Gradle 'integrationTestJdbc' task
	run: ./gradlew integrationTestJdbc -Dscalardb.jdbc.url=jdbc:oracle:thin:@//localhost:1521/FREEPDB1 -Dscalardb.jdbc.username=SYSTEM -Dscalardb.jdbc.password=Oracle ${{ matrix.mode.group_commit_enabled && env.INT_TEST_GRADLE_OPTIONS_FOR_GROUP_COMMIT \|\| '' }}

	- name: Stop Oracle 23 container
	if: always()
	run: docker stop oracle-23 \| xargs docker rm

	- name: Upload Gradle test reports
	if: always()
	uses: actions/upload-artifact@v4
	with:
	name: oracle_23_integration_test_reports_${{ matrix.mode.label }}
	path: core/build/reports/tests/integrationTestJdbc

	integration-test-for-jdbc-sqlserver-2017:
	name: SQL Server 2017 integration test (${{ matrix.mode.label }})
	runs-on: windows-latest
	env:
	# Official Oracle JDK images that are windows compatible and publicly available through direct download do not exist for JDK 8 and 11 so we use instead cached versions hosted on the Scalar container registry.
	# This variable evaluates to: if {!(Temurin JDK 8) && !(Oracle JDK 8 or 11)} then {true} else {false}
	SET_UP_INT_TEST_RUNTIME_JDK_WHEN_NOT_ORACLE_8_OR_11: "${{ (github.event_name == 'workflow_dispatch' && !(inputs.INT_TEST_JAVA_RUNTIME_VERSION == '8' && inputs.INT_TEST_JAVA_RUNTIME_VENDOR == 'temurin') && !(inputs.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' && (inputs.INT_TEST_JAVA_RUNTIME_VERSION == '8' \|\| inputs.INT_TEST_JAVA_RUNTIME_VERSION == '11'))) && 'true' \|\| 'false' }}"
	SET_UP_INT_TEST_RUNTIME_ORACLE_JDK_8_OR_11: "${{ ((inputs.INT_TEST_JAVA_RUNTIME_VERSION == '8' \|\| inputs.INT_TEST_JAVA_RUNTIME_VERSION == '11') && inputs.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle') && 'true' \|\| 'false' }}"

	strategy:
	matrix:
	mode:
	- label: default
	group_commit_enabled: false
	- label: with_group_commit
	group_commit_enabled: true

	steps:
	- uses: actions/checkout@v4

	- name: Setup Sql Server 2017
	uses: rails-sqlserver/setup-mssql@v1
	with:
	components: sqlcmd,sqlengine
	sa-password: "SqlServer17"
	version: 2017

	- name: Set up JDK ${{ env.JAVA_VERSION }} (${{ env.JAVA_VENDOR }})
	uses: actions/setup-java@v4
	with:
	java-version: ${{ env.JAVA_VERSION }}
	distribution: ${{ env.JAVA_VENDOR }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}) to run integration test
	uses: actions/setup-java@v4
	if: ${{ env.SET_UP_INT_TEST_RUNTIME_JDK_WHEN_NOT_ORACLE_8_OR_11 == 'true'}}
	with:
	java-version: ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}
	distribution: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}

	- name: Login to GitHub Container Registry
	uses: docker/login-action@v3
	if: ${{ env.SET_UP_INT_TEST_RUNTIME_ORACLE_JDK_8_OR_11 == 'true'}}
	with:
	registry: ghcr.io
	username: ${{ github.repository_owner }}
	password: ${{ secrets.CR_PAT }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (oracle) to run the integration test
	if: ${{ env.SET_UP_INT_TEST_RUNTIME_ORACLE_JDK_8_OR_11 == 'true'}}
	run: \|
	$container_id=$(docker create "ghcr.io/scalar-labs/oracle/jdk:${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}-windows")
	docker cp "${container_id}:oracle-jdk.exe" .
	docker rm "$container_id"
	Write-Host "Install Oracle JDK"
	Start-Process "oracle-jdk.exe" -NoNewWindow -Wait -ArgumentList "/s"
	Write-Host "Oracle JDK installation successful"
	if ( ${env:INT_TEST_JAVA_RUNTIME_VERSION} -eq '8' ) {
	$jdk_root_dir = "jdk-1.8"
	} else {
	$jdk_root_dir = "jdk-11"
	}
	echo "JAVA_HOME=C:\Program Files\Java\${jdk_root_dir}" >> ${env:GITHUB_ENV}

	- name: Create no superuser
	run: ./ci/no-superuser/create-no-superuser-sqlserver.sh SqlServer17 10 3
	shell: bash
	timeout-minutes: 1

	- name: Setup Gradle
	uses: gradle/actions/setup-gradle@v4

	- name: Execute Gradle 'integrationTestJdbc' task
	run: ./gradlew.bat integrationTestJdbc "-Dscalardb.jdbc.url=jdbc:sqlserver://localhost:1433;databaseName=test_db;encrypt=true;trustServerCertificate=true" "-Dfile.encoding=UTF-8" "-Dscalardb.jdbc.username=no_superuser" "-Dscalardb.jdbc.password=no_superuser_password" ${{ matrix.mode.group_commit_enabled && env.INT_TEST_GRADLE_OPTIONS_FOR_GROUP_COMMIT \|\| '' }}

	- name: Upload Gradle test reports
	if: always()
	uses: actions/upload-artifact@v4
	with:
	name: sqlserver_2017_integration_test_reports_${{ matrix.mode.label }}
	path: core/build/reports/tests/integrationTestJdbc

	integration-test-for-jdbc-sqlserver-2019:
	name: SQL Server 2019 integration test (${{ matrix.mode.label }})
	runs-on: ubuntu-latest

	services:
	sqlserver:
	image: mcr.microsoft.com/mssql/server:2019-latest
	env:
	MSSQL_PID: "Express"
	SA_PASSWORD: "SqlServer19"
	ACCEPT_EULA: "Y"
	ports:
	- 1433:1433
	options: --name sqlserver19

	strategy:
	matrix:
	mode:
	- label: default
	group_commit_enabled: false
	- label: with_group_commit
	group_commit_enabled: true

	steps:
	- uses: actions/checkout@v4

	- name: Set up JDK ${{ env.JAVA_VERSION }} (${{ env.JAVA_VENDOR }})
	uses: actions/setup-java@v4
	with:
	java-version: ${{ env.JAVA_VERSION }}
	distribution: ${{ env.JAVA_VENDOR }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}) to run integration test
	uses: actions/setup-java@v4
	if: ${{ env.SET_UP_INT_TEST_RUNTIME_NON_ORACLE_JDK == 'true'}}
	with:
	java-version: ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}
	distribution: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}

	- name: Login to Oracle container registry
	uses: docker/login-action@v3
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	with:
	registry: container-registry.oracle.com
	username: ${{ secrets.OCR_USERNAME }}
	password: ${{ secrets.OCR_TOKEN }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (oracle) to run the integration test
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	run: \|
	container_id=$(docker create "container-registry.oracle.com/java/jdk:${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}")
	docker cp -L "$container_id:/usr/java/default" /usr/lib/jvm/oracle-jdk && docker rm "$container_id"

	- name: Create no superuser
	run: ./ci/no-superuser/create-no-superuser-sqlserver.sh SqlServer19 10 3 sqlserver19
	timeout-minutes: 1

	- name: Setup Gradle
	uses: gradle/actions/setup-gradle@v4

	- name: Execute Gradle 'integrationTestJdbc' task
	run: ./gradlew integrationTestJdbc "-Dscalardb.jdbc.url=jdbc:sqlserver://localhost:1433;databaseName=test_db;encrypt=true;trustServerCertificate=true" -Dscalardb.jdbc.username=no_superuser -Dscalardb.jdbc.password=no_superuser_password ${{ matrix.mode.group_commit_enabled && env.INT_TEST_GRADLE_OPTIONS_FOR_GROUP_COMMIT \|\| '' }}

	- name: Upload Gradle test reports
	if: always()
	uses: actions/upload-artifact@v4
	with:
	name: sqlserver_2019_integration_test_reports_${{ matrix.mode.label }}
	path: core/build/reports/tests/integrationTestJdbc

	integration-test-for-jdbc-sqlserver-2022:
	name: SQL Server 2022 integration test (${{ matrix.mode.label }})
	runs-on: ubuntu-latest

	services:
	sqlserver:
	image: mcr.microsoft.com/mssql/server:2022-latest
	env:
	MSSQL_PID: "Express"
	SA_PASSWORD: "SqlServer22"
	ACCEPT_EULA: "Y"
	ports:
	- 1433:1433
	options: --name sqlserver22

	strategy:
	matrix:
	mode:
	- label: default
	group_commit_enabled: false
	- label: with_group_commit
	group_commit_enabled: true

	steps:
	- uses: actions/checkout@v4

	- name: Set up JDK ${{ env.JAVA_VERSION }} (${{ env.JAVA_VENDOR }})
	uses: actions/setup-java@v4
	with:
	java-version: ${{ env.JAVA_VERSION }}
	distribution: ${{ env.JAVA_VENDOR }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}) to run integration test
	uses: actions/setup-java@v4
	if: ${{ env.SET_UP_INT_TEST_RUNTIME_NON_ORACLE_JDK == 'true'}}
	with:
	java-version: ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}
	distribution: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}

	- name: Login to Oracle container registry
	uses: docker/login-action@v3
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	with:
	registry: container-registry.oracle.com
	username: ${{ secrets.OCR_USERNAME }}
	password: ${{ secrets.OCR_TOKEN }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (oracle) to run the integration test
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	run: \|
	container_id=$(docker create "container-registry.oracle.com/java/jdk:${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}")
	docker cp -L "$container_id:/usr/java/default" /usr/lib/jvm/oracle-jdk && docker rm "$container_id"

	- name: Create no superuser
	run: ./ci/no-superuser/create-no-superuser-sqlserver.sh SqlServer22 10 3 sqlserver22
	timeout-minutes: 1

	- name: Setup Gradle
	uses: gradle/actions/setup-gradle@v4

	- name: Execute Gradle 'integrationTestJdbc' task
	run: ./gradlew integrationTestJdbc "-Dscalardb.jdbc.url=jdbc:sqlserver://localhost:1433;databaseName=test_db;encrypt=true;trustServerCertificate=true" -Dscalardb.jdbc.username=no_superuser -Dscalardb.jdbc.password=no_superuser_password ${{ matrix.mode.group_commit_enabled && env.INT_TEST_GRADLE_OPTIONS_FOR_GROUP_COMMIT \|\| '' }}

	- name: Upload Gradle test reports
	if: always()
	uses: actions/upload-artifact@v4
	with:
	name: sqlserver_2022_integration_test_reports_${{ matrix.mode.label }}
	path: core/build/reports/tests/integrationTestJdbc

	integration-test-for-jdbc-sqlite-3:
	name: SQLite 3 integration test (${{ matrix.mode.label }})
	runs-on: ubuntu-latest

	strategy:
	matrix:
	mode:
	- label: default
	group_commit_enabled: false
	- label: with_group_commit
	group_commit_enabled: true

	steps:
	- uses: actions/checkout@v4

	- name: Set up JDK ${{ env.JAVA_VERSION }} (${{ env.JAVA_VENDOR }})
	uses: actions/setup-java@v4
	with:
	java-version: ${{ env.JAVA_VERSION }}
	distribution: ${{ env.JAVA_VENDOR }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}) to run integration test
	uses: actions/setup-java@v4
	if: ${{ env.SET_UP_INT_TEST_RUNTIME_NON_ORACLE_JDK == 'true'}}
	with:
	java-version: ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}
	distribution: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}

	- name: Login to Oracle container registry
	uses: docker/login-action@v3
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	with:
	registry: container-registry.oracle.com
	username: ${{ secrets.OCR_USERNAME }}
	password: ${{ secrets.OCR_TOKEN }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (oracle) to run the integration test
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	run: \|
	container_id=$(docker create "container-registry.oracle.com/java/jdk:${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}")
	docker cp -L "$container_id:/usr/java/default" /usr/lib/jvm/oracle-jdk && docker rm "$container_id"

	- name: Set up SQLite3
	run: sudo apt-get install -y sqlite3

	- name: Setup Gradle
	uses: gradle/actions/setup-gradle@v4

	- name: Execute Gradle 'integrationTestJdbc' task
	run: ./gradlew integrationTestJdbc -Dscalardb.jdbc.url=jdbc:sqlite:integration.sqlite3?busy_timeout=50000 ${{ matrix.mode.group_commit_enabled && env.INT_TEST_GRADLE_OPTIONS_FOR_GROUP_COMMIT \|\| '' }}

	- name: Upload Gradle test reports
	if: always()
	uses: actions/upload-artifact@v4
	with:
	name: sqlite_3_integration_test_reports_${{ matrix.mode.label }}
	path: core/build/reports/tests/integrationTestJdbc

	integration-test-for-jdbc-mariadb-10:
	name: MariaDB 10 integration test (${{ matrix.mode.label }})
	runs-on: ubuntu-latest

	strategy:
	matrix:
	mode:
	- label: default
	group_commit_enabled: false
	- label: with_group_commit
	group_commit_enabled: true

	steps:
	- name: Run MariaDB 10.11
	run: \|
	docker run -e MYSQL_ROOT_PASSWORD=mysql -p 3306:3306 -d mariadb:10.11 --character-set-server=utf8mb4 --collation-server=utf8mb4_bin

	- uses: actions/checkout@v4

	- name: Set up JDK ${{ env.JAVA_VERSION }} (${{ env.JAVA_VENDOR }})
	uses: actions/setup-java@v4
	with:
	java-version: ${{ env.JAVA_VERSION }}
	distribution: ${{ env.JAVA_VENDOR }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}) to run integration test
	uses: actions/setup-java@v4
	if: ${{ env.SET_UP_INT_TEST_RUNTIME_NON_ORACLE_JDK == 'true'}}
	with:
	java-version: ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}
	distribution: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}

	- name: Login to Oracle container registry
	uses: docker/login-action@v3
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	with:
	registry: container-registry.oracle.com
	username: ${{ secrets.OCR_USERNAME }}
	password: ${{ secrets.OCR_TOKEN }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (oracle) to run the integration test
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	run: \|
	container_id=$(docker create "container-registry.oracle.com/java/jdk:${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}")
	docker cp -L "$container_id:/usr/java/default" /usr/lib/jvm/oracle-jdk && docker rm "$container_id"

	- name: Setup Gradle
	uses: gradle/actions/setup-gradle@v4

	- name: Execute Gradle 'integrationTestJdbc' task
	run: ./gradlew integrationTestJdbc -Dscalardb.jdbc.url=jdbc:mariadb://localhost:3306 ${{ matrix.mode.group_commit_enabled && env.INT_TEST_GRADLE_OPTIONS_FOR_GROUP_COMMIT \|\| '' }}

	- name: Upload Gradle test reports
	if: always()
	uses: actions/upload-artifact@v4
	with:
	name: mariadb_10_integration_test_reports_${{ matrix.mode.label }}
	path: core/build/reports/tests/integrationTestJdbc

	integration-test-for-jdbc-mariadb-11-4:
	name: MariaDB 11.4 integration test (${{ matrix.mode.label }})
	runs-on: ubuntu-latest

	strategy:
	matrix:
	mode:
	- label: default
	group_commit_enabled: false
	- label: with_group_commit
	group_commit_enabled: true


	steps:
	- name: Run MariaDB 11.4
	run: \|
	docker run -e MYSQL_ROOT_PASSWORD=mysql -p 3306:3306 -d mariadb:11.4 --character-set-server=utf8mb4 --collation-server=utf8mb4_bin

	- uses: actions/checkout@v4

	- name: Set up JDK ${{ env.JAVA_VERSION }} (${{ env.JAVA_VENDOR }})
	uses: actions/setup-java@v4
	with:
	java-version: ${{ env.JAVA_VERSION }}
	distribution: ${{ env.JAVA_VENDOR }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}) to run integration test
	uses: actions/setup-java@v4
	if: ${{ env.SET_UP_INT_TEST_RUNTIME_NON_ORACLE_JDK == 'true'}}
	with:
	java-version: ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}
	distribution: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}

	- name: Login to Oracle container registry
	uses: docker/login-action@v3
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	with:
	registry: container-registry.oracle.com
	username: ${{ secrets.OCR_USERNAME }}
	password: ${{ secrets.OCR_TOKEN }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (oracle) to run the integration test
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	run: \|
	container_id=$(docker create "container-registry.oracle.com/java/jdk:${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}")
	docker cp -L "$container_id:/usr/java/default" /usr/lib/jvm/oracle-jdk && docker rm "$container_id"

	- name: Setup Gradle
	uses: gradle/actions/setup-gradle@v4

	- name: Execute Gradle 'integrationTestJdbc' task
	run: ./gradlew integrationTestJdbc -Dscalardb.jdbc.url=jdbc:mariadb://localhost:3306 ${{ matrix.mode.group_commit_enabled && env.INT_TEST_GRADLE_OPTIONS_FOR_GROUP_COMMIT \|\| '' }}

	- name: Upload Gradle test reports
	if: always()
	uses: actions/upload-artifact@v4
	with:
	name: mariadb_11.4_integration_test_reports_${{ matrix.mode.label }}
	path: core/build/reports/tests/integrationTestJdbc

	integration-test-for-jdbc-yugabytedb-2:
	name: YugabyteDB 2 integration test (${{ matrix.mode.label }})
	runs-on: ubuntu-latest

	strategy:
	matrix:
	mode:
	- label: default
	group_commit_enabled: false
	- label: with_group_commit
	group_commit_enabled: true

	steps:
	- name: Run YugabyteDB 2
	run: \|
	docker run -p 5433:5433 -e YSQL_USER=yugabyte -e YSQL_PASSWORD=yugabyte -d yugabytedb/yugabyte:2.20.4.0-b50 bin/yugabyted start --background=false --master_flag="ysql_enable_db_catalog_version_mode=false" --tserver_flags="ysql_enable_db_catalog_version_mode=false"

	- uses: actions/checkout@v4

	- name: Set up JDK ${{ env.JAVA_VERSION }} (${{ env.JAVA_VENDOR }})
	uses: actions/setup-java@v4
	with:
	java-version: ${{ env.JAVA_VERSION }}
	distribution: ${{ env.JAVA_VENDOR }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}) to run integration test
	uses: actions/setup-java@v4
	if: ${{ env.SET_UP_INT_TEST_RUNTIME_NON_ORACLE_JDK == 'true'}}
	with:
	java-version: ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}
	distribution: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}

	- name: Login to Oracle container registry
	uses: docker/login-action@v3
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	with:
	registry: container-registry.oracle.com
	username: ${{ secrets.OCR_USERNAME }}
	password: ${{ secrets.OCR_TOKEN }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (oracle) to run the integration test
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	run: \|
	container_id=$(docker create "container-registry.oracle.com/java/jdk:${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}")
	docker cp -L "$container_id:/usr/java/default" /usr/lib/jvm/oracle-jdk && docker rm "$container_id"

	- name: Setup Gradle
	uses: gradle/actions/setup-gradle@v4

	- name: Execute Gradle 'integrationTestJdbc' task
	run: ./gradlew integrationTestJdbc -Dscalardb.jdbc.url=jdbc:yugabytedb://localhost:5433/?load-balance=any -Dscalardb.jdbc.username=yugabyte -Dscalardb.jdbc.password=yugabyte -Dscalar.db.jdbc.connection_pool.max_total=12 -Dscalar.db.jdbc.table_metadata.connection_pool.max_total=4 -Dscalar.db.jdbc.admin.connection_pool.max_total=4 ${{ matrix.mode.group_commit_enabled && env.INT_TEST_GRADLE_OPTIONS_FOR_GROUP_COMMIT \|\| '' }}

	- name: Upload Gradle test reports
	if: always()
	uses: actions/upload-artifact@v4
	with:
	name: yugabytedb_2_integration_test_reports_${{ matrix.mode.label }}
	path: core/build/reports/tests/integrationTestJdbc

	integration-test-for-jdbc-db2-11-5:
	name: Db2 11.5 integration test (${{ matrix.mode.label }})
	runs-on: ubuntu-latest

	services:
	db2:
	image: icr.io/db2_community/db2:11.5.9.0
	env:
	DB2INSTANCE: db2inst1
	DB2INST1_PASSWORD: db2inst1
	DBNAME: test_db
	LICENSE: accept
	ports:
	- 50000:50000
	options: --privileged --name db2

	strategy:
	matrix:
	mode:
	- label: default
	group_commit_enabled: false
	- label: with_group_commit
	group_commit_enabled: true

	steps:
	- uses: actions/checkout@v4

	- name: Set up JDK ${{ env.JAVA_VERSION }} (${{ env.JAVA_VENDOR }})
	uses: actions/setup-java@v4
	with:
	java-version: ${{ env.JAVA_VERSION }}
	distribution: ${{ env.JAVA_VENDOR }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}) to run integration test
	uses: actions/setup-java@v4
	if: ${{ env.SET_UP_INT_TEST_RUNTIME_NON_ORACLE_JDK == 'true'}}
	with:
	java-version: ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}
	distribution: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}

	- name: Login to Oracle container registry
	uses: docker/login-action@v3
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	with:
	registry: container-registry.oracle.com
	username: ${{ secrets.OCR_USERNAME }}
	password: ${{ secrets.OCR_TOKEN }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (oracle) to run the integration test
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	run: \|
	container_id=$(docker create "container-registry.oracle.com/java/jdk:${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}")
	docker cp -L "$container_id:/usr/java/default" /usr/lib/jvm/oracle-jdk && docker rm "$container_id"

	- name: Setup Gradle
	uses: gradle/actions/setup-gradle@v4

	- name: Wait for the container to be ready
	timeout-minutes: 10
	run: \|
	while ! docker logs db2 2>&1 \| grep -q "Setup has completed"
	do
	echo "Container is not yet ready"
	sleep 5s
	done
	echo "Container is ready"

	- name: Execute Gradle 'integrationTestJdbc' task
	run: ./gradlew integrationTestJdbc -Dscalardb.jdbc.url="jdbc:db2://localhost:50000/test_db" -Dscalardb.jdbc.username=db2inst1 -Dscalardb.jdbc.password=db2inst1 ${{ matrix.mode.group_commit_enabled && env.INT_TEST_GRADLE_OPTIONS_FOR_GROUP_COMMIT \|\| '' }}

	- name: Upload Gradle test reports
	if: always()
	uses: actions/upload-artifact@v4
	with:
	name: db2_11.5_integration_test_reports_${{ matrix.mode.label }}
	path: core/build/reports/tests/integrationTestJdbc

	integration-test-for-jdbc-db2-12-1:
	name: Db2 12.1 integration test (${{ matrix.mode.label }})
	runs-on: ubuntu-latest

	services:
	db2:
	image: icr.io/db2_community/db2:12.1.1.0
	env:
	DB2INSTANCE: db2inst1
	DB2INST1_PASSWORD: db2inst1
	DBNAME: test_db
	LICENSE: accept
	ports:
	- 50000:50000
	options: --privileged --name db2

	strategy:
	matrix:
	mode:
	- label: default
	group_commit_enabled: false
	- label: with_group_commit
	group_commit_enabled: true

	steps:
	- uses: actions/checkout@v4

	- name: Set up JDK ${{ env.JAVA_VERSION }} (${{ env.JAVA_VENDOR }})
	uses: actions/setup-java@v4
	with:
	java-version: ${{ env.JAVA_VERSION }}
	distribution: ${{ env.JAVA_VENDOR }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}) to run integration test
	uses: actions/setup-java@v4
	if: ${{ env.SET_UP_INT_TEST_RUNTIME_NON_ORACLE_JDK == 'true'}}
	with:
	java-version: ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}
	distribution: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}

	- name: Login to Oracle container registry
	uses: docker/login-action@v3
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	with:
	registry: container-registry.oracle.com
	username: ${{ secrets.OCR_USERNAME }}
	password: ${{ secrets.OCR_TOKEN }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (oracle) to run the integration test
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	run: \|
	container_id=$(docker create "container-registry.oracle.com/java/jdk:${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}")
	docker cp -L "$container_id:/usr/java/default" /usr/lib/jvm/oracle-jdk && docker rm "$container_id"

	- name: Setup Gradle
	uses: gradle/actions/setup-gradle@v4

	- name: Wait for the container to be ready
	timeout-minutes: 10
	run: \|
	while ! docker logs db2 2>&1 \| grep -q "Setup has completed"
	do
	echo "Container is not yet ready"
	sleep 5s
	done
	echo "Container is ready"

	- name: Execute Gradle 'integrationTestJdbc' task
	run: ./gradlew integrationTestJdbc -Dscalardb.jdbc.url="jdbc:db2://localhost:50000/test_db" -Dscalardb.jdbc.username=db2inst1 -Dscalardb.jdbc.password=db2inst1 ${{ matrix.mode.group_commit_enabled && env.INT_TEST_GRADLE_OPTIONS_FOR_GROUP_COMMIT \|\| '' }}

	- name: Upload Gradle test reports
	if: always()
	uses: actions/upload-artifact@v4
	with:
	name: db2_12.1_integration_test_reports_${{ matrix.mode.label }}
	path: core/build/reports/tests/integrationTestJdbc



	integration-test-for-multi-storage:
	name: Multi-storage integration test (${{ matrix.mode.label }})
	runs-on: ubuntu-latest

	services:
	cassandra:
	image: cassandra:3.11
	env:
	MAX_HEAP_SIZE: 2048m
	HEAP_NEWSIZE: 512m
	ports:
	- 9042:9042

	strategy:
	matrix:
	mode:
	- label: default
	group_commit_enabled: false
	- label: with_group_commit
	group_commit_enabled: true

	steps:
	- name: Run MySQL 8
	run: \|
	docker run -e MYSQL_ROOT_PASSWORD=mysql -p 3306:3306 -d mysql:8 --character-set-server=utf8mb4 --collation-server=utf8mb4_bin

	- uses: actions/checkout@v4

	- name: Set up JDK ${{ env.JAVA_VERSION }} (${{ env.JAVA_VENDOR }})
	uses: actions/setup-java@v4
	with:
	java-version: ${{ env.JAVA_VERSION }}
	distribution: ${{ env.JAVA_VENDOR }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}) to run integration test
	uses: actions/setup-java@v4
	if: ${{ env.SET_UP_INT_TEST_RUNTIME_NON_ORACLE_JDK == 'true'}}
	with:
	java-version: ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}
	distribution: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR }}

	- name: Login to Oracle container registry
	uses: docker/login-action@v3
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	with:
	registry: container-registry.oracle.com
	username: ${{ secrets.OCR_USERNAME }}
	password: ${{ secrets.OCR_TOKEN }}

	- name: Set up JDK ${{ env.INT_TEST_JAVA_RUNTIME_VERSION }} (oracle) to run the integration test
	if: ${{ env.INT_TEST_JAVA_RUNTIME_VENDOR == 'oracle' }}
	run: \|
	container_id=$(docker create "container-registry.oracle.com/java/jdk:${{ env.INT_TEST_JAVA_RUNTIME_VERSION }}")
	docker cp -L "$container_id:/usr/java/default" /usr/lib/jvm/oracle-jdk && docker rm "$container_id"

	- name: Setup Gradle
	uses: gradle/actions/setup-gradle@v4

	- name: Execute Gradle 'integrationTestMultiStorage' task
	run: ./gradlew integrationTestMultiStorage ${{ matrix.mode.group_commit_enabled && env.INT_TEST_GRADLE_OPTIONS_FOR_GROUP_COMMIT \|\| '' }}

	- name: Upload Gradle test reports
	uses: actions/upload-artifact@v4
	if : always()
	with:
	name: multi_storage_integration_test_reports_${{ matrix.mode.label }}
	path: core/build/reports/tests/integrationTestMultiStorage

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Move parallelism level for the importing process from the record level to the data chunk level #6096

Workflow file

Move parallelism level for the importing process from the record level to the data chunk level #6096

Uh oh!

Jobs

Run details

Workflow file for this run