[Zope-DB] 3114 error with DCOracle2

[Remy Pinsonnault]

We had that problem for a while until we decided to buy eGenix ODBC
which solved the problem.

It is unfortunate to have no other option than buy this commercial
product but in the end, how many hours did you spent trying to solve
this problem?  I suggest you buy it, because for 95 $, it is cheap...

Remy

On Thu, 10 Feb 2005 10:37:15 +0000, Chris Withers
<chris at simplistix.co.uk> wrote:
> Satchidanand Haridas wrote:
> 
> > I was wondering if anyone on the list has come across a 'ORA-03114: not
> > connected to ORACLE' error while using Zope with DCOracle2 ?
> 
> Yep, plenty...
> 
> > We are using Zope 2.7.3 with Oracle 10g and DCOracle2 ver .
> 
> What version?
> 
> > We have got
> > the error at times. But there seems to be no pattern to its recurrence.
> 
> Check your oracle server, it's probably timing out connections that
> haven't been used for ages.
> 
> > I have checked the earlier posts on the topic on the mailing list. One
> > of the solutions suggested using a patch developed by Chris Withers. Has
> > anyone on the list used the patch? I would appreciate any comments. thanks.
> 
> It's a branch in CVS. It solves this problem, but has other bugs which I
> never had time to track down and fix.
> 
> cheers,
> 
> Chris
> 
> --
> Simplistix - Content Management, Zope & Python Consulting
>             - http://www.simplistix.co.uk
> _______________________________________________
> Zope-DB mailing list
> Zope-DB at zope.org
> http://mail.zope.org/mailman/listinfo/zope-db
>