Book a Demo

Author Topic: Wrong Column type in MySQL DB for UML Patterns  (Read 3671 times)

davisr_uk

  • EA User
  • **
  • Posts: 22
  • Karma: +0/-0
    • View Profile
Wrong Column type in MySQL DB for UML Patterns
« on: June 12, 2015, 10:02:07 pm »
I've been having some problems importing a pattern into a repository hosted in a MySQL database. At first I noticed that the preview images were being dropped which wasn't that big a deal, however I have since had patterns that I simply cannot import.

The reason seems to be that EA stores the patterns as XMI within a single column (PatternXML) on the t_umlpatterns table. The type of the column is text which has a limit of 64Kb. A basic ArchiMate pattern for a database node with 7 elements and their relationships is 300Kb of XML!

The column type really ought to be changed to mediumtext which will allow for up to 16Mb of text.