problem deploying CMP Roster Example with mySQL
wayofdragon Mar 21, 2004 11:40 PMHi all,
I changed my database to mySQL as per the tutorial's intructions. However, I get the following error when I tried to deploy it:
2004-03-22 00:06:22,811 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/C:/jboss-3.2.3/server/default/deploy/RosterApp.ear
2004-03-22 00:06:22,851 INFO [org.jboss.deployment.EARDeployer] Init J2EE application: file:/C:/jboss-3.2.3/server/default/deploy/RosterApp.ear
2004-03-22 00:06:25,254 INFO [org.jboss.ejb.EjbModule] Deploying RosterEJB
2004-03-22 00:06:27,648 INFO [org.jboss.ejb.EjbModule] Deploying PlayerEJB
2004-03-22 00:06:27,888 INFO [org.jboss.ejb.EjbModule] Deploying TeamEJB
2004-03-22 00:06:27,938 INFO [org.jboss.ejb.EjbModule] Deploying LeagueEJB
2004-03-22 00:06:28,429 INFO [org.jboss.ejb.plugins.StatefulSessionInstancePool] Started jboss.j2ee:jndiName=RosterEJB,plugin=pool,service=EJB
2004-03-22 00:06:28,429 INFO [org.jboss.ejb.plugins.StatefulSessionFilePersistenceManager] Started null
2004-03-22 00:06:28,429 INFO [org.jboss.ejb.StatefulSessionContainer] Started jboss.j2ee:jndiName=RosterEJB,service=EJB
2004-03-22 00:06:28,429 INFO [org.jboss.ejb.EjbModule] Started jboss.j2ee:module=roster-ejb.jar,service=EjbModule
2004-03-22 00:06:28,429 INFO [org.jboss.ejb.EJBDeployer] Deployed: file:/C:/jboss-3.2.3/server/default/tmp/deploy/tmp21041RosterApp.ear-contents/roster-ejb.jar
2004-03-22 00:06:33,606 INFO [org.jboss.ejb.plugins.EntityInstancePool] Started jboss.j2ee:jndiName=local/PlayerEJB,plugin=pool,service=EJB
2004-03-22 00:06:33,606 INFO [org.jboss.ejb.EntityContainer] Started jboss.j2ee:jndiName=local/PlayerEJB,service=EJB
2004-03-22 00:06:33,776 INFO [org.jboss.ejb.plugins.EntityInstancePool] Started jboss.j2ee:jndiName=local/TeamEJB,plugin=pool,service=EJB
2004-03-22 00:06:33,776 INFO [org.jboss.ejb.EntityContainer] Started jboss.j2ee:jndiName=local/TeamEJB,service=EJB
2004-03-22 00:06:38,583 ERROR [org.jboss.ejb.EntityContainer] Starting failed
org.jboss.deployment.DeploymentException: Error while creating table TeamEJB; - nested throwable: (java.sql.SQLException: Invalid argument value, message from server: "Too big column length for column 'name' (max = 255). Use BLOB instead")
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:232)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:93)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:484)
I can't figure out what this means? Has anyone experienced this problem?
Any help is much appreciated! Thanks!
P