[KULRICE-13302] RoleDaoJdbc creates invalid sql statement when saving new proposal Created: 19/Sep/14  Updated: 11/Nov/14  Resolved: 30/Sep/14

Status: Closed
Project: Kuali Rice Development
Component/s: Development
Affects Version/s: 2.5
Fix Version/s: 2.5.1
Security Level: Public (Public: Anyone can view)

Type: Bug Fix Priority: Major
Reporter: Joe Williams Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
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:
Application Requirement:
KAI Review Status: Not Required
KTI Review Status: Not Required
Code Review Status: Not Required
Include in Release Notes?:


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.

Comment by Gayathri Athreya [ 30/Sep/14 ]


Comment by Martin Taylor (Inactive) [ 11/Nov/14 ]

Closing 2.5.1 Development

Generated at Fri May 29 04:30:07 CDT 2020 using JIRA 6.1.5#6160-sha1:a61a0fc278117a0da0ec9b89167b8f29b6afdab2.