Re: Strange problem with multiple JDBC connections
Re: Strange problem with multiple JDBC connections
- Subject: Re: Strange problem with multiple JDBC connections
- From: "Jerry W. Walker" <email@hidden>
- Date: Thu, 31 May 2007 14:49:51 -0400
Hi, Ken,
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:
http://forum.java.sun.com/thread.jspa?
threadID=464090&messageID=2131272
Wish I could help more.
Regards,
Jerry
On May 31, 2007, at 10:05 AM, Ken Anderson wrote:
All,
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:
40gmail.com
This email sent to email@hidden
--
__ Jerry W. Walker,
WebObjects Developer/Instructor for High Performance Industrial
Strength Internet Enabled Systems
email@hidden
203 278-4085 office
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden