ofbiz-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Scott Gray (JIRA)" <j...@apache.org>
Subject [jira] Assigned: (OFBIZ-2396) "Manage Picklist" errors out with MS-Sql when there is more than 1 pick list
Date Fri, 01 May 2009 08:05:30 GMT

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

Scott Gray reassigned OFBIZ-2396:
---------------------------------

    Assignee: Scott Gray

> "Manage Picklist" errors out with MS-Sql when there is more than 1 pick list
> ----------------------------------------------------------------------------
>
>                 Key: OFBIZ-2396
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2396
>             Project: OFBiz
>          Issue Type: Bug
>          Components: product
>    Affects Versions: Release Branch 4.0
>            Reporter: Brian Sanders
>            Assignee: Scott Gray
>             Fix For: Release Branch 4.0
>
>         Attachments: picklist.patch
>
>
> This may not affect other DBMS', but it definitely affects MS-Sql. Even though a "workaround"
would be to only have 1 picklist at a time, I don't exactly consider that acceptable. Fortunately,
it's an easy fix. It looks like this issue still lurks in the trunk as well. To sum it up,
getPicklistSingleInfoInline is called for each picklist. In the method there is an "orderBy"
list to which "sequenceId" is added. The first pass works fine, on the second pass, "sequenceId"
is added to the list again and MS-Sql complains because the column is in the "order by" clause
twice. The solution is to clear the field before-hand.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message