3 Replies Latest reply on Sep 14, 2002 12:18 PM by Dain Sundstrom

    MySQL CMP filed too big

    Steve Newbie

      Hi all.
      I am testing a EJB of Oreilly's "Enterprise Java Bean" book. When I used default database in JBoss, a sample EJB was successful. However after changing database to MySQL I have gotten this error messages. It looks like something related with java.lang.String and database column type.
      Please help.


      email : chojes@hanmail.net

      Depends On Me: org.jboss.deployment.DeploymentException: Error while creating table; - nested throw
      able: (java.sql.SQLException: Invalid argument value: Too big column length for column 'name' (max =
      255). Use BLOB instead)]


      19:39:23,384 WARN [ServiceController] Problem starting service jboss.j2ee:service=EJB,jndiName=Cabi
      nHomeRemote
      org.jboss.deployment.DeploymentException: Error while creating table; - nested throwable: (java.sql.
      SQLException: Invalid argument value: Too big column length for column 'name' (max = 255). Use BLOB
      instead)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:175)