java.sql.SQLException: ORA-00932: inconsistent datatypes: expected - got CLOB

[patrick]

Hi,

We are using weblogic 8.1 and oracle 9i
We are facing problems with oracle CLOB fields in entity beans. (See
also stacktrace below)

the weblogic-cmp-rdbms-jar.xml is looking fine. Atleast we always did it
this way in weblogic 6.1 and as described in the weblogic 8.1 docs.

<field-map>
<cmp-field>nonNovStudyDetails</cmp-field>
<dbms-column>NON_NOV_STUDY_DETAILS</dbms-column>
<dbms-column-type>OracleClob</dbms-column-type>
</field-map>


Does someone have any solutions


'***@7e1'
java.sql.SQLException: ORA-00932: inconsistent datatypes: expected - got
CLOB

java.sql.SQLException: ORA-00932: inconsistent datatypes: expected - got
CLOB

at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
at
oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:420)
at
oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:896)
at
oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:452)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:986)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2929)
at
weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:80)
at
de.juwimm.novartis.tania.model.Study_5dphzk__WebLogic_CMP_RDBMS.ejbFindAll(Study_5dphzk__WebLogic_CMP_RDBMS.java:802)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
weblogic.ejb20.cmp.rdbms.RDBMSPersistenceManager.collectionFinder(RDBMSPersistenceManager.java:378)
at
weblogic.ejb20.manager.BaseEntityManager.collectionFinder(BaseEntityManager.java:1700)
at
weblogic.ejb20.manager.BaseEntityManager.collectionFinder(BaseEntityManager.java:1672)
at
weblogic.ejb20.internal.EntityEJBLocalHome.finder(EntityEJBLocalHome.java:467)

[mmoulton mmoulton]

I am experiencing the same problem as patrick. Has anyone else encountered this problem, or have a solution?

-- Mike