[jboss-jira] [JBoss JIRA] Commented: (JBPORTAL-1999) Adding properties through the admin portlet on Oracle fails
[ http://jira.jboss.com/jira/browse/JBPORTAL-1999?page=comments#action_1240... ]
Thomas Heute commented on JBPORTAL-1999:
----------------------------------------
See the comments on: http://blog.thomas.heute.name/2008/04/oracle-db-you-suck.html
It looks like we may not get a fix soon...
I'm a bit reluctant to pollute other databases because of an Oracle issue, at the same
time we cannot leave that open... I still hope we can find a workaround that doesn't
mess up the DB otherwise we will have to go with a JBP_EMPTY_STRING value...
Adding properties through the admin portlet on Oracle fails
-----------------------------------------------------------
Key: JBPORTAL-1999
URL: http://jira.jboss.com/jira/browse/JBPORTAL-1999
Project: JBoss Portal
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Portal Core
Affects Versions: 2.6.4 Final
Reporter: Thomas Heute
Assigned To: Thomas Heute
Fix For: 2.7 Final, 2.6.5 Final
When assigning a property on a portal object through the admin portlet using an Oracle
database, it fails.
This is due to the fact that Oracle considers "" (empty String) as NULL...
(Stupid)
The following scenario happens:
- Store the property value "" on portal object A
- Get the property of portal Object A --> NULL
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira