How to define a data type in cmp field???
Hi, I'm developing an EJB component based on CMP and I'm facing a limitation in orion's CMP engine: how can I map a field of my ejb to a long database field? The field is a variable-length long java.lang.String field used for comments a user enters, and I want it to store it in database using orion's CMP. thanks in advance -sj __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/
Orion, Informix, and fields with more than 256 characters?
Hi All, Does anybody know how we can have a field with more than 256 characters in Informix? how should we define the data types in Informix, in its schema, and in orion-ejb-jar.xml? thanks in advance -sj __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/
How can I use a CLOB data type with Informix?
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/