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.
"DCO
[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
Maan M. Hamze wrote at 2007-12-5 18:32 -0600:
>I compiled dco2.c on Solaris 9 with Oracle 9i and Oracle 10g with no
>problems.
>On Windows XP, compiling dco2.c with Oracle9i is fine.
>
>With Oracle 10g on Windows XP (using Mingw C compiler), I ran into following
>errors:
>#
>In
banaouas wrote at 2007-11-16 07:15 -0800:
>I know there is many restrictions when writing python scripts.
Only "Script (Python)" and derived classes are restricted.
Python in normal Python modules/packages or "External Method"s are
not restricted.
>But is it possible to access to oracle (import
onsombal wrote at 2007-8-27 06:59 -0700:
> ...
> ...
>It's easy to insert and update Z SQL Methods directly from form field
>results.
>
>It's easy to read form field results (e.g. request.field2) and do
>comparisons, etc.
>
>I am struggling to understand how one can change a form field result wit
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
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
> /DAgroups/portal_factory/
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
David Daniel Estévez Durey wrote at 2007-5-22 13:54 +0100:
> ...
>I'm trying to connect FileMaker with Zope through ODBC, but I'm not
>sure if I could do this for free, without buying any driver or
>software. Can anyone explain to me how to do it or if it isn't
>possible?
To access any database
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:
contai
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 anyo
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 o
Pedro León López wrote at 2007-3-26 23:56 +0200:
> ...
> - Module Products.ZMySQLDA.db, line 389, in _abort
>
>error: release unlocked lock
>
>Other people with the problem:
>http://mail.zope.org/pipermail/zope/2005-June/159762.html
>http://dev.plone.org/plone/ticket/6263
>
>It will be possible f
Andreas Jung wrote at 2007-3-27 03:02 +0200:
> ...
>Well you know that Zope does not skip with any DA (except the one
>for Gadyfly). So I am not in the position to replace anything in the Zope
>core that does not exist :-)
You might have attacked "Shared.DC.ZRDB" which is the base of
Z SQL Methods
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
>z3c.zal
Comunian Alessandro wrote at 2007-3-12 15:01 +0100:
> ...
>ImportError: ld.so.1: python: fatal: relocation error:
>file
>/home/wwhypda/.python-eggs/MySQL_python-1.2.2-py2.4-solaris-2.10-sun4u.egg-tmp/_mysql.so:
>
>symbol mysql_set_character_set: referenced symbol not found
I expect that your "M
David Kurtz wrote at 2007-3-8 23:13 +:
> ...
>import _mysql
> File "build/bdist.macosx-10.3-i386/egg/_mysql.py", line 7, in ?
> File "build/bdist.macosx-10.3-i386/egg/_mysql.py", line 6, in __bootstrap__
>ImportError: Inappropriate file type for dynamic loading
An "inappropriate file typ
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 vers
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 mone
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 a
robert rottermann wrote at 2007-2-6 18:55 +0100:
>sorry for crossposting.
>after stoping and restarting zope one of the zeo/zope instances does
>not start anymore, and stop with an error.
>
>what could be the reason. how can we fix it.
>fstest.py does not report any error.
The object with oid "0x
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
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: Op
Pablo Avalos wrote at 2006-12-27 11:28 -0300:
>Sadly I'm stuck here at work with some Sybase DB, and I need to get some
>info to the intranet plone-site..
I have recently seen a new announcement of a "Sybase" module on
"db-sig@python.org". Search the archive.
--
Dieter
CERETTO Thierry wrote at 2006-11-29 09:15 +0100:
> ...
>Also, I test with "test" tab of "Z SQL method", it's the same, when I
>put "f1" in parameter field, that's work but if I put "f1,f2" (list)
>that's doesn't work (I get message above) (alos I tried : "f1","f2" and
>'f1','f2', etc, etc, but with
Andreas Tille wrote at 2006-11-23 16:06 +0100:
>
>Unfortunately
>
>does not seem to work transparently in the SQL-Method
Right.
"ZSQL Method"s take their parameters either from explicitly passed
keyword arguments or from the request but not from the DTML namespace.
--
Dieter
__
Maciej Wisniowski wrote at 2006-11-22 15:12 +0100:
> ...
>I'm especially interested in licensing.
>SQLAlchemy is on MIT license, so I think if it will be
>possible to use SQLAlchemy pool implementation then
>then this DCOracle2 version may be ZPL. Am I right?
I fear that there is a rule that every
M.-A. Lemburg wrote at 2006-10-18 12:02 +0200:
> ...
>As I understand it, the only case that the PYC cleaner is trying
>to work around here is a local configuration problem which only
>occurs if some PY file was removed upstream.
>
>In such a case, checking in the PYC files seems like the
>proper f
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
>(/lib/python/Products) , but it didn't work !
In principle, it should work.
Have you followed
Maciej Wisniowski wrote at 2006-9-28 23:05 +0200:
> ...
>I don't know how abort of ZODB resource managers works but
>doesn't rollback of ZODB resource manager remove _v_ variables?
Usually not.
An abort only deactivates (and deactivation kills the "_v_" variables
together with other content) thos
Paul Winkler wrote at 2006-9-27 17:44 -0400:
>I have the impression that there is no standard way to get access to a
>cursor from a Zope DA.
>Is that true?
True.
But you can get at a cursor for each DA using DA specific implementation
details, as the DA needs a cursor itself.
And as most Zope
Maciej Wisniowski wrote at 2006-9-27 22:40 +0200:
> ...
>> It can lead to nasty, apparently non-deterministic effects.
>> You may lose your database connection mid transaction
>> and part of what you think is a transaction (i.e. atomical) can be lost.
>>
>>
>What are the circumstances under
Maciej Wisniowski wrote at 2006-9-27 21:38 +0200:
> ...
>To be able to finish whole transaction
>for the relational DB...
No.
There are two reasons:
1. that later operations see the effects of earlier
operations in the same request
and more importantly
2. to avoid deadlocks.
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
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
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 "/opt/intranet/cbfmnet/zope_home/Prod
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 ha
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 Transacti
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.
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 the connection
>object.
In my view, this is a bug in Zope's DA code.
H
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 i
Harry Spier wrote at 2006-8-20 05:51 -0400:
>I am building a website with a MYSQL database of text documents (several
>thousand). I need to construct a feature similar to a "find in files" of a
>text editor.
Looks as if you would need text indexing in MySQL.
Check whether MySQL does support thi
Maciej Zi-Bęba wrote at 2006-8-9 12:53 +0200:-A
>I need to insert a python string into Postgresql's text field. I'm using
>a ZSQLMethod with ZPsycopgDA and the template looks like this:
>
>
>'INSERT INTO records (zope_id, title, long_description)
>VALUES (,
>,
>)'
>
>
>long_description is the tex
Sudesh Soni wrote at 2006-8-1 17:14 +0530:
>I get the following error while installing mxODBC 1.0 in zope 2.7.8 :
> ...
>50, in makeLockFile
>os.unlink(lock_filename)
>OSError: [Errno 13] Permission denied: 'd:\\Zope1\\var\\Z2.lock'
Check why the Zope process cannot unlink "d:\...\Z2.lock"...
Sudesh Soni wrote at 2006-6-22 10:39 +0530:
> ...
>Yes , i have SonicWall VPN Client version 2.2.2.210 running on our SQL
>server. If this is the reason then, do i have to make some changes in the
>settings/properties in Sonic wall ?
Usually, firewalls have an option to configure how long the conn
Sudesh Soni wrote at 2006-6-21 18:13 +0530:
>I get the below error :
>
>
>OperationalError on "DSN=Zope" thread 2476/2476 at 0x27150c4>: ('08S01', 11, '[Microsoft][ODBC SQL
>Server Driver][DBNETLIB]General network error. Check your network
>documentation.', 6108)
Do you have a firewall between Z
Andreas Jung wrote at 2006-6-8 10:12 +0200:
> ...
>I am pretty sure you can do it with little coding. Since the DA (or its
>ID is just a property or attribute (check the implemenation) you should be
>able to modify it.
And someone already did this: he had implemented a special
"Z SQL Method" clas
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 t
Michael Mauws wrote at 2006-5-1 19:02 -0600:
> ...
>However, the problem I'm having is that it's not just the
>"update request" that hangs. Rather, it's the whole Zope that hangs
>until this one request has been satisfied.
Even Zope requests that have nothing to do with Oracle?
This would indic
Jonas Nielsen wrote at 2006-4-27 11:56 +0200:
> ...
>The sense is that I would like to find an easy way to install my product
>without setting up the database connection manually. I guess the way to
>do it is to add some code in install.py then ?
That would work if you have a persistent object y
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
Andreas Jung wrote at 2006-4-6 20:52 +0200:
>>[Dieter]
>>> We switched to Postgres, MySQL is used only for legacy components.
>
>Huh...google will tell you that it runs even on Windows.
I probably should have written: we currently use MySQL only for
remaining legacy components.
I did not want to s
Jamie O'Keefe wrote at 2006-4-5 13:54 -0400:
> ...
>What version of MySQL are you using?
An old one...
We switched to Postgres, MySQL is used only for legacy components.
--
Dieter
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/
Jamie O'Keefe wrote at 2006-4-5 01:32 -0400:
>I have written a series of zope pages for a person to update their
>record in our mysql database. They use a zpt->python->db sql->db
>driver->db flow and work pretty well.
>
>Unfortunately, if enough people use it, the number of open db
>connections g
[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 Wind
[EMAIL PROTECTED] wrote at 2006-3-15 09:17 -0500:
> ...
>If you fix someone's C code, you really have to wonder if you did it
>correctly, and you also have to wonder if the next release will contain
>code that is even more difficult to fix. In short, you can hardly trust
>software for industrial u
[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 -I/oracle/product/9.2.0.6/rdbms
Please always stay on the list!
Never send questions to me privately (usually, I do not answer them!).
List readded...
[EMAIL PROTECTED] wrote at 2006-3-3 09:00 +0100:
>which means recompiling exactly what ???
The Python MySQL adapter is usually called "MySQL-python-".
Sources can be found on So
[EMAIL PROTECTED] wrote at 2006-3-2 16:18 +0100:
>After upgrading the passwords in an 5.0 MySQL database, zope 2.8 cannot
>reconnect, because the client parts of mysql changed.
>After changing all my C(++) clients (by using the updated include and libs)
>all if fine, but the ZOPE stuff.
Obviously,
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
___
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
"P
"<-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 "id"s around.
The "id" used in Plone is not a universal id,
[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 prod
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 li
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@zo
Kevin Monceaux wrote at 2005-11-29 13:20 -0600:
>I'm new to Zope so forgive me if the answer to this question is obvious. If
>one performs a select with a limit clause is it possible to determine how
>many results would have been returned if there was no limit? For example,
>if I wanted to select
[EMAIL PROTECTED] wrote at 2005-11-23 06:51 -0800:
> ...
>I regret that I have not yet learned how to "add logging" to
>ZPsycopgDA, and will appreciate learning how to do so.
It looks like this ("ZPsycopgDA/db.py"):
from zLOG import LOG, ERROR, INFO, PROBLEM
...
LOG('Postgres', INFO, sum
Ulrich Wisser wrote at 2005-11-22 13:25 +0100:
>I have a very strange error. From time to time ZPsycopgDA will loose the
>connection to the database (used as authentication source). Subsequently
>Zope does still answer requests, but no authentication is possible and
>all requests are answered wi
[EMAIL PROTECTED] wrote at 2005-11-22 03:27 -0800:
>Problem:
> Database inserts that worked previously are now failing,
> without raising exceptions!
I expect that something in your application catches exceptions.
To verify this, I would add logging to "ZPsycopgDA" (indeed,
I did in o
Sean Fulmer wrote at 2005-11-17 17:04 +:
>How can I insert a new record and have the new record immediately returned to
>me
>as an object?
You must use database means for this.
If your database system supports the "sequence" datatype (and you
use it to generate a unique id) then you can use
Matthew Cahn wrote at 2005-11-16 13:02 -0500:
>I have an application which uses DCOracle2. I wonder if anyone has
>built dco2.pyd for Python 2.4. The 2.3 version built by Mikey at Zope
>has been working great.
You can use the extension build for Python 2.3 for Python 2.4, too.
But version are
Germer, Carsten wrote at 2005-10-24 13:32 +0200:
>Ok, that's a bit much for my question I guess...
>I gather from all your mails that I can not "close" a database
>connection periodically or on event from Zope (Script or whatever)?
Modulo bugs, this happens automatically (when the DA object is flu
Matthew T. Kromer wrote at 2005-10-21 20:39 -0400:
> ...
>What happens with Zope and DCOracle2 I think is when the DA
>connection object is ghosted, it doesn't know about it, and thus
>doesn't close its connection.
Why not?
When the DA instance is ghosted, the "db" object is deleted
(last
Chris Withers wrote at 2005-10-21 16:27 +0100:
> ...
>Well, it depends, there can be a need for lots of infrequently used DA's
>connecting to the same database.
What prevents to replace these DA's by a single instance?
Looks much easier than a sophisticated connection pool management...
>Having
Cynthia Kiser wrote at 2005-10-20 19:09 -0700:
> ...
>I am pretty sure there is a bug in DCOracle2. If you can, try using
>DCOracle2 from the python prompt and close the connection. Now, can
>you still talk to the database? It seemed to me that I could when I
>tried that.
>
>For my particular circ
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 DCOr
Marvin Calingacion wrote at 2005-9-29 21:30 +0800:
>I would like to ask for some advice and tips on how to set-up
>user-privileges on the site I made with Zope. These privileges will be based
>on some sections of a given page while others will require a whole page.
>
>Example:
>
>-> Page 1
>- Secti
Please stay on the list -- readded...
[EMAIL PROTECTED] wrote at 2005-9-23 16:59 +0200:
> ...
>I have thought of another solution, if there is not enough space : it's to
>mount an external nfs patition (as big as possible) and tell zope in
>zope.conf that the database storage is in this partition
[EMAIL PROTECTED] wrote at 2005-9-22 16:46 +0200:
> ...
>The problem is that it's now 25 GB (yes!) and I have to pack it, you
>certainly understand why. But I've understood that when packing, zope
>creates a backup file named data.fs.old, which is , logically, the size of
>the previous database.
>B
Jose Z N wrote at 2005-9-7 01:54 -0500:
> ...
>After I unzip the file I found tree directories, I read what todo with the dll
>and mx folders BUT later It says "Place the database adapter folder in Zope
>products directory" I don`t Know exactly what to do.
The "database adapter folder" has the
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 lo
Nokin Jérôme wrote at 2005-8-9 15:09 +0200:
>I have zope 2.7.3 (on redhat enterprise 3)
>
>Our zope instance has run one week without the 'Data.fs' file (a human error).
>All transactions ware apparently written to 'Data.fs.tmp'. So zope has
>continued to run without any problem.
"Data.fs.tmp" o
Winn, Steven J wrote at 2005-7-28 14:15 -0400:
>I am running Plone using a PostgreSQL database and it works fine with the
>exception of adding new users. When I attempt to add a user from the Plone
>Configuration page, I get the following error:
>
>This site encountered an error trying to fulfill
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
_
Jørgen Frøjk Kjærsgaard wrote at 2005-7-4 11:04 +0200:
> ...
>Another question: When I define an external method to process form data,
>I have to do it like this:
>
>def process_form_data(self, name, address, zip, ...):
> ...
>
>What I would like to do is:
>
>def process_form_data(self, **args):
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 = psycopg.con
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
Ken Winter wrote at 2005-5-31 21:21 -0400:
> ...
>The nicest way would be to just do SQL SELECTs against the data dictionary
>tables.
What happened when you tried the nicest way? ;-)
--
Dieter
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.
Terry Kerr wrote at 2005-5-31 19:02 +1000:
> ...
>For example, the person who is authenticated to the site (will be
>authenticated via my user folder looking at the credentials in the
>person record in the person table), is only allowed to update records in
>a specific table that they own, as de
Maciej Wi-Bśniowski wrote at 2005-5-23 14:54 +0200:-A
>We're using DCOracle2 with Zope. On the client machine I've
>NLS_LANG = polish_poland.UTF8.
>
>The problem appears when I'have 30 characters long column in database,
>and the text stored in this column contains national characters and is full
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 aut
Jason Walsh wrote at 2005-5-17 14:57 +0100:
>I have the following ZPT code
>
>
>
>
>
>
>
>What I want to do is use the results from the first sqlMethod as a parameter
>to the second to get a string that should be displayed. The problem is that
>it says it does not know the variable os_id w
Henk Laloli wrote at 2005-5-12 18:25 +0200:
>There have been some questions concerning the myssql adapter under Zope
>2.7.5. before on this list. I have been trying out
>MySQL-python-1.0.0.win32-py2.3.zip with ZMySQLDA-2.0.8.tar.gz. I use
>Windows XP. But they give the error:
>
>Traceback (most re
Nilesh wrote at 2005-5-11 15:12 -0700:
> ...
>from db import DB
> File "/usr/lib/plone2/lib/python/Products/ZMySQLDA/db.py",
>line 89,
>in ?
>import _mysql
>ImportError: _mysql: init failed
Zope could not import "_mysql" -- maybe because
the MySQL client shared object could not be located
Federica Gomiero wrote at 2005-4-6 17:23 +0200:
> ...
> Invalid connection string: user_name/[EMAIL PROTECTED]
>with this error.log:
>Traceback (innermost last):
> ...
> Module Products.ZOracleDA.DCOracle2.DCOracle2, line 185, in connect
>BadRequest: Invalid connection string: /[EMAIL
>PROTE
Umashankar Rao wrote at 2005-4-5 11:27 -0400:
> ...
>But how to define my database connection parameters like
>username/passwd and SID?
Read the Zope Book (2.6 or 2.7 edition, online) -- especially
the chapter about database integration...
--
Dieter
__
Willadsens wrote at 2005-4-3 19:10 -0400:
> ...
>Correct, and very intentional. The current question is: semaphore or
>trap error and retry?
The standard way is to catch the "ConflictError", abort the transaction
and then retry the transaction.
Of course, you can try to serialize your transactio
Willadsens wrote at 2005-4-1 15:13 -0500:
> ...
>Here is (1) the original trace, failing on the commit:
>
>Traceback (most recent call last):
> ...
> File "/usr/local/lib/python2.4/site-packages/ZODB/Connection.py", line
>610, in commit
> raise ConflictError(object=obj)
>ZODB.POSException.Conflic
Tim Peters wrote at 2005-3-28 14:09 -0500:
>[Shane Hathaway]
>> Ape works just fine, so it doesn't need us much maintenance as it used to.
>> The storage comparison chart is out of date--it's no longer in alpha.
>
>Feel free to check in updates on Zope-2_7-branch:
>
>http://cvs.zope.org/ZODB3/D
99 matches
Mail list logo
