[castor-dev] CLOB Field Not Updating in DB

[August Detlefsen]

I am trying to update a CLOB field in oracle 9i. If I make the content
of the field longer than 4000 characters, the transaction succeeds, but
the value never gets updated in the database. Thereafter, I can see the
changes to the object that is in Castor's cache, but if I reload the
app server (thus wiping the cache) they disappear. 

Has anyone else seen behavior like this? Am I doing something wrong?
Here is the mapping and table definition. 


Here is the mapping, the CLOB field is 'content':

  <!-- Mapping for NavPageContent -->
  <class name="com.codemagi.servlets.content.model.NavPageContent"
identity="id" key-generator="PAGESEQ">
    <description>A single page, with content</description>
    <map-to table="nav_page" />
    <field name="id" type="integer">
      <sql name="page_id" type="integer"/>
    </field>
    <field name="section"
type="com.codemagi.servlets.content.model.Section">
      <sql name="section_id" />
    </field>
    <field name="parentId" type="integer">
      <sql name="parent_page_id" type="integer"/>
    </field>
    <field name="name" type="string">
      <sql name="name" type="varchar"/>
    </field>
    <field name="link" type="string">
      <sql dirty="ignore" name="link" type="varchar"/>
    </field>
    <field name="sortOrder" type="integer">
      <sql name="sort_order" type="integer"/>
    </field>
    <field name="loginRequired" type="boolean">
      <sql name="login_reqd_tf" type="char[1]"/>
    </field>
    <field name="display" type="boolean">
      <sql name="display_tf" type="char[1]"/>
    </field>
    <field name="content" type="string">
      <sql name="content" type="clob"/>
    </field>
  </class>


The database table: 

CREATE TABLE nav_page (
        page_id         INTEGER         NOT NULL
,       parent_page_id  INTEGER
,       section_id      INTEGER
,       name            VARCHAR2(256)   NOT NULL
,       link            VARCHAR2(512)
,       sort_order      INTEGER
,       login_reqd_tf   CHAR(1)         DEFAULT 'F' NOT NULL
,       display_tf      CHAR(1)         DEFAULT 'T' NOT NULL
,       content         CLOB
,       CONSTRAINT page_pkey PRIMARY KEY (page_id)
,       CONSTRAINT page_fkey1 FOREIGN KEY (section_id) REFERENCES
nav_section(section_id)
);

-------------------------------------------------
If you wish to unsubscribe from this list, please 
send an empty message to the following address:

[EMAIL PROTECTED]
-------------------------------------------------