Jboss26CR1 --for mysql5

[kevnlin]

dear all
when I install Jboss26CR1 and Database is mysql5

some talbe cannot be create

[theute]

Please see the Wiki http://wiki.jboss.org/wiki/Wiki.jsp?page=AvoidMySQL5DataTruncationErrors

[kevnlin]

on jboss26beta1 ,the portal server is work ,
but on jboss26cr1 ,the portal is not work
table not be create

my mysql-ds.xml

<local-tx-datasource>
<jndi-name>PortalDS</jndi-name>
<connection-url>jdbc:mysql://192.168.1.254:8888/jbossportal26b?useServerPrepStmts=false&amp;jdbcCompliantTruncation=false</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
</local-tx-datasource>

[kevnlin]

ex: lose JBP_INSTANCE_PER_USER table

[theute]

Try to delete the database and start again.

It has been tested against MySQL as with other databases.

Also please show the stacktace.

[kevnlin]

2007-04-25 16:20:34,379 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2007-04-25 16:20:34,379 DEBUG [org.hibernate.jdbc.ConnectionManager] aggressively releasing JDBC connection
2007-04-25 16:20:34,380 DEBUG [org.hibernate.jdbc.ConnectionManager] releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2007-04-25 16:20:34,381 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not execute query [select taskinstan0_.ID_ as ID1_26_, taskinstan0_.DESTINATION_ as DESTINAT3_26_, taskinstan0_.EXCEPTION_ as EXCEPTION4_26_, taskinstan0_.ISSUSPENDED_ as ISSUSPEN5_26_, taskinstan0_.TOKEN_ as TOKEN6_26_, taskinstan0_.TRANSITIONNAME_ as TRANSIT10_26_, taskinstan0_.TASKINSTANCE_ as TASKINS11_26_ from JBPM_MESSAGE taskinstan0_ where taskinstan0_.CLASS_='K']
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'jbossp26.JBPM_MESSAGE' doesn't exist
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3249)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1403)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1668)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2144)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028)
at org.hibernate.loader.Loader.list(Loader.java:2023)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionIm

[kevnlin]

007-04-25 16:20:39,826 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Warning: 1051, SQLState: 42S02
2007-04-25 16:20:39,826 WARN [org.hibernate.util.JDBCExceptionReporter] Unknown table 'JBPM_ID_PERMISSIONS'
2007-04-25 16:20:39,827 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport]
drop table if exists JBPM_ID_USER
2007-04-25 16:20:39,832 DEBUG [org.hibernate.util.JDBCExceptionReporter] SQL Warning
java.sql.SQLWarning: Unknown table 'JBPM_ACTION'
at com.mysql.jdbc.SQLError.convertShowWarningsToSQLWarnings(SQLError.java:730)
at com.mysql.jdbc.SQLError.convertShowWarningsToSQLWarnings(SQLError.java:658)
at com.mysql.jdbc.Statement.getWarnings(Statement.java:1945)
at org.jboss.resource.adapter.jdbc.WrappedStatement.getWarnings(WrappedStatement.java:144)
at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:309)
at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:284)
at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:186)
at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:133)
at org.jboss.portal.jems.hibernate.SessionFactoryBinder.createSchema(SessionFactoryBinder.java:343)
at org.jboss.portal.jems.hibernate.SessionFactoryBinder.startService(SessionFactoryBinder.java:259)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:196)
at org.jboss.portal.jems.as.system.AbstractJBossService.start(AbstractJBossService.java:73)
at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.portal.jems.as.system.JBossServiceModelMBean$ServiceMixin.execute(JBossServiceModelMBean.java:428)
at org.jboss.portal.jems.as.system.JBossServiceModelMBean$ServiceMixin.startService(JBossServiceModelMBean.java:394)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:196)
at org.jboss.portal.jems.as.system.JBossServiceModelMBean$5.invoke(JBossServiceModelMBean.java:316)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:995)
at $Proxy0.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:417)
at org.jboss.system.ServiceController.start(ServiceController.java:435)
at org.jboss.system.ServiceController.start(ServiceController.java:435)
at org.jboss.system.ServiceController.start(ServiceController.java:435)
at org.jboss.system.ServiceController.start(ServiceController.java:435)

[anders3]

I Also had to drop all tables in my mysql5.0 in order to make it work.
But then it worked for me.
The driver can be found in kit in file: setup/portal-mysql5-ds.xml

I have tried mysql 5.1, and here I had problems with some tables
But Mysql 5.1 is also not for production yet, as far as mysql write on the home page.