[IllegalPropertyException] How to increase JIRA Custom Mail Handler Plugin 255 character limit when saving to DB

Ricardo Joseph

Hi,

I have developed a custom mail handler plugin and am currently unable to save its configuration due to the below error.

Error adding service: com.opensymphony.module.propertyset.IllegalPropertyException: String exceeds 255 characters..

Step by Step example:

1. Administration > Incoming Mail > Mail Handlers - Add incoming mail handler

2. I complete the first page of the form that pops up (e.g. Name, Handler etc...) and then click the Next button

3. I enter all additional configuration into the second page's form, however upon clicking the "Save" button I receive the aforementioned error...

Please advise as to how I go about increasing the 255 character limit or another viable solution.

Tiago Comasseto

Hi Ricardo,

Judging by your description, it seems to me that this limitation is on the database. Mail handlers are stored into the tables propertyentry and it has the character limiti restriction as follow:

mysql> desc propertyentry;
+--------------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+---------------+------+-----+---------+-------+
| ID | decimal(18,0) | NO | PRI | NULL | |
| ENTITY_NAME | varchar(255) | YES | MUL | NULL | |
| ENTITY_ID | decimal(18,0) | YES | MUL | NULL | |
| PROPERTY_KEY | varchar(255) | YES | MUL | NULL | |
| propertytype | decimal(9,0) | YES | | NULL | |
+--------------+---------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

You may change the datatype, but honestly I'm not sure if it's a good idea as it's difficult to know if it's going to affect other functionalities in JIRA.

Cheers