• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Strange problem with multiple JDBC connections
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


References: 
 >Strange problem with multiple JDBC connections (From: Ken Anderson <email@hidden>)

  • Prev by Date: Re: stupid eclipse question of the day: disappearing projects
  • Next by Date: Re: stupid eclipse question of the day: disappearing projects
  • Previous by thread: Strange problem with multiple JDBC connections
  • Next by thread: stupid eclipse question of the day: disappearing projects
  • Index(es):
    • Date
    • Thread