[Zope-Perl] ZOPE DBI adapter - feedback and patch (please rev iew)

[Harry Danilevsky]

I tried Zope DBI adapter with Sybase , and it works fine, but there
is a problem: every time the connection object is used, a new
connection is made ( I can see it when I run sp_who in Sybase).
Do you see this behavior with Oracle?
How is the db connection persistence implemented in Zope ?
Should the specific adapter take care of it (a la Apache::DBI persistent
connections)
or the base class does it? If I use digicool's "native" SybaseDA,
no extra connections are open.

Problem #2. I still can't figure out how to use the DBI connection object in
perl methods.
If I pass the connection to perl method, I get a Python::Object object,
but if I try to call a DBI method on it (prepare, execute, etc.), I get an
error message telling
me that the object doesn't support such methods.


-- Harry Danilevsky
harry@siichi.com

> -----Original Message-----
> From: Joseph Wayne Norton [mailto:norton@alum.mit.edu]
> Sent: Wednesday, August 30, 2000 9:47 AM
> To: Gisle Aas
> Cc: zope-perl@zope.org
> Subject: [Zope-Perl] ZOPE DBI adapter - feedback and patch 
> (please review)
> 
> 
> 
> Gisle -
> 
> I have finally been able to do a little work with the zope DBI
> adapter.  Good stuff!
> 
> 1) FYI - I'm able to connect to oracle with the following connection
>    string:
> 
>         <user>:<pass>@dbi:Oracle:host=<host>;sid=<sid>
> 
>    where <> is replaced with the actual values.  I had to look at your
>    code to see how the user and pass variables are being passed.
> 
>