[JUDDI-500] deleteSQL query is wrong in PublisherAssertionQuery

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.4
• Fix Version/s: 3.1.0
• Component/s: core
• Labels: patch
• Environment: juddi-portal-bundle-3.0.4 (with bundled derby)
• Assignee: Kurt Stam
• Reporter: Dmitry Lipin
• Created: 14/Jun/11 09:53
• Updated: 02/May/13 02:29
• Resolved: 15/Jun/11 13:52

Description

Saving publisherAssertions using set_publisherAssertions API method results in the following exception message been thrown:
Encountered "pa" at character 8, but expected: ["FROM"].

That belongs to the following query statement recorded in the juddi.log:
delete pa from PublisherAssertion pa where ( pa.businessEntityByFromKey.entityKey in ( ?, ?, ?) or pa.businessEntityByToKey.entityKey in ( ?, ?, ?) )

As the result set_publisherAssertions API method is unusable.

Proposed fix attached.

Issue Links

• is depended upon by: SCOUT-109 scout does not conform to jUDDI WSDL