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

From: McBrayer, Roy (Roy.McBraye..ail.va.gov)
Date: Thu Jul 15 2004 - 11:43:40 EDT

  • Next message: Andrus Adamchik: "Re: No more data to read from socket" error."

    I fixed the problem by updating my Oracle jdbc drivers.

    Now I am getting a "java.sql.SQLException: No more data to read from socket"
    error.

    cayenne INFO [main 07-15 10:39:24] QueryLogger: --- transaction started.
    cayenne INFO [main 07-15 10:39:24] QueryLogger: 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 cayenne INFO [main 07-15 10:39:25] QueryLogger: ***
    error. java.sql.SQLException: No more data to read from socket

    Do I have to do something to terminate the connection once the query is
    complete?

    Thanks.

    -----Original Message-----
    From: Gentry, Michael [mailto:michael_gentr..anniemae.com]
    Sent: Thursday, July 15, 2004 9:32 AM
    To: McBrayer, Roy; Andrus Adamchik; cayenne-use..bjectstyle.org
    Subject: RE: Newbie question on Cayenne 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 - 11:43:48 EDT