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

Hibernate exception when querying ModeShape repositories with Oracle DB backend

XMLWordPrintable

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

      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.

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

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

                Created:
                Updated:
                Resolved: