[Zope-DB] ANN: eGenix mxODBC Plone/Zope Database Adapter 2.2.1

2015-04-20 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING mxODBC Plone/Zope Database Adapter Version 2.2.1 for the Plone CMS and Zope server platform Available for Plone 4.0-4.3 and Plone 5.0,

[Zope-DB] ANN: eGenix mxODBC Plone/Zope Database Adapter 2.2.0

2014-12-11 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING mxODBC Plone/Zope Database Adapter Version 2.2.0 for the Plone CMS and Zope server platform Available for Plone 4.0-4.3 and Plone 5.0,

[Zope-DB] ANN: eGenix mxODBC Zope/Plone Database Adapter 2.1.2

2013-05-07 Thread eGenix Team: M.-A. Lemburg
ANNOUNCEMENT mxODBC Zope/Plone Database Adapter Version 2.1.2 for Zope and the Plone CMS Available for Plone 4.0, 4.1 and 4.2,

[Zope-DB] ANN: eGenix mxODBC Zope/Plone Database Adapter 2.1.1

2013-04-02 Thread eGenix Team: M.-A. Lemburg
ANNOUNCEMENT mxODBC Zope/Plone Database Adapter Version 2.1.1 for Zope and the Plone CMS Available for Plone 4.0, 4.1 and 4.2,

[Zope-DB] ANN: eGenix mxODBC - Python ODBC Database Interface 3.1.2

2012-04-26 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING eGenix.com mxODBC - Python ODBC Database Interface Version 3.1.2 mxODBC is our commercially supported Python extension providing ODBC database connectivity to

[Zope-DB] ANN: eGenix mxODBC Zope Database Adapter 2.0.2

2012-02-09 Thread eGenix Team: M.-A. Lemburg
ANNOUNCEMENT mxODBC Zope Database Adapter Version 2.0.2 for Zope and the Plone CMS Available for Zope 2.10 and later on

Re: [Zope-DB] SQLAlchemy

2010-08-30 Thread M.-A. Lemburg
Chris Withers wrote: M.-A. Lemburg wrote: If you want yet another abstraction layer between your code and the database, that's the way to go, yes :-) SA does provides a general abstraction layer, not the application specific one I was talking about. To be honest, I'd prefer to use

Re: [Zope-DB] ORMs (Zope-DB Digest, Vol 72, Issue 1)

2010-08-26 Thread M.-A. Lemburg
Richard Harley wrote: Please can someone explain why ORM is better than speaking directly to the database? Isn't this just adding another layer of complexity which in huge databases is certainly not needed. It really all depends on what your needs are. This is my experience: If you just

Re: [Zope-DB] SQLAlchemy

2010-08-26 Thread M.-A. Lemburg
Chris Withers wrote: M.-A. Lemburg wrote: I'd suggest to use a Python class as abstraction layer Sounds like an ORM to me ;-) No, there's no object-relational mapping being done, only interfacing between the data used by the application and the schema you have in the database. As nice side

[Zope-DB] ANN: eGenix mxODBC Connect 1.0.1 - Python Database Interface

2009-03-19 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING eGenix.com mxODBC Connect Python Database Interface Version 1.0.1 Our new client-server product for connecting Python applications

[Zope-DB] ANN: eGenix mxODBC Connect - Python Database Interface 1.0.0

2008-12-03 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING eGenix.com mxODBC Connect Python Database Interface Version 1.0.0 Our new client-server product for connecting Python applications to

[Zope-DB] ANN: eGenix mxODBC Connect Database Interface for Python 0.9.1 (beta)

2008-06-16 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING eGenix.com mxODBC Connect Database Interface for Python Version 0.9.1 (beta) Our new client-server product for connecting Python applications

Re: [Zope-DB] DCOracle2 installation, I'm missing header files

2008-05-13 Thread M.-A. Lemburg
On 2008-04-04 01:38, David Durham, Jr. wrote: On Thu, Apr 3, 2008 at 6:09 PM, Chris Withers [EMAIL PROTECTED] wrote: David Durham, Jr. wrote: Anyone spot what I'm doing wrong? You're using DCOracle2 instead of cxOracle ;-) http://sourceforge.net/projects/cx-oracle/ Oh, ok. Is there a

[Zope-DB] Re: Floating point errors

2008-02-05 Thread M.-A. Lemburg
.-Math. Marc-Andre Lemburg Registered at Amtsgericht Duesseldorf: HRB 46611 -su *On Mon Feb 4 11:34 , M.-A. Lemburg sent: * On 2008-02-04 08:19, siribu wrote: Hi, I found the a solution to the problem, it cannot be done just by Leave scale

[Zope-DB] Re: Floating point errors

2008-02-04 Thread M.-A. Lemburg
/2003-01/msg00036.html. That solved things for me. Anyway, thanks Marc-Andre :-) You're welcome. Could you explain why you had to set the NLS_NUMERIC_CHARACTERS variable ? Is this needed for the ODBC driver to convert numbers to and from strings correctly ? *On Sun Feb 3 12:37 , M

[Zope-DB] ANN: eGenix mxODBC and mxODBC Zope DA on AIX 5.3 (and later)

2007-11-19 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING eGenix.com mxODBC Database Interface eGenix.com mxODBC Zope Database Adapter for AIX 5.3 and later This announcement is also available on our web-site for

[Zope-DB] ANN: eGenix mxODBC and mxODBC Zope DA on 64-bit FreeBSD

2007-09-12 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING eGenix.com mxODBC Database Interface eGenix.com mxODBC Zope Database Adapter for 64-bit FreeBSD This announcement is also available on our web-site for

[Zope-DB] ANN: eGenix EuroPython 2007 Presentations Videos

2007-07-26 Thread eGenix Team: M.-A. Lemburg
eGenix EuroPython 2007 Presentations Videos eGenix is pleased to announce the immediate availability of PDF and Flash video versions of

[Zope-DB] ANN: eGenix mx Base Distribution 3.0.0 (mxDateTime, mxTextTools, etc.)

2007-05-10 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING eGenix.com mx Base Extension Package Version 3.0.0 Open Source Python extensions providing important and useful services for Python

[Zope-DB] ANN: eGenix mxODBC Distribution 3.0.0 (mxODBC Database Interface)

2007-05-10 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING eGenix.com mxODBC Database Interface Version 3.0.0 Our commercially supported Python extension providing ODBC database connectivity to Python

Re: [Zope-DB] sql query works in database connector but not in ZSQL method

2007-01-17 Thread M.-A. Lemburg
On 2007-01-17 17:42, Charlie Clark wrote: Am 17.01.2007, 17:14 Uhr, schrieb robert rottermann [EMAIL PROTECTED]: If tried that, but somehow I did not get it rigth: questions: - - the first parameter is an integer, how do I force that? int(para) ? - - the second parameter is an out

Re: [Zope-DB] Pitfall: mxODBCZopeDA and test runner in 2.9+

2006-10-13 Thread M.-A. Lemburg
Paul Winkler wrote: If you have mxODBCZopeDA and are using it with zope 2.9 or higher, a word of warning: You *must* use the -k option to the test runner when running tests in your INSTANCE_HOME. Example: ./bin/zopectl test -k If you fail to use -k, the zope test runner will

Re: [Zope-DB] Pitfall: mxODBCZopeDA and test runner in 2.9+

2006-10-13 Thread M.-A. Lemburg
Chris Withers wrote: M.-A. Lemburg wrote: If you fail to use -k, the zope test runner will delete bytecode for all your products - including mxODBCZopeDA, which has no .py files to fall back on. Ouch. I'll investigate further - there might be a bug to file against zope.testing. Why does

[Zope-DB] ANN: eGenix mxODBC Zope Database Adapter 1.0.10 for Intel Mac OS X

2006-09-20 Thread eGenix Team: M.-A. Lemburg
ANNOUNCEMENT EGENIX.COM mxODBC Zope Database Adapter Version 1.0.10 Usable with Zope and the Plone CMS.

Re: [Zope-DB] Zope database connectivity

2006-09-20 Thread M.-A. Lemburg
Matthew T. Kromer wrote: Basically, no. You could recode DA's to close the connection at the end of every transaction and reopen them on demand, but to the best of my knowledge none of the DAs work that way. Once a connection object opens its connection it stays open but in the object

Re: [Zope-DB] Warnings from mxODBC in 2.8.5

2006-01-24 Thread M.-A. Lemburg
Chris Withers wrote: M.-A. Lemburg wrote: Well, given that in Zope 2.9.0 it also doesn't catch the following warning that you get on startup: /home/lemburg/zope/Zope-2.9.0/lib/python/App/ImageFile.py:21: DeprecationWarning: Using OFS.content_types is deprecated (will be removed in Zope 2.11

Re: [Zope-DB] Warnings from mxODBC in 2.8.5

2006-01-23 Thread M.-A. Lemburg
Chris Withers wrote: M.-A. Lemburg wrote: 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

Re: [Zope-DB] Warnings from mxODBC in 2.8.5

2006-01-20 Thread M.-A. Lemburg
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

Re: [Zope-DB] mxODBC Zope DB2 adapter - how to specify the current schema?

2006-01-20 Thread M.-A. Lemburg
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

Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod

2005-04-22 Thread M.-A. Lemburg
Chris Withers wrote: M.-A. Lemburg wrote: Huh? I think you need to provide a little more information there... Sorry, I meant that the native Oracle interface is not DCOracle2, hinting that at the project I mentioned below. right, but DCOracle2 is *A* native oracle interface, right

Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod

2005-04-13 Thread M.-A. Lemburg
Matthew T. Kromer wrote: Chris Withers's branch of DCOracle2 has some changes that help the connection pooling problem. The issue basically is that the Zope adapter for DCOracle2 is fairly old and crusty. I think Jim's correct when he suggests doing your own pool management from a module.