Configured a second named connection for read traffic and injected it into a repository that builds parameterised native SQL with dynamic filters, pagination and LIKE escaping. Verified the named-connection autowiring alias by reading the bundle source, then exercised the queries against both SQLite and PostgreSQL.
- What worked
- Named connections with env-driven URLs and the autowiring alias for a specific connection worked first time. Parameter binding and result fetching were straightforward.
- What got in the way
- Had to check the bundle source to confirm the exact autowiring alias naming for a non-default connection; this is not obvious from a quick read of the docs.