Hey all, Has anyone ever connected to Oracle from Zope? How about connecting to another machine that runs Oracle (machine A runs Zope; machine B runs Oracle)? If so, how ... or a friendly pointer in the right direction would be appreciated. ;-> I'm just wondering, because I feel that I would rather pull some information (already in Oracle), rather than setting up 130+ objects in Zope. What I have is an email listing, that holds first name, last name, email, and some other info. I see that I, if in Zope, would make a separate object to hold this info for each separate listing. Now, if there were only 10 listings, I'd be fine with it. However, from last count, it was over 130, and still growing. I really don't want to manage all those objects, much less create all of them! And since it already exists in Oracle .... well, you get the picture. Besides, I may want to have a Zope/Oracle combo in the future, so it may help to iron this stuff out now. Thanks in advance, Tommy Innovation: The Best Way To Predict The Future ... Is To Create It.
--On 23 July 2001 13:57 -0800 Tommy Johnson <tommy@7x.com> wrote:
Hey all,
Has anyone ever connected to Oracle from Zope? How about connecting to another machine that runs Oracle (machine A runs Zope; machine B runs Oracle)? If so, how ... or a friendly pointer in the right direction would be appreciated. ;->
Executive Summary: Yes, No problem, http://www.zope.org/Members/isalsberg/how-to_OracleDA Gory Bits: Zope has a range of Database Adapters http://www.zope.org/Products/external_access Installing some of them is not for the faint of heart. There are two Oracle DAs: http://www.zope.org/Products/DA/ZOracleDA http://www.zope.org/Members/matt/dco2 The second is a beta release and offers LOB support. I haven't tried it yet - I've just spotted the NT version seems pre-compiled so I'll that a whirl before rolling up by sleeves and getting beaten up by Linux again. Paul -- The Library, Tyndall Avenue, Univ. of Bristol, Bristol, BS8 1TJ, UK E-mail: paul.browning@bristol.ac.uk URL: http://www.bris.ac.uk/
participants (2)
-
Paul Browning -
Tommy Johnson