Has anyone had any success inserting a CLOB into an
Informix DB using CMP?
At the moment the tables are automatically created
with the predefined column type/length through
settings of orion-ejb-jar.xml, like following:
<cmp-field-mapping name="fullName"
persistenc-name="fullName"
persistence-type="varchar(50)"/>
and here is my informix schema:
<?xml version="1.0"?>
<!DOCTYPE database-schema PUBLIC "-//Evermind//-
Database schema"
"http://www.orionserver.com/dtds/database-schemas.dtd">
<database-schema name="Informix-sqli" not-null="not
null" null="" primary-key="primary key">
<type-mapping type="java.lang.String" name="varchar
(50)" />
<type-mapping type="int" name="int" />
<type-mapping type="long" name="int" />
<type-mapping type="float" name="float" />
<type-mapping type="double" name="double" />
<type-mapping type="byte" name="byte" />
<type-mapping type="char" name="char" />
<type-mapping type="short" name="short" />
<type-mapping type="boolean" name="boolean" />
name="text" />
<type-mapping type="java.util.Date" name="datetime
year to fraction(5)" />
<disallowed-field name="username" />
<disallowed-field name="order" />
</database-schema>
I don't have any problems with fields less than 256
chars. But I have a comment field with about 1000-2000
characters.
thanks in advance
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
