[Zope-DB] DCOracle2: close connection doesn't

[Matthew T. Kromer]

Chris Withers wrote:

> Hi Matt,
>
> Just noticed this with a recent CVS checkout of DCOracle 2.
>
> If you click the "Close Connection" button of a DCOracle 2 connection, 
> it doesn't actually close the connection. How come?


Because you clicked on a meaningless button :)

The close connection button causes the current DA instance to close its 
connection.  But it gets reopened in the next transaction.  There is no 
administrative close on DA objects.  Arguably there should be.

>
> This also seems to apply if the connection gets dropped by Oracle:
> http://mail.zope.org/pipermail/zope-db/2003-September/002149.html
> The connection object still reports as being "Open"  on the status 
> tab, and tries to execute queries but fails messily 'cos Oracle has 
> gone away.
>
> On this last point, has anyone implemented something like an 
> 'auto-reconnect' feature for DCOracle 2 so that the user never sees 
> the DCOracle2 Error: (1012, 'ORA-01012: not logged on') message?
>
> cheers,
>
> Chris
>
> PS: Did try and have a look at:
> http://www.zope.org/Members/matt/dco2/Tracker
> ...to report this, but got this error:
>
> Insufficient Privileges
>
> You do not have sufficient privileges to view this page.
>
> If you are getting this message when trying to edit your own zope.org 
> content, remember that you must retract published items before you may 
> edit them. To retract an item, click on the State link to view the 
> publishing status form and select "retract" from the publishing options.
>
> If you believe you are receiving this message in error, please send an 
> e-mail to webmaster at zope.org.
>
>

Hmm I though I had fixed that tracker, but new zope org is frustrating 
to deal with =/

-- 
Matt Kromer
Zope Corporation  http://www.zope.com/