0 Replies Latest reply on May 3, 2006 2:04 PM by Matthew Richardson

    jboss + portal + oracle = has issues

    Matthew Richardson Newbie

      1) describe your environment:
      -> What JBoss version are you using: 4.0.3SP1
      -> What JBoss Portal version are you using: 2.2.1 binaries
      -> What database you are using with version number: Oracle 10g 10.2.0.1.0
      -> What JDBC connector you are using: Oracle JDBC Driver for Oracle 10gR2
      -> What jdk are you using: Sun jdk-1_5_0_6

      2) describe the problem:
      During initial port initialization I get errors creating the tables/views, etc.

      00:13:36,625 WARN [JDBCExceptionReporter] SQL Error: 17068, SQLState: null
      00:13:36,626 ERROR [JDBCExceptionReporter] Invalid argument(s) in call
      00:13:36,626 ERROR [SchemaUpdate] could not complete schema update
      org.hibernate.exception.GenericJDBCException: could not get table metadata: jbp_cms_cmsentry
       at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91)


      00:13:38,097 INFO [SchemaUpdate] updating schema
      00:13:38,098 INFO [Configuration] processing extends queue
      00:13:38,099 INFO [Configuration] processing collection mappings
      00:13:38,100 INFO [Configuration] processing association property references
      00:13:38,101 INFO [Configuration] processing foreign key constraints
      00:13:38,389 WARN [JDBCExceptionReporter] SQL Error: 17068, SQLState: null
      00:13:38,411 ERROR [JDBCExceptionReporter] Invalid argument(s) in call
      00:13:38,413 ERROR [SchemaUpdate] could not complete schema update
      org.hibernate.exception.GenericJDBCException: could not get table metadata: jbp_cms_cmsentry


      00:13:45,649 INFO [SchemaUpdate] fetching database metadata
      00:13:45,662 INFO [SchemaUpdate] updating schema
      00:13:45,666 INFO [Configuration] processing extends queue
      00:13:45,667 INFO [Configuration] processing collection mappings
      00:13:45,678 INFO [Configuration] processing association property references
      00:13:45,685 INFO [Configuration] processing foreign key constraints
      00:13:45,795 WARN [JDBCExceptionReporter] SQL Error: 17068, SQLState: null
      00:13:45,796 ERROR [JDBCExceptionReporter] Invalid argument(s) in call
      00:13:45,800 ERROR [SchemaUpdate] could not complete schema update
      org.hibernate.exception.GenericJDBCException: could not get table metadata: jbp_cms_version_binval


      00:13:46,558 INFO [NamingHelper] JNDI InitialContext properties:{}
      00:13:46,560 INFO [SessionFactoryImpl] Checking 0 named queries
      00:13:46,561 INFO [HibernatePersistenceManager] HibernateSessionFactory Created.
      00:13:58,308 ERROR [[PortalServletWithPathMapping]] Servlet.service() for servlet PortalServletWithPathMapping threw exception
      java.lang.NullPointerException
       at org.jboss.portal.core.impl.model.portal.PersistentPortalObjectContainer.getObject(PersistentPortalObjectContainer.java:153)
       at org.jboss.portal.core.impl.model.portal.PersistentPortalObjectContainer.getContext(PersistentPortalObjectContainer.java:171)


      I also get random messages like

      Skipping aggresive-release due to open resources on batcher


      Thanks for any insight,
      Matt