Uploaded image for project: 'ModeShape'
  1. ModeShape
  2. MODE-1094

Hibernate exception when querying ModeShape repositories with Oracle DB backend

    XMLWordPrintable

Details

    • Bug
    • Resolution: Cannot Reproduce
    • Major
    • 2.5.0.Final
    • 2.2.1.GA
    • Storage
    • None

    Description

      In admin console, Repositories folder under ModeShape node is missing.

      WARN  [org.rhq.core.pc.inventory.InventoryManager] Failure during discovery for [Repositories] Resources - failed after 27887 ms.
      java.lang.Exception: Discovery component invocation failed.
      ...
      Caused by: java.lang.reflect.UndeclaredThrowableException: Failed to invoke method 'getRepositoryVersion' on component 'ModeShapeEngine' with parameters [SimpleMetaType:java.lang.String:eds].
      ...
      Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not load an entity: [org.modeshape.connector.store.jpa.util.StoreOptionEntity#org.modeshape.store.rootNodeUuid]
      ...
      Caused by: org.hibernate.exception.SQLGrammarException: could not load an entity: [org.modeshape.connector.store.jpa.util.StoreOptionEntity#org.modeshape.store.rootNodeUuid]
      ...
      Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
      

      Compare attached server_fail.log and server_success.log and lookup first occurrence of /* load org.modeshape.connector.store.jpa.util.StoreOptionEntity */ to see the point where the problem arises.

      Also take into account that the database account is re-used and the clean up is automated.

      Attachments

        1. create.modeshape-jpa-connector.ddl
          2 kB
        2. drop.modeshape-jpa-connector.ddl
          0.4 kB
        3. modeshape-config.xml
          7 kB
        4. modeshape-eds-store-ds.xml
          1 kB
        5. Screen shot 2011-05-16 at 4.54.37 PM.png
          Screen shot 2011-05-16 at 4.54.37 PM.png
          64 kB
        6. server.log
          102 kB

        Activity

          People

            van.halbert Van Halbert (Inactive)
            jlocker Jiří Locker
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: