Never mind. I resolved it.


frankca wrote:
> 
> Hi Craig,
> 
> Because the default value is 255 which doesn't apply to CLOB, however, it
> doesn't make any different if don't define it.
> 
> Here's from Kodo KB:
> A normal string field was mapped to an Oracle CLOB type. Oracle requires
> special handling for CLOBs. Ensure that the column  for this field
> specifies a jdbc-type  of clob or a  length of -1.
> 
> -Frank
> 
> 
> 
> Craig L Russell wrote:
>> 
>> Hi Frank,
>> 
>> The thing that jumps out at me is the length. What did you intend -1  
>> to mean? This should be the maximum length of data stored in the  
>> column and really needs to be a good application-specific value.
>> 
>> Craig
>> 
>> On Sep 12, 2007, at 10:51 AM, frankca wrote:
>> 
>>>
>>> Hi,
>>>
>>> Does anyone run into this error:
>>> exception is <openjpa-1.0.0-r420667:568756 fatal user error>
>>> org.apache.openjpa.persistence.ArgumentException:
>>> "com.inxight.mdr.dao.model.Sentence.text" declares a column that is  
>>> not
>>> compatible with the expected type "clob".  Column details:
>>> Full Name: sentence.text
>>> Type: integer
>>> Size: 0
>>> Default: null
>>> Not Null: true
>>>
>>> Here's my persistence class:
>>> @javax.persistence.Entity
>>> @Table(name = "sentence")
>>> public class Sentence implements Serializable {
>>>     // ...
>>>     @Lob
>>>     @Column(name = "text", length = -1, nullable = false)
>>>     private String text;
>>> }
>>>
>>>
>>> OpenJPA 1.0.0
>>> Oracle XE 10G R2
>>>
>>> TIA,
>>> Frank
>>>
>>> -- 
>>> View this message in context: http://www.nabble.com/ERROR%3A- 
>>> declares-a-column-that-is-not-compatible-with-the-expected-type-% 
>>> 22clob%22-tf4431073.html#a12640914
>>> Sent from the OpenJPA Users mailing list archive at Nabble.com.
>>>
>> 
>> Craig Russell
>> Architect, Sun Java Enterprise System http://java.sun.com/products/jdo
>> 408 276-5638 mailto:[EMAIL PROTECTED]
>> P.S. A good JDO? O, Gasp!
>> 
>> 
>>  
>> 
> 
> 

-- 
View this message in context: 
http://www.nabble.com/ERROR%3A-declares-a-column-that-is-not-compatible-with-the-expected-type-%22clob%22-tf4431073.html#a12645395
Sent from the OpenJPA Users mailing list archive at Nabble.com.

Reply via email to