Namastack Outbox v1.6.0

What's New

JPA Schema Validation and DDL Compatibility Improvements (GH-288, GH-289)

This release introduces comprehensive JPA schema validation tests for all supported databases and
fixes DDL compatibility issues for OutboxRecordEntity.payload and OutboxRecordEntity.context.
These fields now use Hibernate's dialect-aware large Unicode text mapping, resolving validation
failures and mismatches with shipped DDL schemas—especially for Oracle, SQL Server, MySQL, MariaDB,
and H2. See the detailed migration and impact notes below.

Impact

Setup	Impact
JDBC module	No runtime migration required
JPA with ddl-auto=none	No startup validation impact
JPA with ddl-auto=validate and new schema	No action required
JPA with ddl-auto=validate and existing schema	Migration may be required, see below

Database Notes

Database	Change
Oracle	No DDL change. Existing NCLOB columns now validate correctly.
PostgreSQL	No DDL change. Existing TEXT columns now validate correctly.
SQL Server	context should be NVARCHAR(MAX) instead of VARCHAR(MAX).
MySQL	payload and context should be LONGTEXT CHARACTER SET utf8mb4.
MariaDB	payload and context should be LONGTEXT CHARACTER SET utf8mb4.
H2	payload and context should be CLOB.

Migration Scripts

SQL Server

ALTER TABLE outbox_record
    ALTER COLUMN context NVARCHAR(MAX) NULL;

MySQL

ALTER TABLE outbox_record
    MODIFY COLUMN payload LONGTEXT CHARACTER
SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    MODIFY COLUMN context LONGTEXT CHARACTER
SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL;

MariaDB

ALTER TABLE outbox_record
    MODIFY COLUMN payload LONGTEXT CHARACTER
SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    MODIFY COLUMN context LONGTEXT CHARACTER
SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL;

H2

ALTER TABLE outbox_record
    ALTER COLUMN payload CLOB;
ALTER TABLE outbox_record
    ALTER COLUMN context CLOB;

What's Changed

• GH-288 Add JPA schema validation tests for all supported databases and fix DDL compatibility
  issues by @rolandbeisel in #289
• Bump gradle-wrapper from 9.5.0 to 9.5.1 by @dependabot[bot]
  in #291

New Contributors

• No new contributors in this release.

---

🙏 Contributors

Special thanks to all contributors who made this release possible:

• @rolandbeisel

---

Full Changelog: v1.5.0...v1.6.0