In case you haven't already looked it up, Oracle's documentation for
your error code says:
JZ0PA The query has been cancelled and the same response discarded.
Description: A cancel was probably issued by another statement on the
connection.
Action: Check the chain of SQL exceptions and warnings on this and
other statements to
determine the cause.
There was also another reference to the error message on the
java.sun.com forums, but I don't know how helpful you'll find that:
I've recently added a connection to an Oracle database from my
primarily Sybase based application. Multiple threads are operating
and talking to both Sybase and Oracle through their respective JDBC
drivers. I just received this error:
EvaluateExpression failed: <com.webobjects.jdbcadaptor.SybasePlugIn
$SybaseExpression: "SELECT t0.identifier, t0.oid,
t0.priority_minutes_offset, t0.quote_oid,
t0.rolling_quote_period_oid, t0.trans_id FROM quote_rolling_period
t0 WHERE t0.quote_oid = ?" withBindings: 1:10(quoteOid)>:
Next exception:SQL State:JZ006 -- error code: 0 -- msg: JZ006:
Caught IOException: java.io.IOException: JZ0PA: The query has been
cancelled and the response discarded. The cancel was probably
issued by another statement on the connection.
at com.webobjects.jdbcadaptor.JDBCContext._jdbcErrorWithChannel
(JDBCContext.java:138)
at com.webobjects.jdbcadaptor.JDBCChannel._evaluateExpression
(JDBCChannel.java:310)
at com.webobjects.jdbcadaptor.JDBCChannel.evaluateExpression
(JDBCChannel.java:261)
at com.webobjects.jdbcadaptor.JDBCChannel.selectAttributes
(JDBCChannel.java:185)
I have never seen anything like this before - it never occurred
when I was not querying Oracle simultaneously. Has anyone ever
seen this? Any hints?
Thanks,
Ken
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/jerrywwalker%
40gmail.com
This email sent to email@hidden
--
__ Jerry W. Walker,
WebObjects Developer/Instructor for High Performance Industrial
Strength Internet Enabled Systems
