0 Replies Latest reply on Feb 3, 2006 4:46 AM by Manuel Fagiolini

    Problem about CMP and primary key

    Manuel Fagiolini Newbie

      Hi all,
      I have to do a persistence table using CMP entity with two fields: an ID as TEXT and a Content as LONGTEXT. ID is the primary key. The problem is that I can't make a primary key with a TEXT field because I have this error:
      "BLOB/TEXT column 'ID' used in key specification without a key lenght"
      So, where and how can i tell the lenght of the TEXT field?
      I'm using JBOSS 3.2.6, Eclipse 3.0 and MySQL.
      Thanks for your helps.....