[QPID-8117] [Broker-J] Table prefix of JDBC Virtual Host Node is ignored by preferences store

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: qpid-java-broker-7.0.2, qpid-java-6.1.2, qpid-java-6.1.3, qpid-java-6.1.4, qpid-java-broker-7.0.0, qpid-java-6.1.5, qpid-java-broker-7.0.1
• Fix Version/s: qpid-java-broker-7.1.0
• Component/s: Broker-J
• Assignee: Unassigned
• Reporter: Alex Rudyy
• Created: 06/Mar/18 14:13
• Updated: 05/Jan/19 20:01
• Resolved: 09/Mar/18 14:01

Description

QPID-7558 introduced a notion of table prefix which allows to share the same database/schema by multiple virtual hosts. The prefix is used in naming the store tables which allows to distinguish tables belonging to different VHNs.

However, the tables of preferences store do not respect the prefix. The preferences tables are created without a prefix. As result, the preference tables can be shared by
multiple Virtual Host instances. On deletion of one of VHNs the preferences tables are deleted and attempts to save preferences for remaining virtual host nodes might end-up in broker crash.

The preferences store should respect the prefix and create the tables with the specified prefix.