Hello Everyone, Appian enforces a 30 character limit on database obje

Jin Pheh

Certified Associate Developer

over 11 years ago

Hello Everyone,

Appian enforces a 30 character limit on database objects because several DB vendors have the same limit. In the Appian custom.properties files it says the following:

Note: The effective max length is 3 characters less than the given value as 3 characters are reserved for system use.

Does anyone know what Appian is reserving these characters for and how they are used? I would like to map to an existing table that has 28 characters but I can't find any documentation about the implications of raising conf.data.sql.name.maxlength from 30 to 33 would be....

Discussion posts and replies are publicly visible

Parents

0 Jin Pheh
Certified Associate Developer
over 11 years ago

Hi Sathya,

I am using JPA annotation to define the table name however the name is only 29 characters long. As specified in the documentation here: forum.appian.com/.../Post-Install_Configurations
Appian will truncate characters from table names over 30 characters unless the config I mentioned earlier is raised. However I cannot find anything in the documentation that tells me what the 3 reserved chracters are for or when they are used.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Jin Pheh
Certified Associate Developer
over 11 years ago

Hi Sathya,

I am using JPA annotation to define the table name however the name is only 29 characters long. As specified in the documentation here: forum.appian.com/.../Post-Install_Configurations
Appian will truncate characters from table names over 30 characters unless the config I mentioned earlier is raised. However I cannot find anything in the documentation that tells me what the 3 reserved chracters are for or when they are used.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data