Re: Cayenne error while committing CLOB on Oracle

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Tue Sep 14 2010 - 21:45:24 UTC

  • Next message: bdflyfisher: "Re: Cayenne error while committing CLOB on Oracle"

    Hi there,

    My memory of this code is a bit rusty now. Could you provide a bigger chunk of the stack please - up to the DataContext commit call? And also maybe an output of DESC CSPROPERTY to see the types of PROPERTYVALUE and CSPROPERTYGUID columns.

    Andrus

    On Sep 14, 2010, at 5:23 PM, bdflyfisher wrote:

    >
    > Using Cayenne 3.0 against Oracle 11 with driver ojdbc6-11.2.0.1.0.jar.
    >
    > Getting a commit error. We get java.sql.SQLException: Invalid argument(s) in
    > call.
    >
    > Here is part of the info stack:
    >
    > SELECT PROPERTYVALUE FROM CSPROPERTY WHERE CSPROPERTYGUID = ? FOR UPDATE
    > [bind: 1:'...']
    >
    > INFO: [write LOB: 1:'true']
    >
    >
    >
    >
    > It seems it is trying to write a LOB to a CLOB and is failing at that.
    > Suggestions?
    > --
    > View this message in context: http://cayenne.195.n3.nabble.com/Cayenne-error-while-committing-CLOB-on-Oracle-tp1475847p1475847.html
    > Sent from the Cayenne - User mailing list archive at Nabble.com.
    >



    This archive was generated by hypermail 2.0.0 : Tue Sep 14 2010 - 21:45:52 UTC