I just tried to map my first CLOB column.  I defined the field this way:

    @Lob
    private String  longDescription;

The XML has this (I'm aware of the fact that I don't technically need
both the annotation and the XML):

    <basic name="longDescription">
       <column name="LONG_DESCRIPTION"/>
       <lob/>
    </basic>

When OpenJPA runs the query, I get back the following from Oracle:

  Caused By: org.apache.openjpa.lib.jdbc.ReportingSQLException:
ORA-00932: inconsistent datatypes: expected - got CLOB

What do I need to do to map a CLOB column into a String?

Reply via email to