[Zope] ZOracleDA/DCOracle problem

Paul Browning paul.browning@bristol.ac.uk
Tue, 24 Aug 1999 08:53:42 +0100 (British Summer Time)


Using the advice recently broadcast by ldl@LDL.HealthPartners.COM
(sorry ldl, don't know your name) I've got ZOracleDA/DCOracle working
with Zope2 and Oracle 8.0.5 under RedHat 5.2. Great stuff but .....

...... _every_ first use of a query from Zope to the Oracle database gives
the error messages listed below. Re-loading the page in the browser _always_
makes the query work OK (and the query will work OK subsequently).
As it stands it's a bit of a show-stopper and I would dearly welcome
suggestions of how to solve the problem (being a Python babe in the
wood).

TIA

Paul 

From the shell window from which Zope was started:

Exception exceptions.AttributeError: <exceptions.AttributeError instance 
at 84f71d0> in <method Transaction.__del__ of Transaction instance 
at 84d9d00> ignored

From the browser:

Zope Error

Zope has encountered an error while publishing this resource. 

Error Type: AttributeError
Error Value: tpc_begin

Troubleshooting Suggestions

     The URL may be incorrect. 
     The parameters passed to this resource may be incorrect. 
     A resource that this resource relies on may be encountering an error. 

For more detailed information about the error, please refer to the HTML source for this page. 

If the error persists please contact the site maintainer. Thank you for your patience. 

Traceback (innermost last):
  File /usr/local/bin/zope205/lib/python/ZPublisher/Publish.py, line 209, in publish_module
  File /usr/local/bin/zope205/lib/python/ZPublisher/Publish.py, line 179, in publish
  File /usr/local/bin/zope205/lib/python/Zope/__init__.py, line 199, in zpublisher_exception_hook
    (Object: test1)
  File /usr/local/bin/zope205/lib/python/ZPublisher/Publish.py, line 169, in publish
  File /usr/local/bin/zope205/lib/python/ZODB/Transaction.py, line 236, in commit
AttributeError: (see above)

--
 The Library, Tyndall Avenue, Univ. of Bristol, Bristol, BS8 1TJ, UK
     E-mail: paul.browning@bris.ac.uk  URL: http://www.bris.ac.uk/