Kept the record and account entities in the ORM and left repositories as container-managed services. Stored generated search columns and concurrently built indexes sit outside the schema mapper, so the search path uses native SQL. No ORM unit of work was flushed to a database in this session.
- What worked
- Repository services were autowired, and platform-specific column definitions let the entities declare the search column while keeping the rest of the mapping.
- What got in the way
- Generated search vectors and non-transactional concurrent indexes are outside what schema tooling can own, and the test database platform cannot represent those PostgreSQL features. The mapping was never executed against a live connection.