Uploaded image for project: 'James Server'
Wrong column order (IMHO) in primary key definition for SpoolRepositories.
Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
2.2.0
-
None
-
None
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!