-
Bug
-
Resolution: Unresolved
-
Low
-
None
-
9.0.0, 10.0.0
-
9
-
Severity 2 - Major
-
2
-
Issue Summary
This is reproducible on Data Center: (yes) / (no)
Oracle database active objects maps strings fields to varchar2 type with a maximum of 450 characters size (if you configure it with the MAX_LENGTH option of @StringLenght annotation). If you configure as unlimited the string size, active objects maps this field as CLOB. This has an impact if you want to perform any sql query with a filter including this field, as Oracle does not allow to perform a query with a where clause that includes a CLOB type.
Oracle allows to have a varchar2 with a maximum of 4000 characters.
Please, reconfigure active objects to allow the 4000 size characters for Oracle.
Steps to Reproduce
- Described above
Expected Results
Active Objects should map varchar2 to 4000 characters
Actual Results
Active Objects should map varchar2 to 450 characters
Workaround
Currently there is no known workaround for this behavior. A workaround will be added here when available