[
https://issues.apache.org/jira/browse/JUDDI-341?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kurt T Stam closed JUDDI-341.
-----------------------------
Resolution: Fixed
Added compareTo so JPA only does a distinct on the PK, and not the entire
object.
> Distinct query is causing an issue on Db2 and SqlServer
> -------------------------------------------------------
>
> Key: JUDDI-341
> URL: https://issues.apache.org/jira/browse/JUDDI-341
> Project: jUDDI
> Issue Type: Bug
> Components: core
> Affects Versions: 3.0
> Reporter: Kurt T Stam
> Assignee: Kurt T Stam
> Fix For: 3.0.1
>
>
> Both dbs have issues with: the query:
> select distinct ss from Subscription ss where (ss.authorizedName = ?)
> "The text data type cannot be selected as DISTINCT because it is not
> comparable." I think it does a distinct over all the fields rather then just
> the PK, and one of the fields on subscription is "text", which is causing an
> issue.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
