I have defined a Global Case in BPM 4.0 with two attributes of type text in the Resource Tab, The Maximum text length is set as follows:
correlation_id: 50
tipoPratica: 50
Looking at the Oracle table that has been generated after the deployment, I can see the two fields have been defined as nvarchar2 of 400!
Name Null Type
------------- -------- --------------
BDS_ID NOT NULL NUMBER(19)
DTYPE NOT NULL NVARCHAR2(255)
BDS_VERSION NUMBER(19)
CORRELATIONID NOT NULL NVARCHAR2(400)
TIPOPRATICA NOT NULL NVARCHAR2(400)
CREATE_DATE TIMESTAMP(6)
Is this correct? Is there any relationship between the attribute size defined at Design time and database columns?
Environment
OS: All Supported Operating Systems
Resolution
Yes, this is correct. Though the database type allows up to 400 characters, validation rules in global data will ensure that users are only allowed to insert values of up to 50 characters.
Text types are given 400 characters in the database so that we could allow text length increases(as part of application upgrades) up to 400 characters without changing the database schema.
Issue/Introduction
Global case data inquiry concerning how the relevant database table is generated.