> 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 _transacti
> 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 we
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
> 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
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.or
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
> 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 - Zope@zo
> 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, la
> 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
> no
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
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 perio
> 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 v
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 a
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 timeout
and your problem
> 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 i
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 o
> 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 _v_db
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 of
--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
___
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 -
20 matches
Mail list logo