[Zope-dev] ADO Database Connections

Theodore Patrick tpatrick@IndigoNetworks.com
Tue, 25 Apr 2000 11:42:04 -0500


Has anyone done any work in making database connections via ADO/OLEDB or
JDBC in JAVA?

I do not know what would be involved but there has been allot of work in
this area from a performance standpoint. Both JDBC and ADO are widely
supported on many platforms and both provide native database functionality
via native drivers.

Is there a way for ZOPE to utilize ADO/OLDB or JDBC via a python component
(maybe implemented as LOCAL STORAGE(ZEO))?
Is there a way to provide Database Connection Pooling (add/remove DB
connections based on application usage?)

Lack of support for Native database functionality in ZOPE is a major
drawback and getting every DB vendor to code Python Drivers for ZOPE doesn't
seem reasonable from a maintenance standpoint on both sides of the
coin(developer/database manufacturer). Coding a DB connection manager to an
"DB DRIVER standard"(I use the term loosely) would provide better long term
support and flexibility.

Any thoughts?

Thanks in advance.

Theodore E. Patrick
Indigo Networks - Ishophere.com