Hi,
I have a problem using a clob field in Castor Jdo with an Oracle database
(no problem with mysql) :
2004-06-24 11:35:45,943 [FATAL] org.exolab.castor.jdo.engine.SQLEngine - A
fatal error occurred while creating
fr.cnam.scapin.metier.donnees.dossiers.NotesAssure using SQL: UPDATE
"SCA_ASS_NOTES" SET "NOT_TEXTE"=?,"NOT_MODIF_TIME"=? WHERE "NOT_ID"=? AND
"NOT_TEXTE"=? AND "NOT_MODIF_TIME"=? 2004-06-24 11:35:45,950 [ERROR]
fr.cnam.scapin.util.exception.ApplicationException -
--------------- DEBUT ERREUR ------------------------- 2004-06-24
11:35:45,950 [ERROR] fr.cnam.scapin.util.exception.ApplicationException -
nestedException = org.exolab.castor.jdo.TransactionAbortedException: Nested
error: org.exolab.castor.jdo.PersistenceException: Nested error:
java.sql.SQLException: ORA-00932: types de donn�es incoh�rents : - attendu ;
CLOB obtenu
java.sql.SQLException: ORA-00932: types de donn�es incoh�rents : - attendu ;
CLOB obtenu
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java(Compiled Code))
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java(Inlined Compiled
Code))
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java(Compiled Code))
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java(Compiled
Code))
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java(Compiled
Code))
at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java(Comp
iled Code))
at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java(Inlin
ed Compiled Code))
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
(Compiled Code))
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
ment.java(Compiled Code))
at org.exolab.castor.jdo.engine.SQLEngine.store(SQLEngine.java:852)
at
org.exolab.castor.persist.ClassMolder.store(ClassMolder.java:1609)
at
org.exolab.castor.persist.LockEngine.store(LockEngine.java(Compiled Code))
at
org.exolab.castor.persist.TransactionContext.prepare(TransactionContext.java
(Compiled Code))
at
org.exolab.castor.jdo.engine.DatabaseImpl.commit(DatabaseImpl.java(Compiled
Code))
Has somebody had this error before ?
Thanks for your help.
Sylvie
___________________
CREDI RA
Sylvie Palluel
[EMAIL PROTECTED]
___________________
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
