Bug 536526 (RHQ-867) - config props with empty string value (i.e. "") are persisted as NULL by Oracle, so the actual value is lost
Summary: config props with empty string value (i.e. "") are persisted as NULL by Oracl...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: RHQ-867
Product: RHQ Project
Classification: Other
Component: Configuration
Version: 1.0.1
Hardware: All
OS: All
medium
medium
Target Milestone: ---
: ---
Assignee: RHQ Project Maintainer
QA Contact:
URL: http://jira.rhq-project.org/browse/RH...
Whiteboard:
Depends On:
Blocks: rhq_triage
TreeView+ depends on / blocked
 
Reported: 2008-09-20 01:41 UTC by Ian Springer
Modified: 2014-05-15 21:17 UTC (History)
4 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2014-05-15 21:16:15 UTC
Embargoed:


Attachments (Terms of Use)

Description Ian Springer 2008-09-20 01:41:00 UTC
This is unfortunate, because we jumped through a lot of hoops in the GUI layer to distinguish null (aka unset) values from empty values. This was to allow a user to specify one or the other, depending on if they want the prop to be unset (which tells the plugin to either specify null as the value or to not specify any value), or if they want the property to literally have "" as the value. This distinction is currently thrown away if the Server database is Oracle. The solution is probably to store some sort of special marker value in the DB to represent an empty string (e.g. a TAB character or some other character that's impossible to even enter via the GUI).


Comment 1 Red Hat Bugzilla 2009-11-10 21:18:32 UTC
This bug was previously known as http://jira.rhq-project.org/browse/RHQ-867


Comment 2 wes hayutin 2010-02-16 16:59:23 UTC
Temporarily adding the keyword "SubBug" so we can be sure we have accounted for all the bugs.

keyword:
new = Tracking + FutureFeature + SubBug

Comment 3 wes hayutin 2010-02-16 17:04:30 UTC
making sure we're not missing any bugs in rhq_triage

Comment 4 Corey Welton 2010-10-07 03:47:22 UTC
ips - isn't this a dupe of something?

Comment 5 Ian Springer 2010-10-07 16:59:17 UTC
No, I don't think so.


Note You need to log in before you can comment on or make changes to this bug.