4 Replies Latest reply on May 30, 2006 1:15 PM by saradhi1976

    JBoss Portal using Oracle

    andytsoy

      Dear all,
      I am using JBoss Portal 2.2. with JBoss -4.0.3 sp1
      I want to use Oracle, so I copy the portal-oracle-ds.xml and change the corresponding values inside the file. When I startup JBoss, It throw exception : ERROR [JDBCExceptionReporter] ORA-00942: ????????? .It seems that the table does not exist, But I saw there are tables created in oracle (jbp_.......) already. How can I fix it? Please give help ! Thank you!

      The followings are the part of startup log:

      09:26:58,126 INFO [SessionFactoryImpl] Checking 0 named queries
      09:26:58,829 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
      09:26:58,844 ERROR [JDBCExceptionReporter] ORA-00942: ?????????

      09:26:58,860 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
      09:26:58,876 ERROR [JDBCExceptionReporter] ORA-00942: ?????????

      09:26:58,891 INFO [Dialect] Using dialect: org.hibernate.dialect.Oracle9Dialect
      09:26:58,891 INFO [Configuration] processing extends queue
      09:26:58,907 INFO [Configuration] processing collection mappings
      09:26:58,907 INFO [Configuration] processing association property references
      09:26:58,907 INFO [Configuration] processing foreign key constraints
      09:26:58,907 INFO [Configuration] processing extends queue
      09:26:58,907 INFO [Configuration] processing collection mappings
      09:26:58,922 INFO [Configuration] processing association property references
      09:26:58,922 INFO [Configuration] processing foreign key constraints
      09:26:58,922 INFO [SchemaExport] Running hbm2ddl schema export
      09:26:58,938 INFO [SchemaExport] exporting generated schema to database
      09:26:58,938 INFO [NamingHelper] JNDI InitialContext properties:{}
      09:26:58,938 INFO [DatasourceConnectionProvider] Using datasource: java:PortalDS
      09:26:59,594 INFO [SchemaExport] schema export complete
      09:26:59,610 INFO [TreeCache] interceptor chain is:
      class org.jboss.cache.interceptors.CallInterceptor
      class org.jboss.cache.interceptors.LockInterceptor
      class org.jboss.cache.interceptors.CacheStoreInterceptor
      class org.jboss.cache.interceptors.CacheLoaderInterceptor
      class org.jboss.cache.interceptors.UnlockInterceptor
      09:26:59,626 INFO [TreeCache] cache mode is local, will not create the channel
      09:26:59,641 INFO [TreeCache] preloading transient state from cache loader
      09:26:59,766 INFO [TreeCache] preloading transient state from cache loader was successful (in 125 milliseconds)
      09:27:00,016 INFO [TreeCache] interceptor chain is:
      class org.jboss.cache.interceptors.CallInterceptor
      class org.jboss.cache.interceptors.LockInterceptor
      class org.jboss.cache.interceptors.UnlockInterceptor
      09:27:00,032 INFO [TreeCache] cache mode is local, will not create the channel
      09:27:00,032 INFO [Configuration] processing extends queue
      09:27:00,032 INFO [Configuration] processing collection mappings
      09:27:00,047 INFO [HbmBinder] Mapping collection: org.jboss.portal.core.impl.user.PreferencesGroupImpl.prefMap -> jbp_user_pref_set
      09:27:00,047 INFO [HbmBinder] Mapping collection: org.jboss.portal.core.impl.user.PreferencesImpl.content -> jbp_user_pref
      09:27:00,047 INFO [Configuration] processing association property references
      09:27:00,047 INFO [Configuration] processing foreign key constraints
      09:27:00,063 INFO [NamingHelper] JNDI InitialContext properties:{}
      09:27:00,063 INFO [DatasourceConnectionProvider] Using datasource: java:PortalDS
      09:27:00,063 INFO [SettingsFactory] RDBMS: Oracle, version: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit Production
      With the Partitioning, OLAP and Data Mining options
      09:27:00,063 INFO [SettingsFactory] JDBC driver: Oracle JDBC driver, version: 10.1.0.3.0
      09:27:00,079 INFO [Dialect] Using dialect: org.hibernate.dialect.Oracle9Dialect
      09:27:00,079 INFO [TransactionFactoryFactory] Transaction strategy: org.hibernate.transaction.JTATransactionFactory
      09:27:00,079 INFO [NamingHelper] JNDI InitialContext properties:{}
      09:27:00,079 INFO [TransactionManagerLookupFactory] instantiating TransactionManagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup
      09:27:00,094 INFO [TransactionManagerLookupFactory] instantiated TransactionManagerLookup
      09:27:00,094 INFO [TransactionManagerLookupFactory] instantiating TransactionManagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup
      09:27:00,094 INFO [TransactionManagerLookupFactory] instantiated TransactionManagerLookup
      09:27:00,094 INFO [SettingsFactory] Automatic flush during beforeCompletion(): enabled
      09:27:00,094 INFO [SettingsFactory] Automatic session close at end of transaction: enabled
      09:27:00,110 INFO [SettingsFactory] JDBC batch size: 15
      09:27:00,110 INFO [SettingsFactory] JDBC batch updates for versioned data: disabled
      09:27:00,110 INFO [SettingsFactory] Scrollable result sets: enabled
      09:27:00,110 INFO [SettingsFactory] JDBC3 getGeneratedKeys(): disabled
      09:27:00,110 INFO [SettingsFactory] Connection release mode: auto
      09:27:00,125 INFO [SettingsFactory] Default batch fetch size: 1
      09:27:00,125 INFO [SettingsFactory] Generate SQL with comments: disabled
      09:27:00,125 INFO [SettingsFactory] Order SQL updates by primary key: disabled
      09:27:00,125 INFO [SettingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
      09:27:00,141 INFO [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory
      09:27:00,141 INFO [SettingsFactory] Query language substitutions: {}
      09:27:00,141 INFO [SettingsFactory] Second-level cache: enabled
      09:27:00,141 INFO [SettingsFactory] Query cache: enabled
      09:27:00,141 INFO [SettingsFactory] Cache provider: org.hibernate.cache.EhCacheProvider
      09:27:00,157 INFO [SettingsFactory] Optimize cache for minimal puts: disabled
      09:27:00,157 INFO [SettingsFactory] Structured second-level cache entries: disabled
      09:27:00,157 INFO [SettingsFactory] Query cache factory: org.hibernate.cache.StandardQueryCacheFactory
      09:27:00,157 INFO [SettingsFactory] Statistics: disabled
      09:27:00,157 INFO [SettingsFactory] Deleted entity synthetic identifier rollback: disabled
      09:27:00,172 INFO [SettingsFactory] Default entity-mode: POJO
      09:27:00,172 INFO [SessionFactoryImpl] building session factory
      09:27:00,172 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.role.RoleImpl]; using defaults.
      09:27:00,282 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.PreferenceImpl]; using defaults.
      09:27:00,313 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.UserImpl]; using defaults.
      09:27:00,360 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.PreferencesImpl]; using defaults.
      09:27:00,391 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.PreferencesGroupImpl]; using defaults.
      09:27:00,407 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.UserImpl.dynamic]; using defaults.
      09:27:00,422 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.role.RoleImpl.users]; using defaults.
      09:27:00,422 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.PreferencesImpl.content]; using defaults.
      09:27:00,422 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.PreferenceImpl.strings]; using defaults.
      09:27:00,438 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.PreferencesGroupImpl.prefMap]; using defaults.
      09:27:00,438 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.UserImpl.roles]; using defaults.
      09:27:00,454 INFO [SessionFactoryObjectFactory] Not binding factory to JNDI, no JNDI name configured
      09:27:00,454 INFO [NamingHelper] JNDI InitialContext properties:{}
      09:27:00,454 INFO [UpdateTimestampsCache] starting update timestamps cache at region: org.hibernate.cache.UpdateTimestampsCache
      09:27:00,469 INFO [StandardQueryCache] starting query cache at region: org.hibernate.cache.StandardQueryCache
      09:27:00,469 INFO [SessionFactoryImpl] Checking 0 named queries
      09:27:00,485 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
      09:27:00,500 ERROR [JDBCExceptionReporter] ORA-00942: ?????????

      09:27:00,516 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
      09:27:00,516 ERROR [JDBCExceptionReporter] ORA-00942: ?????????

      09:27:00,532 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
      09:27:00,547 ERROR [JDBCExceptionReporter] ORA-00942: ?????????

      09:27:00,579 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
      09:27:00,579 ERROR [JDBCExceptionReporter] ORA-00942: ?????????

      09:27:00,594 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
      09:27:00,594 ERROR [JDBCExceptionReporter] ORA-00942: ?????????

      09:27:00,610 INFO [Dialect] Using dialect: org.hibernate.dialect.Oracle9Dialect
      09:27:00,610 INFO [Configuration] processing extends queue
      09:27:00,610 INFO [Configuration] processing collection mappings
      09:27:00,625 INFO [Configuration] processing association property references
      09:27:00,625 INFO [Configuration] processing foreign key constraints
      09:27:00,625 INFO [Configuration] processing extends queue
      09:27:00,625 INFO [Configuration] processing collection mappings
      09:27:00,625 INFO [Configuration] processing association property references
      09:27:00,641 INFO [Configuration] processing foreign key constraints
      09:27:00,641 INFO [SchemaExport] Running hbm2ddl schema export
      09:27:00,641 INFO [SchemaExport] exporting generated schema to database
      09:27:00,641 INFO [NamingHelper] JNDI InitialContext properties:{}
      09:27:00,657 INFO [DatasourceConnectionProvider] Using datasource: java:PortalDS
      09:27:01,500 INFO [SchemaExport] schema export complete
      09:27:01,500 INFO [SessionFactoryBinder] Creating database content
      09:27:01,735 INFO [Configuration] processing extends queue
      09:27:01,735 INFO [Configuration] processing collection mappings
      09:27:01,735 INFO [HbmBinder] Mapping collection: org.jboss.portal.core.impl.model.instance.InstanceImpl.preferencesMap -> JBP_INSTANCE_PREF
      09:27:01,735 INFO [Configuration] processing association property references
      09:27:01,750 INFO [Configuration] processing foreign key constraints
      09:27:01,750 INFO [NamingHelper] JNDI InitialContext properties:{}
      09:27:01,750 INFO [DatasourceConnectionProvider] Using datasource: java:PortalDS
      09:27:01,750 INFO [SettingsFactory] RDBMS: Oracle, version: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit Production
      With the Partitioning, OLAP and Data Mining options
      09:27:01,766 INFO [SettingsFactory] JDBC driver: Oracle JDBC driver, version: 10.1.0.3.0
      09:27:01,766 INFO [Dialect] Using dialect: org.hibernate.dialect.Oracle9Dialect
      09:27:01,766 INFO [TransactionFactoryFactory] Transaction strategy: org.hibernate.transaction.JTATransactionFactory
      09:27:01,766 INFO [NamingHelper] JNDI InitialContext properties:{}
      09:27:01,782 INFO [TransactionManagerLookupFactory] instantiating TransactionManagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup
      09:27:01,782 INFO [TransactionManagerLookupFactory] instantiated TransactionManagerLookup
      09:27:01,782 INFO [TransactionManagerLookupFactory] instantiating TransactionManagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup
      09:27:01,782 INFO [TransactionManagerLookupFactory] instantiated TransactionManagerLookup
      09:27:01,782 INFO [SettingsFactory] Automatic flush during beforeCompletion(): enabled
      09:27:01,797 INFO [SettingsFactory] Automatic session close at end of transaction: enabled
      09:27:01,797 INFO [SettingsFactory] JDBC batch size: 15
      09:27:01,797 INFO [SettingsFactory] JDBC batch updates for versioned data: disabled
      09:27:01,797 INFO [SettingsFactory] Scrollable result sets: enabled
      09:27:01,797 INFO [SettingsFactory] JDBC3 getGeneratedKeys(): disabled
      09:27:01,813 INFO [SettingsFactory] Connection release mode: auto
      09:27:01,813 INFO [SettingsFactory] Default batch fetch size: 1
      09:27:01,813 INFO [SettingsFactory] Generate SQL with comments: disabled
      09:27:01,813 INFO [SettingsFactory] Order SQL updates by primary key: disabled
      09:27:01,828 INFO [SettingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
      09:27:01,828 INFO [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory
      09:27:01,828 INFO [SettingsFactory] Query language substitutions: {}
      09:27:01,828 INFO [SettingsFactory] Second-level cache: enabled
      09:27:01,828 INFO [SettingsFactory] Query cache: enabled
      09:27:01,844 INFO [SettingsFactory] Cache provider: org.hibernate.cache.EhCacheProvider
      09:27:01,844 INFO [SettingsFactory] Optimize cache for minimal puts: disabled
      09:27:01,844 INFO [SettingsFactory] Structured second-level cache entries: disabled
      09:27:01,844 INFO [SettingsFactory] Query cache factory: org.hibernate.cache.StandardQueryCacheFactory
      09:27:01,844 INFO [SettingsFactory] Statistics: disabled
      09:27:01,860 INFO [SettingsFactory] Deleted entity synthetic identifier rollback: disabled
      09:27:01,860 INFO [SettingsFactory] Default entity-mode: POJO
      09:27:01,860 INFO [SessionFactoryImpl] building session factory
      09:27:01,875 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.instance.InstanceImpl]; using defaults.
      09:27:01,891 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.instance.PreferenceImpl]; using defaults.
      09:27:01,938 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.instance.InstanceImpl.preferencesMap]; using defaults.
      09:27:01,953 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.instance.PreferenceImpl.strings]; using defaults.
      09:27:01,953 INFO [SessionFactoryObjectFactory] Not binding factory to JNDI, no JNDI name configured
      09:27:01,953 INFO [NamingHelper] JNDI InitialContext properties:{}
      09:27:01,969 INFO [UpdateTimestampsCache] starting update timestamps cache at region: org.hibernate.cache.UpdateTimestampsCache
      09:27:01,969 INFO [StandardQueryCache] starting query cache at region: org.hibernate.cache.StandardQueryCache
      09:27:01,969 INFO [SessionFactoryImpl] Checking 0 named queries
      09:27:02,000 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
      09:27:02,000 ERROR [JDBCExceptionReporter] ORA-00942: ?????????

      09:27:02,032 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
      09:27:02,032 ERROR [JDBCExceptionReporter] ORA-00942: ?????????

      09:27:02,047 INFO [Dialect] Using dialect: org.hibernate.dialect.Oracle9Dialect
      09:27:02,047 INFO [Configuration] processing extends queue
      09:27:02,047 INFO [Configuration] processing collection mappings
      09:27:02,047 INFO [Configuration] processing association property references
      09:27:02,063 INFO [Configuration] processing foreign key constraints
      09:27:02,063 INFO [Configuration] processing extends queue
      09:27:02,063 INFO [Configuration] processing collection mappings
      09:27:02,063 INFO [Configuration] processing association property references
      09:27:02,063 INFO [Configuration] processing foreign key constraints
      09:27:02,078 INFO [SchemaExport] Running hbm2ddl schema export
      09:27:02,078 INFO [SchemaExport] exporting generated schema to database
      09:27:02,078 INFO [NamingHelper] JNDI InitialContext properties:{}
      09:27:02,078 INFO [DatasourceConnectionProvider] Using datasource: java:PortalDS
      09:27:02,422 INFO [SchemaExport] schema export complete
      09:27:02,422 INFO [Configuration] processing extends queue
      09:27:02,422 INFO [Configuration] processing collection mappings
      09:27:02,422 INFO [HbmBinder] Mapping collection: org.jboss.portal.core.impl.model.portal.ObjectNode.children -> JBP_OBJECT_NODE
      09:27:02,438 INFO [Configuration] processing association property references
      09:27:02,438 INFO [Configuration] processing foreign key constraints
      09:27:02,453 INFO [NamingHelper] JNDI InitialContext properties:{}
      09:27:02,453 INFO [DatasourceConnectionProvider] Using datasource: java:PortalDS
      09:27:02,453 INFO [SettingsFactory] RDBMS: Oracle, version: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit Production
      With the Partitioning, OLAP and Data Mining options
      09:27:02,469 INFO [SettingsFactory] JDBC driver: Oracle JDBC driver, version: 10.1.0.3.0
      09:27:02,469 INFO [Dialect] Using dialect: org.hibernate.dialect.Oracle9Dialect
      09:27:02,485 INFO [TransactionFactoryFactory] Transaction strategy: org.hibernate.transaction.JTATransactionFactory
      09:27:02,485 INFO [NamingHelper] JNDI InitialContext properties:{}
      09:27:02,485 INFO [TransactionManagerLookupFactory] instantiating TransactionManagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup
      09:27:02,485 INFO [TransactionManagerLookupFactory] instantiated TransactionManagerLookup
      09:27:02,485 INFO [TransactionManagerLookupFactory] instantiating TransactionManagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup
      09:27:02,500 INFO [TransactionManagerLookupFactory] instantiated TransactionManagerLookup
      09:27:02,500 INFO [SettingsFactory] Automatic flush during beforeCompletion(): enabled
      09:27:02,500 INFO [SettingsFactory] Automatic session close at end of transaction: enabled
      09:27:02,500 INFO [SettingsFactory] JDBC batch size: 15
      09:27:02,516 INFO [SettingsFactory] JDBC batch updates for versioned data: disabled
      09:27:02,516 INFO [SettingsFactory] Scrollable result sets: enabled
      09:27:02,516 INFO [SettingsFactory] JDBC3 getGeneratedKeys(): disabled
      09:27:02,516 INFO [SettingsFactory] Connection release mode: auto
      09:27:02,516 INFO [SettingsFactory] Default batch fetch size: 1
      09:27:02,532 INFO [SettingsFactory] Generate SQL with comments: disabled
      09:27:02,532 INFO [SettingsFactory] Order SQL updates by primary key: disabled
      09:27:02,532 INFO [SettingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
      09:27:02,532 INFO [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory
      09:27:02,532 INFO [SettingsFactory] Query language substitutions: {}
      09:27:02,547 INFO [SettingsFactory] Second-level cache: enabled
      09:27:02,547 INFO [SettingsFactory] Query cache: enabled
      09:27:02,547 INFO [SettingsFactory] Cache provider: org.hibernate.cache.EhCacheProvider
      09:27:02,547 INFO [SettingsFactory] Optimize cache for minimal puts: disabled
      09:27:02,563 INFO [SettingsFactory] Structured second-level cache entries: disabled
      09:27:02,563 INFO [SettingsFactory] Query cache factory: org.hibernate.cache.StandardQueryCacheFactory
      09:27:02,563 INFO [SettingsFactory] Statistics: disabled
      09:27:02,563 INFO [SettingsFactory] Deleted entity synthetic identifier rollback: disabled
      09:27:02,563 INFO [SettingsFactory] Default entity-mode: POJO
      09:27:02,578 INFO [SessionFactoryImpl] building session factory
      09:27:02,578 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.portal.PortalObjectImpl]; using defaults.
      09:27:02,703 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.portal.ObjectNode]; using defaults.
      09:27:02,735 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.portal.PortalImpl.windowStates]; using defaults.
      09:27:02,750 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.portal.PortalObjectImpl.declaredProperties]; using defau
      lts.
      09:27:02,750 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.portal.ObjectNode.children]; using defaults.
      09:27:02,750 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.portal.PortalImpl.modes]; using defaults.
      09:27:02,766 INFO [SessionFactoryObjectFactory] Not binding factory to JNDI, no JNDI name configured
      09:27:02,766 INFO [NamingHelper] JNDI InitialContext properties:{}
      09:27:02,782 INFO [UpdateTimestampsCache] starting update timestamps cache at region: org.hibernate.cache.UpdateTimestampsCache
      09:27:02,782 INFO [StandardQueryCache] starting query cache at region: org.hibernate.cache.StandardQueryCache
      09:27:02,782 INFO [SessionFactoryImpl] Checking 0 named queries
      09:27:02,797 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
      09:27:02,797 ERROR [JDBCExceptionReporter] ORA-00942: ?????????

      09:27:02,813 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
      09:27:02,828 ERROR [JDBCExceptionReporter] ORA-00942: ?????????

      09:27:02,844 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
      09:27:02,844 ERROR [JDBCExceptionReporter] ORA-00942: ?????????

      09:27:02,860 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
      09:27:02,860 ERROR [JDBCExceptionReporter] ORA-00942: ?????????

      09:27:02,875 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
      09:27:02,875 ERROR [JDBCExceptionReporter] ORA-00942: ?????????

      09:27:02,922 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
      09:27:02,922 ERROR [JDBCExceptionReporter] ORA-00942: ?????????

      09:27:02,922 INFO [Dialect] Using dialect: org.hibernate.dialect.Oracle9Dialect
      09:27:02,922 INFO [Configuration] processing extends queue
      09:27:02,938 INFO [Configuration] processing collection mappings
      09:27:02,938 INFO [Configuration] processing association property references
      09:27:02,938 INFO [Configuration] processing foreign key constraints
      09:27:02,938 INFO [Configuration] processing extends queue
      09:27:02,953 INFO [Configuration] processing collection mappings
      09:27:02,953 INFO [Configuration] processing association property references
      09:27:02,953 INFO [Configuration] processing foreign key constraints
      09:27:02,953 INFO [SchemaExport] Running hbm2ddl schema export
      09:27:02,969 INFO [SchemaExport] exporting generated schema to database
      09:27:02,969 INFO [NamingHelper] JNDI InitialContext properties:{}
      09:27:02,969 INFO [DatasourceConnectionProvider] Using datasource: java:PortalDS
      09:27:03,750 INFO [SchemaExport] schema export complete
      09:27:03,781 INFO [PersistentPortalObjectContainer] Created portal object root context
      09:27:05,000 WARN [ObjectDeployment] Cannot create portal object null because the parent that the deployment descriptor references does not exist
      09:27:05,000 WARN [ObjectDeployment] Cannot create portal object null because the parent default that the deployment descriptor references does not exist
      09:27:05,000 WARN [ObjectDeployment] Cannot create portal object null because the parent default that the deployment descriptor references does not exist
      09:27:05,031 WARN [ObjectDeployment] Cannot create portal object null because the parent default.default that the deployment descriptor references does not
      exist
      09:27:05,047 WARN [ObjectDeployment] Cannot create portal object null because the parent default.CMS Manager that the deployment descriptor references does
      not exist
      09:27:05,734 INFO [LayoutDeployment] create new layout(s), found in : /portal
      09:27:05,750 INFO [LayoutDeployment] done creating new layout(s), found in : /portal
      09:27:05,875 INFO [LayoutDeployment] create new layout(s), found in : portal
      09:27:05,891 INFO [LayoutDeployment] done creating new layout(s), found in : portal
      09:27:05,906 INFO [ThemeDeployment] create new theme(s), found in : portal
      09:27:05,922 INFO [ThemeDeployment] done creating new theme(s), found in : portal
      09:27:07,156 INFO [FacesConfigurator] Reading standard config org/apache/myfaces/resource/standard-faces-config.xml
      09:27:07,234 INFO [FacesConfigurator] Reading config jar:file:/D:/test-jboss-4.0.3/server/default/tmp/deploy/tmp60929jsf-facelets.jar!/META-INF/faces-confi
      g.xml
      09:27:07,234 INFO [FacesConfigurator] Reading config jar:file:/D:/test-jboss-4.0.3/server/default/tmp/deploy/tmp60941tomahawk.jar!/META-INF/faces-config.xm
      l
      09:27:07,312 INFO [FacesConfigurator] Reading config /WEB-INF/faces-config.xml
      09:27:07,344 ERROR [LocaleUtils] Locale name null or empty, ignoring
      09:27:07,359 INFO [RenderKitFactoryImpl] RenderKit with renderKitId 'HTML_BASIC' was replaced.
      09:27:07,359 INFO [MyFacesGenericPortlet] PortletContext 'D:\test-jboss-4.0.3\server\default\.\deploy\jboss-portal.sar\portal-core.war\' initialized.
      09:27:07,547 WARN [ObjectDeployment] Cannot create portal object null because the parent default that the deployment descriptor references does not exist
      09:27:08,437 INFO [TomcatDeployer] deploy, ctxPath=/nggDataExtractor, warUrl=.../tmp/deploy/tmp6101511nggDataExtractor-exp.war/
      09:27:08,594 INFO [NGGDataExtractorPortlet] mips.nggDataExtractor.portlet.NGGDataExtractorPortlet: Called init()
      09:27:08,594 WARN [ObjectDeployment] Cannot create portal object null because the parent default that the deployment descriptor references does not exist
      09:27:08,719 INFO [TomcatDeployer] deploy, ctxPath=/nggDefaultInfo, warUrl=.../tmp/deploy/tmp6101612nggDefaultInfo-exp.war/

        • 1. Re: JBoss Portal using Oracle
          andytsoy

          The "?????????" is chinese characters mean the table does not exist.

          • 2. Re: JBoss Portal using Oracle
            andytsoy

            I have done one more things, there is no error on table or view does not exist, that is in
            <JBOSS_HOME>\server\default\deploy\jboss-portal.sar\conf\hibernate
            named hibernate.cfg.xml with the following uncomment:
            <!-- Force the dialect instead of using autodetection -->
            org.hibernate.dialect.Oracle9Dialect

            But my portal object still cannot be found, detail as following:

            10:21:37,434 INFO [StandardQueryCache] starting query cache at region: org.hibernate.cache.StandardQueryCache
            10:21:37,434 INFO [SessionFactoryImpl] Checking 0 named queries
            10:21:37,934 INFO [PersistentPortalObjectContainer] Created portal object root context
            10:21:38,043 WARN [ObjectDeployment] Cannot create portal object null because the parent that the deployment descriptor references does not exist
            10:21:38,043 WARN [ObjectDeployment] Cannot create portal object null because the parent default that the deployment descriptor references does not exist
            10:21:38,059 WARN [ObjectDeployment] Cannot create portal object null because the parent default that the deployment descriptor references does not exist
            10:21:38,059 WARN [ObjectDeployment] Cannot create portal object null because the parent default.default that the deployment descriptor references does not
            exist
            10:21:38,074 WARN [ObjectDeployment] Cannot create portal object null because the parent default.CMS Manager that the deployment descriptor references does
            not exist
            10:21:38,293 INFO [LayoutDeployment] create new layout(s), found in : /portal
            10:21:38,293 INFO [LayoutDeployment] done creating new layout(s), found in : /portal
            10:21:38,480 INFO [LayoutDeployment] create new layout(s), found in : portal
            10:21:38,512 INFO [LayoutDeployment] done creating new layout(s), found in : portal
            10:21:38,512 INFO [ThemeDeployment] create new theme(s), found in : portal
            10:21:38,527 INFO [ThemeDeployment] done creating new theme(s), found in : portal
            10:21:40,074 INFO [FacesConfigurator] Reading standard config org/apache/myfaces/resource/standard-faces-config.xml
            10:21:40,152 INFO [FacesConfigurator] Reading config jar:file:/D:/test-jboss-4.0.3/server/default/tmp/deploy/tmp20319jsf-facelets.jar!/META-INF/faces-confi
            g.xml
            10:21:40,168 INFO [FacesConfigurator] Reading config jar:file:/D:/test-jboss-4.0.3/server/default/tmp/deploy/tmp20331tomahawk.jar!/META-INF/faces-config.xm
            l
            10:21:40,246 INFO [FacesConfigurator] Reading config /WEB-INF/faces-config.xml
            10:21:40,277 ERROR [LocaleUtils] Locale name null or empty, ignoring
            10:21:40,293 INFO [RenderKitFactoryImpl] RenderKit with renderKitId 'HTML_BASIC' was replaced.
            10:21:40,293 INFO [MyFacesGenericPortlet] PortletContext 'D:\test-jboss-4.0.3\server\default\.\deploy\jboss-portal.sar\portal-core.war\' initialized.
            10:21:40,512 WARN [ObjectDeployment] Cannot create portal object null because the parent default that the deployment descriptor references does not exist
            10:21:40,871 INFO [TomcatDeployer] deploy, ctxPath=/nggDataExtractor, warUrl=.../tmp/deploy/tmp2040511nggDataExtractor-exp.war/
            10:21:41,058 INFO [NGGDataExtractorPortlet] mips.nggDataExtractor.portlet.NGGDataExtractorPortlet: Called init()
            10:21:41,058 WARN [ObjectDeployment] Cannot create portal object null because the parent default that the deployment descriptor references does not exist
            10:21:41,308 INFO [TomcatDeployer] deploy, ctxPath=/nggDefaultInfo, warUrl=.../tmp/deploy/tmp2040612nggDefaultInfo-exp.war/
            10:21:41,449 INFO [NGGDefaultInfoPortlet] mips.nggDefaultInfo.portlet.NGGDefaultInfoPortlet: Called init()
            10:21:41,449 WARN [ObjectDeployment] Cannot create portal object null because the parent default that the deployment descriptor references does not exist
            10:21:41,590 INFO [TomcatDeployer] deploy, ctxPath=/nggVersionInfo, warUrl=.../tmp/deploy/tmp2040713nggVersionInfo-exp.war/

            • 3. Re: JBoss Portal using Oracle
              theute

              Tables don't exist at the first startup, then the error messages. Don't worry, since they don't exist JBoss Portal creates them. On second startup, you won't have those messages again since they will be existing.

              • 4. Re: JBoss Portal using Oracle
                saradhi1976

                Hi,

                I am using JBOSS Portal 2.2 on JBoss AS 4.0.3SP1, Oracle 10G/XE. I configured the portal-oracle-ds.xml file.

                I have restarted the JBOSS couple of times, but still I got the messages

                [ObjectDeployment] Cannot create portal object null because the parent that the deployment descriptor references does not exist
                [ObjectDeployment] Cannot create portal object null because the parent default that the deployment descriptor references does not exist
                [ObjectDeployment] Cannot create portal object null because the parent default that the deployment descriptor references does not exist
                [ObjectDeployment] Cannot create portal object null because the parent default.default that the deployment descriptor references does not exists.

                [ObjectDeployment] Cannot create portal object null because the parent default.CMS Manager that the deployment descriptor references does not exists.



                I have done one more things, there is no error on table or view does not exist, that is in
                <JBOSS_HOME>\server\default\deploy\jboss-portal.sar\conf\hibernate
                named hibernate.cfg.xml with the following uncomment:
                <!-- Force the dialect instead of using autodetection -->
                org.hibernate.dialect.Oracle9Dialect


                Can you please help me to getrid of this error.
                What is the necessary config needs to be done.


                Thanks in advance
                Saradhi