Trying to install Jboss portal, but having issue

[wangyi1031]

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.

[rutfield]

This has been mentioned previously in this forum.

The workaround for now is to add "jdbcCompliantTruncation=false" to the connection url in the -ds.xml file.

It only works if the MySQL5 server is *not* set to strict mode (see following mysql bug report: http://bugs.mysql.com/bug.php?id=14048 )

To prevent the server from throwing errors instead of warnings in strict mode, remove the "STRICT_TRANS_TABLES" part from sql-mode=STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION in my.ini.


Or you can try changing the following:

jbp_viewrealemail TINYINT(1)
jbp_enabled TINYINT(1)

The other tables should have been created in your portal database when the initialization saw they did not exist.

Did that work?
CR

[wangyi1031]

Hi, rutfield,

I tried both ways. They work fine.

Thanks very much.

Richard