RE: Newbie question on Cayenne error at runtime

From: Gentry, Michael (michael_gentr..anniemae.com)
Date: Thu Jul 15 2004 - 10:32:25 EDT

  • Next message: McBrayer, Roy: "No more data to read from socket" error. RE: Newbie question on C ayenne error at runtime,"

    "t0" is an alias. If you look at the end of your SQL, you'll see "FROM
    SITE_DAILY_SUM t0", so it is equating t0 with SITE_DAILY_SUM. The alias
    just keeps the SQL shorter, but shouldn't hurt anything. If you are
    using Oracle, it shouldn't be a case sensitive issue, I don't believe.
    You might want to copy/paste that SQL into a separate SQL window and see
    what you get.

    /dev/mrg

    -----Original Message-----
    From: McBrayer, Roy [mailto:Roy.McBraye..ail.va.gov]
    Sent: Thursday, July 15, 2004 9:56 AM
    To: 'Andrus Adamchik'; cayenne-use..bjectstyle.org
    Subject: RE: Newbie question on Cayenne error at runtime

    Thanks. The logging was very helpful.

    I turned on logging and this is the result of the query. As you can
    see, it
    is using t0 as the table name before the field name. Where is this
    coming
    from within the configuration. Instead of t0 it should be
    Site_Daily_Sum.fieldname. Is there something I must do when I run the
    modeler?

    SELECT t0.INQ_CACHE_GEN_ELIG, t0.INQ_CACHE_GENERATED, t0.INQ_IDFY_BLANK,
    t0.INQ_IDFY_NAMED, t0.INQ_IDFY_TOTAL, t0.INQ_INVALID, t0.INQ_TOTAL,
    t0.INQ_VRFY_CACHE_RESP, t0.INQ_VRFY_TOTAL, t0.RESP_271_ELIG,
    t0.RESP_271_NOTELIG, t0.RESP_271_TOTAL, t0.RESP_AAA_TIMEOUT,
    t0.RESP_AAA_TOTAL, t0.RESP_ACTIVE, t0.RESP_BADRESP, t0.RESP_CACHE,
    t0.RESP_INACTIVE, t0.RESP_INQ_MGR, t0.RESP_INVALID270, t0.RESP_NULL,
    t0.RESP_UNDETERMINED, t0.SITE_NUMBER, t0.SUMMARY_DATE, t0.VISN_NUMBER
    FROM
    SITE_DAILY_SUM t0

    Thanks,
    Roy

    -----Original Message-----
    From: Andrus Adamchik [mailto:andru..bjectstyle.org]
    Sent: Wednesday, July 14, 2004 9:25 PM
    To: cayenne-use..bjectstyle.org
    Subject: Re: Newbie question on Cayenne error at runtime

    On Jul 14, 2004, at 6:05 PM, McBrayer, Roy wrote:

    > iiv_test.CreateReport.main(CreateReport.java:20) Caused by:
    > java.sql.SQLException: ORA-00600: internal error code, arguments:
    > [ttcgcshnd-1], [0], [], [], [], [], [], []

    This is an Oracle error and does not seem to be related to Cayenne.
     From http://www.orafaq.com/error/ora-00600.htm :

    "Possible causes include
         * time-outs,
         * file corruption,
         * failed data checks in memory, hardware, memory, or I/O messages,
         * incorrectly restored files"

    Sounds scary, and not related to the client-sent SQL... One more thing
    to check before calling your DBA. Turn on SQL logging per
    http://objectstyle.org/cayenne/userguide/deploy/logging.html and see
    what SQL is generated by Cayenne. Try running the same query from
    SQLPlus and see if it produces a similar crash.

    Andrus

    This archive was generated by hypermail 2.0.0 : Thu Jul 15 2004 - 10:32:34 EDT