[OPENMEETINGS-531] Error Missing[XXXX]

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0 Apache Incubator Release
• Fix Version/s: 2.1.0 Apache Release
• Component/s: UI
• Environment: Windows and Oracle
• Assignee: Steve R Wagner
• Reporter: DROOPY
• Created: 18/Feb/13 03:07
• Updated: 01/Feb/19 14:59
• Resolved: 18/Feb/13 04:59

Description

UI display Error Missing[XXXX] when I use Oracle

ERROR 02-18 11:08:27.781 Fieldmanagment.java 678985 255 org.openmeetings.app.data.basic.Fieldmanagment [NioProcessor-2] - [getLabelsByLanguage]:
java.lang.NullPointerException: null
at org.openmeetings.app.data.basic.Fieldmanagment.performReplace(Fieldmanagment.java:591) ~[openmeetings-2.0.0-RELEASE.jar:na]
at org.openmeetings.app.data.basic.Fieldmanagment.getLabelsByLanguage(Fieldmanagment.java:209) ~[openmeetings-2.0.0-RELEASE.jar:na]

Because in Oracle "" == null

These rows in Oracle the value field is null.

select t.value
from FIELDLANGUAGESVALUES t
where t.language_id = 11
and t.fieldvalues_id in
(300, 400, 971, 998, 1012, 1027, 1028, 1199, 1205)

org.openmeetings.app.data.basic.Fieldmanagment
line 205-211
for (Object fl : query.getResultList())

{ Map<String, Object> map = new HashMap<String, Object>(); Object[] row = (Object[])fl; map.put("id", (Long)row[0]); map.put("value", -------------------------> performReplace((String)row[1], appName) <-------------------------); returnList.add(map); }

when id in (300, 400, 971, 998, 1012, 1027, 1028, 1199, 1205)
NullPointerException Occur
the loop was break and the other row was not add into the List