Re: [Zope-DB] regarding zope

, a restart is necessary that Zope sees a change. -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] MySQL ZSQL Transactions or Commit in Zope?

). -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Zope 2.8 and DCOracle2 Stored Procedures

301 of DCOracle2/SP.py and check the implicated object and its type. -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Using psycopg directly in Zope Python script

message! Cancel the login dialog and you will get the error message :-) Does Zope somehow create a restricted environment PythonScripts are a restricted environment where import is restricted as well as access to attributes. -- Dieter ___ Zope-DB mailing

Re: [Zope-DB] Deleting a ZCatalog Object from ZODB

Takahashi, Michael wrote at 2005-7-7 09:27 -0700: But there must be another more efficient way to delete just the single object in the ZCatalog. Indeed: If you look at the catalog API (e.g. in the source or via DocFinder), you will find the uncatalog_object method. -- Dieter

Re: [Zope-DB] psycopg + zope problem

logfile lies on your installation. -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Closing idle DCoracle2 Connections?

OperationalErrors and reopens the connection. It tries to do this transparently (though a bit wrong). -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] can't Show More than 20 records

Rajesh wrote at 2005-12-29 13:37 +0530: 1. can not show more than 20 records (Roman Page) ... KeyError: 'query' Traceback (innermost last): A bug which should be fixed in quite recent Zope versions -- Dieter ___ Zope-DB mailing list Zope-DB

Re: [Fwd: Re: [Zope-DB] database connection]

Martin Krallinger wrote at 2006-1-10 16:57 +0100: thanks for the info. I am actually using zope 2.7 but still I encountered this problem. I think the poster wrote: fixed in Zope 2.7. Maybe, you try 2.8.5 or 2.9? -- Dieter ___ Zope-DB mailing list

Re: [Zope-DB] help appreciated [Virus checked]

is broken!) The import of the corresponding class failed -- almost surely because your change broke something... -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] regarding zope database

, nor an URL nor a parent -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] external ZODB from Zope interface

Products.ZODBMountPoint.MountedObject.MountedObject instances. Mounting is similar to mounting under *nix. -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] How I can connect MySQL database?

G E R R I T wrote at 2006-2-9 10:01 +0800: How I can connect MySQL database from my zope web project? Read the relevant chapter in the Zope Book (2.7 editon, online). BTW: Why to you attach an image when you post to a technical newsgroup? -- Dieter

Re: [Zope-DB] DCOracle2 on AIX5.2 -- issues

(to be precise: the implicit conversion between short and unsigned short) that the author did not expect to hurt compilers (and which most compilers accept). Your options: * use a different (less strict) compiler * fix the code (such that even your strict compiler feels happy). -- Dieter

Re: [Zope-DB] Oracle 9i, Zope 2.9.0 and Windows

. DCOracle2 currently has not maintainer. Maybe, you should look for cx_Oracle (which has an active maintainer). -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Help request from a non-developer

in the other direction. There are a few object types that unfortunately mix configuration and content. Catalogs are a prominent example. We handle them by manually performing the reconfiguration in the production site that we previously tested in the development site. -- Dieter

Re: [Zope-DB] Zope, DCOracle2, concurrent transactions, etc.

, some have suggested that this is solved with ZEO. They err. As well, I found one post that seemed to be suggesting the problem had to do with running Zope behind Apache. It, too, errs. Do either of these explanations make any sense? No. -- Dieter

Re: [Zope-DB] Some help about introductory Zope concepts.

than files. -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Zope database connectivity

Chris Withers wrote at 2006-9-22 10:48 +0100: Dieter Maurer wrote: M.-A. Lemburg wrote at 2006-9-20 23:00 +0200: ... I'll correct that slightly: Zope DAs usually open the connection as soon as the connection object is loaded into memory, e.g. if you look at the folder contents containing

Re: [Zope-DB] Zope database connectivity

connecting to relational database.', error=exc_info()) -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Zope database connectivity

nasty, partly non deterministic and very difficult to understand effects) and then calls connect. In the context of our discussion, it is equivalent to connect. -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo

Re: [Zope-DB] KeyError from Shared.DC.DA.DA

is more efficient anyway (it uses a module level cache rather than a ZODB cache) and definitely will avoid the problem above. -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Zope database connectivity

for several other things (beside database connections) as well that suffer from the same deficiency. -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Zope database connectivity

whether that of psycopg 2.x uses a connection pool and uses it in the correct way. I only know that the correct connection pool use is tricky... -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Zope and MySQL talking on Windows

the installation instructions to the point? -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

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

documentation to learn under what circumstances this error is raised. -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Can I change the ZSQL max_rows default value?

(beside the options already outlined in other replies) possible to use so called monkey patching to modify thee value. For details, search for it. -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Please help me

the (reasonable, as I have been told) fees for mxODBC or try again with pymssql (for access to the MS SQL server) or cxOracle.(for access to Oracle). The ZODBCDA is no longer reliably maintained (at least as far as I know). -- Dieter ___ Zope-DB mailing list

Re: [Zope-DB] Please help me about driver adapter

in the Zope Book (2.7 edition, online on plope.org). -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] ZMySQLDA on solaris10

with your MySQL version). -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Unified DA for Zope 2 using SQLAlchemy?

-- and many people would stop to use new Zope releases. Otherwise, I would not object against an *additional* SQLAlchemy based adapter. -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Unicode charset problems dealing with the ZmySQLDA product

encoding. The client encoding controls which encoding (aka charset) the client expects for unicode strings. There may be differences between your two configurations. -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo

Re: [Zope-DB] Connecting FileMaker with Zope

could tell me a choice to get it for free! You could use the (commercial!) ZMxOdbcDA from egenix to connect via ODBC. -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Unable to fix a POSKeyError

._setOb(idOfBrokenObject, someNewObject) After that, you can delete the broken object container._delObject(idOfBrokenObject) and commit. -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] FileMaker with Zope

, as suggested by Andreas. Thank you very much for answering, Dieter, but the same I explained to Andreas, money is a very big problem in my case. Then, you need to read very carefully! I sketched an option that does not cost money: Maybe, you try to search for it (ZODBCDA). I do not know

RE: [Zope-DB] Using dtml-vars in ZSQL methods?

keyword parameter there. -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Migration from Windows to Linux. How to do it?

). -- Dieter ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] zope2 rdb and reconnect

. A better way would be to raise an exception derived from ConflictError. Such an exception would cause ZPublisher to perform the Retry and with a good name for your new exception you would clearly see what happened in case, the exception were repeated. -- Dieter

Re: [Zope-DB] Zope - Oracle Database Connection

. Essentially, you need to start Zope in the foreground and it must not run in production mode. Under *nix (and Windows with very recent Zope versions), zopectl fg can be used for this. Watch out Could not import . -- Dieter ___ Zope-DB mailing