Trying to install Jboss portal, but having issue
wangyi1031 Mar 28, 2006 6:05 PMI 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.