Cayenne named query problem on Oracle 10g

From: Parth Pandya (ppandy..voka.com)
Date: Fri Jul 18 2008 - 01:42:52 EDT

  • Next message: Malcolm Edgar: "Re: Cayenne named query problem on Oracle 10g"

     

    Hi All,

     

    I've hit a problem in executing a named query in cayenne 3 m4 release.

    I posted on the group last week that I'm getting java.io.StreamCorrupted
    error regarding the CLOB but I've found that the exception is thrown for
    all named queries in cayenne.

     

    My previous post are at - http://markmail.org/message/7bpcafekap2pa53q

     

    Here is my SQL:

     

    SELECT s.submission_oid, s.submission_code, s.submission_status,
    s.form_version_oid, s.creation_user, s.creation_timestamp,
    s.modification_user, s.modification_timestamp, s.assigned_user

     
    FROM submission s WHERE submission_oid IN

     
    (SELECT DISTINCT submission_oid FROM submission_version WHERE
    submission_status = 'Submitted' AND creation_user = 1)

     
    ORDER BY s.modification_timestamp DESC

     

     

    I'm expecting few varchar2, timestamp and numeric fields out of this
    query and I always get the java.io.StreamCorrupted exception.

     

     

    Can anyone please suggest a workaround/fix??

     

    Thanks a lot,

    Parth

    This archive was generated by hypermail 2.0.0 : Fri Jul 18 2008 - 01:46:14 EDT