Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-2355

Hibernate queries not working with Oracle 9

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 1.5 M2
    • None
    • {Unused} Core
    • 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.

      Attachments

        Activity

          People

            sdumitriu Sergiu Dumitriu
            jgerbracht jeff gerbracht
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: