[Zope] ZODBC hangs up Zope

Capesius, Alan CapesiusA@Sysmex.com
Wed, 25 Apr 2001 18:03:29 -0500


look at zmxODBC

>>>-----Original Message-----
>>>From: albert boulanger [mailto:aboulang@ldeo.columbia.edu]
>>>Sent: Wednesday, April 25, 2001 5:24 PM 
>>>To: zope@zope.org
>>>Subject: [Zope] ZODBC hangs up Zope
>>>
>>>
>>>
>>>I am using the ZODBC product in Zope 2.2.4 to connect to an 
>>>Oracle data
>>>warehouse and it seems that all of Zope hangs up when there 
>>>are tables
>>>being locked during updates and a sql query is done using ZODBC. I am
>>>using the ZDGchart product to summarize some data in the 
>>>warehouse. It
>>>looks like the ORA-04020 error (Deadlock detected) is not being
>>>trapped and then ZODBC hangs up the rest of Zope.
>>>
>>>Should I be using some other DA product?
>>>
>>>
>>>Thanks,
>>>Albert Boulanger
>>>aboulanger@vpatch.com
>>>
>>>_______________________________________________
>>>Zope maillist  -  Zope@zope.org
>>>http://lists.zope.org/mailman/listinfo/zope
>>>**   No cross posts or HTML encoding!  **
>>>(Related lists - 
>>> http://lists.zope.org/mailman/listinfo/zope-announce
>>> http://lists.zope.org/mailman/listinfo/zope-dev )
>>>