[Zope] - ZOracle DA...

David White davew@ed.ray.com
Mon, 18 Jan 1999 10:28:29 -0500


Hello,

I've been quietly following the development of Zope and I'm VERY
impressed
and happy to see such a wonderful tool available as open source.  I've
been
anxiously awaiting the release of DCOracle and the ZOracle database
adapter
and was overjoyed to see them arrive last week.  Unfortunately, I've run
into a
little snag which I was hoping someone could help me through.

I downloaded both DCOracle and the ZOracle DA (then realizing the
ZOracle DA
has DCOracle in the src directory...)  I extracted the ZOracle DA
product to the
<Zope_Home>/lib/python/Products location and I then compiled the
DCOracle
piece in the <Zope_Home>/lib/python.Products/ZOracleDA/src directory.  I
ran
the DCOracle_test.py file and got no errors.  Having thought all was
well I moved
the Buffer.so and oci_.so shared libs to the
<Zope_Home>/lib/python/Products/DCOracle
directory.  When I restarted Zope, the product appeared to be installed
correctly
as it wasn't 'broken' (no tracebacks), but when I tried to create a
connection
I got this traceback:

-------------------------------------------------------------

Invalid connection string: webtools/webtools

Traceback (innermost last):
  File /local/app/dc/Zope/lib/python/ZPublisher/Publish.py, line 879, in
publish_module
  File /local/app/dc/Zope/lib/python/ZPublisher/Publish.py, line 595, in
publish
    (Info: /Development/manage_addZOracleConnection)
  File lib/python/Products/ZOracleDA/DA.py, line 121, in
manage_addZOracleConnection
    (Object: Navigation)
  File /local/app/dc/Zope/lib/python/Shared/DC/ZRDB/Connection.py, line
139, in __init__
    (Object: RoleManager)
  File /local/app/dc/Zope/lib/python/Shared/DC/ZRDB/Connection.py, line
168, in edit
    (Object: RoleManager)
  File /local/app/dc/Zope/lib/python/Shared/DC/ZRDB/Connection.py, line
212, in connect
    (Object: RoleManager)
  File lib/python/Products/ZOracleDA/db.py, line 127, in __init__
  File lib/python/Products/ZOracleDA/DCOracle/ocidb.py, line 65, in
__init__
BadRequest: (see above)

-------------------------------------------------------------

I have Zope being published through PCGI.  I have an apache webserver
which is running as a user
which 'knows' where ORACLE_HOME so the PCGI process should 'know' this
too.  Did I just
miss something obvioius?

Any help is greatly appreciated, and once again thanks for a GREAT tool!

Dave

--
----------------------------------------------------
David R. White          Raytheon Electronic Systems
Process Support                      (508) 440-2087
528 Boston Post Rd.
Sudbury, MA 01776
davew@ed.ray.com
----------------------------------------------------