[JAMES-396] Wrong column order (IMHO) in primary key definition for SpoolRepositories.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.2.0
• Fix Version/s: 2.3.0
• Assignee: Stefano Bagnara
• Reporter: Stefano Bagnara
• Created: 10/Aug/05 04:02
• Updated: 21/Nov/07 08:31
• Resolved: 10/Aug/05 05:41

Description

In sqlResources.xml many JDBCSpoolRepository createTable definition declare a primary key as (message_name, repository_name) instead of (repository_name, message_name) .
this is "bad" for hypersonic, mysql, mssql, oracle, postgresql, sapdb
db2 seems to be correctly configured.

Why?

AFAIK every query we do against the spool will include a filter on the repository_name. Some of them also includes the message_name but others does not include the message_name!