1 Reply Latest reply on Oct 26, 2003 4:40 AM by rstranders

    Too big column length for column 'id'

    rstranders Newbie

      Hi,

      I've just set up Mysql + Jboss on a Redhat 9 box. However, I keep getting the following error when I deploy my ejb's:

      Invalid argument value, message from server: "Too big column length for column 'id' (max = 255). Use BLOB instead")]

      My mysql-ds.xml contains the following:
      <local-tx-datasource>
      <jndi-name>RAPDS</jndi-name>
      <connection-url>jdbc:mysql://localhost:3306/rap</connection-url>
      <driver-class>com.mysql.jdbc.Driver</driver-class>
      <user-name>XXX</user-name>
      XXX
      </local-tx-datasource>

      The strange thing is: I've already got this working on in my windows environment. Jboss and MySQL worked seamlessly in this configuration.

      For my id's I use the xdoclet GUID (global unique ID's) generator. (see: http://xdoclet.sourceforge.net/bp.html) This generator generates 32 character strings.
      Does anyone recognize this problem?

      thanks in advance,
      Ruben