0 Replies Latest reply on Mar 21, 2004 11:40 PM by wayofdragon

    problem deploying CMP Roster Example with mySQL

    wayofdragon

      Hi 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