[Zope] Interest in continued Oracle support in Zope

[Dario Lopez-Kästen]

Anthony Baxter wrote:
> Nope. To be honest, I'd suspect Oracle-on-Linux. We ran with that for
> a while, several years ago, but gave it up because it was too fragile.
> AFAIK, Solaris is still one of Oracle's primary platforms. It's
> possible, of course, that Oracle have fixed Oracle on Linux up in the
> meantime.

hm.. maybe you are right... though we only use the client libs - oru 
oracle servers are on Solaris atm.

Here is an selection of a traceback that I got a short while ago:

-----
2004-08-31T18:36:23 ERROR(200) SiteError 
https://XXXX/search_icon.gif/index_html
Traceback (most recent call last):
   File 
"/usr/local/zope/software/zope-2.7.1/lib/python/ZPublisher/Publish.py", 
line 92, in publish
     object=request.traverse(path, validated_hook=validated_hook)
   File 
"/usr/local/zope/software/zope-2.7.1/lib/python/ZPublisher/BaseRequest.py", 
line 423, in traverse
     else: user=v(request, auth, roles)

....

   File 
"/usr/local/zope/software/zope-2.7.1/lib/python/Shared/DC/ZRDB/DA.py", 
line 454, in __call__
     else: result=DB__.query(query, self.max_rows_)
   File "/usr/local/zope/instances/cdks/Products/DCOracle2/db.py", line 
175, in query
     r=c.execute(qs) # Returns 1 on SELECT
   File 
"/usr/local/zope/instances/cdks/Products/DCOracle2/DCOracle2/DCOracle2.py", 
line 1006, in execute
     result = self._cursor.execute()
DatabaseError: (3113, 'ORA-03113: end-of-file on communication channel')
------

This happens a lot on RH 3.0, DCOracle2 from CVS HEAD, Oracle 9 
libraries. We do not use Solaris to host Zope-servers anymore, since we 
had horrible perfromance problems on Solaris and could not get around them.

Dunno if this actulayy gives any hints on where to begin with...

What version of DCOracle2 do you use?

/dario

-- 
-- -------------------------------------------------------------------
Dario Lopez-Kästen, IT Systems & Services Chalmers University of Tech.