I followed the insttructions of chapter 8.2 to get the cmproster application runngin with MySql 4.1.7. Unfortunatley I keep getting the error shown below.
The first 3 tables are created correctly. As far as I understand, then the generated DDL trys to create a primary key which is to long. Any ideas about how to fix this? Best Regards Ernst | 09:18:39,087 INFO [EARDeployer] Init J2EE application: file:/C:/Programme/jboss-4.0.1/server/default/deploy/RosterApp.ear | 09:18:39,306 INFO [EjbModule] Deploying RosterBean | 09:18:39,462 INFO [EjbModule] Deploying TeamBean | 09:18:39,493 INFO [EjbModule] Deploying LeagueBean | 09:18:39,509 INFO [EjbModule] Deploying PlayerBean | 09:18:39,728 INFO [EJBDeployer] Deployed: file:/C:/Programme/jboss-4.0.1/server/default/tmp/deploy/tmp4586RosterApp.ear-contents/roster-ejb.jar | 09:18:40,509 ERROR [EntityContainer] Starting failed jboss.j2ee:jndiName=local/PlayerBean,service=EJB | org.jboss.deployment.DeploymentException: Error while creating table PlayerBean_teams_TeamBean_players; - nested throwable: (java.sql.SQLException: Syntax error or access violation message from server: "Specified key was too long; max key length is 1 | 000 bytes") | at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:540) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:302) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:484) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:381) | at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:157) | at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:340) | at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:272) | at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:222) | at sun.reflect.GeneratedMethodAccessor152.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:144) | at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80) | at org.jboss.mx.server.Invocation.invoke(Invocation.java:72) | at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642) | at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:891) | at $Proxy0.start(Unknown Source) | at org.jboss.system.ServiceController.start(ServiceController.java:416) | at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:144) | at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80) | at org.jboss.mx.server.Invocation.invoke(Invocation.java:72) | at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642) | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) | at $Proxy75.start(Unknown Source) | at org.jboss.ejb.EjbModule.startService(EjbModule.java:394) | at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:272) | at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:222) | at sun.reflect.GeneratedMethodAccessor152.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:144) | at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80) | at org.jboss.mx.server.Invocation.invoke(Invocation.java:72) | at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642) | at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:891) | at $Proxy0.start(Unknown Source) | at org.jboss.system.ServiceController.start(ServiceController.java:416) | at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:144) | at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80) | at org.jboss.mx.server.Invocation.invoke(Invocation.java:72) | at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642) | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) | at $Proxy22.start(Unknown Source) | at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:605) | at org.jboss.deployment.MainDeployer.start(MainDeployer.java:964) | at org.jboss.deployment.MainDeployer.start(MainDeployer.java:956) | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:775) | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:738) | at sun.reflect.GeneratedMethodAccessor25.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:144) | at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80) | at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:122) | at org.jboss.mx.server.Invocation.invoke(Invocation.java:74) | at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:131) | at org.jboss.mx.server.Invocation.invoke(Invocation.java:74) | at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642) | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) | at $Proxy8.deploy(Unknown Source) | at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:305) | at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:463) | at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:204) | at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:215) | at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:194) | Caused by: java.sql.SQLException: Syntax error or access violation message from server: "Specified key was too long; max key length is 1000 bytes" | at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997) | at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167) | at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278) | at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1224) | at com.mysql.jdbc.Connection.execSQL(Connection.java:2248) | at com.mysql.jdbc.Connection.execSQL(Connection.java:2196) | at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1259) | at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1205) | at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:229) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:527) | ... 75 more | 09:18:40,525 WARN [ServiceController] Problem starting service jboss.j2ee:jndiName=local/PlayerBean,service=EJB | org.jboss.deployment.DeploymentException: Error while creating table PlayerBean_teams_TeamBean_players; - nested throwable: (java.sql.SQLException: Syntax error or access violation message from server: "Specified key was too long; max key length is 1 | 000 bytes") | at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:540) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:302) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:484) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:381) | at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:157) | at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:340) | at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:272) | at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:222) | at sun.reflect.GeneratedMethodAccessor152.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:144) | at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80) | at org.jboss.mx.server.Invocation.invoke(Invocation.java:72) | at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642) | at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:891) | at $Proxy0.start(Unknown Source) | at org.jboss.system.ServiceController.start(ServiceController.java:416) | at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:144) | at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80) | at org.jboss.mx.server.Invocation.invoke(Invocation.java:72) | at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642) | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) | at $Proxy75.start(Unknown Source) | at org.jboss.ejb.EjbModule.startService(EjbModule.java:394) | at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:272) | at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:222) | at sun.reflect.GeneratedMethodAccessor152.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:144) | at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80) | at org.jboss.mx.server.Invocation.invoke(Invocation.java:72) | at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642) | at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:891) | at $Proxy0.start(Unknown Source) | at org.jboss.system.ServiceController.start(ServiceController.java:416) | at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:144) | at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80) | at org.jboss.mx.server.Invocation.invoke(Invocation.java:72) | at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642) | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) | at $Proxy22.start(Unknown Source) | at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:605) | at org.jboss.deployment.MainDeployer.start(MainDeployer.java:964) | at org.jboss.deployment.MainDeployer.start(MainDeployer.java:956) | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:775) | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:738) | at sun.reflect.GeneratedMethodAccessor25.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:144) | at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80) | at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:122) | at org.jboss.mx.server.Invocation.invoke(Invocation.java:74) | at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:131) | at org.jboss.mx.server.Invocation.invoke(Invocation.java:74) | at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642) | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) | at $Proxy8.deploy(Unknown Source) | at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:305) | at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:463) | at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:204) | at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:215) | at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:194) | Caused by: java.sql.SQLException: Syntax error or access violation message from server: "Specified key was too long; max key length is 1000 bytes" | at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997) | at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167) | at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278) | at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1224) | at com.mysql.jdbc.Connection.execSQL(Connection.java:2248) | at com.mysql.jdbc.Connection.execSQL(Connection.java:2196) | at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1259) | at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1205) | at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:229) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:527) | ... 75 more | 09:18:40,650 INFO [EJBDeployer] Deployed: file:/C:/Programme/jboss-4.0.1/server/default/tmp/deploy/tmp4586RosterApp.ear-contents/team-ejb.jar | 09:18:40,681 INFO [EARDeployer] Started J2EE application: file:/C:/Programme/jboss-4.0.1/server/default/deploy/RosterApp.ear | View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3866615#3866615 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3866615 ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
