Re: [Zope-DB] Warnings from mxODBC in 2.8.5
Chris Withers wrote: Hi All, I get the following warnings from mxODBC on Zope 2.8.5: lib/python/OFS/Application.py:788: DeprecationWarning: __init__.py of Products.mxODBCZopeDA has a long deprecated '__ac_permissions__' attribute. '__ac_permissions__' will be ignored by install_product in Zope 2.10. Please use registerClass instead. DeprecationWarning) lib/python/OFS/Application.py:803: DeprecationWarning: __init__.py of Products.mxODBCZopeDA has a long deprecated 'meta_types' attribute. 'meta_types' will be ignored by install_product in Zope 2.10. Please use registerClass instead. DeprecationWarning) lib/python/OFS/Application.py:820: DeprecationWarning: __init__.py of Products.mxODBCZopeDA has a long deprecated 'methods' attribute. 'methods' will be ignored by install_product in Zope 2.10. Please use registerClass instead. DeprecationWarning) Have other people seen this? I tried adding a warning filter but it didn't have any effect. My only guess is becuase mxODBC ships only as .pyc files :-S The warning filter should work for any Python code which issues these warnings, regardless of where and how it is defined. However, you'd have to register the filter early during Zope startup in order for it to be active by the time OFS.Application.py is imported. Anyway, I guess this is mainly aimed at the eGenix people: is there a version of mxODBC available which has these problems fixed? No. The reason is that the mxODBC Zope DA supports many old Zope versions (starting with Zope 2.3). Our next version will only be available for Zope 2.7 onwards and will remove much of the old-style interface logic which we still have to keep around for backwards compatibility reasons. Cheers, -- Marc-Andre Lemburg eGenix.com Professional Python Services directly from the Source (#1, Jan 20 2006) Python/Zope Consulting and Support ...http://www.egenix.com/ mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/ mxODBC, mxDateTime, mxTextTools ...http://python.egenix.com/ ::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] mxODBC Zope DB2 adapter - how to specify the current schema?
Gergana Silvanova wrote: Dear all, I'm using Zope with IBM DB2... the adapter which I use is mxODBC DA from eGenix... in the database connection string, I can specify DSN, UID, PWD and adapter-specific stuffdoes someone know if there is a way to specify the current schema? I looked in the documentation, but did not find it. The only way to do this would be in the connection string, using additional parameters. Please consult the ODBC driver documentation for available options. FWIW, this page lists the options for the Linux DB2 ODBC driver: http://www-03.ibm.com/servers/eserver/iseries/linux/odbc/guide/odbcproperties.html This is the general documentation page for the driver: http://www-03.ibm.com/servers/eserver/iseries/linux/odbc/guide/ Until now I was using the Zope DBDA adapter from BlueDynamics, and I easily could specify the schema, together with the database, username and password, in the database connection. -- Marc-Andre Lemburg eGenix.com Professional Python Services directly from the Source (#1, Jan 20 2006) Python/Zope Consulting and Support ...http://www.egenix.com/ mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/ mxODBC, mxDateTime, mxTextTools ...http://python.egenix.com/ ::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db