0 Replies Latest reply on Nov 18, 2003 8:12 AM by shadinata

    can't create mysql table (cmp)

    shadinata Newbie

      i got this message when deploy entity bean (cmp) :

      org.jboss.deployment.DeploymentException: Error while creating table; - nested throwable: (java.sql.SQLException: Invalid argument value: Too big column length for column 'userId' (max = 255). Use BLOB instead)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:190)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:84)

      my cmp-field not tell about database mapping, like this:

      <cmp-field>
      <field-name>userId</field-name>
      <cmp-field>

      i have try to add information about database mapping in jbosscmp-jdbc.xml :

      <cmp-field>
      <field- name>userId</field-name>
      <jdbc-type>VARCHAR</jdbc-type>
      <sql-type>VARCHAR(25)</sql-type>
      </cmp-field>

      but, still not work. i got same deployment exception message.

      Please help me to solve this problem...

      NOTE: i'm using jboss 3.0.0.