When creating an active object table that includes an unlimited string field, oracle maps the fields as CLOB column type. This type is not possible to include it as a filter in a sql query, throwing an exception. Is there any known workaround for that? I see as well that maximum size to configure is 450 characters size when Oracle allows until 4000 characters. Is there any way to configure the active object to include this size? I see this error when I try to configure it.
net.java.ao.ActiveObjectsConfigurationException: @StringLength must be <= 450 or UNLIMITED