You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by "Byrne, Ailish M" <ab...@indiana.edu> on 2006/03/03 20:49:04 UTC
OJB 1.0.4 Error: Oracle thin driver cannot insert CLOB values with length>4000
We can't figure out why we are sporadically receiving the exception
below. We are using OJB 1.0.4, and our platform is set to Oracle9i.
Any help would be much appreciated.
Thank you,
Ailish
2006-03-03 14:25:59,107 [TP-Processor16] ERROR
org.apache.ojb.broker.accesslayer.JdbcAccessImpl ::
* SQLException during execution of sql-statement:
* sql statement was 'UPDATE FP_MAINTENANCE_DOCUMENT_T SET
VER_NBR=?,FDOC_EXPLAIN_TXT=?,LOCK_REPRESENTATION_TXT=?,LOCKED_IND=?,DOCU
MENT_CONTENTS=? WHERE FDOC_NBR = ? AND VER_NBR = ? '
* Exception message is [Oracle thin driver cannot insert CLOB values
with length>4000. (Consider using Oracle9i as OJB platform.)]
* Vendor error code [0]
* SQL state code [null]
* Target class is 'org.kuali.core.document.MaintenanceDocumentBase'
* PK of the target object is [financialDocumentNumber=97177]
* Source object:
maintenanceDocumentBasedocumentHeaderId(versionNumber,level,comp,app,ack
,fyi)=97177(2,0,false,false,false,false)
* The root stack trace is -->
* java.sql.SQLException: Oracle thin driver cannot insert CLOB values
with length>4000. (Consider using Oracle9i as OJB platform.)
at
org.apache.ojb.broker.platforms.PlatformOracleImpl.setObjectForStatement
(Unknown Source)
at
org.apache.ojb.broker.platforms.PlatformOracle9iImpl.setObjectForStateme
nt(Unknown Source)
at
org.apache.ojb.broker.accesslayer.StatementManager.setObjectForStatement
(Unknown Source)
at
org.apache.ojb.broker.accesslayer.StatementManager.bindUpdate(Unknown
Source)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeUpdate(Unknown
Source)
...
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Re: OJB 1.0.4 Error: Oracle thin driver cannot insert CLOB values
with length>4000
Posted by Armin Waibel <ar...@apache.org>.
Hi Ailish,
please set log-level for PlatformOracle9iImpl to DEBUG (e.g. when using
OJB console logging set entry in change entry
org.apache.ojb.broker.platforms.PlatformOracle9iImpl.LogLevel=DEBUG).
Do you get any notes about connection unwarp problems ("... could not
unwrap ..."). Seems that OJB fallback to default Oracle LOB handling,
instead using Oracle9i.
regards,
Armin
Byrne, Ailish M wrote:
> We can't figure out why we are sporadically receiving the exception
> below. We are using OJB 1.0.4, and our platform is set to Oracle9i.
> Any help would be much appreciated.
>
> Thank you,
> Ailish
>
> 2006-03-03 14:25:59,107 [TP-Processor16] ERROR
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl ::
> * SQLException during execution of sql-statement:
> * sql statement was 'UPDATE FP_MAINTENANCE_DOCUMENT_T SET
> VER_NBR=?,FDOC_EXPLAIN_TXT=?,LOCK_REPRESENTATION_TXT=?,LOCKED_IND=?,DOCU
> MENT_CONTENTS=? WHERE FDOC_NBR = ? AND VER_NBR = ? '
> * Exception message is [Oracle thin driver cannot insert CLOB values
> with length>4000. (Consider using Oracle9i as OJB platform.)]
> * Vendor error code [0]
> * SQL state code [null]
> * Target class is 'org.kuali.core.document.MaintenanceDocumentBase'
> * PK of the target object is [financialDocumentNumber=97177]
> * Source object:
> maintenanceDocumentBasedocumentHeaderId(versionNumber,level,comp,app,ack
> ,fyi)=97177(2,0,false,false,false,false)
> * The root stack trace is -->
> * java.sql.SQLException: Oracle thin driver cannot insert CLOB values
> with length>4000. (Consider using Oracle9i as OJB platform.)
> at
> org.apache.ojb.broker.platforms.PlatformOracleImpl.setObjectForStatement
> (Unknown Source)
> at
> org.apache.ojb.broker.platforms.PlatformOracle9iImpl.setObjectForStateme
> nt(Unknown Source)
> at
> org.apache.ojb.broker.accesslayer.StatementManager.setObjectForStatement
> (Unknown Source)
> at
> org.apache.ojb.broker.accesslayer.StatementManager.bindUpdate(Unknown
> Source)
> at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeUpdate(Unknown
> Source)
> ...
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org