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

0 Sathya Srinivasan
Appian Employee
over 11 years ago

Are you using JPA annotation to define your CDT? If my memory serves me right, you should be able to use the @Table annotation to define the table name to map to your underlying entity. The character limit is for tables created BY Appian when you publish a CDT that's created via Appian CDT builder into the data store without JPA annotation.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
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