You have convinced me
Something silly is happening in the storage procedure handling
of DCO2.
I've checked same function but with ZSQLMethod:
select wyjatek() from dual
In this case I have only one resource manager that is
being aborted:
2006-11-22 06:34:04 INFO _transaction
Chris Withers escreveu:
rieh25 wrote:
I wanted to do it because for some reason, my oracle connector (DCOracle)
keeps disconnecting,
DCOracle is broken ;-)
The errors you are seeing are likely due to a silly timeout being set on
the TNS listener by your oracle dbas. Tell them to remove the
What do you think about ZcxOracleDA[1]?
I don't use Oracle, but I spoke with Wilton and he told me that it was
working fine. Please try it, may be a good solution.
[1] http://www.tom.pro.br/componentes
I've tested this some time ago. It works but, at the time I checked,
this, there were no
rieh25 said the following on 11/16/2006 09:12 PM:
I wanted to do it because for some reason, my oracle connector (DCOracle)
keeps disconnecting, and so I thought maybe it would be possible to define a
python method to periodically check on it and reconnect it if necessary.
i one ancient app
rieh25 said the following on 11/16/2006 09:12 PM:
I wanted to do it because for some reason, my oracle connector (DCOracle)
keeps disconnecting, and so I thought maybe it would be possible to define a
python method to periodically check on it and reconnect it if necessary.
* for various
Maciej Wisniowski said the following on 11/17/2006 10:41 AM:
rieh25 said the following on 11/16/2006 09:12 PM:
I wanted to do it because for some reason, my oracle connector (DCOracle)
keeps disconnecting, and so I thought maybe it would be possible to define a
python method to periodically
Dario Lopez-Kästen said the following on 11/17/2006 01:07 PM:
Do you know these reasons?
yes, we sometimes get deadlocks in the database, net outages and general
misbehavior of DCO2.
Sorry, i am casting too much blame on DCO2 here; in reality we have a
combination of zope2.6, large file
yes, we sometimes get deadlocks in the database, net outages and general
misbehavior of DCO2. This is on zope2.6; we have not been able to use
ChrisW's latest modifications to the the python side of DCO2, because
for our use cases it hanged even worse. This was some two years ago, and
now
Dario Lopez-Kästen said the following on 11/17/2006 01:07 PM:
Do you know these reasons?
yes, we sometimes get deadlocks in the database, net outages and general
misbehavior of DCO2.
Sorry, i am casting too much blame on DCO2 here; in reality we have a
combination of zope2.6, large file
Seeing that Zope2 is still alive, kicking and in perfectly good health I
think that many people would like an improved DCO2 adapter.
I've published my code. Information is availaible at Zope-DB list
--
Maciej Wisniowski
___
Zope maillist -
rieh25 wrote at 2006-11-16 12:12 -0800:
I wanted to do it because for some reason, my oracle connector (DCOracle)
keeps disconnecting, and so I thought maybe it would be possible to define a
python method to periodically check on it and reconnect it if necessary.
Many DA catch the exceptions
Dario Lopez-Kästen wrote at 2006-11-17 13:07 +0100:
...
yes, we sometimes get deadlocks in the database, net outages and general
misbehavior of DCO2.
But DCO2 is not responsible for your deadlocks...
--
Dieter
___
Zope maillist - Zope@zope.org
Dario Lopez-Kästen wrote at 2006-11-17 13:07 +0100:
...
yes, we sometimes get deadlocks in the database, net outages and general
misbehavior of DCO2.
But DCO2 is not responsible for your deadlocks...
Depends what version of DCOracle Dario has, but I've found that
StoredProcedures may cause
Could somebody tell me how to close/open a database connection through
python instructions?
Thanks in advance...
___
Zope maillist - Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
--On 16. November 2006 11:33:06 -0600 Roberto Edwins
[EMAIL PROTECTED] wrote:
Could somebody tell me how to close/open a database connection through
python instructions?
What's the usecase? DAs usually connect automatically?!
-aj
pgptNUpurPGQO.pgp
Description: PGP signature
Roberto Edwins wrote:
Could somebody tell me how to close/open a database connection through
python instructions?
Thanks in advance...
Just do a google on your database + python. Of course, it would be
better if you found your database + zope - because (at least zope2) has
a nice array
Could somebody tell me how to close/open a database connection through
python instructions?
If you want to close database connections from Zope then it may be not
so easy. Depends on DatabaseAdapter how it is resolved. I mean that Zope
DatabaseAdapters usually use volatile attributes like
I wanted to do it because for some reason, my oracle connector (DCOracle)
keeps disconnecting, and so I thought maybe it would be possible to define a
python method to periodically check on it and reconnect it if necessary.
I imagined it wouldn't be so easy, but anyways I think I may be capable
I wanted to do it because for some reason, my oracle connector (DCOracle)
keeps disconnecting
By DCOracle you mean DCOracle2?
What do you mean by 'keeps disconnecting'. What kind of errors do you
see. We're using DCO2 - but so far we had only few
accidents that something was disconnected and it
19 matches
Mail list logo