Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Zope: Announce

ZcxOracleDA 0.5 released

 

 

Zope announce RSS feed   Index | Next | Previous | View Threaded


andyh at ekit-inc

Aug 6, 2007, 8:44 AM

Post #1 of 1 (1563 views)
Permalink
ZcxOracleDA 0.5 released

I'm pleased to announce the first release of ZcxOracleDA - a Zope
database adaptor for Oracle using the cx_Oracle library.

This is an initial development release and should be used with caution!

You can download it from:
http://www.zope.org/Members/andyhird/ZcxOracleDA

>From the README.txt:

Z cxOracle DA

This is a Zope Database Adaptor for cx_Oracle. It's currently only
been tested with Zope 2.7 and above with cx_Oracle 4.3.1 and above.

Installation

You must install cx_Oracle before attempting to use this DA.

You can find cx_Oracle at::

http://cx-oracle.sourceforge.net/

Then extract this product into your Zope instances Products
directory.

Connection Strings

The connection string is passed directly to cx_Oracle.connect().

The string is usually of the form username/password [at] TN

Known Issues

cx_Oracle returns date types as python datetime.datetime types. The
DA will check the queries description to see if any of the rows
being returned are of that type and if they are will convert them
on the fly to Zopes DateTime type. Unfortunately this currently
means the DA iterates through all the rows returned and modifies
the return values which is far from optimal.

Also the DA currently doesn't handle returned datetime timezones
well. It currently converts all datetimes to UTC regardless of the
timezone Oracle is using. Ideally the DA would query the current
Oracle DBTIMEZONE and use that instead. If you want to change the
timezone used for datetime conversion then edit db.py and modify
CONVERSION_TIMEZONE.


_______________________________________________
Zope-Announce maillist - Zope-Announce [at] zope
http://mail.zope.org/mailman/listinfo/zope-announce

Zope-Announce for Announcements only - no discussions

(Related lists -
Users: http://mail.zope.org/mailman/listinfo/zope
Developers: http://mail.zope.org/mailman/listinfo/zope-dev )

Zope announce RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.