Hi there,
in a plone site where Data is partially maintained in a mysql db, I get a
ConnectionStateError when I try to access properties on the sit.
the error is as follows:
Time2010/04/25 15:10:28.998 GMT+2
User Name (User Id) beat (beat)
Request URL
Hi there,
in a plone site where Data is partially maintained in a mysql db, I get a
ConnectionStateError when I try to access properties on the sit.
the error is as follows:
Time2010/04/25 15:10:28.998 GMT+2
User Name (User Id) beat (beat)
Request URL
Hi there,
I am using z3c.saconfig and zope.sqlalchemy to access an relational db.
Now I would like to use a different db schema for the test than for the real
thing.
I am usin a zcml stanza to define the the db:
configure xmlns=http://namespaces.zope.org/zope;
Hi there,
I am using collective tin.
the new version users z3c.saconfig.
to use it I have to declare the database in the configure.zcl like this:
db:engine name=declarations.database
url=mysql://[EMAIL PROTECTED]/energie echo=True /
db:session name=energiecluster.eccontent.platforms
Cu Vinh Loc schrieb:
Dear friends,
I am using plone for deploying the website, but I have some problems
such as:
- Using relational (internal) database Gadfly database: I do not know
where the database is stored in the Zope. Can I manipulate directly
this database visual?
-
I do not think any one of us can help you unless you tell us what
exactly your problem with installing pymssql ist.
by the way: do you mean MySQLdb?
there is very good documentation on using Z SQL in the zope book:
http://www.plope.com/Books/2_7Edition/RelationalDatabases.stx
there you find
Robert-Reinder Nederhoed wrote:
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?
Friendly greetings,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
hi there,
I think I found the reason, for my problems with stored procedures.
it seems that on can not call a stored MySQL 5.0x procedure from zope
that returns a data set.
when I call the body of the stored procedure everything works fine.
what I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi there,
I try the following statement:
CALL selectVertexProperties(1, @error2)
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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Charlie Clark schrieb:
Am 17.01.2007, 15:42 Uhr, schrieb robert rottermann [EMAIL PROTECTED]:
Hi there,
I try the following statement:
CALL selectVertexProperties(1, @error2)
when I execute this directly in the test window of the database
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kevin Campbell schrieb:
On Wed, Jan 17, 2007 at 03:42:04PM +0100, robert rottermann wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi there,
I try the following statement:
CALL selectVertexProperties(1, @error2)
when I execute
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Charlie Clark schrieb:
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) ?
I of course
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Robert,
Looks very much like an issue due to transactions. Are you using auto-commit
on either the MySQLdb connection or the zope database adapter? Perhaps
you could test the issue by placing get_transaction().commit() before
the start of
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi there,
I am implementing a tool to handle userdata that is stored in a MySQL
db. The underlaying logic of the stored procedures used to maintain the
db content dictate that I have to control the transactions myself.
I understand that there is a
14 matches
Mail list logo