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