[Zope-DB] 3114 error with DCOracle2

[Chris Withers]

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