7 Replies Latest reply on Apr 25, 2007 5:16 PM by Anders Andersen

    Jboss26CR1 --for mysql5

    kevnlin kevnlin Newbie

      dear all
      when I install Jboss26CR1 and Database is mysql5

      some talbe cannot be create

        • 2. Re: Jboss26CR1 --for mysql5
          kevnlin kevnlin Newbie

          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>

          • 3. Re: Jboss26CR1 --for mysql5
            kevnlin kevnlin Newbie

            ex: lose JBP_INSTANCE_PER_USER table

            • 4. Re: Jboss26CR1 --for mysql5
              Thomas Heute Master

              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 kevnlin Newbie

                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 kevnlin Newbie

                  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
                    Anders Andersen Newbie

                    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.