-
1. Re: Jboss26CR1 --for mysql5
theute Apr 25, 2007 3:34 AM (in response to kevnlin)Please see the Wiki http://wiki.jboss.org/wiki/Wiki.jsp?page=AvoidMySQL5DataTruncationErrors
-
2. Re: Jboss26CR1 --for mysql5
kevnlin Apr 25, 2007 3:57 AM (in response to 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&jdbcCompliantTruncation=false</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
</local-tx-datasource> -
3. Re: Jboss26CR1 --for mysql5
kevnlin Apr 25, 2007 4:05 AM (in response to kevnlin)ex: lose JBP_INSTANCE_PER_USER table
-
4. Re: Jboss26CR1 --for mysql5
theute Apr 25, 2007 4:06 AM (in response to kevnlin)Try to delete the database and start again.
It has been tested against MySQL as with other databases.
Also please show the stacktace. -
5. Re: Jboss26CR1 --for mysql5
kevnlin Apr 25, 2007 4:47 AM (in response to 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 -
6. Re: Jboss26CR1 --for mysql5
kevnlin Apr 25, 2007 4:49 AM (in response to 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) -
7. Re: Jboss26CR1 --for mysql5
anders3 Apr 25, 2007 5:16 PM (in response to kevnlin)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.