2 Replies Latest reply on Mar 30, 2006 12:27 PM by y w

    Trying to install Jboss portal, but having issue

    y w Newbie

      I am trying to install jboss portal in my PC. I tried integrate jboss portal sar with my exiting jboss app server and use the bundle portal. However, I got the same error in both ways:

      14:58:17,969 WARN [EhCacheProvider] Could not find configuration [org.hibernate
      .cache.StandardQueryCache]; using defaults.
      14:58:17,979 WARN [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02
      14:58:17,979 ERROR [JDBCExceptionReporter] Table 'jbossportal.jbp_users' doesn't
       exist
      14:58:17,989 WARN [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02
      14:58:17,989 ERROR [JDBCExceptionReporter] Table 'jbossportal.jbp_user_pref' doe
      sn't exist
      14:58:17,999 WARN [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02
      14:58:17,999 ERROR [JDBCExceptionReporter] Table 'jbossportal.jbp_roles' doesn't
       exist
      14:58:18,009 WARN [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02
      14:58:18,009 ERROR [JDBCExceptionReporter] Table 'jbossportal.jbp_user_pref_set'
       doesn't exist
      14:58:18,039 WARN [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02
      14:58:18,039 ERROR [JDBCExceptionReporter] Table 'jbossportal.jbp_user_prefs_gro
      up' doesn't exist
      14:58:18,039 INFO [Dialect] Using dialect: org.hibernate.dialect.MySQLDialect
      14:58:18,050 INFO [SchemaExport] Running hbm2ddl schema export
      14:58:18,050 INFO [SchemaExport] exporting generated schema to database
      14:58:18,050 INFO [NamingHelper] JNDI InitialContext properties:{}
      14:58:18,050 INFO [DatasourceConnectionProvider] Using datasource: java:PortalD
      S
      14:58:20,814 INFO [SchemaExport] schema export complete
      14:58:20,814 INFO [SessionFactoryBinder] Creating database content
      14:58:21,625 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: 01004
      14:58:21,625 ERROR [JDBCExceptionReporter] Data truncation: Data too long for co
      lumn 'jbp_viewrealemail' at row 1
      14:58:21,635 ERROR [SessionFactoryBinder] Error in the bsh script
      Sourced file: inline evaluation of: ``// This bsh script setup the default conte
      nt of the portal. // It is called when . . . '' : Method Invocation session.save
       : at Line: 41 : in file: inline evaluation of: ``// This bsh script setup the d
      efault content of the portal. // It is called when . . . '' : session .save ( ad
      min )
      
      Target exception: org.hibernate.exception.GenericJDBCException: could not insert
      : [org.jboss.portal.core.impl.user.UserImpl]
      
      




      Checking table column viewRealEmail, the type is bit, but in setup.txt the pass value is "true".

      Could you please help me to figure out what I did is incorrect? I followed the installation manual step by step.

      Thanks very much.

      AT&T
      Richard.