I have changed entries in  prefs_repository.xml to:
</field-descriptor>
          <field-descriptor
              name="propertyValue"
              column="PROPERTY_VALUE"
              jdbc-type="CLOB"
              nullable="true"
              length="1048576"
          >

and I have changed field PROPERTY_VALUE to CLOB(1048576). Now I can store
Preferences with length more than 254 but less then 8193 bytes. When I store
preference with 8192 bytes length all is ok. But when I try to store
preference with 8193 bytes length, I have still the same error: "public void
net.liga.portal.htmlportlet.Edit.doAction() throws
javax.portlet.PortletModeException' on [EMAIL PROTECTED]: Value too
long".

Why?? Why do I have 8192 bytes limit now? What can I do to store preferences
with unlimited size?


2006/10/3, David Sean Taylor <[EMAIL PROTECTED]>:

>
> 2006/10/3, Stephen Greenlee <[EMAIL PROTECTED]>:
>
>>
>> Vitaly,
>>
>> We also set "PROPERTY_VALUE" of type BLOB for the same reason. I think
>> that you can do so without any problem.
>>
>> Stephen
>>
>> On 10/3/06, Vitaly Baranovsky <[EMAIL PROTECTED]> wrote:
>> > Hmm... Maybe, making column "PROPERTY_VALUE" of type BLOB would be
>> better
>> > decision? Because there can be preference with big length. And
>> length of
>> > preference doesn't limited in JSR-168 specification. How do you
think?
>> >

Changing the column data type will require a change to the jdbc-type om
the object-relational mapping file prefs_repository.xml found inside the
prefs jar:

           </field-descriptor>
           <field-descriptor
               name="propertyValue"
               column="PROPERTY_VALUE"
               jdbc-type="VARCHAR"
               nullable="true"
               length="254"
           >

Hopefully it supports mapping CLOB onto java.lang.String, it should
Also, you will want to experiment with changing and removing the length


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


Reply via email to