[jira] [Updated] (JUDDI-500) deleteSQL query is wrong in PublisherAssertionQuery

["Dmitry Lipin (JIRA)" <ju...@ws.apache.org>]

     [ https://issues.apache.org/jira/browse/JUDDI-500?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dmitry Lipin updated JUDDI-500:
-------------------------------

    Attachment: X.diff

Patch to PublisherAssertionQuery.java

> deleteSQL query is wrong in PublisherAssertionQuery
> ---------------------------------------------------
>
>                 Key: JUDDI-500
>                 URL: https://issues.apache.org/jira/browse/JUDDI-500
>             Project: jUDDI
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 3.0.4
>         Environment: juddi-portal-bundle-3.0.4 (with bundled derby)
>            Reporter: Dmitry Lipin
>            Assignee: Kurt T Stam
>              Labels: patch
>         Attachments: X.diff
>
>
> 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.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira