Kuali Rice Development
  1. Kuali Rice Development
  2. KULRICE-13302

RoleDaoJdbc creates invalid sql statement when saving new proposal

    Details

    • Type: Bug Fix Bug Fix
    • Status: Closed Closed
    • Priority: Major Major
    • Resolution: Duplicate
    • Affects Version/s: 2.5
    • Fix Version/s: 2.5.1
    • Component/s: Development
    • Security Level: Public (Public: Anyone can view)
    • Labels:
      None
    • Similar issues:
      KULRICE-12842RoleDaoJdbc generating wrong SQL when null qualifier passed in.
      KULRICE-5400Case/When statement does not execute RequiredConstraint (SimpleConstraint) DictionaryValidatoinServiceImpl
      KULRICE-7291caching issue exposed when creating agenda for new context
      KULRICE-5933Error saving a newly created agenda with a new rule.
      KULRICE-3585Can't create new Role, get exception incident page
      KULRICE-8277Several ITs fail with OJB operation; bad SQL grammar []; nested exception is java.sql.SQLException: ORA-00904: "ROUTEHEADERID": invalid identifier
      KULRICE-8458Shared: System Displays Stack Trace Error Upon User Clicking Save After Entering Invalid Namespace Code
      KULRICE-12601Term Parameters are not saved when a Term is created or copied
      KULRICE-1540Invalid bootstrap.sql file created
      KULRICE-7094DocumentSearchGeneratorImpl creates bad SQL when UI date format is changed
    • Rice Module:
      KIM
    • Application Requirement:
      KC
    • KAI Review Status:
      Not Required
    • KTI Review Status:
      Not Required
    • Code Review Status:
      Not Required
    • Include in Release Notes?:
      Yes

      Description

      when I try to save a new proposal i get a bad sql grammar exception. appears to happen when the qualification values passed to getRoleMemebersForRoleIds are empty. starting on line 149 of RoleDaoJdbc produces "where () and" in the sql statement which is not valid.

        Activity

        Show
        Gayathri Athreya added a comment - https://jira.kuali.org/browse/KULRICE-12842
        Hide
        Martin Taylor (Inactive) added a comment -

        Closing 2.5.1 Development

        Show
        Martin Taylor (Inactive) added a comment - Closing 2.5.1 Development

          People

          • Assignee:
            Unassigned
            Reporter:
            Joe Williams
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Structure Helper Panel