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 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

Reply

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

Children

No Data