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
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
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 =
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
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
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
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
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
[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
-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
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
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
[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
[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.
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
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.
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
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
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
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
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
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?
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
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
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:
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
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
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).
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:
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
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
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
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:
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,
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
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
[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
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
38 matches
Mail list logo