Details
-
Bug
-
Resolution: Fixed
-
Major
-
None
-
None
-
hibernate, oracle, null, patch
-
Description
There are several hibernate queries that do not work in oracle due to the way oracle treats blank strings and nulls
in XWikiHibernateStore.jaga
select doc.language from XWikiDocument as doc where doc.web = 'Main' and
doc.name = 'WebHome' and doc.language <> ''
There were also three instances of
nameFilter = "name not like '%.%' and name <> ''";
in XWikiStatsServiceImpl.java.
If these are changed to is not null instead of <> '', this will work in oracle, though I'm not sure of possible impacts to other databases.