Book a Demo

Author Topic: Cannot import UML patterns on a MySQL DB  (Read 3492 times)

Guillaume

  • EA Practitioner
  • ***
  • Posts: 1405
  • Karma: +42/-2
    • View Profile
    • www.umlchannel.com
Cannot import UML patterns on a MySQL DB
« on: January 31, 2018, 07:18:39 pm »
Hi,

I'm getting the following error when I try to import a UML pattern: "Failed to import Pattern '...'.  Pattern too large for database field."
I found a thread here matching this issue on MySQL EA projects: http://www.sparxsystems.com/forums/smf/index.php/topic,26367.msg206158/topicseen.html#msg206158

Unfortunately even removing the image does not sort the issue as the XML file remains to large (140 kB).

Is there a way round to resolve this with the current build?

Guillaume

Blog: www.umlchannel.com | Free utilities addin: www.eautils.com


Guillaume

  • EA Practitioner
  • ***
  • Posts: 1405
  • Karma: +42/-2
    • View Profile
    • www.umlchannel.com
Re: Cannot import UML patterns on a MySQL DB
« Reply #1 on: January 31, 2018, 09:21:04 pm »
As a follow up, I found a way round via a script:
- the user selects the folder and provides the XML file name
- the script gets the content, and reads the pattern name, notes, version, and category
- the script runs an insert query in the t_umlpattern table

I also had to change a column type to longtext in MySQL on the t_umlpattern table (alter table...).
« Last Edit: February 01, 2018, 12:14:40 am by Guillaume »
Guillaume

Blog: www.umlchannel.com | Free utilities addin: www.eautils.com