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]
-------------------------------------------------
