1 Reply Latest reply on Jul 9, 2004 4:33 AM by Alexey Loubyansky

    Limit on Number of CMP Fields per DB Table?

    Hugh Allen Newbie

      Is there a limit on the number of CMP Fields for one database table in JBoss 3.2.2 when used with MySQL 4.0.20?

      One response to a prior post indicated that there is a limit of 63 CMP fields per table, due to a bug in JBoss 3.2.2 and that this bug may be fixed in JBoss 3.2.4? Is either of these true?

      Since I am using MySQL InnoDB tables, the MySQL limit is 1,000 fields per table, so a JBoss limit of 63 would be very restrictive.

      I searched the forums but could not find any reference to such a limitation.

      Thanks, Hugh