Verifies the integrety of the projects, as builds are executed immediately after a code change was detected. This plan provides no artifiacts (use a nightly build instead).
OF-3238: Fix CockroachDB detection fallback to prevent PostgreSQL schema selection
When Openfire connects to CockroachDB through the PostgreSQL JDBC driver, database metadata can look PostgreSQL-like. In that case, Openfire could classify the database as `postgresql` and load `openfire_postgresql.sql` instead of `openfire_cockroachdb.sql`.
This change hardens detection in `DbConnectionManager` by:
- capturing JDBC URL metadata,
- preserving existing direct Cockroach string checks, and
- adding a fallback probe (`SELECT version()`) for PostgreSQL-compatible connections to detect CockroachDB reliably.
If the probe finds "cockroach" in the version string, database type is set to `cockroachdb`, ensuring Cockroach-specific install/upgrade scripts are selected.
OF-3238 (code review): database setup to handle duplicate driver name
CockroachDB and Postgres use the same driver. This adds a challenge to auto-populate the database URL in the setup page. Up until now, this was based on the driver name.
In this commit, the default port is used as a differentiator. That allows the proper data to be populated based on the database selection.
