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

2005-05-17 Thread Dieter Maurer
Michael Schwartz wrote at 2005-5-15 16:30 -0400: I am trying to find sample code for performing transactions in ZSQL with mysql 4.1. I'd like to do something like this: 1 - Insert record A into USER table 2 - Get auto_increment id for record A 3 - Insert record B into WIDGET table with

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

2005-06-23 Thread Dieter Maurer
Maciej Wisniowski wrote at 2005-6-23 10:28 +0200: ... Module Products.DCOracle2.SP, line 301, in __call__ TypeError: unbound method _lobConvert() must be called with DB instance as first argument (got list instance instead) On Zope 2.7.x everything is OK. Any ideas what is wrong?? Look at line

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

2005-07-03 Thread Dieter Maurer
Jørgen Frøjk Kjærsgaard wrote at 2005-7-1 23:28 +0200: I need to be able to access a Postgresql database directly from Zope Python scripts (Z SQL Methods is not an option as the SQL code occurs in modules that must be re-usable in a non-Zope context). ... import psycopg dbcon =

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

2005-07-08 Thread Dieter Maurer
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

2005-09-07 Thread Dieter Maurer
Martin Konicek wrote at 2005-9-7 17:26 +0200: ... * ls /var/lib/zope/lib/python/Products/ZPsycopgDA/ [ ...output ommited...] Provided that Zope looks there for its products, you should see any problems with the import of ZPsycopgDA in your Zope logfile. I cannot tell you where the Zope

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

2005-10-20 Thread Dieter Maurer
Germer, Carsten wrote at 2005-10-20 11:16 +0200: ... As we start to use our zope-Ora connection more frequently our database administrator complains that he sees a lot of idle conections. I know theres connection.close() in DCOra2 but does anyone know of a way to autmatically close a DCOra

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

2005-12-29 Thread Dieter Maurer
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

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

2006-01-13 Thread Dieter Maurer
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]

2006-01-13 Thread Dieter Maurer
[EMAIL PROTECTED] wrote at 2006-1-12 15:03 +0100: After creating about 20 ZSQL Methods and polishing them out, I tried some changes in opt/Zope-2.8/lib/python/Shared/DC/ZRDB which worked fine. But then these Objects all appreared like this: Abrechnung (This object from the ZSQLMethods product is

Re: [Zope-DB] regarding zope database

2006-01-30 Thread Dieter Maurer
-bhavana - [EMAIL PROTECTED] wrote at 2006-1-30 10:27 +0700: ... How to communicate with zope database? You use Zope (or scripts using the Zope codebase). the documents that we post in Plone have id, ya? There are lots of ids around. The id used in Plone is not a universal id, but unique

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

2006-02-02 Thread Dieter Maurer
gyro funch wrote at 2006-2-2 04:34 -0800: I am a Zope newbie with some Python experience. We have a large amount of scientific data that we are planning to load into several ZODBs. From the Zope interface, how can I access these 'external' databases? To access additional storages, you use

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

2006-02-09 Thread Dieter Maurer
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

2006-03-14 Thread Dieter Maurer
[EMAIL PROTECTED] wrote at 2006-3-13 13:32 -0500: ... However, during compilation of cdo2.o, I did encounter these symptoms: cc_r -DNDEBUG -O -I/oracle/product/9.2.0.6/rdbms/demo -I/oracle/product/9.2.0.6/network/public -I/oracle/product/9.2.0.6 /plsql/public

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

2006-04-04 Thread Dieter Maurer
[EMAIL PROTECTED] wrote at 2006-4-4 13:08 CES: ... I've found the wiki page: http://zopewiki.org/Oracle and it seems that DOracle2 would be the best thing for my needs (I only n= eed simple inserts and querries, nothing really fancy). But as I see ther= e is no binary for Python 2.4 and Windows.

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

2006-04-14 Thread Dieter Maurer
Christophe Appell wrote at 2006-4-14 17:43 +0200: On 4/13/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Well, this is one reason that I strongly prefer keeping my code on the file system. The availability of change-control software is the other. I happen to like git. Well, we are probably

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

2006-05-03 Thread Dieter Maurer
Please always stay on the list! Michael Mauws wrote at 2006-5-2 14:39 -0600: ... In light of the above, I don't think it's a GIL problem (without having a clue what a GIL actually is) This is the Global Interpreter Lock. It prevents more than a single thread to run Python code at the same time.

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

2006-09-07 Thread Dieter Maurer
Jose Carlos Balderas Alberico wrote at 2006-9-6 08:42 +0200: I've been reading documentation for a month, and although I think I understand what Zope is used for, there's still something I can't embrace, which is Zope's interaction with Apache. Please read the virtual hosting section in the

Re: [Zope-DB] Zope database connectivity

2006-09-22 Thread Dieter Maurer
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

2006-09-24 Thread Dieter Maurer
Maciej Wisniowski wrote at 2006-9-23 00:27 +0200: You could recode DA's to close the connection at the end of every transaction and reopen them on demand, Seems for me that difference betwen connect on load and connect on demand is in _begin, _finish and __init__ methods of TransactionManager

Re: [Zope-DB] Zope database connectivity

2006-09-25 Thread Dieter Maurer
Maciej Wisniowski wrote at 2006-9-24 22:00 +0200: ... Do you have 'connect_' defined elsewhere or it is expected to raise an exception here and just log this? Sure, I have defined connect_. It uses a private ZODB extension to prevent _v_ attributes to be lost mid transaction (which can have

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

2006-09-25 Thread Dieter Maurer
FAIRS, Dan, GBM wrote at 2006-9-25 08:58 +0100: ... Here's the salient part of the traceback: File /opt/intranet/cbfmnet/zope_home/Products/Membership/Member.py, line 118, in _getDBValue values = self._getDBValues(attributes=[attribute]) File

Re: [Zope-DB] Zope database connectivity

2006-09-26 Thread Dieter Maurer
Maciej Wisniowski wrote at 2006-9-25 20:09 +0200: It uses a private ZODB extension to prevent _v_ attributes to be lost mid transaction (which can have nasty, partly non deterministic and very difficult to understand effects) and then calls connect. Does this mean that there is a bug in ZODB?

Re: [Zope-DB] Zope database connectivity

2006-09-27 Thread Dieter Maurer
Maciej Wisniowski wrote at 2006-9-27 17:49 +0200: ... Thanks again for explanations. Seems that I'll change my DA's (DCOracle2 and ZCxOracleDA) to use connection pool like psycopg does. After quick look at their (psycopg) solution I think it is really good and solves (or may solve) few other

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

2006-10-02 Thread Dieter Maurer
shahrzad khorrami wrote at 2006-9-30 12:42 +: ... I Installed The Zope MySQL Database Adapter (ZMySQLDA) and The Python MySQL Database Interface (MySQLdb) to Zope's Products directory (Zope/lib/python/Products) , but it didn't work ! In principle, it should work. Have you followed

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

2007-01-17 Thread Dieter Maurer
robert rottermann wrote at 2007-1-17 15:42 +0100: ... when I execute this directly in the test window of the database connection, it works fine. when i execute the same line in the test window of a ZSQL Method then I get an error: Error, Products.mxODBCZopeDA.ZopeDA.ReplayTransaction:

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

2007-02-08 Thread Dieter Maurer
Robert-Reinder Nederhoed wrote at 2007-2-6 10:29 +0100: Good day, We use Zope 2.8, still from ZMI. We ran into the 1000 limit several times. Instead of remembering to set it to a higher value, I would like to change the ZSQL max_rows default to 5000. Is it possible to do this? It is also

Re: [Zope-DB] Please help me

2007-02-14 Thread Dieter Maurer
Nguyen Viet Minh Quang wrote at 2007-2-14 04:52 +0700: ... I would like to develop a new product running on Plone that can get data from relational databases (SQL Server and Oracle). I know also to connect to relational databases to install driver adapter. Yes, I found some driver adapter as

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

2007-02-16 Thread Dieter Maurer
Nguyen Viet Minh Quang wrote at 2007-2-16 12:42 +0700: ... I would like to use pymssql and another one, although I try to install it more times but it's not working. Can you help me to install it? No. I do not have an MS SQL server (I do not like MicroSoft and do not want to pay them any money).

Re: [Zope-DB] ZMySQLDA on solaris10

2007-02-22 Thread Dieter Maurer
Comunian Alessandro wrote at 2007-2-22 12:30 +0100: ... import _mysql ImportError: ld.so.1: python: fatal: relocation error: file /home/wwhypda/plone/instance_test01/lib/python/_mysql.so: symbol mysql_errno: referenced symbol not found You MySQL-python does not fit with your MySQL version:

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

2007-03-26 Thread Dieter Maurer
Andreas Jung wrote at 2007-3-25 17:49 +0200: In the Zope 2 worlds we have dedicated database adapters for different databases. Fortunately the Python world made us a wonderful present called SQLAlchemy that abstracts the different databases. In the Zope world we have some wrappers like

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

2007-04-30 Thread Dieter Maurer
Miguel Sánchez Beato wrote at 2007-4-30 12:33 +0200: I'm having problems when I retrieve data from the database because the data is not rendered using the unicode charset when the zope instance is in a vserver (with a Gentoo Linux distribution), so I get weird characters like 'á' instead of

Re: [Zope-DB] Connecting FileMaker with Zope

2007-05-04 Thread Dieter Maurer
David Daniel Estévez Durey wrote at 2007-5-3 10:44 +0100: I am trying to connect my FileMaker database with Zope, so I need a Zope Database Adapter for FileMaker. I haven't founded any in the Zope site, in exception of mxODBC Zope DA, but this bridge isn't free. I would be so pleased if anyone

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

2007-05-20 Thread Dieter Maurer
Ben Lobo wrote at 2007-5-18 17:33 +0100: ... I'm getting a POSKeyError when I try to access a particular file in a Plone site within the ZMI (see error report at http://hobointernet.com/POSKeyError.htm). You replace this file by a new object using an interative Python interpreter:

Re: [Zope-DB] FileMaker with Zope

2007-05-23 Thread Dieter Maurer
David Daniel Estévez Durey wrote at 2007-5-23 10:52 +0100: ... There used to be a ZODBCDA database adapter as Zope product. However, maintenance by zope.com stopped and some interested people took it over. Maybe, you try to search for it. Or you pay the XXX Euro and buy the eGenix mxZODBDA,

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

2007-06-17 Thread Dieter Maurer
Ken Winter wrote at 2007-6-16 16:03 -0400: ... Exception Type KeyError Exception Value 'id_list' Traceback (innermost last): ... * Module Products.CMFCore.FSPythonScript, line 164, in _exec * Module None, line 4, in people_delete_control FSControllerPythonScript at

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

2007-07-06 Thread Dieter Maurer
Mongolkhuu Baatar wrote at 2007-7-5 18:26 -0700: I am newbie and sorry for if I ask too simple question. I have designed my Plone site on my localhost (Windows server) machine. Then I need to move my real Zope and Plone server running on the Linux machine. How do I to do this? My both

Re: [Zope-DB] zope2 rdb and reconnect

2007-12-10 Thread Dieter Maurer
[EMAIL PROTECTED] wrote at 2007-12-9 13:42 -0500: Found the problem. I back ported this connector from a zope3 app. For the retry, being raised was rdb.interfaces.Retry, I changed it to raise ZPublisher.Retry, which works for zope2. Maybe there is a better way for zope2, but this works. A

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

2008-12-01 Thread Dieter Maurer
Nachiyappan wrote at 2008-12-1 10:12 +0530: ... i have installed DCOracleda for oracle . but i didn't make connection in zope to oracle ! Zope won't display the connection adapter . Something went wrong with your installation. First of all DCOracleDA needs DCOracle to be installed. DCOracle